Denial of Service Attack on SSRS?

SSRS 2014 limits the number of simultaneous connections from one user to prevent DDoS, and confuse me… Continue reading

Persistent Divide by Zero Error

SQL Server Reporting Services will always return a divide by zero error when using nested IIf functions in an expression even when you guard against it. Here’s a workaround… Continue reading

Reports with MultiSelect Parameters Not Working

Yesterday your reports were working, today they just display blank pages. Sometimes a security patch can break things, but they’re easily fixed… Continue reading

Use File System Task Results in an Email

Here’s a simple how-to on emailing the results of a batch file execution to some email recipients in an SSIS package. Continue reading

Fill Missing Dates without Loops

A common task Database Developers must perform is to create a query that returns data for a date range. All dates must be returned regardless of if there is data for a given date. This is a solution that is fast. Continue reading

SSIS’s different data types – a history

Have you ever wondered why SSIS has multiple data type systems and asked, “what were they thinking?!” Here’s what they were thinking… Continue reading