Saturday March 29th: SQL Saturday #287 in Madison, WI
Tuesday April 1st: PASSMN Tabletop Gaming and Pizza Night (No Foolin’)
Saturday April 26th: SQL Saturday #291 in Chicago, IL
Saturday October 12th: SQL Saturday #238 in my own back yard.
Monday October 14: I will be attending Redgate’s SQL in the City Charlotte, NC.
October 15-8: My first time attending the PASS Summit!
On Saturday October 19th: I will be presenting at SQL Saturday #237 BI Edition in Charlotte, NC.
End of last year: I switched to the consulting world and I am now an Information Management Consultant at Digineer.
Earlier this year : As of January 1, 2013 I was assigned the role of Director of Program Development for the PASSMN Board. We’re looking for a few good SQLGeeks to present.
On Saturday April 6th: I will be presenting at SQL Saturday #206 in Madison, WI.
SQL Server MVP Deep Dives 2, Chapter 60
This is the first chapter in Deep Dives V2 that I read which felt like I was reading a textbook. I really wanted this chapter to be something I could hand to a manager, DBA, or developer who hadn’t worked on a Business Intelligence project and they would come away with a good understanding of what it was and all of the pieces needed to build it. Essentially I wanted something the me from 3 years ago could have read and not have to learn everything on the job.
Last month: I published an article on SQLServerPro called Combining CDC and SSIS for Incremental Data Loads.
This Saturday 9/29: I will be presenting at SQL Saturday #149 in my own Twin Cities.
Next Month : I am Running for the PASSMN Board. Vote for Mike! You know if we have to vote or anything.
In February I was lucky enough to see Brian Larson give a talk on GeoSpatial visualization using SSRS at the PASSMN meeting. He showed us how to use the Map Wizard in SSRS to quickly create some cool reports. As he was looking up the latitude and longitude for the addresses I remembered a project I had worked on using SSIS and Google Maps to geocode data. For the March PASSMN Meeting I agreed to share some information on the Scripting Task in SSIS and I decided to use the geocode example. Since I was giving this presentation in a Microsoft building I changed from Google to Bing. Leave out having to learn the Bing API in a couple of days the package for doing this is pretty straight forward. A SQL Task to get the address information is passed to a For Each Loop that runs the script for each address. The Loop updates the Lat and Long and then a final SQL task to create the geospatial points in the database. Continue reading