2015-10-01 (first published: 2015-09-13)
1,959 reads
Scripts
2015-09-30 (first published: 2015-09-17)
1,821 reads
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,780 reads
2015-09-28 (first published: 2015-09-10)
1,197 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,209 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,994 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,899 reads
2015-09-22 (first published: 2012-10-01)
4,814 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,618 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,746 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
10 Reasons the 2CT Engagement Ring Is the Most Popular Proposal Choice Right Now
Walk into any jewelry consultation these days and you’ll hear a familiar request: “Something...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers