Adding a VLDB database to an SQL Server Availability Group

Recently, I was tasked with making an 60TB database highly available by adding it to an availability group. The following,...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Nesting Aggregates with Window Functions

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....

Studying for the 70-462 Exam: Database Mirroring

If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...

Monitoring SQL Server on a budget

Monitoring SQL Server on a budget

Cheap ain’t easy
There’s a lot of tools out there, and very few that are polished,...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Are you Ready to Use Power BI?

What! NO? Get with it, my friend.  Power BI is for everyone.  All the kids are doing it… not to...

Zero to hero in SSIS (SQL SERVER Integration Services) TIP #110

Recently, Many friends of mine are interested in learning SSIS so , I thought to write some blogs which might help...

SQL Saturday #403–Louisville

This weekend I’ll be attending SQL Saturday #403 in Louisville, KY. If you’re in the area, think about taking a...

Ignore a warning on a dacpac reference at your peril

I worked on a project where we had two SSDT projects with different versions of SQL, one 2012 and one...