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

SELECT…INTO in SQL Server 2017

One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...

TechMentor Dine Around

Next week I’ll be speaking at TechMentor in Redmond, I’m doing a 1/2 day workshop on Linux OS Fundamentals for the Windows Admin be sure to come see me!
If you’re...

TechMentor Dine Around

Next week I’ll be speaking at TechMentor in Redmond, I’m doing a 1/2 day workshop on Linux OS Fundamentals for...