|
Author: Derik Hammer
#TSQL2SDAY (8) Administration (41) AI (2) 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)
-
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…
-
Demonstration
/
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…
-
Stored Procedures, Dynamic SQL and Execution Plans
/
Question > If stored procedure execution plans are cached once and then reused, what version of the execution plan is cached for stored procedures…
-
Derik Hammer Presents, Fun with DATETIME
/
As my regular readers might have noticed, I get a lot of my ideas for this blog from my daily life. This post is…
-
Paul Randal, please mentor me
/
Today I’m going to go a bit off schedule and deviate from my usual technical content. Paul Randal (b | t) is the owner…
-
Optimizing for unknown and NULLs
/
The other day I had an interesting conversation about something that sounds counter-intuitive. If NULL means unknown or missing, then does OPTIMIZE FOR UNKNOWN…
-
Active sessions and block duration
/
As a DBA, we all need the ability to take a quick glance at the currently active processes on our servers. A lot of…
-
How to log errors with T-SQL try/catch
/
Today a co-worker of mine (Brad) asked a question regarding the usage of T-SQL’s Try-Catch block. Brad wanted to write to a table every…
-
PowerShell Profile Tips
/
Automation is one of the purposes for using PowerShell. Automation is a funny thing, however. You can perform steps of automation almost to infinity.…
-
Merry Christmas Eve!
/
Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell. That post covered the basics of how to…