2014-11-28 (first published: 2012-12-06)
16,649 reads
Eric Wahner
Procedure Class Generator
Dynamically creates a VB.NET class from parameters in a SQL Stored procedure.
2009-03-09 (first published: 2009-02-16)
1,007 reads
2009-03-04 (first published: 2009-02-16)
1,230 reads
Who's Blocking
A quick little standalone script that tells you what process is blocking and what processes the blocking processing actually blocking.When running this script in QA, change your output to "Results in Text" ( CTRL-T ). Utilizes the blocking info in sp_who2 combined with dbcc inputbuffer and a little cursor to wrap it all up. Formatting […]
2007-04-19 (first published: 2007-03-20)
7,417 reads
What's Running
spWhatsRunning does just that. It tells you exactly what is executing on your server. By combining the output of the sp_who and dbcc inputbuffer, this script will tell you exactly whats being executed. DBCC INPUTBUFFER will tell you the same thing, but by the time you get the spid, the offending process may be gone. […]
2007-04-17 (first published: 2007-03-20)
2,535 reads
Blogs
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to...
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the...
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
By Steve Jones
I was recently doing some work on Always Encrypted in SQL Server 2019 and...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Query help on Pivoting on two columns
DECLARE @RegionCounts Table ( TYear char(2), Region varchar(30), RowCnt int ) Insert into @RegionCounts...
Response to Bloor article on SQL Provision
I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow. It would be more...
Ask SSC