Index Basics: Find Tables That Do Not Have A Clustered Index
In a previous Index Basics post we went over the importance of having a Clustered Index on your tables, and we learned that SQL Server will automatically create a Clustered …
Notes From A SQL 2017 Azure Install – Trace Flags
Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers. These are my tried and true trusty companions, used to help …
Notes From A SQL 2017 Azure Install
Now that SQL Server 2017 is out it’s time for everyone to start migrating to it, right? RIGHT? Well, in my case, the answer actually is “Yes!” At my day …
Slides From NCDevCon 2017
The slides from my session, “Managing Your SQL Server When You Don’t Have A DBA”, are attached here. In this particular presentation there are a lot of links to documentation, …
Index Basics: Hidden Costs Associated With Indexes
I have a confession. When I was a developer, I didn’t understand indexes in SQL Server. I rarely added them to my tables, and when I did there was not …
SQL Scripts: How To Change The Owner Of A Database
Sometimes it becomes necessary to change the owner of a database. When a database is first created, SQL Server likes to set the owner of that database to the login …
SQL Scripts: How To Check Logins And Permissions
Security and permissions are a big part of a DBA’s job, and being able to find out things such as who has elevated login permissions, or when the last time …
Generating A Database Snapshot For DBCC CHECKDB
Many people don’t realize that DBCC CHECKDB actually uses an internal database snapshot of the database to run the consistency checks on. (See the “Internal Database Snapshot” section of the …
Slides From Scenic City Summit 2017
The slides from my session, Building Better SQL Server Databases, are attached here. This was my first time at Scenic City Summit, and I really enjoyed it. The venue was …
Speaking At Adobe ColdFusion Summit 2017
I have been selected to speak at the Adobe ColdFusion Summit again! This year’s event will be held November 16–17, 2017, at The Mirage in Las Vegas. I’m really excited to …