-
Recent Posts
Recent Comments
- bala on Configuring SQL Server to use Managed Service Accounts (in PowerShell)
- Eduardo on Database Corruption Challenge Part 1
- BPOTW – 2015-05-15 | SQL Notes From The Underground on Debugging Long-Running SQL Queries
- Robin on Bike Tour Business Intelligence: Part 6 [Building the Fact Table]
- BPOTW 2015-03-21 | SQL Notes From The Underground on Bike Tour Business Intelligence: Part 4 [Populating a staging table]
Archives
Categories
Microsoft Blogs
SQL Blogs
Meta
Category Archives: SSIS
Bike Tour Business Intelligence: Part 6 [Building the Fact Table]
At this stage the BI database contains the Date, Time and Location Dimension tables as well as a staging table with all the points captured by my GPS. This post covers creating and populating the Fact table, as well as … Continue reading
Posted in SQL Server, SSIS
2 Comments
Bike Tour Business Intelligence: Part 5 [Dimensions]
Our star schema has three dimensions – Date, Time and Location. This post will cover populating the dimension tables in preparation for cube generation. Date Dimension There are lots of date dimension generation scripts online, Mike Davies’ script is good, … Continue reading
Posted in SQL Server, SSIS
Leave a comment
Bike Tour Business Intelligence: Part 4 [Populating a staging table]
A quick recap of the series so far: I’m building a cube using the data recorded by my Garmin Edge GPS during a 4 month bike tour last across Europe last year. So far we’ve analysed a single GPX file … Continue reading
Posted in SQL Server, SSIS
1 Comment
Bike tour Business Intelligence: Part 3 [Reverse Geocoding]
In Part 2 I modified the SSIS data flow to add a column containing the position of each trackpoint read from the GPX file in the SQL Server spatial type geography . Part three investigates SQL spatial types further and … Continue reading
Bike Tour Business Intelligence: Part 2 [Geography]
My previous post covered using SSIS to read XML from a GPX file saving the data to a new table in a SQL Server Destination. This post will cover extending the SSIS workflow to create spatial data; the next on … Continue reading
Bike Tour Business Intelligence: Part 1 [Reading GPX files with SSIS]
Last year I spent the summer riding my bike across Europe, clocking up 6100km through 7 different countries. Riding through the countryside with the wind blowing through your hair is a great feeling and I had a fantastic time. Now … Continue reading