SQL Live! Day Sessions
Wednesday, April 26
Developing with SQL Server 2005
John Papa, ASPSOFT
10:30 a.m.
This session will demonstrate how to use stored procedures, triggers, functions, views and other constructs in enterprise solutions using SQL Server 2005. We'll walk through the tools that have made the transition from SQL 2000 to 2005 as well as many of the new features available to developers in SQL Server 2005 including the new full featured XML datatype.
SQL Server Reporting Services
Bill Wolff, Agility Systems
11:45 a.m.
Learn about advanced techniques for building reports with SQL Server 2005 Reporting Services and the Visual Studio-based Report Designer. Topics 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. You’ll see the new features available to report designers in SQL Server 2005 along with walkthroughs of sample reports and tips and tricks for using the Report Definition Language (RDL).
Managed Code in SQL
Josh Holmes, SRT Solutions
2 p.m.
SQL Server 2005 will change the way that you architect your databases. Among the many enhancements to SQL Server for the 2005 version, one of the most anticipated and exciting features is the ability to run managed code within the SQL Server process. But how do you as a developer leverage this ability? There are many ways for you to leverage this new functionality from writing your triggers to writing your business logic in C# or VB.NET or even creating UDT (User Defined Types). Some of these features are more useful and practical than others. As the adage says, just because you can doesn’t mean that you should. It applies here because there are times that you should not use .NET to solve a problem that T-SQL solves better and vice-versa. In this session, we discuss how, why and (very importantly) when you would want to write managed code for SQL Server 2005.
Exploring T-SQL in SQL Server
John Papa, ASPSOFT
3:15 p.m.
This session will demonstrate how to use stored procedures, triggers, functions, views and other T-SQL constructs in enterprise solutions. You'll learn some basic T-SQL planning techniques and key points with code examples including special T-SQL commands that enhance queries and improve interaction of stored procedures with ADO. You’ll also learn how take advantage of the XML features built into SQL Server 2000, how to audit databases using triggers and how to call ActiveX servers from T-SQL.
Using SQL Service Broker
Bill Wolff, Agility Systems
4:30 p.m.
Many Service Oriented Architecture implementations use synchronous, connection oriented communications between services. This talk introduces the SQL Service Broker and how it can be used to build reliable, asynchronous Service Orientated Architecture applications.
