-
Recent Posts
Recent Comments
- bala on Configuring SQL Server to use Managed Service Accounts (in PowerShell)
- Eduardo on Database Corruption Challenge Part 1
- BPOTW – 2015-05-15 | SQL Notes From The Underground on Debugging Long-Running SQL Queries
- Robin on Bike Tour Business Intelligence: Part 6 [Building the Fact Table]
- BPOTW 2015-03-21 | SQL Notes From The Underground on Bike Tour Business Intelligence: Part 4 [Populating a staging table]
Archives
Categories
Microsoft Blogs
SQL Blogs
Meta
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