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
98 reads
Blog Posts
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
385 reads
SQL Server Clustered & NonClustered Indexes Explained
When using row level indexes there are two types Clustered and NonClustered both of which are there to make data...
2017-05-16
103 reads
SQL Server on VMware Workshop at VMworld US 2017
I am extremely proud to announce that we’re holding the second SQL Server workshop at this year’s VMworld US in Last Vegas on...
2017-05-16
381 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,342 reads
T-SQL Tuesday #90 Shipping Database Changes – Wrap Up
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
430 reads
What Do You Do When Performance Sucks?
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
580 reads
XML vs JSON Shootout: Which is Superior in SQL Server 2016?
Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...
2017-05-16
35 reads
A (mostly) Unwired Week at #MSBuild
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
Last week I...
2017-05-15
680 reads
Building a container running SQL Server 2014 SP2 Developer
One of the things about working with SQL in Docker is that you kinda have to use the images that...
2017-05-15 (first published: 2017-05-02)
2,426 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers