Corruption With Backup Compression And TDE In SQL 2017
Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017. …
Notes From A SQL 2017 Azure Install – Using A Cloud Witness With An Availability Group
As I build out my new SQL Server 2017 Availability Group in Azure, running on Windows 2016, I’m wanting to leverage some of the new technologies available. I’ve already written …
Slides From Nashville SQL Server User’s Group December 8th Presentation
The slides from my session, Lessons Learned From An Azure Migration, are attached here. Thanks to everyone who attended! If you happened to attend my session, please leave a comment …
Speaking At Nashville SQL Server User’s Group On December 8th
Next Friday, December 8th 2017, I will be speaking at the Nashville SQL Server User’s Group. My topic will be “Lessons Learned From An Azure Migration”, where I will be …
SQL Server Permissions Manager
Last week I announced 3 new open source SQL Server projects that I have on GitHub. One of those projects is SQL Server Permissions Manager, and today I would like to …
Slides From Adobe ColdFusion Summit 2017
The slides from my session, Building Better SQL Server Databases, are attached here. If you happened to attend my session, please leave a comment below and let me know what you …
3 New Open Source SQL Server Projects
Today I would like to officially unveil 3 new open source SQL Server projects that I have on GitHub! I will have upcoming blog posts that discuss each project in …
Notes From A SQL 2017 Azure Install – Using A Load Balancer As An Availability Group Listener
When setting up SQL Server Availability Groups on Azure virtual machines, one of the requirements is that you use a load balancer for your Availability Group listener. The load balancer stores the …
Notes From A SQL 2017 Azure Install – Using Group Managed Service Accounts
One of the new features that I’m excited about implementing on my Windows 2016 SQL Server 2017 servers is the ability to use Group Managed Service Accounts, or “gMSA” for short. …
SQL Scripts: How To Make Sure Your Backup Is Valid
I recently had a case where I needed to download a database backup to my laptop. It usually takes about 12 hours for this particular backup to copy down, so …
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 …