Working with tabs and spaces in SSMS (Day 34)
There are several different options available for working with tabs and spaces in SSMS. In fact, there are enough that...
2018-03-29 (first published: 2018-03-21)
2,943 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Using a gMSA with SQL Server
As you already know, SQL Server runs as a service. And services require a service account to run under. While...
2018-03-02 (first published: 2018-02-19)
17,060 reads
Using the Full Screen Mode in SSMS (Day 33)
Do you ever find yourself working on a query and realize that you need just a bit more real estate...
2018-02-28
543 reads
Connecting to a SQL Server instance – Back to Basics
Back to the SQL Server Basics with Wayne
Connecting to a SQL Server instance is one of the first things that...
2018-02-19 (first published: 2018-02-07)
2,877 reads
Adaptive Query Processing – Interleaved Execution
Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.
2018-02-08
1,163 reads
Automatic Plan Correction
SQL Server 2017 lets you solve parameter sniffing problems - Automatically!
2018-02-04 (first published: 2017-11-20)
2,661 reads
Adaptive Query Processing – Batch Mode Memory Grant Feedback
Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017
2018-02-01
1,020 reads
Controlling what appears in the status bar and query tabs (Day 32)
When you run a query in SSMS, you are probably aware that the status bar contains many pieces of information...
2018-02-01
532 reads
SSMS Activity Monitor (Day 31)
SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance....
2018-01-31
788 reads
Reports in SSMS (Day 30)
SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of...
2018-01-30
534 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers