-
Query Store Questions From The Field
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read on the internet so this video is aimed… Continue Reading
-
Trace Flag 1117 Growth and Contention
In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in TempDB consistent. You’ll… Continue Reading
-
New Challenges
I’m sure everyone remembers the movie The Matrix. You probably also remember the scene where Morpheus asks Neo if he wants to take the red pill or the… Continue Reading
-
Database Mail Breaks with TLS 1.0 Disabled
Discovery I ran across an issue where I had just configured database mail on a new server, went to send a test email, and I waited to receive… Continue Reading
-
My First PASS Board Meeting
Let me start off with a disclaimer that these thoughts on the January PASS board meeting are my own as I do not speak on behalf of PASS.… Continue Reading
-
Query Active Directory from SQL Server
Have you ever had the need to query Active Directory right out of SQL Server using native TSQL? There are 3 ways to accomplish this. The first is… Continue Reading
-
SQL Server on Linux Authentication
Yesterday Microsoft announced that they will now support SQL Server on Linux. They are targeting mid-2017, but you can download a preview now. I am on a technical… Continue Reading
-
Fix a Network Binding Order Warning
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance… Continue Reading
-
Change Availability Group Endpoint Port
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can we accomplish this? The first step is to… Continue Reading
-
Change Availability Group Endpoint IP
Availability Group Endpoint I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s no surprise that IPs need… Continue Reading
-
Could not Register Service Principal Name
Have you ever seen the error below in your SQL Server log about the Service Principal Name shortly after startup? You’ll actually see two of them and you… Continue Reading
-
Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3
I ran across a bug in SSMS 2016 CTP 2 back in August where you cannot open an Availability Group. If you try to right click and look… Continue Reading
