Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server

/0 Comments/in , , , , ,
With the total of 4 new index types we have gained since SQL Server 2012 now we also have a total of 4 basic formats (Heap, Clustered Index, Clustered Columnstore Index, memory-optimized “varheap”) for data storage in SQL Server. And what’s more, with SQL Server 2016, these can be combined in various ways.
Read more

Free SQL Deadlock Collector & Parser published at codeplex

/0 Comments/in , , ,
Today I redeemed a promise made long ago: To provide the deadlock-collector framework, which I developed for use at my customers’, as a Codeplex project. Until now I have only given it out to attendees of my SQL Server Master-Classes and a few fellow Microsoft Certified Masters. From today on it is freely available to […]
Read more

SQL Server Database Ownership: survey results & recommendations

/9 Comments/in , ,
You may remember the survey on database ownership which I launched several months ago. In the following, I am now presenting the results and giving my official recommendation for a best practice for security in terms of database ownership. First, if you still need the script:
Read more

Security-Check-Script & Survey: SQL Server Security – Database-Owners, critical Permissions and role membership

/1 Comment/in , ,
In this survey, I would like to explore in a greater radius which accounts are typically used as database owners. I will subsequently publish the cumulated results here to share them with the community together with some recommendations for hardening security. In this instance, particular server-wide permissions both of the used account as well as, […]
Read more