Running Linux Containers on Windows

Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container...

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

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

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

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

Are your indexes being thwarted by mismatched datatypes?

In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...

Manually updating Statistics

Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...

Power BI Custom Visuals Class (Module 60 – Drilldown Player)

In this module you will learn how to use the Drilldown Player Custom Visual.  The Drilldown Player acts like a...

RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...