Domain Independent Cluster and Availability Group
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 SQL Server Availability Group...
2018-07-05
9 reads
Ryan Adams
Domain Independent Cluster and Availability Group
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 […]
The post Domain Independent...
2018-07-05
9 reads
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...
2018-06-19
700 reads
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...
2018-06-19
80 reads
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...
2017-11-09
167 reads
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...
2017-11-09
80 reads
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...
2017-06-08
679 reads
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...
2017-06-08
82 reads
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...
2017-05-29 (first published: 2017-05-18)
1,412 reads
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...
2017-05-18
184 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers