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…

0

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  

2

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…

0

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…

1

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…

0

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.

0

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. …

1

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…

0