Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,333 reads
Free SSIS Tips and Tricks Webinar
On Thursday of this week I will be presenting a webinar for Pragmatic Works Free Training on the T’s. I...
2013-10-02
949 reads
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,046 reads
Enable Instant File Initialization to accelerate database restore
Today my colleague come to me and ask me why her database restore query was hang. She was going to...
2013-10-01
1,275 reads
I’m a Microsoft SQL Server Most Valuable Professional (MVP)!
I have been honored to be chosen a Microsoft SQL Server Most Valuable Professional (MVP). Here is a video on my...
2013-10-01
2,360 reads
Awarded Microsoft MVP
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
702 reads
What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted to share my thoughts with you here. Since I only...
2013-10-01
40 reads
What’s the Age Limit for Becoming a DBA?
I received an email from a nice chap recently, concerning a subject that I’m often asked about and I wanted...
2013-10-01
1,187 reads
PowerShell – Script to Monitor Disk Space of a Group of servers – HTML Formatted Email Output
This post explains how to monitor DiskSpace of a group of listed servers in a text file.
The function Get-DiskSpaceReport comprises...
2013-10-01
4,410 reads
Stupid me #3 – Building the script component
After over 6 months of silence, it is time again for another Stupid me™®©! For those unfamiliar with the concept:
Every...
2013-10-01
367 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...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers