Microsoft's Lineup of SQL Server Related WebcastsMarch 28, 2005 Twenty-two new webcasts are Scheduled for April, covering such topics as Server 2005 Express, Using Web Services To Connect to SQL Server 2005 from Your Smart Client Applications, Defending the Database and more. TechNet Webcast: SQL Server 2005 Series (Part 3 of 10): Achieving Greater Concurrency (Level 200) Mon, 04 Apr 2005 SQL Server 2005 provides enhancements to enable greater concurrency and significantly reduce lock contention. In part three of this series, we show you how to use Snapshot Isolation to reduce currency contention. Gain an understanding of database snapshots and replication for scaling and read-only views, and learn how Dynamic Management Views can help you proactively monitor locking and avoid deadlocks. MSDN Webcast: Introducing SQL Server 2005 Express: Your Smart Client Data Store (Level 200) Mon, 04 Apr 2005 One of the most powerful features of a Smart Client Application is its ability to work offline. To do this, most applications require data. Microsoft SQL Server 2005 Express Edition allows you to build powerful data-driven smart client applications. MSDN Webcast: New Data Features in Visual Studio 2005 Windows Forms (Level 200) Mon, 04 Apr 2005 Working with data in your Smart Client application is one of the key components for success. This session introduces the new data features for Windows Forms in Microsoft Visual Studio 2005. Tue, 05 Apr 2005 This session explores advanced concepts and techniques for working with XML data types using Microsoft SQL Server 2005 and Visual Studio 2005. Topics covered include casting to and from CLR types, working with XML on the provider level, and integrating with SQLXML 4.0. MSDN Webcast: Data-Disconnected: Working with Disconnected Data Using ADO.NET 2.0 (Level 400) Thu, 07 Apr 2005 What's so great about Microsoft ADO.NET 2.0 and the disconnected model? Check out this webcast and find out about the strong and powerful disconnected model built into ADO.NET that allows applications to work with databases that exist in memory. Thu, 07 Apr 2005 This talk examines the XML native Web services capability in Microsoft SQL Server 2005. Learn how this feature greatly enhances the accessibility and interoperability of SQL Server 2005 through demonstrations, specific examples and scenarios that involve access to SQL in a heterogeneous environment. TechNet Webcast: Clustering Windows Server 2003 and SQL Server 2000 / 2005 (Level 200) Fri, 08 Apr 2005 Clustering is an important technique for building resilient systems and maintaining throughput. Two Microsoft complementary technologies for implementing low-cost, highly available clusters are Network Load Balancing (NLB) and Microsoft Cluster Service (MSCS). Fri, 08 Apr 2005 Developers the world over underestimate the seriousness of a SQL Injection Attack. In this session we will dive deep into the topic and do some live hacks to see the huge danger of SQL Injection. MSDN Webcast: Native Data Access Technologies for SQL Server 2005 (Level 300) Fri, 08 Apr 2005 Learn about all of the ways to connect natively to Microsoft SQL Server 2005 from your smart client application. Fri, 08 Apr 2005 All Microsoft SQL Server data access APIs provide an abstraction to represent sessions and requests within those sessions. SQL Server 2000 and earlier restricted the programming model such that at any point in time there would be at most one pending request on a given session. Several alternatives have been implemented to work around this limitation... TechNet Webcast: SQL Server 2005 Series (Part 4 of 10): Securing your SQL Server (Level 200) Mon, 11 Apr 2005 Parts four and five in our series highlight the security enhancements in SQL Server 2005. MSDN Webcast: Advanced Reporting with SQL Server 2005 Reporting Services (Level 200) Wed, 13 Apr 2005 Microsoft Visual Studio 2005 and SQL Server 2005 Reporting Services provide a powerful platform for reporting on enterprise data. In addition to basic table layouts, reports can be structured with drill-down levels, hyperlinked related reports, and flexible data-based formatting. Fri, 15 Apr 2005 Smart clients such as Microsoft Office can leverage the extensive XML support for object property management, data interchange and content management in Microsoft SQL Server 2005. The new data type XML can be used to store and manipulate XML data at the server, which can be optionally bound to XML schemas. TechNet Webcast: SQL Server 2005 Series (Part 5 of 10): Protecting Sensitive Data (Level 200) Mon, 18 Apr 2005 Parts four and five in our series highlight the security enhancements in SQL Server 2005. Building upon the discussion of authentication and authorization in the previous session, part five of the series covers the crypto support in SQL Server 2005. MSDN Webcast: SQL 2005: Data Replication (Level 300) Mon, 18 Apr 2005 Replication is a complex and involved topic that traditionally has required deep knowledge of the services and processes involved to configure and operate a widely distributed database solution. Learn about the Microsoft SQL Server 2005 enhancements to data replication for getting started using this vital technology to build a large scale data environment. Mon, 18 Apr 2005 This webcast provides an overview of the steps involved in building occasionally connected applications. MSDN Webcast: T-SQL Exception Handling in SQL Server 2005 (Level 300) Tue, 19 Apr 2005 Microsoft SQL Server 2005 introduces rich exception handling capabilities into the T-SQL language. MSDN Webcast: T-SQL vs. the CLR in SQL Server 2005- How Should You Choose? (Level 200) Wed, 20 Apr 2005 The ability to run managed code in Microsoft SQL Server 2005 doesn't mean that T-SQL is going away. In fact, SQL Server 2005 has significant T-SQL enhancements. However, a Microsoft .NET language can be useful in some situations. In this webcast, we'll discuss how CLR-based code might be a better choice for computation and logic-intensive operations. Thu, 21 Apr 2005 This presentation will explain how to use the new Service Broker feature in Microsoft SQL Server 2005 to build reliable, distributed rich-client database applications that offer the loose coupling of message-based services. Fri, 22 Apr 2005 After drilling down into the infamous SQL Injection attack in Part 1 of the Defending the Database, we will now address several of the questions and answers developers have concerning the database and security. Fri, 22 Apr 2005 This session shows how to make use of these new controls in your smart client applications as well as how to enhance their functionality by migrating them to a central Report Server. TechNet Webcast: SQL Server 2005 Series (Part 6 of 10): Managing Large Databases (Level 200) Mon, 25 Apr 2005 Partitioned tables improve the scalability and manageability of very large SQL Server databases. In part six of this series we look at the table and index partitioning capabilities in SQL Server 2005. |