2014-11-28 (first published: 2012-12-06)
16,703 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,008 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,420 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,537 reads
Blogs
Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method
Yesterday in this post I described a method to correct permissions when upgrading a...
Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers
By Devin-Knight
Welcome back to my Power Platform Quick Tips series! In this second episode we...
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Kill 2 databases connections
Hi Gurus, Below script kills the only connection related to the AdventureWorks databases. If...
Previous Day (Business Day Only) Needed for Auto Tableau Server Script
Hello, Need a simple script that would pull back the previous business days' assigned...
Ask SSC