Book – ‘What’s New in SQL Server 2012’ Published

Waaaaay back in 2012, I had the great pleasure of being a technical reviewer of another book, What’s New in SQL Server 2012, authored by Rachel Clements (@RachelClements) and Jon Reade (@JonReade) and published by Packt Publishing. Together, these two authors put together a very nice desk reference of the new features introduced in SQL […]

Read more
SQL Server 2012 SP1 – Endless MsiInstaller Application Log Entries

If you are on SQL Server 2012 SP1 (11.0.3000) and are experiencing higher than normal CPU loads on your machine, please take a look at the Windows Application log for the following: Warning / Event ID 1004 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’, component ‘{0CECE655-2A0F-4593-AF4B-EFC31D622982}’ failed. The resource ” does not exist. […]

Read more
Omaha SQL Server User Group Meeting – 5 Years!

While I have not been active in the Omaha SQL Server User Group (SSUG) for all of its five years, I am proud to be part of an ever-growing SQL Community in the Omaha area. Please be sure to join me on Wednesday, December 5th, at Farm Credit Services America for our last 2012 SSUG […]

Read more
SQL Saturday #165 – Presentation/resource files uploaded

If you attended my SQL Saturday 165 presentation in Lincoln, NE, on October 6th, I have uploaded the materials from that presentation. If you did not attend, please download, review the PowerPoint slides, and contact me with any feedback/questions you may have. You can view the materials either through the SQL Saturday 165 Website (http://www.sqlsaturday.com/165/eventhome.aspx) […]

Read more
SSIS 2012 – Export old version of a deployed project

New in the 2012 version of SSIS is a feature that lets us keep a user-configurable amount of deployed project versions in the catalog. The problem, and the point of this blog post, is that you cannot export an older version of a project without reverting back to that version. This may not be possible […]

Read more
SSIS – Package Configuration Errors (Incorrect Format)

When using package configurations in SSIS (pre-SQL 2012 or SQL 2012 with package deployment models), you may run into the following errors: The configuration entry, “????????????????????????????”, has an incorrect format because it does not begin with the package delimiter. Prepend “\package” to the package path. The package path referenced an object that cannot be found: […]

Read more
Speaking at SQL Saturday #165, Lincoln, NE

Don’t miss out on your opportunity for a day of free SQL Server training! Come join us in Lincoln, NE, on Saturday, October 6th starting at 8:30 AM. The event will be held in Avery Hall on the University of Nebraska-Lincoln campus. There are 6 tracks with each having 5 sessions. That’s 30 FREE sessions […]

Read more