STS-134 Rollout
If you follow me on Twitter or talk to me in person you'll come to realize I'm a space enthusiast....
2011-03-15
514 reads
Blog Posts
The MCM is Worldwide
Well, not everywhere, but as long as Prometric sites meet some security requirements, they can offer the MCM tests. I...
2011-03-15
840 reads
To Script or Not To Script
When approaching an automation problem the first questions you must answer is whether you should even invest the time to...
2011-03-15
688 reads
Waiting For Superman
This site really is about business intelligence, but it is good to mix things up a bit every now and...
2011-03-15
716 reads
ANSI Connection Settings
It’s reasonably well known that you can get different execution plans if you change the ANSI connection settings. But the...
2011-03-14
1,706 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then...
2011-03-14
4 reads
DB Benchmarking
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking,...
2011-03-14
1,098 reads
Happy Pi Day
Here’s wishing you a Happy Pi Day…
Pi in Pie Pan
If my picture isn’t good enough, here’s a better representation of...
2011-03-14
501 reads
Mirrored Database Backups vs. Striped Database Backups
I have seen a few people get confused about the difference between a mirrored database backup (which is only available...
2011-03-14
1,412 reads
More Changes for the Dimension Merge SCD?
A while back, I ran a contest to find a new name for the SCD component hosted on CodePlex. The results were the best "lemons into lemonade" situation I could...
2011-03-14
8 reads
Blogs
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
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
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