Author Archives: Mark Holahan

Alternative Approach: Using SQLCmd to Execute a Large Script

Scenario: You’ve scripted the data of a largish table to a file (perhaps you need to deploy a solution you’ve built and SSIS is not expedient). You’re all set to execute your script in SSMS when…”Gadzooks!…an ‘out of memory’ error?!” … Continue reading

Posted in Alphabetical, Alternative Approach | Tagged , , , | 2 Comments

Automation: Get System Monitor Counters Into LogMan With ReLog

Scenario: System Monitor (née Performance Monitor in NT4.0) also know as “SysMon” is a Windows application we use to measure a computer’s performance. There are literally hundreds of metrics from which to choose. We can use the tool in a … Continue reading

Posted in Alphabetical, Automation, DBA Best Practice, Windows Server 2003 | Tagged , , , , | Comments Off on Automation: Get System Monitor Counters Into LogMan With ReLog

“Email Available Disk Space” Tool for SQL Server 2005

Scenario: You’d like to receive a periodic email relaying your SQL Server’s available disk space. Solution: This straight-forward post is a bolt-on to my previous “‘Get Available Disk Space’ Tool for SQL Server 2005” post. This script presumes the “DBA.dbo.AvailableDiskSpace” … Continue reading

Posted in Alphabetical, DB Mail, DBA Best Practice, DBA Tools | Tagged , , , , , | Comments Off on “Email Available Disk Space” Tool for SQL Server 2005

“Email SQL Server Errors” Tool for SQL Server 2005

Scenario: You want the skinny on your SQL Server error log. That is, you don’t want to skim hundreds of lines for possible embedded errors (“Error Log,” after all, is a bit of a misnomer as this file holds much … Continue reading

Posted in Alphabetical, DB Mail, DBA Best Practice, DBA Tools | Tagged , , , , , | Comments Off on “Email SQL Server Errors” Tool for SQL Server 2005

“Turn On Debugging Trace Flags” Tool for SQL Server 2005 Part I

Scenario: You’re suspicious that deadlocks are lurking in your system. And you’d like to capture as much information as possible in the SQL Server error log. You need to enable trace flags 1204 and 1222 to have SQL Server output … Continue reading

Posted in Alphabetical, DBA Best Practice, DBA Tools, DBCC | Tagged , , , , , , , , | Comments Off on “Turn On Debugging Trace Flags” Tool for SQL Server 2005 Part I