Ask The Experts, Now!

by Valentino Vranken 1 September 2010 06:26

The Belgian SQL Server User Group is teaming up with Microsoft to organize an “Ask The Experts” event. The purpose of this event is to give you, the SQL Server user, an opportunity to ask Microsoft those things which you’ve always wanted to know but never could find on the internet. The questions are currently being gathered [...]
Click here to see the original post

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: events, community event, data, sqlug

A Developer's Blog

12 + 12 = 24

by Valentino Vranken 31 August 2010 07:36

For the second time this year, the SQL PASS folks are organizing another 24 Hours of PASS, a 24-hour free virtual training event. Each session takes one hour, so there are 24 presentations in total. Instead of putting them right after each other, this time they’ve decided to split the event in half: 12 hours [...]
Click here to see the original post

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: events, community event, data, pass

A Developer's Blog

Calculating LastXMonths Aggregations Using T-SQL and SSIS

by Valentino Vranken 26 August 2010 20:25

With the holidays I haven’t been able to write much. So I’ll make up for it with this +3000 words article. If you’re reading this early in the morning, you’d better get a double espresso first In this article I will demonstrate a method that can be used to calculate aggregations over a certain [...]
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, sqlserverpedia syndication, t-sql, data, ssis

A Developer's Blog

Put Some Images On Those SSRS Reports

by Valentino Vranken 7 July 2010 16:05

On the forums I now and then encounter questions regarding images on SSRS reports. Instead of re-inventing the wheel each time, I decided to write an article about the subject. So in this article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting [...]
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, sqlserverpedia syndication, data, reporting services 2008, ssrs, tutorial

A Developer's Blog

Getting Cooperation From A Stubborn Data Dude

by Valentino Vranken 9 June 2010 19:59

Lately I’ve been using Visual Studio Team System 2008 Database Edition with the GDR R2 add-on, also known as “The Data Dude”, to compare databases with each other. And during a schema compare I noticed that the dude can be quite stubborn now and then. Here’s an example and an explanation of why, as far as I [...]
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, visual studio, data, visual studio 2008

A Developer's Blog

Getting Cooperation From A Stubborn Data Dude

by Valentino Vranken 9 June 2010 19:59

Lately I’ve been using Visual Studio Team System 2008 Database Edition with the GDR R2 add-on, also known as “The Data Dude”, to compare databases with each other. And during a schema compare I noticed that the dude can be quite stubborn now and then. Here’s an example and an explanation of why, as far as I [...]
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, visual studio, data, visual studio 2008

A Developer's Blog

Aggregating Data With The OVER Clause

by Valentino Vranken 1 June 2010 21:12

In this article I will show you a couple of different T-SQL queries to fetch aggregated data. The main purpose is to illustrate how the OVER clause can be used to aggregate data. For the examples I will use data from the AdventureWorks2008R2 database, available at CodePlex. The Data The AdventureWorks 2008 R2 database contains a view called [...]
Click here to see the original post

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: t-sql, data, sql server

A Developer's Blog

Implementing Data Bars In A Grouped Table

by Valentino Vranken 27 May 2010 20:16

Earlier I wrote an article about the new lookup functions that ship with SQL Server 2008 R2. Today I’m going to show you another new feature of SSRS 2008 R2, this time in the visualization department. This feature is the Data Bar. With this new component it’s fairly easy to make your tabular data a [...]
Click here to see the original post

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: reporting services, sqlserverpedia syndication, data, reporting services 2008 r2, sql server 2008 r2, ssrs, tutorial

A Developer's Blog

Looking Up Data On Different Sources

by Valentino Vranken 16 May 2010 12:41

Almost a year ago I wrote a small blog post to ask everyone to vote on a certain Connect item related to the linking of two datasets in a Reporting Services report. At this moment there have been 87 positive votes on the request. Now that SQL Server 2008 R2 has been RTM’ed, it’s time 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: reporting services, sqlserverpedia syndication, data, reporting services 2008 r2, sql server 2008 r2, ssrs, tutorial

A Developer's Blog

Remove Unused Columns From The Data Flow

by Valentino Vranken 12 May 2010 16:25

Consider the following scenario. You’ve been developing some SSIS packages, nicely making sure that all errors and warnings are gone from the Error List window. So the next step is to deploy the packages to the server and schedule them. After some days you decide to have a look at the sysssislog table and discover [...]
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, data, integration services 2008, ssis

A Developer's Blog

Blog N-Technologies

Ask The Experts, Now!

12 + 12 = 24

Calculating LastXMonths Aggregations Using T-SQL and SSIS

Put Some Images On Those SSRS Reports

Getting Cooperation From A Stubborn Data Dude

Getting Cooperation From A Stubborn Data Dude

Aggregating Data With The OVER Clause

Implementing Data Bars In A Grouped Table

Looking Up Data On Different Sources

Remove Unused Columns From The Data Flow

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts