Living The SQL Life, Spring 2014 Edition

Saturday March 29th: SQL Saturday #287 in Madison, WIsqlsat287_web

Tuesday April 1st: PASSMN Tabletop Gaming and Pizza Night (No Foolin’)

logo

Saturday April 26th: SQL Saturday #291 in Chicago, IL

sqlsat291_web

 

Continue reading

Advertisements

Living The SQL Life, October 2013 Edition

Saturday October 12th: SQL Saturday #238 in my own back yard.

sqlsat238_web

Monday October 14: I will be attending Redgate’s SQL in the City Charlotte, NC.

sqlinthecity

October 15-8: My first time attending the PASS Summit!

summit

On Saturday October 19th: I will be presenting at SQL Saturday #237 BI Edition in Charlotte, NC.

sqlsat237_web

Continue reading

Living The SQL Life, Winter 2013 Edition

End of last year: I switched to the consulting world and I am now an Information Management Consultant at Digineer.

digineer_Logo

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.

sqlsat206_web

On Saturday April 11th: I will be presenting at SQL Saturday #211 in Chicago, IL.

sqlsat211_web

Continue reading

Business Intelligence 201

SQL Server MVP Deep Dives 2, Chapter 60

BI Solution Development Design Considerations– by Siddharth Mehta (B|T)

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.

Figure 1 Typical BI design for an OLTP-to-dashboard solution from Chapter 60 of SQL Server MVP Deep Dives V2

Continue reading

Living The SQL Life, Fall 2012 Edition

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.

Friday 10/19: SQL Friends with Dan English (B|T)  at the Edina Grill.

 

Next Month : I am Running for the PASSMN Board. Vote for Mike! You know if we have to vote or anything.

Continue reading

Using the SSIS Scripting Task to Geocode Addresses

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