Installing a Visual Studio Team Services private build agent hosted On-Premises

This blog post is about a situation where I  use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...

Retrospective analysis of SQL Saturday South Island (#sqlsat614)

Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...

Why Did Your Availability Group Creation Fail?

Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly the easiest thing in the world to pull off...

Why Did Your Availability Group Creation Fail?

Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly...

2 Great Courses For Databases Professionals - Deal Of the Week

I received  the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education...

DevOps Basics– git Cloning Repos

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Database File Wise Disk Space Monitoring

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...

When should I add an index?

We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we...

Microsoft Data Amp event announcements

Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:
SQL Server vNext CTP 2.0...

Resolution to “Connection Timeout Expired. [Pre-Login] initialization =18090; handshake=14281” error

This blog post is about a SQL Server connection issue that presents itself:

We were building an Availability Group (AG) at...