SQL Tact

For testlab purposes, I often have a group of Azure VMs to manually spin up/spin down at once. I've had this script in use for a while a...

If you're used to the behavior of SSMS or PowerShell ISE where upon executing code in the script panel, your cursor stays in the script ...

Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older places as well. SQL Server's performance...

Rule "Microsoft .NET Framework 3.5 Service Pack 1 is required" failed. This is a common problem and relatively easy fix for SQL ...

Have you found yourself on a server or workstation that doesn't have telnet (typical in new builds and new Azure VM's from the galle...

If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here:  https:...

I had a project to automate the import of a large number of excel files via SSIS into SQL 2012. Many of the files had different headers, but...

Here's a link to my slide deck and examples (including the sample scripts we didn't get to talk about) from the Baton Rouge SQL Ser...

Had to set up back up a SQL Express 2005 database.  Why some vendors insist on creating software dependent on SQL Express, and then not givi...

So, as a precursor to my next blog post where I actually do something SQL related with Powershell, I'll post my first two powershell scr...