Wait Stats – Monitoring and Using
sys.dm_os_wait_stats is one of the most important DMVs out there, and one that you should know the historical values of...
2013-05-21
1,848 reads
SQLSaturday Redmond(SQLSat212) – A quick recap !
That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...
2013-05-20
709 reads
Getting Information from a Database using Dynamic SQL
I ran across someone that was building a restore script to automated their restores. This person wanted their script to...
2013-05-20
963 reads
The many uses of CROSS APPLY
Over the last few years of studying SQL I’ve noticed 4 different uses for the command CROSS APPLY.
In the first...
2013-05-23 (first published: 2013-05-20)
21,552 reads
Azure does Powershell too
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of...
2013-05-23 (first published: 2013-05-20)
1,942 reads
Last Weeks Top “Reading” Links #33
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-20
629 reads
SQL – SQL Server Script to Iterate through All SQL Instances – Example Transaction Log Shrinking
There are many ways to execute SQL’s or T-SQL’s across listed SQL Instances. Most of us might have faced and...
2013-05-20
1,866 reads
Per Member Per Month Per 1000 Calculations in MDX
In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the...
2013-05-24 (first published: 2013-05-20)
4,154 reads
SQL Server – Show/Hide Results Pane in Management Studio 2012
In earlier version of SQL Server Management Studio (2005, 2008 and 2008 R2) you can show/hide results pane using keyboard...
2013-05-20
1,851 reads
SQLSaturday#200 PA Event Update!
With less
than two weeks to go until SQLSaturday#200 at 45
Liberty Blvd., Suite 210 Malvern, PA 19355, Malvern, PA, 19355 they're...
2013-05-20
1,785 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers