I show DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Monthly Archive: February 2015
I address a popular theory that NOLOCK can substantially reduce locking overhead against #temp tables.
Tip : Give SQL Server users access to Extended Events
I discuss why developers and DBAs should work together.
Microsoft has released Cumulative Update #6 for SQL Server 2014. This update fixes a few important issues exposed in Cumulative Update #5; see this blog post for some more information about those issues. KB...
I talk about a couple of subtleties of THROW, and how to avoid frustrating bouts of troubleshooting.
Back in September, I blogged about the availability of SQL Server 2008 R2 Service Pack 3 and SQL Server 2008 Service Pack 4. I made it clear that there would be no cumulative updates after...
I share one of the most insightful pieces of feedback I have ever received from a session attendee – who happens to be a 6th grader.
A hotfix has been released for an issue that causes Availability Groups to show as NOT SYNCHRONIZING. The original issue is described in KB #3033492 and in this SQL Server Release Services Team blog...