Challenge Accepted

My life for the last 2 years has been a constant battle of putting out fires with system performance; finally...

DBCC CHECKFILEGROUP

Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...

Future DBA Part 1

As I stated in my earlier blog on future DBA, we should learn many things as we can to be...

PowerShell to create Azure SQL DBs

Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...

SQL Saturday Minneapolis Precon – Complete Primer to SQL Server Virtualization – Coming Soon!

This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the...

SQL Server Execution Plan formats

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL...

SSRS Mobile Reports – JSON error

Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS...

The SQL Server Community Collaborative GitHub Organisation is born

My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...

This Week In Data – Episode 4 (What is Slack?)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Azure: Creating a BACPAC from an On-Premises SQL Server Database

So to start, what’s a BACPAC?

Per the Azure documentation
When you need to create an archive of an Azure SQL database,...