SQLpassion Online Training in October 2017

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Distributed Writes

In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out...

Recover Deleted Data from SQL Table Using Transaction Log and LSNs

Introduction
At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition....

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in...

Test Database Compatability with dbatools

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and...

Does rebuilding my clustered index also rebuild my non-clustered indexes?

I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered...

An open letter to the PASS community (2017)

PASS is our community.

It may sound a little cliche, especially with the current political climate in the US and other...

Do what I say, not what I do

I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...

Hmmm… What’s This?

OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...

TSQL2sDay – Get-PostRoundup

First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...