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,519 reads
Blog Posts
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
28 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,229 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
629 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,191 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
185 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
201 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
61 reads
PASS Summit: Planting Seeds of Knowledge
On the eve of this year’s PASS Summit, I find myself reflecting on my first Summit in 2012. My employer was generous enough to pay for not only Summit...
2018-11-04
SQL work-vacation, T-2 days (#Workation #PASSSummit)
We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just...
2018-11-04
195 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers