Keep focused DBA scripts for active requests, blocking, table size, index usage, backups, and failed jobs, with clear limits on each result.
Restart History: Preserve Startup Evidence Before Logs Cycle
Restart history records startup evidence before retained logs disappear. Keep each source and timestamp separate, and test repeat collection with synthetic archives.
SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created
SSMS says saving changes is not permitted when a table must be re-created. Learn to turn off Prevent saving changes, and why I still prefer T-SQL.
Dynamic PIVOT: Building Report Columns From the Data
Build a dynamic PIVOT with ordered STRING_AGG and QUOTENAME, parameterized filters, zero-filled results, and explicit report-width limits.
SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table
Readers often ask how to check existence of a temp table and how to drop temp table without Msg 2714. My earlier article answers all of these questions.
SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
TechEd India 2009 has ended. Day 3 was the best, with a meeting with the SQL Server product group under NDA, final presentations and time with friends.
SQLAuthority News – TechEd India 2009 – Day 2 – In-Person Meeting with Industry Leaders – Community Party
Day 2 of TechEd India 2009 was even better: talks with industry leaders, Vinod Kumar’s session on data compression in SQL Server 2008, and a community party.
SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
The first day of TechEd India 2009 was a blast: Steve Ballmer’s keynote, my tech session with the SQL Server cheat sheet, and meeting great people.
SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live
I am at TechEd India 2009 in Hyderabad, leading a session on SQL Server Management Studio 2008 new features. Catch me live and grab my SQL Server cheat sheet.
What Changes When You Move to a New Major Version
A New Major Version of SQL Server changes the engine while database compatibility, query plans, and deprecated features need separate review.