New String Function – TRIM – in SQL Server vNext

As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...

On Stepping Down and Out… For a Bit

For those of you on the Denver SQL Server User Group e-mail list, you probably heard the news I am...

Database snapshots for everyone!

If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots...

Watch the Manual DBA v Automated Deployment Challenge

At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...

Hold The Fort

Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...

Looking Back: 2016 was Awesome!

With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different...

Looking Back: 2016 was Awesome!

With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.
resources.azure.com

To give you an idea why I find...

Clearing Plan Cache in SQL Database (Azure)

Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot...

Running SQL Queries with Visual Studio Code

Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use...