QS-Config v2.0 has passed closed beta and is now entering open beta. Feature changes / additions: Supports PowerShell v2.0 and higher. Supports SQL Server 2014. One script for all supported versions of SQL Server, rather than a script per version….
Version control (VC) is very important for any type of IT shop, big and small, as well as for application code and database code. Most of my career I’ve used Microsoft’s Team Foundation Server (TFS) for my VC system. I have…
Often database administrators must ask themselves a simple, yet tedious question, “what server is that database on,” or maybe, “how many servers do we still have on SQL Server 2005?” This article will cover how to use SQL Server’s Central…
The Start-Job Cmdlet is a fast and extremely simple means of spawning asynchronous threads. Why do we care? Because performing parallel work is faster and our time is important. If I want to inventory the Windows services running on every…
Today is my last day working for Liberty Tax Service. Liberty took a chance on me when I was fresh out of the Navy with no experience as a DBA and has been there every step of the way as…
Years ago I found myself frustrated with the SQL Server installation wizard. I was working for an organization where SQL Server installs were needed regularly during points in their operational cycle and often they were not cookie cutter. Tweaks were…
Happy April Fools Day everyone! I hope that you do not spend too much time reading completely false blog posts today. I, for one, promise that this post is not an April Fools Day joke. Feel free to read on…
Last Saturday I attended #SQLSATRVA, which was SQL Saturday #381. It was a blast! The day started off with the usual registration process. Thankfully, I remembered to print out and cut my SpeedPass in advance. The line to use the…
My organization enabled READ COMMITTED SNAPSHOT ISOLATION (RCSI) on one of our major systems before we entered a peaking operating cycle. We had tested the impact to our system and felt that it was pretty safe. About half way through…
When creating a SQL Agent Job to execute a PowerShell script, you have to decide which way that you want the PowerShell to run. Depending upon which version of SQL Server that you are using and which job step type that you…