SQL Server
Blogs

This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be...

Earlier this year I got embarked on a book project together with Joost Van Rossum ( B | T ) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend...

Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will,...

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask? One of the dev groups I support has been referring to their instances as...

Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect.
Consider the following two tables in an Excel worksheet, called ColourFruit and FruitPrice...

If you want to jump straight to the condensed solution, then please feel free to go to the Condensed Installation instructions below. If you find this post useful or have any feedback then please leave me a comment so that I know my efforts were not wasted...

Welcome to part 3 of a 3-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early March 2015 and is subject to change as the Power BI Preview evolves. Part I: Overview of Using Analysis Services Data in the...

I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. This isn’t...

For many years, the Danish SQL Server User group (under the PASS umbrella) has been stagnating !! So much stagnating that other successful initiatives have started.
Some of my fellow members and myself really want to reinvigorate this group, which had...

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!). There is no getting around it – blogging...

For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait...

Last Saturday I attended #SQLSATRVA , which was SQL Saturday #381 . It was a blast! The day started off with the usual registration process. Thankfully, I remembered to print out and cut my SpeedPass in advance. The line to use the scissors was ridiculous...

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
Tables and Schemas in the data warehouse
Dimensions and Slowly...

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I actually submitted a session. This is the first time I’ve ever submitted something for the summit and only the third time I’ve submitted...