|
Category: Uncategorized
#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)
-
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…
-
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…
-
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…
-
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…