May 2012 - Posts

• Smart defaults [SSDT]

  I’ve just discovered a new, somewhat hidden, feature in SSDT that I didn’t know about and figured it would be worth highlighting here because I’ll bet not many others know it either; the feature is called Smart Defaults. It gets around the problem of Read More... Posted Thursday, May 31, 2012 12:55 PM by jamiet | 2 Comments Filed under: sql server, SQL Server Data Tools, SSDT

• Redistribution of sqlpackage.exe [SSDT]

  This is a short note for anyone that may be interested in redistributing sqlpackage.exe. If this isn’t you then no need to keep reading. Ostensibly this is here for anyone that bingles for this information. sqlpackage.exe is a command-line that ships Read More... Posted Wednesday, May 30, 2012 4:15 PM by jamiet | 1 Comments Filed under: sql server, SQL Server Data Tools, SSDT, sqlpackage.exe

• SSIS Reporting Pack v0.4 – Execution Report updated

  SSIS Reporting Pack is a suite of reports that I maintain at http://ssisreportingpack.codeplex.com/ that provide visualisation over the SSIS Catalog in SQL Server 2012 and attempt to add value over the reports that ship in the box. Work on the reports Read More... Posted Tuesday, May 22, 2012 10:22 AM by jamiet | 2 Comments Filed under: SSIS Reporting Pack

• Messages do not always appear in [catalog].[event_messages] in the order that they occur [SSIS]

  This is a simple heads up for anyone doing SQL Server Integration Services (SSIS) development using SSIS 2012. Be aware that messages do not always appear in [catalog].[event_messages] in the order that they occur, observe… In the following query I am Read More... Posted Tuesday, May 15, 2012 5:07 PM by jamiet | 0 Comments

• DATEFROMPARTS

  I recently overheard a remark by Greg Low in which he said something akin to "the most interesting parts of a new SQL Server release are the myriad of small things that are in there that make a developer's life easier" (I'm paraphrasing because I can't Read More... Posted Thursday, May 10, 2012 10:53 AM by jamiet | 4 Comments Filed under: t-sql, SQL Server 2012

• Speaking at SQLRelay. Will you be there?

  SQL Relay ( #sqlrelay ) is fast approaching and I wanted to take this opportunity to tell you a little about it. SQL Relay is a 5-day tour around the UK that is taking in five Server Server user groups, each one comprising a full day of SQL Server related Read More... Posted Wednesday, May 09, 2012 2:26 PM by jamiet | 0 Comments Filed under: SQl Relay

• Publish Profile Files in SQL Server Data Tools (SSDT)

  I have been using SQL Server Data Tools (SSDT) both at work and on some hobby projects for quite a few weeks now and of all the new features I have to say the one that I am appreciating the most is Publish Profile files. I have been searching around on Read More... Posted Wednesday, May 09, 2012 12:07 AM by jamiet | 9 Comments Filed under: sql server, SQL Server 2012, SQL Server Data Tools, SSDT, Deployment, Publish Profile Files

• New version of SSDT Power Tools are available – but with a caveat

  A little over a month ago the first version of the SSDT Power Tools were made available bringing with them some much needed functionality – a replacement for Schema View called SQL Server Object Explorer. Along with the first release of the power tools Read More... Posted Thursday, May 03, 2012 10:12 PM by jamiet | 3 Comments