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 […]
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. […]
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 […]
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) […]
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 […]
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: […]
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 […]
