-
StatPress TopPosts
- How to Shrink TempDB in SQL 2005 (2290)
- A Busy/Accidental DBA's Guide to Managing VLFs (2233)
- Stored Procedure to Sequentially Run SQL Agent Jobs (2184)
- Why Do I Need All These Servers? (2173)
- Stored Procedure to Get SQL Job Execution Status (2131)
Archives
- May 2011 (4)
- April 2011 (1)
- January 2011 (1)
- November 2010 (8)
- October 2010 (3)
- September 2010 (6)
- August 2010 (1)
- July 2010 (2)
- June 2010 (1)
- May 2010 (5)
- April 2010 (11)
- March 2010 (2)
- February 2010 (3)
- January 2010 (3)
- December 2009 (4)
Categories
- Azure (1)
- Backup (1)
- CLR (1)
- Dynamic SQL (1)
- File Management (5)
- General (7)
- PowerShell (6)
- Reporting (1)
- Security (4)
- Security Cache (2)
- SQL University (4)
- Tracing and Profiler (1)
- Troubleshooting (7)
- User Management (6)
- Utilities (22)
Meta
Disclaimer
All thoughts and opinions expressed here do not reflect those of my employer in any way.
Monthly Archives: July 2010
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server, scripting them out. Continue reading
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading
