-
Recent Posts
Recent Comments
- Andras on Turning a Sonos into an AirPlay device
- 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]
Archives
Categories
Microsoft Blogs
SQL Blogs
Meta
Tag Archives: SQL Server
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