Monthly Archives: May 2015

Debugging Long-Running SQL Queries

The T-SQL PRINT statement lets you write to the Messages window in SQL Server Management Studio, which makes it a helpful aid when debugging SQL scripts and stored procedures. Unfortunately there is one major issue with using PRINT. The messages … Continue reading

Posted in SQL Server | 1 Comment

Automated Configuration Management: Deploying SQL Server via PowerShell DSC

Desired State Configuration (DSC) is a new PowerShell feature that manages Windows infrastructure (servers and applications), both on premises and in the cloud. It’s built into PowerShell 4.0 and is part of the Windows Management Framework. PowerShell DSC comes shipped … Continue reading

Posted in Automation, Deployment | Leave a comment