Default Database Reports – Disk Usage by Table

Every now and again you need to know how big a table is. Or several tables. Or all of the...

SQL Server 2016 helps with Best Practices

In order for your SQL Server instance to run optimally, there are many SQL Server best practices that you need...

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

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

Default Instance Reports – Configuration Changes History

Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...

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

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