Farewell, Gareth Swanepoel
Not easy to say, Gareth passed away a few days ago. We’d both gotten busy and with Covid added in, we had not caught up in a while. Now,...
2021-01-14
623 reads
Blog Posts
Query to list all the procedures and triggers not having SET NOCOUNT ON defined
It is a tiny query in size but can play a crucial role to avoid overhead, caused due to missing SET NOCOUNT ON definition in the stored procedures and...
2021-01-14
387 reads
SQLSaturday Doesn’t Have to Be a Platform
When we built the first SQLSaturday it was about 2 pages of HTML. No login, no tools, just get it done. Worked ok. Didn’t work so well for the...
2021-01-14
8 reads
T-SQL script to find hierarchy of tables – Row-wise result
As I promised in my previous post T-SQL script to find hierarchy of tables – Columnar result – SQL Server Carpenter, here is another version of the query to...
2021-01-14 (first published: 2021-01-07)
950 reads
Using Amazon FSx for SQL Server Failover Cluster Instances – What You Need to Know!
Intro If you are considering deploying your own Microsoft SQL Server instances in AWS EC2 you have some decisions to make regarding the resiliency of the solution. Sure, AWS...
2021-01-14 (first published: 2021-01-08)
466 reads
Daily Coping 13 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-13
10 reads
EightKB is coming!
The next EightKB is coming on January 27th, kicking off at 2pm UTC. Once again we have 5 mind melting sessions on 5 in-depth SQL Server internals topics, from...
2021-01-13 (first published: 2021-01-07)
515 reads
Power BI: Data Model Optimization
Saving the Day from Delay Part 1 Optimizing your data model can be a daunting task. If you read the intro to this series, you know one of the...
2021-01-13
5 reads
Top 3 Easy Help Queries for XEvents in Azure SQL
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-13 (first published: 2021-01-04)
205 reads
T-SQL Tuesday #133 - Taking a Break
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month James McGillivray (blog | twitter) asks us about our views on...
2021-01-13
5 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Cara membuka blokir aplikasi BTN mobile banking
Untuk membuka blokir akun Bank BTN seperti bale by BTN atau BTN Mobile, hubungi...
Cara Buka Blokir Qlola By BRI
Cara membuka blokir BRI Qlola/ by BRI dapat dilakukan dengan menghubungi Call Center (0818)-3983-99,...
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers