SQL – Scripting out DB Mail Config with PowerShell and SMO

Fellow MVP Jonathan Kehayias has a post on scripting out the Database Mail configuration with PowerShell and SMO. While this solution looks perfect, there is a bug in the Mail.Script() output, not mentioned in Jonathan’s post except for one reader’s comment, that does not script out the SMTP server name and port number. (Note, that […]

Read more
Quick Tip – Run SSIS 2012 packages synchronously and other execution parameters

In the new SSIS 2012 catalog’s project deployment model, by default if you execute a package with the Execute Package control flow task, or through the new API’s start_execution, the call will be made asynchronously. In order to call the package synchronously, and therefore keep the caller waiting until the package finishes, you have to […]

Read more
SQL Saturday #165 – Lincoln, NE

On Saturday, October 6th, 2012, please plan on attending SQL Saturday #165 in Lincoln, NE, at the University of Nebraska-Lincoln’s main campus. This SQL Saturday is shaping up to be a great event with several high-caliber speakers from around the Omaha/Lincoln area, as well as some from surrounding states. The event is hosted by the […]

Read more
SSIS 2012 – Beware the SSIS Server Maintenance Job

Those of you running SSIS 2012 may not yet be pushing the limits of the RTM release, and while I can’t tell you where the limit boundary lies, I can give you advanced notice about a fairly big problem. The entire SSISDB catalog is linked together via foreign keys, most of which are all linked […]

Read more
Connecting to a pre-SQL 2012 SSIS Instance with SQL 2012 SSMS

If you are using SQL Server Management Studio in SQL 2012 to try to connect to an older SSIS instance (SQL 2008 R2 and earlier) called “SSISServerName”, you will get an error: Connecting to the Integration Services service on the computer “SSISServerName” failed with the following error: “Class not registered”. This error can occur when […]

Read more