TechEd 2005 – Auckland New Zealand

Just a quick post to let you all know, that I am presenting two sessions on the next version of SQL Server 2005.

I will be covering the advanced features of Report builder New in SQL Server 2005. Also I will be covering migration tips from Project REAL for migration of Analysis Services 2000 OLAP cubes to AS 2005.

Once I have a confirmed schedule I will publish my session times.

Myles

SQL Server 2005 - Formally Known as Yukon

Ok it’s been along wait; in fact it’s been a very long wait. To be truthful when I joined the Yukon Beta 1 program in the UK, I knew Yukon was special. SQL Server 2005 is jammed packed with new features with a large number around Business Intelligence.

SQL Server 2005 is the first major release of the SQL server product line since SQL server 2000. Microsoft has reviewed the editions of SQL Server to provide cost effective solutions. Have a look at the following new editions for SQL Server 2005.

SQL Server 2005 Features Comparison
http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx


SQL Server 2005 is the only platform to offer end to end BI. From Extract, Transform, Load processes with Integration Services through to Information Delivery with Reporting Services and Report Builder. Not only will my development time decrease I will be able to deliver a cost effective solution without having to integrate multiple vendor products.

I have put together are few links to help you get started.

Get Ready for Microsoft SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/learning/default.mspx

SQL Server 2005 – Business Intelligence
http://www.microsoft.com/technet/prodtechnol/sql/2005/BI/default.mspx

SQL Server 2005 Business Intelligence Web Casts
http://www.microsoft.com/events/series/sqlserverbi.mspx

Getting Started with DTS 2000

Hello All,

I thought it would be a good idea to list some useful sites for first time users of Microsoft SQL server 2000 DTS.

Check out the following links. These will help you get started using
DTS as an ETL development platform.

DTS Tutorials

The link below is a great overview of DTS designer


http://www.sqldts.com/default.aspx?278


DTS white papers


DTS Programming Techniques Used in Microsoft SQL Server Accelerator for
Business Intelligence


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_dts_ssabi.asp


Best Practices for Using DTS for Business Intelligence Solutions
(updated web version)


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

Good Luck,

Myles

Hello World

Hello All

Welcome to my small part of the web. I have started this blog to share my thoughts on Business Intelligence and its applications using Microsoft Technologies primarily SQL server, and of course anything else that interest me.

But first a bit about me.....

I have been working in the field of Business Intelligence for the last seven years. During that time I have worked in New Zealand, Australia and the United Kingdom. My focus has been delivering BI solutions using SQL Server 2000. I have completed numerous projects across multiple industries. I am currently living back in New Zealand leading BI projects in Auckland.

Mainly I hope to tie all the key web resources I use and publish my thoughts on the direction I am taking. Of course I want to hear what you are doing. I guess that’s the great thing about blogging everyone can have a say.

So stay tuned,

Myles