|
Author: Derik Hammer
#TSQL2SDAY (8) Administration (41) AI (10) 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)
-
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…
-
DING – LEVEL 2 !!!
/
DING – LEVEL 2 !!! I am excited to announce that I have achieved level 2 in My Epic Life Quest. My epic life…
-
Start and Save Hyper-V VMs with PowerShell
/
I use Windows 8 or Windows Server 2012 R2 on most of my local workstations between home and work. In order to conserve memory,…