Archives: July 2015
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.
You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more
SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading!
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit,… Read more
Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different.
What I want to describe in this blog post is a method forcing a parent-child… Read more
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The SQL Server Days is the largest SQL Server conference in the Benelux (and maybe beyond :)) and is hosted by sqlug.be. It will be great to see the #sqlfamily… Read more
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version.… Read more
It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited… Read more
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10, 2015
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to the rescue!
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest,… Read more
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of 2012, almost 3 years ago and it has been an amazing ride so far. I’ve apparently gathered almost 1.5 million views (I don’t really trust that figure… Read more
Here is an overview of the articles I published in the secondt quarter of 2015.
I’ve been busy writing tips!
- Purging Entity Members in SQL Server Master Data Services
- Using the Transaction History in SQL Server Master Data…
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog, because I have already been blogging for almost 3 years at the site LessthanDot. I gathered 100 blog posts about business intelligence, SQL Server, Integration Services and other… Read more
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned tables. We’ll see what catches on. In a gist, such a table keeps track of the history of its rows by the use… Read more
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use… Read more