Should you update stats for your SQL Server database?
Statistics on database objects are very important to the SQL Server engine optimizing execution plans and running at the most...
2018-11-06
300 reads
Blog Posts
T-SQL Tuesday #108 - Learning Tech Beyond SQL Server
Malathi Mahadevan (blog|twitter) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community.
Malathi has asked us to:
Pick one thing you want to learn that...
2018-11-06
5 reads
Using MAXDOP to fix a performance problem
As DBA’s we are sometimes put in a rock and hard place when it comes to database performance. This situation...
2018-11-06 (first published: 2018-10-29)
4,525 reads
Want to learn about Azure Data Studio (formerly SQL Operations Studio)
Come see my inaugural presentation at the Lexington PASS User Group meeting, Tuesday, Nov 13th, at 6:30 PM at the Blue Stallion Brewing Co. Azure Data Studio [pptx 6MB]
2018-11-06
34 reads
Better Keyboard Extensions in Azure Data Studio
I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started...
2018-11-05 (first published: 2018-10-23)
2,232 reads
Failed Installation of SQL Server Cumulative Updates Debugged
Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....
2018-11-05
635 reads
Identifying delays between SQL calls using SQL profiler
One of the common goto methods for query specific slowness which can be replicated via an application can be to...
2018-11-05 (first published: 2018-10-24)
2,199 reads
SQL work-vacation, Monday (#Workation #PASSSummit)
Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...
2018-11-05
189 reads
What Is Happening, Right Now, At the PASS Summit?
Honestly, that’s a very hard question to answer. I mean, first of all, you can look at the schedule. There...
2018-11-05
203 reads
Last week reading (2018-11-04)
Good morning folks! I wish you very good week at work, at home or wherever you are/will be. Last week...
2018-11-04
64 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
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...
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