The times they are ae-changing

I have been quite on this blog for a couple of weeks now, and there are a couple of reasons...

Automating installation of Docker & SQL command line tools on Linux

I’ve been getting to grips with Docker SQL Containers on Linux (specifically Ubuntu 16.04) and have found that I’ve been...

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 2

In my previous blog we learnt to connect to Azure subscription by importing azure license setting file. In this blog...

Training and tips to get certified with Microsoft (Part 1)

In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...

SQL Server Unique Constraints With Where Conditions

Imagine we have the following table

Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...

Locks, Blocks, and Isolation Levels

Last week we looked at ACID compliance. This week we dive a little deeper into the Isolation portion, and what...

MSBuild and Azure SQL Database

I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to...

Azure Analysis Services web designer

Microsoft has released a preview of the Azure Analysis Services web designer.  This is a browser-based experience that will allow...

Training and tips to get certified with Microsoft (Part 1)

In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...

SQL Homework – August 2017 – Create a table

If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...