SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live action? You can watch my MSSQLTips.com webcast on-demand where I demonstrate this trick. Start watching at around minute 38. Lately I have been using more and more the awesomeness of the Alt-button in SQL Server […]
Tag: sql server
The SSDT Evolution
When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects. If you have a full blown Visual Studio installation, you needed the BI templates; if you didn’t have Visual Studio (or the right version), you would install a shell that could […]
Reblog: How I prepared myself for the MCSE certification
SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today. Last week (this is a repost, so not actually last week but over 2 years ago) I […]
My favourite books
As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in the Spotlight section on the site, where a speaker can introduce him/her self by answering a simple survey. One of the questions is “Which SQL Server […]
Reblog: What’s the deal with Excel and SSIS?
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, because numerous issues can rise […]