Memory Dumps And Crazy Code Samples

by Valentino Vranken 6 February 2010 10:53

I usually don’t write posts just to mention a link to another site. Except when I’ve come across articles which are so good that I want everyone to know about them. Here are a couple of articles in that particular category. What Does Microsoft Do With Those Memory Dumps? The first one is written by Adam W. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, t-sql, data, fun, memory dump, ssrs

A Developer's Blog

Your First OLAP Report

by Valentino Vranken 24 January 2010 14:28

Introduction This article is aimed at report developers who are used to develop reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Server Reporting Services 2008 with data coming from an OLAP cube running on SQL Server Analysis Services 2008. The OLAP [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, reporting services, data, mdx, reporting services 2008, ssas, ssrs, tutorial

A Developer's Blog

Free SQLUG Evening: Service Broker

by Valentino Vranken 20 January 2010 21:18

What? Service Broker provides queuing and reliable messaging for SQL Server. Service Broker is used both for applications that use a single SQL Server instance and applications that distribute work across multiple instances. Within a single SQL Server instance, Service Broker provides a robust asynchronous programming model. Database applications typically use asynchronous programming to shorten interactive response [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, community event, data, sqlug

A Developer's Blog

List All SSIS Packages Deployed On Your Integration Server

by Valentino Vranken 10 January 2010 22:23

When deploying packages to SQL Server Integration Services, it’s advisable to set up a folder structure so that you can easily distinguish packages belonging to different projects. Furthermore it may be interesting to create subfolders under the main project folder to separate packages according to the different phases in your ETL (Extract, Transform, Load) process. [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: integration services, t-sql, data, etl, ssis

A Developer's Blog

SSMS Showing Incorrect Version Numbers In Object Explorer

by Valentino Vranken 9 January 2010 22:21

Ever since I upgraded to SQL Server 2008 Service Pack 1 I noticed that the Management Studio was reporting incorrect version numbers when connected to Integration or Reporting Services. This incorrect version number is located to the right of the server instance in the Object Explorer. As usual, a picture says so much more than … [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql server, bug, data, integration services 2008, reporting services 2008, sql server 2008, ssis, ssrs

A Developer's Blog

Adding Leading Zeroes To A Number

by Valentino Vranken 6 January 2010 21:17

After having successfully survived the festivities, here I am again, ready for another year of blogging, article writing, forum answering, conference attending, … Happy New Year to anyone reading this!! In this year’s first post I’d like to share my preferred way of adding leading zeroes to a number, useful for any situation where you need to [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: t-sql, data

A Developer's Blog

Publishing Articles On Experts Exchange

by Valentino Vranken 13 December 2009 11:10

Since a while now, about two months and a bit to be exact, I’ve been publishing some of my articles on Experts Exchange. It all started when their Content Coordinator found my blog and convinced me to start doing that, thanks for that Jenn (aka jennhp)! In total I have now six articles published and four [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: general, articles, data, experts exchange

A Developer's Blog

SSAS: Custom format string for “duration” using MDX

by Davy Knuysen 7 December 2009 21:38

I recently struggled with the following challenge in Analysis Services: In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″. bing brought me to the following great article, where Mosha explains how [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: analysis services, bi, excel, mdx, sql 2008 r2, sql server, data

Davy Knuysen

Generating A List Of Dates Out Of Numbers

by Valentino Vranken 2 December 2009 21:57

This post is meant partly as a “reminder to self” but also to show that, if you need to generate a list of dates, all you need are numbers. Oh well, if that doesn’t make sense: read on! One of the undocumented tables of SQL Server is called spt_values and it is located in the master [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: t-sql, data

A Developer's Blog

Reporting On Data From Stored Procedures (part 2)

by Valentino Vranken 21 November 2009 20:59

Introduction In a previous article I announced that I would write a sequel covering how to pass multiple-value parameters from a SQL Server Reporting Services report to a stored procedure. So that’s what I will be writing about in this article. As usual, I will be using the AdventureWorks2008 sample database (running on SQL Server 2008 SP1), [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: reporting services, data, reporting services 2008, ssrs, tutorial

A Developer's Blog

Blog N-Technologies

Memory Dumps And Crazy Code Samples

Your First OLAP Report

Free SQLUG Evening: Service Broker

List All SSIS Packages Deployed On Your Integration Server

SSMS Showing Incorrect Version Numbers In Object Explorer

Adding Leading Zeroes To A Number

Publishing Articles On Experts Exchange

SSAS: Custom format string for “duration” using MDX

Generating A List Of Dates Out Of Numbers

Reporting On Data From Stored Procedures (part 2)

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts