Friday, November 25, 2011

2011 Municipal Election: Allegheny County judicial results

Allegheny County results reflected state-wide results, in which Democrat David Wecht was elected to the Pennsylvania Superior Court while Republican Anne Covey won a position on the state Commonwealth Court.

Superior Court Results (Excel)

Commonwealth Court Results (Excel)

Superior Court:

Commonwealth Court:

Monday, November 21, 2011

2011 Municipal Election: Allegheny County Treasurer

Incumbent County Treasurer John Weinstein defeated Ned Pfeifer to retain his position.

Full Results (Excel)

Sunday, November 20, 2011

2011 Municipal Election: Allegheny County Controller

Former State Representative Chelsa Wagner defeated Robert Howard to become Allegheny County's next Controller.

Full Results (Excel)

2011 Municipal Election: Allegheny County Executive

Former County Councilman Rich Fitzgerald defeated businessman D. Raja by 24% to become Allegheny County's next Chief Executive.

Full Results (Excel)

Sunday, October 23, 2011

Basic SSIS Best Practices

Thank you to everyone who attended our SSIS Best Practices presentation today! We hope that you found it useful and are able to apply something from our presentation to your SSIS development.

Below are links to our slide deck and a ZIP file containing our 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 we used.

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

Presentation slides

Demos zip file

Also, there was a question about importing data from Excel with SSIS on a 64-bit server and the Microsoft Access Database Engine 2010 Redistributable (ACE OLE DB driver). The download is available from Microsoft at:

Tuesday, May 31, 2011

2011 Municipal Primary: Flaherty vs Fitzgerald

On the Democratic side of the ballot, former County Councilman Rich Fitzgerald edged out Country Controller Mark Patrick Flaherty based largely on the strength of his results in the City of Pittsburgh.

Full Results (Excel)

Monday, May 30, 2011

2011 Municipal Primary: Kress vs Heidelbaugh

Heather Heidelbaugh defeated appointed County Councilman Ed Kress for the Republican nomination for the Allegheny County Council At-Large position.

Full Results (Excel)

2011 Municipal Primary: Raja vs McCullough

D. Raja won the Republican nomination for Allegheny County Executive convincingly over County Councilman Chuck McCullough.