TSQL Tue 63: Extensible Key Management
It’s TSQL Tuesday! Edition 63 is being hosted by Kenneth Fisher (@sqlstudent144). The topic this month is security, and what a globally relevant topic it is. Target, Home Depot, Blue … Continue reading
What Every DBA and SWE Should Know About EF
ATTENTION!! Some time after writing this original post I joined Pluralsight as an author. My very first course was a 2 hour collection of modules on this very topic. If you have … Continue reading
You say po-tay-toh; I say physical reads
Consider the following hypothetical conversation between two DBAs. Alpha: Hey, take a look at the query running in prod. It’s generating a ton of reads. Omega: 40 thousand reads? That doesn’t seem so high. … Continue reading
TSql Tue 60: Hey Ma, looky here what I learnt!!
Pass Summit has come and gone. I am definitely suffering from the post-PASS blues. My head is all full of interesting stuff but also… I’m exhausted. Hats off to those who are able … Continue reading
TSQL Tue #59: My Heroes
I’m looking forward to reading the TSQL2SDAY posts this month. Hero worship is something I have a bit of a problem with. The problem being, there are way too many … Continue reading
Violating AdventureWorks Dating Policy with Merge, Hash, and Loop Joins
The logical joins (inner, outer, left, right etc) are familiar to any SQL pro. As the optimizer selects the physical join type that will actually perform the work however, this part of … Continue reading
Rolling Upgrade: Synch Mirrors, Log Shipped DR – Lessons Learned
We recently did a hardware/software upgrade of a set of servers participating in synchronous mirroring for HA purposes with a log shipping solution for disaster recovery to a remote location. … Continue reading
HELP! PK is Running out of Identity Values
You never thought it’d happen. Way back when you picked an Int as your PK with an auto-increment identity you said. 2.1 billion inserts?? That’ll never happen. But business exploded. Developers … Continue reading
TSQL Tue #58: Passwords and Registered Servers
It’s TSQL Tuesday!!! The topic was picked by Sebastian Meine over at SQLIty.net who is hosting this month’s edition of the rotating monthly blog party known as TSQL Tuesday. Sebastian … Continue reading
31 Days of SQL Server Management Studio
I have always wanted to do a 31 day series. Something like Kehayias’ 31 days of extended events, or Strate’s 31 days of SSIS. These posts in turn were inspired by … Continue reading
Russ Thomas - SQL Judo 