February 2012 - Posts

• Variable enhancements in RC0 [SSIS]

  I have been poking around idly in the RC0 release of SQL Server Integration Services (SSIS) 2012 and noticed a few nice enhancements that hadn’t really hit the newsstands as yet (well, I didn’t know about them anyway). Here is a quick rundown: Expression Read More... Posted Wednesday, February 22, 2012 11:56 PM by jamiet | 1 Comments Filed under: sql server, sql server integration services, ssis, SQL Server 2012

• Is the SSIS Catalog going to be enough?

  Over the past year or so I have written at length about the SSIS Catalog that will be provided in the upcoming version of SQL Server Integration Services (SSIS 2012) and the capabilities that it will bring; one of the biggest benefits (in my opinion) Read More... Posted Wednesday, February 22, 2012 10:00 AM by jamiet | 27 Comments Filed under: sql server integration services, ssis, SQL Server 2012, SSIS Catalog

• SQL Server Data Tools does support required variables

  Over the past few years of using datadude (aka DBPro aka Visual Studio Database Projects) I have fallen prey to a peculiar little nuance – if you forget to supply a value for a sqlcmd variable then it will simply use a default and often that is not the Read More... Posted Sunday, February 12, 2012 12:58 PM by jamiet | 13 Comments Filed under: sql server, Datadude, SQL Server 2012, SQL Server Data Tools, SSDT, sqlpackage.exe

• PBM for SSIS? What policies would you want?

  My mind was wandering today after reading Andy Leonard's excellent post Name Those Connections and it occurred to me that due to SQL Server 2012 including an SSIS Server there may be an opportunity to leverage Policy-Based Management (PBM) for ensuring Read More... Posted Thursday, February 9, 2012 2:50 PM by jamiet | 10 Comments Filed under: sql server integration services, ssis, SQL Server 2012, PBM

• SQLBits now publishing all SQLBits agendas as an iCalendar

  Three weeks ago I published a blog post Get the SQLBits agenda in your phone's calendar where I said: If you want to get the SQLBits calendar onto your smartphone then the easiest way to do it is add my calendar [containing all SQLBits sessions] to whichever Read More... Posted Wednesday, February 8, 2012 9:36 AM by jamiet | 2 Comments Filed under: SQLBits, iCalendar