November 2003 :  SQL Pass Presentation: Embrace XML

Don’t delay building database solutions which embrace the use of XML until the "Yukon" release! Sprinkle a little XML into your stored procedure parameters, enhance your SELECT statements to obtain data from your stored procedure as XML, and create XML Web services from your SQL Server stored procedures. In this session we are going to look at a Web-based ASP.Net reporting solution written in C# that makes the most of the SQL Server 2000 XML features as well as those available in ADO.NET. All code will be provided.


Click here to download presentation

Summer 2003 :  12 Hour Course: SQL Server 2000 Distributed Transformation Services

Course Goals: At the end of this course, the students will be able to: Design dynamic DTS packages to migrate and transform data using SQL Server 2000 Data Transformation Services. How to build packages for Maximum Portability: The Power of Global Variables and the Dynamic Properties Task. Executing a DTS Package: From Another Package, From A Stored Procedure, From a Scheduled Job, from a .Net application. Using the ActiveX Task to Work with Files and the FileSystemObject Looping, Importing, and Archiving The DTS Send Mail Task Lesson Learned the Hard Way - Now You Don't Have To: Using the Disconnected Edit, Working with Excel Files, Running Processes in Parallel, Using Workflow Properties, Setting the Data Pump to Do Many to Many Relationships DTS Error Handling Intended Audience:Programmers and DBAs. Prerequisites: Basic Microsoft programming skills and basic database skills are required. We will use a lot of the Microsoft development technologies such as SQL tables and databases, SQL statements, SQL stored procedures, VBScript, and .Net programming.


Click here to view course website

March 2003 :  MSDN Roadshow Presentation: ADO.NET

Why let C# and java developers have all the fun? We will be looking at a solution that allows database developers to document their stored procedures and functions using XML. The solution also includes the ability to document tables and columns in multiple SQL Server databases via a synchronized Microsoft Access linked server. During this session, we are going to put SQL Server to work for us. Using custom stored procedures and VB.Net we’ll unpack our XML into a relational documentation database. We’ll add additional information to this database from the information_schema views and system stored procedures. We’ll look at the benefits of updating the MS_Description extended property in multiple databases from our linked server. Finally we’ll see what we can do with this new documentation database. As part of the solution, there is a VB.Net report generator that uses Crystal Reports 8.5. We will discuss additional uses for our documentation database, such as using XSLT to create a documentation website and building code generators.


Click here to download presentation

November 2002 :  SQL Pass Presentation: Using XML and Meta Data to Document Your Database

Why let C# and java developers have all the fun? We will be looking at a solution that allows database developers to document their stored procedures and functions using XML. The solution also includes the ability to document tables and columns in multiple SQL Server databases via a synchronized Microsoft Access linked server. During this session, we are going to put SQL Server to work for us. Using custom stored procedures and VB.Net we’ll unpack our XML into a relational documentation database. We’ll add additional information to this database from the information_schema views and system stored procedures. We’ll look at the benefits of updating the MS_Description extended property in multiple databases from our linked server. Finally we’ll see what we can do with this new documentation database. As part of the solution, there is a VB.Net report generator that uses Crystal Reports 8.5. We will discuss additional uses for our documentation database, such as using XSLT to create a documentation website and building code generators.


Click here to download presentation