A good point to start with, if you need to upgrade your skills to SQL Server 2005, is the new Microsoft Webcasts Page entirely dedicated to this, at http://www.microsoft.com/events/series/technetsqlserver2005.mspx.
What's new this week:
Friday, February 23, 2007
Microsoft SQL Server 2005 Integration Services (SSIS) is a completely redesigned, feature-rich, data-integration platform for the enterprise environment. In this webcast, we introduce you to the robust, enterprise-class capabilities of SSIS, including dedicated management functionality, a collaborative development environment, high scalability, and increased reliability. Join this session to learn how you can use SSIS to implement data quality, data profiling, and custom transforms in your organization.
Tuesday, March 06, 2007
Sometimes even the most seasoned developers need helpful advice to make their jobs easier and their products better. Attend this webcast to learn some of these practical tips and tricks for Microsoft SQL Server 2005 Express Edition, the free database offering from Microsoft. In this session, we cover topics such as writing SELECT statements and reading query plans, using the SqlClient namespace, stored procedures, error handling, and transactions.
Thursday, March 15, 2007
Microsoft SQL Server 2005 is the next generation data management and analysis software that empowers authorized IT managers, application developers, and database administrators to access more insightful, meaningful and reliable data, helping you to deliver on the very real demands you face every day. Migrating to Microsoft SQL Server 2005 cost-effectively adds new functionality to your database applications and cuts costs and paperwork by providing real-time, self-service reporting to decision makers throughout Northup Grumman’s business. Attend this webcast to learn how SQL Server 2005 provides an integrated database management and analysis solution to help your IT staff.
Wednesday, March 28, 2007
Do you have an application that depends on a Microsoft SQL Server 2005 database? Are there tables in that database with columns that contain decimal values? If so, you may be able to reduce the size of those tables, and thereby reduce the size of the database. This webcast provides the details you need to use a new, more efficient storage format for decimal and numeric data. We also discuss the database size reduction you can expect, and the effect this may have on the performance of your applications.