I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post You can vote for me at the following URL: http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp Note that you can cast a vote […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Browsing "Web Developer"
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS developer? for the PASS BI virtual chapter. This is great news for the people who couldn’t attend my session at the SQL Server Days and who still want to see it (I hope those people […]
Here is an overview of the articles I published in the third quarter of 2014. INTENSE SCHOOL MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part 2) Book Review: SQL Server 2012 Integration Services Design Patterns MSSQLTIPS Adding Custom Reports to SQL Server Management Studio More Text Analysis with the SSIS Term Lookup […]
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 (twitter) on Big Data (and […]
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 I can consult if it […]
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 as far as I could tell […]
Validation exists to “ensure that the application is robust against all forms of input data” (owasp.org). Invalid data can cause unexpected execution errors, break assumptions elsewhere in your application, introduce errors into reporting, and even let someone hijack your service to attack others (script injection, sending spam, etc). When we’re talking about web form submission, […]
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 for the official data vault certification. […]
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 that hard. My starting point is a […]
Here is an overview of the articles I published in the second quarter of 2014. Intense School 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 1) MSSQLTips Improve SSIS data […]