Skip to main content

SQL Server Best Practices

 Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected developers and engineers at Microsoft, who walk you through the specifics on solving particularly difficult issues.

Technical White Papers

Deep level technical papers on specific SQL Server topics that were tested and validated by SQL Development.

SQL Server 2012

SQL Server 2008 R2

SQL Server 2008

Best Practices-Related Blogs Best Practices-Related Blogs OPMLfeed

SQL Server - Best Practices

CSS SQL Server Engineers
Why won't my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?
Thursday, May 23 psssql
SQL Server Tips & Tricks
How do I map a differential/transaction log backup to its full backup without using MSDB?
Wednesday, May 22 HarshDeep_Singh
SQL Server Security
Filter SQL Server Audit on action_id / class_type predicate
Wednesday, Oct 3 Rinku Agarwal
SQL Server Protocols Team
Announcing Microsoft SQL Server ODBC Driver for Linux
Thursday, Oct 13 dpblogs
SQL Server Manageability Team Blog
Connection Loss Errors in SSMS Query Editor
Monday, Jul 25 gcmouli