Transposing Columns onto Rows

After a long period of absence, I have returned to posting some blog articles.  This one popped up last week from an Oracle DBA while I was onsite with a customer.  The conversation went something along the lines of: Oracle DBA: “How can I place columns values on rows? I have a limited page width…


SQL Server 2008 R2 RTM BOL now available



Using SSIS with SQL Azure databases

I’m quite surprised how easy it is to setup an SSIS package to read and write data to a SQL Azure database.  A simple data flow task with an ADO.NET Destination is easy to setup, just make sure the SQL Azure table has a clustered index otherwise writing data will not work (as this is…


New editions of SQL Server 2008 R2 announced

SQL Server 2008 R2 Datacenter SQL Server 2008 R2 Parallel Data Warehouse


SQL Server 2008 R2 Master Data Services

In case you missed the Tech-Ed 2009 announcement, you can find the info here “On initial scoping, it was determined that ‘Bulldog’ would ship as part of Microsoft Office SharePoint in the O14 wave.  At TechEd 2009, we announced a change in packaging for the new MDM capabilities. Project ‘Bulldog’ will now ship as…