Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong
Doing things by the book isn’t necessarily the only way to learn a new skill. Sometimes, experiencing everything that can...
2012-02-28
4,125 reads
How’s Microsoft doing with community involvement? (updated)
Update: Jen Lussier has blogged a summary of the talks she had at the MVP summit last week. Take a...
2012-02-28
1,616 reads
A Script A Day - Day 24 - Object Qualification
Today’s script is one I use as an example to explain that there is method behind my standards that some...
2012-02-28
1,523 reads
SQL Server 2008/2008 R2 Diagnostic Queries for March 2012
Since it is nearly March, I will go ahead and jump the gun by a few days and post an...
2012-02-28
1,856 reads
Monday Morning Mistakes: Not Setting Memory Limits
Welcome back to another addition of Monday Morning Mistakes series. Today’s issue is one I tend to run into quite...
2012-03-12 (first published: 2012-02-28)
42,480 reads
Converting SQL SERVER DateTime? Test it thoroughly….
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,295 reads
Presenting at SQL Saturday #110
On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-02-28
1,410 reads
SQL Server Agent Job Steps
To list a SQL Server Agent Job Steps use the T-SQL example below.
This example displays the step id, SQL Server...
2012-02-28
1,987 reads
Learn Mirroring with me at SQLRally
I just found out that I will be speaking at SQLRally Dallas in May. I submitted 3 sessions. As an...
2012-02-27
674 reads
I’m Going to SQL RALLY!
Hello Dear Reader, I’ve just received great news I’M HEADED TO SQL RALLY 2012! But I didn’t get here on...
2012-02-27
765 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers