What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a domain independent cluster and run a […]
Category: SQLServerCentral Syndication
All posts in this category get syndicated to SQLServerCentral.com
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice is to format using a […]
How to Upgrade an AG Cluster to Windows 2016
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The best part is it’s not an […]
Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video. If you […]
Implementing Buffer Pool Extension
Buffer Pool Extension was released in SQL 2014 so it’s not new. It is also not advertised very much, but that’s not for lack of […]
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 […]
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 […]
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 […]
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 […]
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. […]
You must be logged in to post a comment.