Friday, September 13, 2013

SQLSaturday 250 - Basic SSIS Best Practices

Thank you to everyone who attended my SSIS best practices presentation today!  I hope that you found it useful and are able to apply something from it to your SSIS development.

Below are links to the slide deck and a ZIP file containing the demos if you would like to try running them on your own. The demo files are set up to run in a C:\SSISDemos\ folder. If you run them from a different location you will just need to modify the paths to the Excel files. The demos also assume that you are running SQL Server locally (localhost), and that will need to be modified if that isn't the case. A SQL script has also been provided in the ZIP file that will create the SSIS_DEMO database and tables that I used.

Please feel free to e-mail me at the e-mail address in the slides if you have any questions or if you need any assistance getting the demos running.

Presentation slides

Demos zip file

Monday, June 10, 2013

2013 Municipal Primary: Means vs Harris

Sue Means defeated appointed incumbent Councilwoman Krista Harris for the Republican nomination for Allegheny County Council District 5.  With no Democratic candidate on the ballot, unless another candidate received a sufficient number of write-in votes, Sue Means will be the only candidate on the ballot in the November election.

Full Results (Excel)

2013 Municipal Primary: Kress vs McMullen

Former County Councilman Ed Kress of Shaler handily defeated Mike McMullen of Hampton to earn the Republican nomination for Allegheny County Council District 3.

Full Results (Excel)

2013 Municipal Primary: Baker vs Drozd

In the Republican primary to represent Allegheny County Council District 1, North Hills School Board Director Tom Baker defeated two-term incumbent Councilman Matt Drozd.

Full Results (Excel)

Saturday, April 27, 2013

Creating maps in SQL Server Reporting Services - SQLSaturday #193

Thank you to everyone who attended my presentation on using spatial data in SQL Server Reporting Services (SSRS) today! I hope that I was able to show everyone at least one new thing that they will be able to use in their own reports in the future.

I have included a link below to my PowerPoint slide deck, a (SQL Server 2012) backup of the database, and the shapefiles that I used. The slides have notes that might be helpful, particularly the demo slides - I have included step by step instructions that you can use to walk through the demos again.

Presentation file downloads (zip file)

Please e-mail me with any questions that you might have, and also please feel free to connect with me on LinkedIn if you're on there.

Thank you!

Saturday, November 10, 2012

2012 General Election: PA Senate 37th Senatorial District

A late replacement on the ballot after the original Democratic party candidate Greg Parks dropped out for "personal reasons", State Representative Matt Smith defeated former Mt. Lebanon Commissioner D. Raja by five points.

Full Results (Excel)

2012 General Election: PA House 30th Legislative District

An open seat as a result of the election of Randy Vulakovich to the State Senate in the August special election, Pennsylvania's 30th Legislative District saw a competition between community leader and elder law attorney Hal English, and newcomer David Tusick.  Despite getting a late start in the race as replacement on the ballot for Senator Vulakovich, English defeated Tusick by a margin of almost 15 points.

Full Results (Excel)