|
Author: Derik Hammer
#TSQL2SDAY (8) Administration (41) AI (11) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
User Groups
Photo credit for Community Wall (above): Pat Wright (t | b) User Groups Rebooted the Hampton Roads SQL Server User Group (t | w)…
-
Row Level Security in SQL Server 2016 CTP2
Earlier this year Microsoft Azure implemented Row-Level Security (Brent’s announcement). In following Microsoft’s cloud-first release concept, this great feature is now part of SQL…
-
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…
-
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.…
-
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…
-
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…
-
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…
-
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,…
-
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,…
-
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…