Here is an overview of the articles I published in the third quarter of 2014.
- MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part 2)
- Book Review: SQL Server 2012 Integration Services Design Patterns
Ada Lovelace has been an inspiration to many. In keeping with my blog theme, let’s call her a hero. We all have our heroes, those people who…
Some time ago I was writing some windowing functions on a set of data. Basically I was looking for the last date an event had occurred for each type of event. Let’s illustrate with an example:
CREATE TABLE dbo.TestOver (ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL ,[Group] CHAR(1) NOT NULL…
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers! My session went pretty well, somewhere around 60 attendees I would guess and they didn’t seem too bored. I saw some other great sessions as well, such as Buck Woody… Read more
Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text.
Note that this is not an… Read more
After quite a while it has finally returned: another Stupid Me™®©! A reminder:
Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I’ll have a solution online… Read more
After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh Nandeshwar. The book is published by Packt but I am relieved to say this time there were no significant editing issues. In fact it is quite well written and… Read more
A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a local training provider. As part of the training, I received the book Modeling the Agile Data Warehouse with Data Vault written by Hans Hultgren who also is an instructor… Read more
With “Matrix Infographic” I simply mean those infographics FiveThirtyEight (site | Twitter), the website of statistic revelation Nate Silver, uses to display forecasts of World cup matches. An example:
I was wondering if something similar could be built using SSRS. And yes, it is possible and it isn’t… Read more
Here is an overview of the articles I published in the second quarter of 2014.
- MCSE Prep: The Integration Services Package and Project Deployment Models—Part 1
- MCSE Prep: The Integration Services Package and Project Deployment Models—Part 2
- MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part…
I received this book through the O’Reilly blogger review program, which I already mentioned in the review of Thinking With Data. The actual publisher of the book is Packt Publishing, not O’Reilly itself.
TABLEAU DASHBOARD COOKBOOK
I guess most people who have been in contact with the… Read more
I am absolutely delighted to share the great news that I have been selected as one of the speakers for the 2014 edition of the SQL Server Days in Belgium. It is one of the biggest SQL Server events in Europe and this will be the 4th time I am… Read more
ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very big thank you and “well done” to the organizers. It has been a great gathering of the #sqlfamily, with superb sessions about Azure, restoring databases with PowerShell, Hekaton… Read more
Once considered tedious, the field of statistics is rapidly evolving into a discipline Hal Varian, chief economist at Google, has actually called “sexy.” From…
A few days ago there was an interesting question on the forum:
How can I get None in each cell of a table in the report if no rows are returned? If I use “No rows message” property, header is not displaying on the report but I would like to…
I’m delighted to announce I will be giving a session at ITPROceed, a new event in Belgium for the IT Professional. From their website:
ITPROceed is a joint effort between the ITProfessional User Groups with the strong support of Microsoft to bring you the best on the Cloud OS,…
First I thought about writing a rant about the beginning of every interview and hiring process: recruiters. You can’t live with… Read more
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:
515: A database error has occurred. Please contact your system administrator
Too bad I am the system administrator on that machine…
Anyway, after some searching it came… Read more
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an overview from time to time to keep track of all the published material. It makes it easier to follow and it’s also a chance for me to… Read more
I had to do some performance testing for an upcoming MSSQLTips article and I thought I’d share the framework I used in a blog post.
First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a… Read more