blog community

Mark Streutker

Sort by: Most Recent | Most Viewed | Most Commented

  • Speeding things up in SSIS, literally

    Anyone who works with SSIS on a regular basis knows that there are many roads that lead to Rome. A datasource, for example, can be configured in a few different ways. One possibility is by using a parameterized query to retrieve data from a database,...
    Published 31-05-2010 21:29 by marks
    Filed under: , , ,

  • Modify Reporting Services Export to CSV behavior

    Aside from the default HTML rendering, SQL Server Reporting Services (SSRS) supports rendering extensions as well. You can write your own extension if necessary, or you can use one of the rendering extensions that are included in SSRS . These default...
    Published 18-04-2010 19:56 by marks
    Filed under: , ,

  • Report Builder 2.0 security extension issues

    One of the ways to add more flexibility to your SQL Server Reporting Services (SSRS) is to extend SSRS with custom extensions. SSRS supports a wide variety of extensions that serve different purposes, i.e. the custom data extension to manipulate a connectionstring...
    Published 29-03-2010 21:13 by marks

  • Handling EAV-data: Timelines

    As promised in my previous post about working with EAV-data this post would about handling multiple timelines (or periods for that matter). While this blog is specifically written for an EAV-environment, the technique explained in this post can be useful...
    Published 22-02-2010 19:29 by marks
    Filed under: , , ,

  • Is ISNUMERIC numeric?

    In SQL, if you’re not sure if a value can be cast to a certain datatype there are some built-in functions that can help you out. Take the following construction, where col_Value is a CHAR(4): 1: SELECT CASE ISNUMERIC (col_Value) 2: WHEN 1 THEN CAST...
    Published 30-10-2009 20:14 by marks
    Filed under: , ,

  • Handling EAV-data

      In my line of work I often have to develop reports on all kinds of environments, but most of the time the underlying databases are limited to relational or dimensional models. A few months ago, however, I was faced with the tedious task challenge...
    Published 01-06-2009 18:38 by marks
    Filed under: , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems