Articles

On this blog you’ll find a mix of typical blog posts and longer articles, usually written in tutorial-style.  This page is meant to contain a list of all the articles, sorted by category.  This makes it easier for everyone to find them and gives an overview of what’s available.

SQL Server

General

Calling A Web Service From SQL Server 2005 (2008/11/11)

Learn how you can get results from a web service inside a stored procedure.  Involves the creation of a custom CLR procedure in C#.

T-SQL

Aggregating Data With The OVER Clause (2010/06/01)

Did you know that you don’t necessarily need to use GROUP BY to aggregate your data by something?  Find out how to use the OVER clause in combination with PARTITION BY and make those queries more readable, easier to maintain, …

Reporting Services (SSRS)

Put Some Images On Those SSRS Reports (2010/07/07)

The article shows you three different ways of adding images to your reports.  If you’re struggling with your images, or you just haven’t done that before: this article is for you.

Implementing Data Bars In A Grouped Table (2010/05/27)

Make your data tables more graphical by using the Data Bar, a new feature in SSRS 2008 R2.  Explains how they can be customized over the different levels of a grouped table.

Looking Up Data On Different Sources (2010/05/16)

Demonstrates how the Lookup functions – new in SQL Server 2008 R2 – can be used to retrieve data from a other datasets to be displayed inside your favorite data region.

Your First OLAP Report (2010/01/24)

Aimed at SSRS developers who are new to reporting off SSAS cubes.  You’re introduced to some typical terms from the OLAP world, shown how to set up your first report with data from a cube and given an explanation on why certain features are working the way they do.

Reporting On Data From Stored Procedures (part 2) (2009/11/21)

Explains how to set up a multi-value parameter in your report and use it in combination with a stored procedure.  Shows how those multi-value parameters are working behind the SSRS scenes.

Reporting On Data From Stored Procedures (part 1) (2009/11/10)

Introduction for people new to SSRS.  Explains how data can be retrieved using a stored procedure.  Starts with an explanation of what stored procedures are, continues by implementing a simple stored procedure call and finishes by adding a parameter to the stored procedure.

Pie Chart Techniques (2009/10/25)

Several techniques on optimizing the pie chart in SSRS 2008.  How to sort the numbers, making it readable by putting the smallest pieces into one separate item, show percentages in the labels, rotate it, put the labels on the outside and how the colors can be customized and even made dynamic.

Chart Optimization Tips (2009/07/20)

Read here about some optimization techniques to improve your SSRS 2008 column charts, such as showing all labels, rotating those labels, making numbers on the Y-axis readable and moving it to the other side.

SSRS and MDX: Detecting Missing Fields (2009/07/06)

Find out how you can retrieve data from an OLAP cube (SSAS 2008) while taking empty cells into account.  It also shows you how to color your data by using customizable thresholds.

The Power Of The Placeholder (2009/04/07)

The Placeholder is a new feature of SSRS 2008 and allows mixing different font styles in one textbox.  Find out how it works.

Integration Services (SSIS)

Importing Excel Data Using Integration Services (2010/04/20)

If you’re looking for a way to get your Excel information imported into a database then this is one for you!  Shows how the SQL Server Import and Export Wizard makes use of SSIS while importing an Excel file.