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

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...

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...

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,...

When Things Go Wrong in Azure

Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...

Automate Parameterising SSIS Connection Managers

Hello!
Back when SQL Server 2012 was known as Denali, one of the new and exciting features released was that all...