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