T-SQL Tuesday #90 — Bringing Continuous Delivery to a ‘brownfield’ database system

This blog post is part of  T-SQL Tuesday #90 – Shipping Database Changes.
I have decided to write about  a client’s SQL...

Creating an App Service in Azure that connects to an Azure SQL Database.

Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...

Removing an Azure SQL Database using PowerShell..

In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning...

Moving Azure resources between subscriptions – especially VSTS Team Services Account

For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...

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...

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...

Can I tune the tempDB of an Azure based SQL Server database…

Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...

How to grow the exposure of a Data Platform based conference (SQL Saturday South Island)

SQL Saturday conferences are awesome.
That is the opening line of this blog post – because it’s true and understated.
If you’re reading...

Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”

This blog post is a form of resolution to the issue of not being able to shrink a transaction log...