Synchronizing NOT NULL Columns

Applies to: xSQL Schema Compare v7.0.0 – v 9.0.0, xSQL Data Compare v7.0.0 – v9.0.0

Description: Using xSQL Schema Compare and xSQL Data...

VOTE!!! PASS Board of Director Elections

It is voting season again, and there is a great group of individuals running for the Board of Directors of...

Documenting your Tabular or Power BI Model

If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...

Floor, Round, and Ceiling

I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...

Microsoft certification changes

A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...

MOSL – Memory Optimised Scripts Library

SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...

Notes about Postponing SQLSaturday Orlando Due to the Hurricane

We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want...

Overview of Published Articles – 2016Q3

Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...

SQL Live Health Check - part 2 - historical data and configuation

In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the...

Studying Failures

Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...