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, […]
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"
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 […]
DISCLAIMER 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 SQL Server community have at least heard […]
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 get headers along with “NONE” […]
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, System Center, SQL, Office 365, Windows […]
It’s time for another T-SQL Tuesday! This month’s blog party is hosted by Boris Hristov (blog | twitter) and the subject is about interviews and hiring. First I thought about writing a rant about the beginning of every interview and hiring process: recruiters. You can’t live with them and you can live without them. But […]
I use a continuous testing tool named NCrunch for all of my .Net code. In fact, NCrunch has spoiled me so much that manually running tests is bordering on painful. I’ve gotten used to doing absolutely nothing and still having the latest build results, test results, code coverage, highlighted execution paths for failed tests, and […]
Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this: For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the United States. In Belgium (and other […]