Some SQL 2005 Resources for ya
I put together some SQL 2005 resources for one of my ISV's so thought I'd share with you... Most of the questions I get are from people wanting more info on Reporting Services so I've highlighted that below.
Upcoming Webcasts
Lots of upcoming webcasts in April where you can ask questions directly during the presentation
https://www.microsoft.com/events/series/msdnsqlserver2005.mspx
In particular, there's one coming up on Reporting Services on April 13th
MSDN Webcast: Advanced Reporting with SQL Server 2005 Reporting Services (Level 200) Wednesday, April 13, 20059:00 A.M.–10:00 A.M. Pacific Time |
Webcasts
Overview of the new Developer features in SQL Server 2005—Level 200 Q&A from this webcast The release of SQL Server 2005 brings with it many new productivity enhancements for the database developer. This webcast will give you a brief overview of the major new developer features of SQL Server 2005. |
Introducing the New SQL Server Management Studio—Level 100 Q&A from this webcast Get an overview of the new tools in SQL Server 2005, including SQL Server Management Studio, Database Tuning Advisor and SQLCMD. Also see the enhancements that have been made to existing tools such as Profiler and SQL Agent. |
SQL Server 2005 as a .NET Runtime Host—Level 100 Q&A from this webcast See how to create database objects such as user-defined types and aggregates in SQL Server 2005, using familiar languages such as C# and Visual Basic .NET. |
Introducing XML in SQL Server 2005—Level 200 Q&A from this webcast Learn what the new XML data type will mean to your database applications, and see some simple examples of how to utilize this new feature. |
Introducing ADO.NET 2.0 for SQL Server 2005—Level 200 Q&A from this webcast See how SQL Server 2005 provides greater scalability and flexibility in dataset access and manipulation, using the enhancements available in ADO.NET 2.0 |
T-SQL Enhancements in SQL Server 2005—Level 200 Q&A from this webcast By now you have heard that you can write stored procedures in C# and VB .NET for SQL Server 2005. Does that mean TSQL is dead? NO! A lot has changed in the world of TSQL for SQL Server 2005. Come see the new features of T-SQL for SQL Server 2005, including features such as error handling and XML manipulation, that have been added to make developing with SQL Server easier and more productive. |
The New Security Model in SQL Server 2005—Level 200 Q&A from this webcast SQL Server 2005 brings with it many changes to the traditional SQL Server security model. Attend this webcast to learn about the new security model and the basic concepts behind it, as well as new security features such as data encryption. |
Introducing Web Services in SQL Server 2005—Level 200 Q&A from this webcast Learn about the new Web service features in SQL Server 2005, such as supporting XML as a first-class data type, providing a new query language for XML documents, and allowing you to perform in-place modifications. |
Introducing Service Broker in SQL Server 2005—Level 200 Q&A from this webcast Learn more about SQL Server 2005 Service Broker, a new feature that allows you to build reliable, scalable, asynchronous, queued database applications. Get an overview of the major features of the Service Broker, including queues as database objects; data integrity for queued messages; activation of processing logic triggered by message arrival; and reliable, transactional delivery of messages between SQL Server instances. |
Introducing Reporting Services for SQL Server 2005—Level 200 Q&A from this webcast Register today to find out more about the Reporting Services enhancements that will be available in SQL Server 2005. |
Introducing SQL Server Integration Services for SQL Server 2005—Level 200 Q&A from this webcast See what Integration Services (formerly DTS) can do to make your data loading and transformation tasks faster and easier. |
Introducing SQL Server 2005 Analysis Services for Developers—Level 200 Q&A from this webcast Get an introduction to the main developer features of Analysis Services. This includes an overview of the Unified Dimensional Model (UDM) which provides a rich layer of meta data over a relational source, to provide the best of both traditional OLAP based reporting (performance and analytical capabilities) and relational reporting (currency of the data, and flexibility). |
Introducing Full-Text Search in SQL Server 2005—Level 200 Q&A from this webcast Join this webcast for coverage of the fundamentals of full-text search in SQL Server 2005, including an examination of the new features and performance upgrades that have been introduced in SQL Server 2005 to support this new feature. |
Introducing Replication in SQL Server 2005—Level 200 Q&A from this webcast Get an overview of the new Replication features in SQL Server 2005. See how ease of use and monitoring has been greatly enhanced, along with the ability to synchronize subscriptions over the Internet. We'll also cover replicating new SQL Server 2005 data types and the many improvements in merge replication scalability. |
Introducing Notification Services in SQL Server 2005—Level 200 Q&A from this webcast Get more information about the Notification Services enhancements in SQL Server 2005. Learn about notification applications and how Notification Services in SQL Server 2005 can make it easier for you to build and deploy these applications. |
MSDN Webcasts
MSDN Webcast: Advanced Reporting with SQL Server 2005 Reporting Services (Level 200)
MSDN Webcast: Introducing SQL Server 2005 Express: Your Smart Client Data Store (Level 200)
MSDN Webcast: SQL 2005: Integration Services (Level 300)
MSDN Webcast: T-SQL vs. the CLR in SQL Server 2005- How Should You Choose? (Level 200)
MSDN Webcast: Native Data Access Technologies for SQL Server 2005 (Level 300)
MSDN Webcast: Data-Disconnected: Working with Disconnected Data Using ADO.NET 2.0 (Level 400)
SQL 2005 Beta Newsgroup
https://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
Hands-On Labs Manuals
Data Transformation Services (DTS) Hands-On Lab Manual
Reporting Services Hands-On Lab Manual
Management Studio Hands-On Lab Manual
XML Features Hands-On Lab Manual
SQL Server 2005 and ADO.NET Hands-On Lab Manual
T-SQL Enhancements Hands-On Lab Manual
SMO and Web Services Hands-On Lab Manual
Analysis Services Hands-On Lab Manual
Data Mining Hands-On Lab Manual
Database Tuning Hands-On Lab Manual
SQL Server 2005 Articles |
Look here to learn about all the new and improved technologies that SQL Server 2005 will deliver: improvements in T-SQL, integration with the .NET Framework CLR, ADO.NET 2.0, new XML features, and more. |
An Overview of SQL Server 2005 for the Database DeveloperDiscover the great new features of SQL Server 2005, including CLR integration, T-SQL enhancements, and improvements to security, performance, and scalability. |
Multiple Active Result Sets (MARS) in SQL Server 2005Understand the design, architecture, and semantic improvements that MARS offers in SQL Server 2005, and learn the ways in which your applications may benefit from these changes. |
Using Partitioned Tables and Indexes in SQL Server 2005Find out why, when, and how to use SQL Server 2005 table-based partitioning features to improve the manageability and performance of your large tables. |
Business Intelligence |
Overview of the Analysis Services Development and Management EnvironmentsSQL Server 2005 introduces a rich set of tools supporting the development and management of Business Intelligence applications using Analysis Services (OLAP and Data Mining), Reporting Services, and Data Transformation Services. |
Introduction to the Unified Dimensional Model (UDM)This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models. |
Introduction to MDX Scripting in Microsoft SQL Server 2005 Beta 2Learn how Multidimensional Expressions (MDX) for SQL Server 2005 Beta 2 can be applied to common business problems. |
Integration Services for SQL Server 2005: Frequently Asked Design QuestionsGet answers to common questions and design issues regarding Data Transformation Services in SQL Server 2005. |
SQL Server 2005 Integration Services: Lessons from Project REALGet insight into best practices and potential issues when implementing business intelligence systems using Microsoft SQL Server 2005, based on lessons learned doing data extraction, transformation, and loading (ETL) work on data and scenarios from real companies. |
Fuzzy Lookup and Fuzzy Grouping in Integration Services for SQL Server 2005Fuzzy Grouping and Fuzzy Lookup transformations simplify data cleaning and preparation tasks in data warehousing. You can customize them to use search and clustering algorithms inside DTS Designer. |
SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005Learn about the new data mining features in Analysis Services 2005, including new and enhanced algorithms, plus more than a dozen added visualizations. |
SQL Server Data Mining: Plug-In AlgorithmsSee how SQL Server 2005 Data Mining allows aggregation directly at the algorithm level. |
A Tutorial for Constructing a Plug-in AlgorithmCreate a "shell" plug-in algorithm using stub code that integrates into SQL Server 2005 Analysis Services. |
A Tutorial for Constructing a Plug-in ViewerStep through the process of implementing a plug-in viewer and integrating it into Analysis Services. Get stub code that enables you to quickly write a plug-in viewer into Analysis Services. |
Snapshot Isolation in SQL Server 2005 Beta 2SQL Server 2005 provides non-locking, non-blocking read consistency to your users via snapshot isolation. Find out when to use it to improve performance and reduce latency in your applications. |
CLR Integration |
Using CLR Integration in SQL Server 2005Compare CLR-based programming models with SQL Server models such as Transact SQL and extended stored procedures. Get tips on how to choose a model, code samples, and more. |
ADO.NET |
ADO.NET 2.0 Feature MatrixPreview the new features in ADO.NET 2.0, including a new base-class provider model, SqlClient enhancements, pooling enhancements, asynchronous commands, and more. |
Asynchronous Command Execution in ADO.NET 2.0Get an overview of the new asynchronous execution functionality in ADO.NET 2.0, the scenarios it was developed to enable, plus some of the issues to keep in mind when using this feature. |
Query Notifications in ADO.NET 2.0See how the new notification technologies in ADO.NET 2.0 and SQL Server 2005 handle ad-hoc data refreshes. |
XML |
XML Options in SQL Server 2005Get usage scenarios and guidelines to help you choose between System.Xml, SQLXML, and the SQL Server 2005 XML data type for handling your XML data in your Visual Studio 2005/SQL Server 2005 environment. |
Overview of Native XML Web Services for Microsoft SQL Server 2005Get an overview of how to setup and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. |
Performance Optimizations for the XML Data TypeDiscover ways to improve query and data modification performance of the XML data type in the upcoming version of Microsoft SQL Server 2005. |
XML Best Practices for Microsoft SQL Server 2005Get the latest guidelines for XML data modeling and usage in SQL Server 2005 to help you develop rich applications for semi-structured and unstructured data management. |
XML Data Type Support in ADO.NET 2.0: Handling XML from SQL Server 2005See how improvements to XML support in ADO.NET 2.0 and SQL Server 2005 work together to make handling XML data in your applications easier. |
XML Support in Microsoft SQL Server 2005Preview the XML support built into SQL Server 2005, which integrates with the programming support in the .NET Framework V2.0, OLEDB, and SQLXML. |
What's New in FOR XML in Microsoft SQL Server 2005This first in a series of articles by Michael Rys details the major new capabilities of the server-side FOR XML clause in the next version of SQL Server. |
|
Service Broker |
A First Look at SQL Server 2005 Service BrokerSee how the new Service Broker functionality in SQL Server 2005 enables faster and easier development of SQL Server applications that rely upon asynchronous, queued operations. |
Full-Text Search |
SQL Server 2005 Full-Text Search: Internals and EnhancementsSee the benefits and new features of SQL Server "Yukon" full-text search for both developers and database administrators. Significant enhancements in performance, manageability, and functionality deliver best-of-breed search capabilities for applications of any size. |
DBA & IT Pro Articles |
Additional SQL Server 2005 Articles on TechNetFind administrator-oriented content on SQL Server 2005 on TechNet. |