28/10/2005 1:06:11 AM
This month the SIG will be presented by Neil Jacobson in two parts:
Part 1 - Scripting with Metadata for Common Tasks
Putting Information_schema views and system tables to work.
Part 2 - Introduction to Upgrading a SQL 2000 Database System to a SQL 2005 system.
Basic differences e.g.
DTS to SSIS,
OSQL to SQLCMD,
What needs to be redesigned. Leveraging new features in SQL 2005 to solve limitations on SQL 2000.
About the presenter:
Neil Jacobson has a degree in Electrical Engineering from QUT. He has been a full time SQL Server DBA for the last 7 years and has been using SQL for close to 10 years.
He is employed at Commander Communications Ltd, Australia's largest SQL Server 2000 site [source: Microsoft Australia/Wintercorp]. With 7 Terabytes of data to manage he has been an entrant in the Winter Corporation Top Ten program (an international survey of the largest database installations).
He is a participant in the SQL 2005 Beta program and has discussions with Microsoft occasionally regarding features and future directions of the SQL Server product.
Updated scripts uploaded on 11 Nov 2005
Venue: Level 2, 44 Sydney Avenue, Barton ACT 2600 |
Duration Pizza & drinks from 5:00 pm for a 5:30 pm start |
On: Tuesday, 8 November 2005