An Update on My 2012 Mac Air

Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m...

Check Database Server Workload - Batches/ Sec

Today's post is about a simple but very useful query.

One of the basic things one needs to check is the...

Diff All Files - Reviewing Changesets Quickly

Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...

Diff All Files - Reviewing Changesets Quickly

If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...

Power BI Desktop hosted on premises with SSRS 2016

UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...

So Long, Farewell, I Hate to Say Goodbye

The Sound of Music is one of my all time favorite movies.  It reminds me of some great times with...

SQL Live Health Check - part 3 - permission requirements and the rest

This is the last part of the series, where I discuss about the monitoring application that I build. If you...

Stretch Databases in 60 seconds

SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...

Stretch Databases in 60 seconds

SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...

The Snippet Manager in SQL Prompt

I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet...