Perth SQL Server User Group

We have meetings once a month on a Thursday. As of September 2013 the group will be meeting at the Enex 100 Seminar Room at 100 St George's Terrace.

We use EventBrite for meeting registrations - check out http://pssug.eventbrite.com/ for a list of our previous events. Anyone is welcome to register, but please let us know at the meeting if you want to be added to the mailing list so you get email notifications of upcoming events.

We are always looking for local speakers, so if you want to try your hand at presenting feel free to let us know!

-- Jenny

 

PLEASE NOTE: This month's meeting is being held at the Institute of Chartered Accountants, Level 11, 2 Mill St.


Topic: Metadata Based Database Migrations
Date: Thursday 30th October, 5.00pm-7.00pm
Speaker:

Nick Jacobsen

Abstract:

Faced with the proposition of migrating hundreds of tables, views and stored procedures from one database to another, do you really want to hand craft schema and all the related SSIS data flows to pump data?

This session will demonstrate techniques to leverage metadata to migrate tables, indexes, referential integrity, triggers, views, stored procedures and data; referencing a recent TAFE student system migration from Ingres to SQL Server as a case study. Also included are methods to optimise performance and post migration data audit reporting. Using SQL Server technologies such as Service Broker, CLR stored procedures, openrowset, for XML, BCP and copious amounts of SQL generation we will take a journey through repeatable, dynamic and ubiquitous techniques for data and database transpositions that can be applied to the majority of today’s data migration projects.

Speaker Bio:

Nick Jacobsen has been administering databases and developing applications utilising SQL Server since 1998. During that time he has developed a myriad of applications utilising SQL Server 6.5 to SQL Server 2012. Nick has provided consulting services on database design and infrastructure to various organisations for the past 10 years.  Currently he is designing and developing a Corporate Data Layer for the Department of Training and Workforce Development’s internal applications utilising SQL Server 2012, Service Broker and C#. The corporate data layer controls master data as well as integrates applications on SQL 2005, SQL 2008R2, SQL 2012, Microsoft CRM Dynamics 2011, Sharepoint and provides BI feeds to Cognos and SSAS.

Nick is a Senior SQL DBA at OnCall DBA and holds numerous Microsoft Certifications; MCSE in SQL 2012, MCSA, MCITP and MCTS.

Register: http://www.eventbrite.com/e/pssug-metadata-based-database-migrations-nick-jacobsen-tickets-13768920211