SQLpassion Online Training about Availability Groups

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

Understanding ANOVA

ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...

Using Backup-DbaDatabase for a Quick Backup

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

More Notes on Non Profit Status

Following up on my post about forming a non profit here in Orlando, here are some notes that might help...

This Made Me Laugh: SQL v NoSQL

It’s a humorous history lesson on SQL (and product promotion), but it opens like this:

SQL awakens to fight the dark...

What is DBCC CLONEDATABASE ?

DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used...

Your Name is Your Brand

This topic is one that has been stewing for a while and finally this week it decided to boil over.
My...

Your Name is Your Brand

Building your brand is not an overnight sensation. It does take a while and possibly a bit of luck here or there along the way. The one thing it...

Extracting Deadlock information using SYSTEM_HEALTH Extended Events

Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...

Getting the Random Module in SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it,...