Yup, @StrateSQL’s Running for the PASS Board of Directors

Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....

Yup, @StrateSQL’s Running for the PASS Board of Directors

Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...

Microsoft certification changes

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

Where Do We Go To Share?

No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...

Floor, Round, and Ceiling

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

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

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

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

Understanding the new MAXDOP settings in SQL 2016

If you have just begun using SQL Server 2016 or you have been using it for a while now you...

Restore through FULL backup

Problem

A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...