SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in ‘free tools’ category  I’m constantly asked “what’s Microsoft doing about metadata and do we have a solution.” In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools and applications manage metadata and information models more effectively. It included the Open Information…


New SQL 2005 code samples available

I guess now the pressure is off to release the product we’ll see more useful samples comming out of corp; here’s a link to the latest December update: http://msdn.microsoft.com/sql/downloads/samples/default.aspx  


Microsoft .NET Data Provider for SAP

After my recent SQL 2k5 BI session, here at TVP Reading, I had an enquiry asking for more info regarding the SAP provider I showed in the list of providers available to SQL Server Integration Services .  The best public information I can find is @ http://msdn2.microsoft.com/en-us/library/ms216599.  The provider isn’t publicly available at the moment but…


SQL Server Integration Services Samples – Including Fuzzy Logic

At a recent Technet presentation, someone came up to me and asked me if I could post my Fuzzy Logic sample package to my Blog.  I confess I haven’t got round to wrapping it all up, but now it looks like I’m off the hook as one has been supplied with the samples that come…


Project REAL—Business Intelligence in Practice – great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005.  The leasons learnt from all their work is being continually published to this website http://www.microsoft.com/sql/bi/projectreal/default.mspx in the form of…


SQL Server 2005 Integration Services – Top Reference Site

SQL Server 2005 Integration Services – Top Reference Site From the people that brought you www.SQLDTS.com we now have www.SQLIS.com .  This is a top website for examples, information, news and links to MSDN, MSDNTV and blogs etc covering Integration Services.  I know I’m going to find it very useful – thanks to the SQLIS team.


London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms

I had a question, at the London roadshow (8th June), which I wasn’t sure if I could answer reliably, so I promised to blog the answer. The question: “Can I run selected (with mouse) tasks and transforms from inside the SQL Server Integration Services package designer?” The answer I have is, for transforms, no you can’t. …


Transfering Data Oracle Data To And From SQL Server

This post is for two purposes: firstly to point to a comprehensive blog post covering the transfer of data between Oracle and SQL Server using SQL Server 2005 Integration Services – which answers a recuring question from customers and partners with insight, accuracy and the most cherished of properties – honesty. Secondly I want to…