Introduces the technologies and features of Microsoft Windows Workflow Foundation that will be of interest to developers in need of creating workflow-driven applications for the Microsoft .NET platform.
Date:September 2005, Source:Microsoft
Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.
Date:August 2005, Source:Microsoft
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 examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.
Date:June 2005, Source:Microsoft
The Microsoft SQL product team is hosting special week of live MSDN Webcasts to provide you a sneak peek at what Microsoft SQL Server 2005 Beta 2 has in store for the future database development. SQL Server 2005 offers a new paradigm for database development that integrates SQL Server and the CLR to provide several major benefits including enhanced programming mode, enhanced safety and security, user defined types and aggregates, and a common development environment, where database development is integrated into the Microsoft Visual Studio 2005 development environment.
Date:October 2004, Source:Microsoft
This paper describes how database application developers and architects can take advantage of the CLR integration features in SQL Server 2005. It compares CLR-based programming with existing programming models supported in SQL Server, such as Transact-SQL and extended stored procedures, and highlights the relative strengths and weaknesses of each. It also provides a set of high-level guidelines to pick the appropriate programming alternative, and a set of examples and code samples.
Date:November 2004, Source:Microsoft
SQL Server Professional magazine writer S. A. Miller shows how unit tests can help make testing easier and better, along with an open source testing framework called TSQLUnit.
Date:November 2004, Source:SQL Server Professional
The Microsoft SQL Server 2000 High Availability Series helps you plan and deploy a highly available data center that uses Microsoft SQL Server 2000 through proper procedures that increase availability, backups help recover from catastrophic disasters, redundant components prevent downtime, and redundant servers minimize downtime.
Date:November 2002, Source:Microsoft
To manage SQL Server in a day-to-day environment, an operations team needs to perform a wide variety of procedures, including server monitoring, backup, verification of scheduled events, capacity planning, and developer and end user support. This guide includes instructions for the procedures along with steps for dealing with unresolved issues in a timely manner.
Date:October 2001, Source:Microsoft
Transaction Cost Analysis (TCA) is a very reliable way for estimating the capacity required to run a web application. As you start developing web applications and the number of users using it increases, your web site is bound to start experiencing some performance issues. How you prepare for this is the concept of capacity planning.
Date:July 2002, Source:Microsoft
The availability of Microsoft Windows Server 2003 introduces a new era of database computing for SQL Server users. Database applications on Windows Server 2003 can reach levels of reliability, security, availability, and scalability previously attainable only on mainframe systems.
Date:April 2003, Source:Microsoft
This guide provides end-to-end guidance for managing performance and scalability throughout your application life cycle to reduce risk and lower total cost of ownership. It provides a framework that organizes performance into a handful of prioritized categories where your choices heavily impact performance and scalability success.
Date:April 2004, Source:Microsoft
The world of the DBA is changing. DBAs are seeing more and more requests for them to manage more systems with larger amounts of data while at the same time the corporation is trying to keep IT costs the same or slightly lower. At the same time, corporate developers are requesting more of the DBAs time to help them understand the data models and best data access paradigms to build reliable applications that perform to the scale that the corporation requires. With these tensions, DBAs need more from their database technologies in terms of enterprise manageability, scalability and availability. SQL Server Yukon will provide the bedrock foundation that DBAs can bet on to build their next generation IT infrastructure.
Date:October 2003, Source:Eric Brown
PDC 2003 featured 6 technical tracks with more than 120 sessions. Find the topics and sessions you're interested in, along with the PowerPoint slides and demo code from the sessions here.
Date:November 2003, Source:Microsoft
Explore the logging block, which provides extensions to the Enterprise Instrumentation Framework (EIF) architecture, helping to address the common usage scenarios for logging.
Date:November 2003, Source:Microsoft Patterns and Practices
Microsoft released a new set of patterns for data access, implemented via SQL Server.
Date:October 2003, Source:Microsoft Patterns and Practices
This link contains a good introduction to error handling techniques in SQL Server
Date:July 2003, Source:Erland Sommerskog
This link contains a good introduction to error handling techniques in SQL Server and ADO.
Date:July 2003, Source:Erland Sommerskog
This link contains a nice list of all undocumented SQL Server stored procedures.
Date:March 2001, Source:Alexander Chigrik
This link explains how you can make a query between SQL Server and Active Directory.
Date:June 2000, Source:Microsoft PSS
Can you call a .NET component from SQL Server?? No, you cannot and this article describes why you cannot.
Date:June 2000 (Updated), Source:Microsoft PSS
The most comprehensive list of FAQ that you can find on SQL Server (all versions). Compiled by Neil, this is a storehouse of information.
Date:June 2000 (Updated), Source:mssqlserver.com
This is a Microsoft Knowledge Base Article - 243588 and discusses how to troubleshoot the slow performance of many concurrent ad-hoc queries.
Date:June 2003, Source:Microsoft PSS
This is the article that I like the best. It explores how to use arrays (a concept that does not exist) in SQL Server. Very interesting and very useful.
Date:March 2003 (Added), Source:Erland Sommarskog, SQL Server MVP
This article deals with how to understand and consider the implications of query recompilation during the application development cycle.
Date:May 2002, Source:Thomas Davidson, Microsoft
This is a Microsoft Knowledge Base Article - 243586 and discusses one specific type of performance issue that applications may experience with Microsoft SQL Server: the run-time recompilation of stored procedures.
Date:June 2003, Source:Microsoft PSS
This article looks at the relationship between SET options in SQL Server and stored procedure compilation.
Date:Feb 2001, Source:Kalen Delaney
This is a Microsoft Knowledge Base Article - 224587 and discusses how to troubleshoot SQL Server performance issues.
Date:June 2003, Source:Microsoft PSS
This is a Microsoft Knowledge Base Article - 271509 and discusses about how to monitor blocking queries in SQL Server. Very useful for debugging purposes.
Date:July 2003, Source:Microsoft PSS
An excellent article that examines how Microsoft SQL Server queries are processed on the client, how the various clients interact with SQL Server, and what SQL Server does to process clients' requests.
Date:January 2000, Source:Hal Berenson and Kalen Delaney
This is a Microsoft Knowledge Base Article - 186265 and discusses how to get the milliseconds of a SQL Server datetime field returned to a Visual Basic application.
Date:January 2001, Source:Microsoft PSS
Understand various things that you need to keep in mind while working on SQL Server 2000.
Date:June 2003, Source:Vinod Kumar (MSDN India, Community Star)
Learn about the .NET Framework's Common Language Runtime from a performance perspective. Learn how to identify managed code performance best practices and how to measure the performance of your managed application.
Date:June 2003, Source:Gregor Noriskin (MSDN)
Discusses Microsoft .NET Enterprise Services and its use of COM+ middle tier services. Introduces new COM+ 1.5 features as well as design guidelines to take full advantage of these new capabilities in .NET applications.
Date:June 2003, Source:Michael McKeown (MSDN)
This article looks at how you can generate comma-seperated files using the BCP command.
Date:June 2003, Source:Shane Dovers (SQL Server Magazine)
Last Updated On: 6th, February, 2006