A 2-day interactive workshop that drills down into new features, tools and best practices for developers working with SQL Server 2008 or 2008 R2.
This course will be taught by Gavin Payne.Â Gavin is a Senior Consultant for Coeo Ltd, a Microsoft Gold Partner providing SQL Server consulting services for upgrade, performance tuning, scalability and availability solutions for all versions of SQL Server.
This popular workshop will broaden and deepen your understanding of SQL Serverâ€™s newest and upgraded development features. You will gain new knowledge and confidence through the right balance of theory, insights and hands-on experience.
we combine presentation-based content and instructor-led demos to introduce topics and explain the detail behind the concepts.
we enhance the theory with nuggets of real world experience gained from implementing, optimising and performance tuning SQL Server 2008 for our clients.
try out the new features for yourself on your own instance of SQL Server in several supported lab sessions throughout the two days.
Who is it for?
This level 300 workshop is for development professionals who create or maintain database applications, schemas or queries. Attendees should be familiar with developing databases and queries with SQL Server and its T-SQL query language.
What you will learn
On the first day we will focus on changes to the most commonly used parts of SQL Server: client tools, T-SQL query language and database table design. Features covered will include:
Changes to SQL Server Management Studio
T-SQL assignment operators and row constructors
The new merge command
Enhancements to date and time storage
On day two we will look at new features in SQL Server 2008 and R2Â for handling non-relational data and trackÂ changes to data within databases. We will also explore SQL Server's integration with the .Net developer world by reviewing SQL Server's support for XML data manipulation and CLR assemblies. Features covered will include:
Manipulating spatial and hierarchical data
Tracking data changes
Using full-text indexing
XML and CLR support
Cost £990 + VAT