Welcome to EMC Consulting Blogs

July 2008 - Posts

• SSDS demo code now on Codeplex

  Last Friday at Conchango’s latest community day (something we have every 6 weeks where all of our 250 consultants down tools and get together back at base) I ran a cloud computing demo where I showed off some of the capabilities of SQL Server Data Services Read More... Posted 29 July 2008 11:02 by jamie.thomson | 3 Comments Filed under: SQL Server, Conchango, SSDS, SQL Server Data Services, cloud computing, SDS, SQL Data Services

• Microsoft to acquire Zoomix

  News just in… Microsoft have purchased Zoomix, a data quality software vendor. From the press release : Zoomix will contribute a critical layer of data improvement to Microsoft's SQL Server Data Platform Interesting stuff. One would think this will sit Read More... Posted 14 July 2008 21:01 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Microsoft, MDM, Master Data Management, Zoomix

• SSIS Nugget: Conditionally email a file containing error rows

  Someone emailed me today asking: I have an SSIS package that outputs data that can’t be inserted into destination tables into flat log files [JT: I presume he means that error rows are redirected to a flat file] What is the easiest way to then after processing Read More... Posted 11 July 2008 20:02 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Dataflow Task, Expressions, Demo, Nugget

• Query Analyzer or Management Studio?

  Lately I’ve been working on a SQL2000 project and its afforded me the opportunity to get re-aquainted with the granddaddy of SQL Server query tools – Query Analyzer. For those that don’t know, Query Analyzer (QA) was the query tool provided with SQL Server Read More... Posted 10 July 2008 01:02 by jamie.thomson | 14 Comments Filed under: SQL Server, SSMS

• T-SQL: Do you use aliases?

  A pet peeve of mine is the lack of alias usage when using T-SQL. I’m not sure why people don’t bother using aliases –I’ve never asked- but I suspect its laziness. I can understand that but I want to speak up for the bastion of embattled SQL developers Read More... Posted 04 July 2008 20:58 by jamie.thomson | 29 Comments Filed under: SQL Server, T-SQL