Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up a project where the data warehouse needed to be fully in the cloud. This was an Azure SQL Database, not Azure Data Warehouse. The size of the DWH was just not big enough (although Microsoft […]
Author: Koen Verbeeck
Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.
SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error: A .NET Framework error occurred during execution user-defined routine or aggregate “deploy-project-internal”: System.Data.SqlClient.SqlException: The locale […]
Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher. Title: Supercharge Your SQL Server Data Warehouse […]
The times they are ae-changing
I have been quite on this blog for a couple of weeks now, and there are a couple of reasons for this. First of all, it’s the holiday season and I need some rest too 🙂 Secondly, I have changed jobs since the 1st of August 2017. This means a lot of ongoing projects had […]
Microsoft Professional Program in Data Science – Continued
A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve now finished the remainder of the courses. Now I only need to finish the capstone project. This project only occurs at the start of each quarter and runs for a month. The next runs are […]
Where’s the Trend Line in Power BI Desktop?
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it is in the analytics pane for certain types of visualization. However, it doesn’t always show up: (I really resisted the urge to post another “Dude, where is my car” image) So why did the trend […]
Microsoft Professional Program in Data Science – The Road So Far
I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the price from $49 to $99 for some […]
Power BI Announcements Summary
It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well. POWER BI DESKTOP Again an amazing release (May 2017). Noticeable features are: Measures on top of live SSAS Tabular connections! I’ve been […]
Book Review – The Truthful Art
I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about data visualization and we post our thoughts online. A blog post with more detail: Introducing our Data Viz Book Club. The first selected book is The Truthful Art by Alberto Cairo (blog | twitter). I’ve always […]
PASS BA Marathon – Spring Edition Q&A
The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar went great (lots of great feedback!) and there were a lot of interesting questions. You can find the recording here. Since I didn’t have the time to answer all questions, I’ll tackle them in this […]