July 2010 - Posts

• Lock variables in Script Task using C# [SSIS]

  If you have ever written code to lock variables inside a SSIS Script Task or Script Component then you will probably have written some VB.Net code that looks something like this: Public Sub Main() Dim vars As Variables Dim fireAgain As Boolean = True Read More... Posted Thursday, July 29, 2010 2:09 PM by jamiet | 2 Comments Filed under: sql server integration services, ssis, Script Task, C#

• A strategy for managing security for different environments using the Database Development Tools in Visual Studio 2010

  Intro Of late I have been getting down and dirty with the Database Development tools in Visual Studio 2010. You may know this feature set by one of the plethora of other names it has had over recent years such as: Visual Studio Team System for Database Read More... Posted Wednesday, July 21, 2010 10:59 PM by jamiet | 11 Comments Filed under: sql server, Datadude, msbuild, Visual Studio 2010, Security, Powershell

• Project Houston CTP released - try it out with brentotweets

  The SQL Azure team have just announced in their blog post CTP1 of Microsoft® Project Code-Named “Houston” now available that their web based admin tool for SQL Azure (codenamed Houston) has just hit CTP release - you can hit it up on SLQ Azure Labs at Read More... Posted Wednesday, July 21, 2010 4:19 PM by jamiet | 5 Comments Filed under: sql server, SQL Azure, Project Houston, brentotweets

• Recover Backed-up query files in SQL Server Management Studio

  This is a useful little tip that I discovered today. If SQL Server Management Studio (SSMS) ever crashes on you for whatever reason then there is a chance that you’ll lose whatever queries you had open at the time of the crash. Sometimes when you re-open Read More... Posted Monday, July 19, 2010 11:25 PM by jamiet | 23 Comments Filed under: sql server, sql server management studio

• Some thoughts on PivotViewer and SQL Azure

  Today there was an exciting announcement from Microsoft’s Business Intelligence (BI) team, they have released a preview of a tool called PivotViewer which is a visualisation tool for BI data stored in Analysis Services. If you’re familiar with Pivot from Read More... Posted Friday, July 16, 2010 11:10 PM by jamiet | 2 Comments

• Why a SQL or BI developer should learn .Net

  Siddharth Mehta posted a nice blog post today entitled Why a SQL developer of BI developer should learn .Net in which he outlined four reasons that he thinks make it beneficial for SQL Server developers to have an appreciation of .Net. Those reasons being: Read More... Posted Monday, July 05, 2010 1:59 PM by jamiet | 11 Comments Filed under: random waffle

• SSIS gotcha: Beware of multiple outputs from a synchronous script component

  A few days ago I was alerted to a peculiarity of SSIS’s Script Component that I believe people need to be aware of. Its a peculiarity that can rear its head when your script component is synchronous and has multiple outputs . Here’s an example of a dataflow Read More... Posted Sunday, July 04, 2010 10:43 PM by jamiet | 1 Comments Filed under: nugget, sql server integration services, ssis, video, dataflow, synchronous components