Ridiculous. I was staring at Visual Studio 2013 in disbelief, looking at the empty Toolbox thinking I missed an installation step, even though all the other functionality of SQL Server Integration Services (SSIS) was working just fine. After doing a little digging (this time Stack Overflow did not help), it turns out that SSIS has its own dedicated Toolbox, and it’s basically hidden. Thanks to an article by Robert Bigec, the answer is pretty simple, but not obvious. The Empty Toolbox – SSIS 2012 | Robert’s Spout.ToString() I stared at this toolbox in disbelief. White and spacious with a confirming message that gave me no comfort: “There are no usable controls in here … “. What happened to the Source[…]

Many of my colleagues know that I like to do lo-fi prototypes since I can iterate so much faster on them, get a sense of whether it’s a good design choice or not. So, it was really nice to see this article on Smashing Magazine by Laura Busche on the subject, entitled The Skeptic’s Guide To Low-Fidelity Prototyping | Smashing Magazine In it, she shows that: Low-fidelity prototypes, in particular, are rough representations of concepts that help us to validate those concepts early on in the design process. Throughout this article, we will look at some of the features that make low-fidelity prototyping a unique tool to radically improve your work and to build an environment in which users’ needs[…]

Found this to be a really helpful tip from Using Temporary Tables in SQL Statements. I wanted to be able to quickly construct a temporary table within a stored procedure and this was just a super-simple set of examples to get that going. Hope others find it useful as well! Using Temporary Tables in SQL Statements Temporary tables can be used in the SQL statement wherever the regular tables can be used. To identify a table being a temporary table in the SQL statement, prefix the table name with the ‘#’ character. Examples: // Create a temporary table named Temp1 with two columns CREATE TABLE #Temp1 ( Name Char( 30 ), seqid integer ); // This example creates two temporary[…]