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...
2017-05-16
378 reads
Ryan Adams
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...
2017-05-16
88 reads
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...
2017-05-16 (first published: 2017-05-05)
1,330 reads
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...
2017-05-05
94 reads
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...
2016-07-13 (first published: 2016-07-05)
1,884 reads
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...
2016-07-05
84 reads
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...
2016-04-18
499 reads
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...
2016-04-18
82 reads
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...
2016-03-21 (first published: 2016-03-15)
3,760 reads
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...
2016-03-15
146 reads
Blogs
Running SQL Server on KubeVirt – Getting Started
With all the changes that have happened with VMware since the Broadcom acquisition I...
Why is shrinking IT budgets a good thing?
Each year around this time, companies enter the familiar ritual of budgeting. For many,...
Reverse Engineering a Physical Model Diagram
By Steve Jones
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...
Forums
Best analysis approach to reduce data type length in multiple tables
Hello SSC, I hope everyone is having a happy and safe holiday season! I...
Do you separate data/log files and TempDB files on different disks using AWS EC2
Hello, I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...
Service account being in local admin in AWS EC2 environment?
Hello, I am working with a company on their database administration. I am trying...
Question of the Day
A New Operator
In SQL Server 2025, what does this code return?
SELECT '1' || '0'See possible answers