Blogs

Complementary Microsoft Technical Training Event on SQL Server 2005

  • Comments 4
  • Likes

We're hosting a TechNet Training event on SQL Server 2005 in both Dublin and Belfast on September 26th and 28th respectively.  This event will be technical deep dive covering best practices on how to upgrade from older versions of SQL Server or how to migrate from Oracle to SQL Server 2005.  It will also cover Advanced SQL Server 2005 Integration and Reporting Services (Level 300).  The focus of the event will be on practical demos and working examples as well as practical tips and tricks from the field.

You are welcome to forward the details of this invite on to the relevant members of your team and/ your colleagues who may be interested in the events.

** Links to register for this event are at the bottom of this post. **

 

The agenda for this complimentary event is as follows:

Afternoon - TechNet Event (IT Professional): Microsoft SQL Server 2005

Audience: IT Professionals, Database Administrators, Architects

Technical Level: 300

 

12:45 Registration

13:15: In-depth Exploration of SQL 2005 Upgrade and Migration processes

This session will show you the best methods to upgrade from earlier version of SQL Server to Microsoft SQL Server 2005.  You will find out how to identify any incompatibility issues that you must address before you begin the process and how to prepare your system for a successful upgrade. We also offer tips and techniques that can help you make the most effective use of the upgrade tools and minimize downtime during the upgrade process.

We will also show you a new tool to you called Microsoft SQL Server Migration Assistant (SSMA). Have you ever wondered how to take PL/SQL code and convert it to T-SQL? SSMA automates the conversion of Oracle Database schema and data to Microsoft SQL Server. We show you the steps of a typical migration project. Learn how you can use the different modules of SSMA to automate assessment, schema and data migration, and testing.

14:30 Advanced SQL Server 2005 Reporting Services Level 300

See advanced techniques for building reports with Microsoft SQL Server 2005 Reporting Services and the Microsoft Visual Studio-based Report Designer. Topics in this sessions include: how to use the built-in expression language, report parameterization (data driven, multi-valued, and hierarchical), supporting multiple data sources (including relational, multi-dimensional, and XML), and making reports interactive. Learn about the new features in Microsoft SQL Server 2005 for report designers, receive a walk-through of sample reports and discover tips and tricks for using the Report Definition Language (RDL).

What We Will Cover

·         New Data Sources in SSRS 2005

·         Reporting Services Data Extensions

·         Working with SSAS and SSIS Data

·         End-User Sort and Parameterization

·         Schedules and Subscriptions

 

15:30: Coffee Break

15:45: Advanced SQL Server 2005 Integration Services Level 300

SQL Server 2005 Integration Services (SSIS) has been completely re-architected to support enterprise requirements for scale and performance. This session presents key enhancements in SSIS that make it extremely scalable. This session will also cover use of scripting, performance optimisation and interoperability.

What We Will Cover

·         SSIS enhancements

·         SSIS v SQL Server

·         Advanced Scripting (samples from the field)

·         Optimisation for scalability (tips from the field)

·         Performance Monitoring

·         Interoperability (Excel/Oracle)

 

17:15 Refreshments

 

DUBLIN Event - 26th Sept: Click on the below links to register:

Target Audience: IT Professionals, Database Administrators, Architects, IT Managers

Dublin Venue: Burlington Hotel

Afternoon Session - TechNet Event (IT Professional): Microsoft SQL Server 2005

===================================================================

BELFAST Event - 28th Sept: Click on the below links to register:

Target Audience: IT Professionals, Database Administrators, Architects, IT Managers

Belfast Venue: Hilton Hotel

Afternoon Session - TechNet Event (IT Professional): Microsoft SQL Server 2005

Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment