Friday Reading 2017-08-04

It’s a bank holiday weekend here in Ireland so I’m looking forward to having the extra day off. Bought a...

Azure – Storing all cmdlets in a file using Windows Azure PowerShell

Hello friends, windows Azure Powershell has a big library for Azure cmdlets which is very helpful in doing things without...

Beware the automated backup window when running native SQL Server backups in RDS

Beware the automated backup window when running native SQL Server backups in RDS
If you’ve ever fired up an RDS instance...

Checking Your Database Properties–#SQLNewBlogger

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

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