It’s About the Journey, Not the Exam
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
2013-12-23
146 reads
Articles
Next-Level Parallel Plan Forcing: An Alternative to 8649
The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.
2013-12-23
2,190 reads
Recognizing community leaders
Voting is open for the Tribal Awards finalists. Choose which community warriors you think went above and beyond the call of duty with their blog, presentation, advice, user group, and more.
2013-12-20
478 reads
Repairing a Broken Log Shipping Plan From a Differential Backup
This article details how to reinitialise a Log Shipping scenario from a primary differential backup
2013-12-20 (first published: 2012-09-27)
4,029 reads
Creating a Table Warehouse to Retain Historical Data for a SQL Server Table
Brady Upton explains how to create a quick data warehouse to store all the data in a separate table so that it doesn’t get groomed.
2013-12-20
9,732 reads
Automation: Changing SQL Service Startup Parameters using T-SQL
Quick and efficent way to change SQL service startup parameters for 1000 instances!
2013-12-19
5,559 reads
Primary Key Primer for SQL Server
Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.
2013-12-19
5,005 reads
How to Use Microsoft's AMR Tool
In order to help DBAs determine which tables and stored procedures might be good to take advantage of using the new In-Memory OLTP tables in SQL Server 2014, Microsoft introduced the AMR Utility. Greg Larsen explores how to use this tool.
2013-12-18
3,168 reads
Removing the Linked Server 2 hop Limitation
This article talks about how you can get around the "Login Failed for user 'NT Authority\ANONYMOUS' LOGON" error when using linked servers and Windows authentication.
2013-12-17
9,105 reads
SQL Saturday #272 - Nashville, TN
SQL Saturday is coming to Nashville on January 18th 2014. This is a free full day of SQL Server training and networking. There are also paid-for Pre-con sessions available to sign up for presented by Denny Cherry and David Klee.
2013-12-17
2,784 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
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