ETL #73–NULL or NOT NULL and SQL Interview Questions

Today is the day after Thanksgiving. There are many things to be thankful so I decided to write a short...

Friday Reading 2016-11-25

Friday again so before I spend a weekend watching sci-fi movies, I’ll be reading:-
Virtue in the Virtual

Tony Davies discusses containerisation...

sqlservr.exe

We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...

Video: Introduction to SQL Server Change Tracking

SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...

AlwaysON database not synchronizing mode SQL service account change

AdvertisementsAlwaysON database not synchronizing mode SQL service account change
Suddenly, one of our alwaysON server databases are went not synchronizing mode.
Errors...

Calculate a semi-additive average in DAX

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...

Happy Thanksgiving

It’s Thanksgiving again here in the United States. Throughout the years, the IT community has been awesome. I have been...

Power BI On Premises Integration with Reporting Services Preview

Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment...

SQL Server Restore to LSN

For this post I want to show you how I recovered to a LSN where I did do this on...

Two Weeks to Live! 360 and VSLive Orlando

A short break in speaking, as I haven’t been on stage since Oct 11.

Now it’s two weeks to Live! 360...