|
|
-
|
|
Learn about the guidelines for XML data modeling and usage in Microsoft SQL Server 2005, and see illustrative examples http://technet.microsoft.com/en-us/library/ms345115(SQL.90).aspx...
|
|
-
|
|
This 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. These enable you to further enhance the XML support in your applications and to write easy-to-maintain...
|
|
-
|
|
Get a detailed look at how to set up SQL Server 2005 for Web service access in a heterogeneous environment, and learn more about key scenarios for Web services in SQL Server 2005. http://technet.microsoft.com/en-us/library/ms345140(SQL.90).aspx...
|
|
-
|
|
SQL Server 2005 provides the database application programmer with a rich new development platform by hosting the .NET Framework Common Language Runtime environment (CLR). With new capabilities come new roles and responsibilities for the Database Administra...
|
|
-
|
|
This paper provides the information about the available MDX query troubleshooting tools and demonstrates how to use the most common of these tools to identify and resolve MDX query performance bottlenecks with individual MDX queries There are a variety of...
|
|
-
|
|
The recommendations in this white paper provide best practices for processing in Microsoft® SQL Server™ 2005 Analysis Services. These performance optimizations are based on real-world implementations with some of our top customers and partners who use SQL ...
|
|
-
|
|
SQL Server Integration Services (SSIS) brings a revolutionary concept of enterprise-class ETL to the masses. The engine is robust enough to handle hundreds of millions of rows with ease, but is simple enough to let both developers and DBAs engineer an ETL ...
|
|
-
|
|
This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For backgro...
|
|
-
|
|
Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005 (formerly known as "Yukon"). Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web servic...
|
|
-
|
|
This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and exampl...
|
|