New Functions of SQL 2008/2008R2 from a Programmer’s Perspective


Creating database applications working in Microsoft SQL Server 2008 environment should not be limited to writing T-SQL scripts with SSMS console. Just the opposite, a database application project may and should be executed along similar standards and using similar tools as projects of other types. This means, for instance, that the source code should be versioned and stored in the repository, all the changes should be tested prior to implementation, and given tasks be executed with technologies best suiting them. The course trains database programmers to use SQL Server 2008 to its full capacities, starting with choosing most suitable tools, writing and optimizing T-SQL code, programming the access to non-relational types of data and writing SQLCLR code, and finishing with using tried and tested design patterns. We have designed this course building on our many years’ experience, best programming practices and tried and tested methods of their application in database projects. All this has resulted in a course which will enable you to use fully the extended capabilities of SQL 2008 for database applications.


  • Course level: 400
  • Start date: as required
  • Duration time: 2 days

Price: 2800 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer


The course is aimed at database programmers, as well as all those who have experience in working with previous SQL Server versions, yet want to find out the new functions of SQL Server 2008. The participants will acquire the practical skills necessary to be able to independently create database applications using various editions of SQL Server 2008 and SQL Server 2008 R2.


The basic training is comprised of 7 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants.  We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered throughout the course.
Our trainings are unique also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.


Duration: Level:
Module 1

Development Tools
  • SQL Server Management Studio and SQL Server Data Tools
  • Visual Studio 2010 Database Projects (SQLCLR)
  • Online Development
  • Database Projects
  • Source Code Versioning
  • Debugging Stored Procedures And Functions
  • Code Versioning and Synchronizing Changes
  • Refactoring T-SQL Code
  • Unit Tests
  • Deploying and Publishing Database Projects
  • Data-Tier Applications

60 minutes 300
Module 2

TSQL Improvements and Data Types
  • Data/Time Types
  • T-SQL Assign and Increment Operators
  • Row Constructors
  • Table-Valued Parameters
  • Common Table Expressions (CTE)
  • OVER Clause (Ranking and Grouping Functions, Grouping and Ordering Rows)
  • MERGE Statement
  • Dependency Views

210 minutes 400
Module 3

Non-Relational Data
  • Spatial Data (Geometry and Geography Data Types)
  • Spatial Indices
  • Hierarchical Data
  • XML (XML Data Type, XML Schema, Xpath and Xquery, FOR XML Clause, XML Data Type Methods)
  • XML Indexes
  • Modeling Sparse Data (SPARSE, COLUMN SET Attributes)

150 minutes 400
Module 4

Storing and Quering Documents
  • Large Binary Objects and FILSTETREAM Attribute
  • Integrated Full Text Search Service - Overview
  • Fulltext Indexes and their Components
  • Working with Multilanguage Documents

60 minutes 400
Module 5

CLR Integrations
  • SQL Server as a .Net Runtime Host
  • SQLCLR Reliability, Scalability, and Security
  • Assemblies and User Defined Objects (Functions, Procedures, DML and DDL Triggers, User-Defined Types and Aggregates)
  • SQLCLR Best Practices

120 minutes 400
Module 6

Service-Oriented Architecture And HTTP Programming
  • Service Broker and Messaging (Messages, Contracts, Queues, Services And Routes)
  • Service Broker Programmability (Conversations, Sending & Receiving Messages, Security)
  • Service Broker Troubleshooting
  • Web Services and REST Architecture
  • ADO.NET Data Services

60 minutes 400
Module 7

Occasionally Connected Systems
  • SQL Server Compact Edition (Tools, Features and Limitations, Programmability, Distribution)
  • Server-Directed Synchronization (Remote Data Access, Merge Replication, Sync Services and SQL Server 2008 Change Tracking)

60 minutes 400


Ask Question