I show a workaround for an obscure error you might receive while patching SQL Server: "No room is available to display rows."
Monthly Archive: April 2015
Microsoft has released Cumulative Update #7 for SQL Server 2014. See this blog post for more information. KB Article: KB #3046038 41 fixes listed publicly at time of publication (47 total) Build number is...
Tip : Convert Existing SQL Server Traces to Extended Events Sessions
I try to raise awareness of a significant security issue when creating or altering logins using a password hash. Please vote!
Updated April 17, 2015: SQL Server 2014 Service Pack 1 has been released, but was quickly pulled. This post explains why and shows how to fix any affected instances.
Stop me if you've heard this one before. Microsoft has released Service Pack 1 for SQL Server 2014. However, do not install it if you use the SSIS catalog (SSISDB). From the Release Services...
For T-SQL Tuesday< #65, I give a little detail on something I learned this week about altering a column from NOT NULL to NULL.
A little advice on the use of MDF/LDF files for backups.
Tip : Prevent and Log Certain SQL Server Login Attempts
Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock...