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

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

Retrieving Data From Excel

by Valentino Vranken 29 March 2010 20:16

The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who’s ever used a computer for a significant amount of time has probably come into contact with Excel, the spreadsheet application part of the Microsoft Office suite. Its [...]
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, data, excel, t-sql

A Developer's Blog

Recursively Delete SSIS Folder

by Valentino Vranken 28 February 2010 22:12

A while ago I posted a query to create a list of all the Integration Services packages deployed to the MSDB. I am now using that query to take it a step further. If you’ve been using SSIS for a while you’ve probably noticed that the Management Studio doesn’t like to delete Integration Services folders that [...]
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, script, ssis

A Developer's Blog

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

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

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

Currently rated 3.0 by 5 people

Currently 3/5 Stars.
1
2
3
4
5

Tags: t-sql, data

A Developer's Blog

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

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: t-sql, data

A Developer's Blog

Fun With Strings

by Valentino Vranken 4 October 2009 11:07

Initially I was going to call this article "Struggling With Collation: The SeQueL", but it just doesn’t have the same ring to it as "Fun With Strings". In that previous article I showed how you might get different results when loading data from a temporary table or table variable and I suggested that one way [...]
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, t-sql, collation, data, integration services, ssis

A Developer's Blog

Script: find all empty columns in database

by Valentino Vranken 15 February 2009 21:06

Earlier this week a colleague had an interesting question. He was working on an application that uses a database containing more than 200 tables and wanted to find all columns in the database where this column is null for all records, so in other words all empty columns. This would give him an idea of [...]
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, script, sql server

A Developer's Blog

Blog N-Technologies

Calculating LastXMonths Aggregations Using T-SQL and SSIS

Aggregating Data With The OVER Clause

Retrieving Data From Excel

Recursively Delete SSIS Folder

Memory Dumps And Crazy Code Samples

List All SSIS Packages Deployed On Your Integration Server

Adding Leading Zeroes To A Number

Generating A List Of Dates Out Of Numbers

Fun With Strings

Script: find all empty columns in database

RecentPosts

Blog N-Technologies

Tag cloud

RecentPosts