-
Store Optional Connection Parameters in SQL Server Management Studio
About six months ago I wrote about the challenges of using the Always-On Availability Group Listeners with SSMS. At the time, I had presented three problems and only solutions for two of them. At this time, I am happy to announce that Microsoft has responded to our connect ticket and provided a current version work […]
-
QS-Config v2.0 Enters Open Beta: Major Refactoring
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. Supports FILESTREAM. Exposed explicit control over installation directories. Behind the scenes changes / bug fixes: […]
-
Choosing a Git Client
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 recently changed organizations and found VC to not exist in my new environment. This is […]
-
Multiple Server Management – Finding the Database Server
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 Management Server to manage your server list and it will demonstrate how to use T-SQL […]
-
PowerShell Start-Job
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 server in my company, I don’t want to wait for each one to return data, […]
-
The end of an era
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 I grew. My co-workers are the living embodiment of their mission statement to, “set the […]
-
QS-Config v2.0 coming soon
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 necessary to many of their configurations and to say that I was overworked would be […]
-
Database Deployment Work Flow with SQL Server Data Tools (SSDT)
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 without fear of frustration. Today I wanted to talk about SQL Server Data Tools, specifically […]
-
SQL Saturday #381 – Richmond, VA
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 scissors was ridiculous! I heard recommendations that perforated paper be used next year. Once the sessions […]
-
Statement was run under snapshot isolation but the transaction did not start in snapshot isolation
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 our operating cycle we were sick of fixing duplicate insert issues by escalating to REPEATABLE […]