2015-09-30 (first published: 2015-09-17)
1,775 reads
Scripts
Get Server version Info
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,736 reads
2015-09-28 (first published: 2015-09-10)
1,167 reads
Show solving arithmetic expression step by step
A script to show how to solve arithmetic expressions step-by-step, for my 9-year old daughter.
2015-09-25 (first published: 2015-09-09)
1,188 reads
Document the output of all the SPs in HTML fashion
A script to document the output columns of all the SPs in a given database, with a HTML formatted document
2015-09-24 (first published: 2015-09-08)
1,936 reads
Open transactions on a database
This script will show you all open transactions from any query windows.
2015-09-23 (first published: 2013-01-14)
3,866 reads
2015-09-22 (first published: 2012-10-01)
4,783 reads
SQL Server CPU Usage History Histogram
Returns a summary of CPU usage by SQL Server over the last 4 hours (default).
Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.
2015-09-18 (first published: 2014-05-14)
5,569 reads
SQL Job Timeline (Graphical)
This script generates a graphical timeline of all SQL jobs with a variable zoom level
2015-09-17 (first published: 2013-01-14)
6,685 reads
Reindex Procedure with a Twist (or two) the SQL
A 2012 update to "Reindex Procedure with a Twist (or two)":
2015-09-15 (first published: 2014-05-16)
4,401 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers