- Understanding Microsoft SQL Server 2000 Analysis Services
- Sep 5, 2003
- Analyzing data stored in OLTP systems is time-consuming and can eat computer resources. OLAP technology can provide a speedier and more effective use of your data.
|
- Using Application Blocks for Data Access
- Oct 22, 2004
- If code reuse is important to you then don't waste any time writing your own data access layer. Microsoft's Data Access Application Block provide handy wrappers that make it easy to move data in and out of the SQL Server provider using ADO.NET.
|
- Using CLR Integration in SQL 05 for Writing Stored Procedures
- Apr 13, 2007
- Join Jesse Smith to learn more about writing stored procedures using a .NET-based language with SQL Server 2005.
|
- Using Full-Text Search Catalogs
- Jun 1, 2001
- Using the Microsoft Search service with SQL Server, part 2: Working with full-text catalogs.
|
- Using Online Resources to Explore SQL Server 2000
- Oct 5, 2001
- In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne discusses Books Online, which ships with SQL Server 2000. It is very comprehensive, and can help you with almost everything you need to know about the different ...
|
- Using SQL Profiler to Find Errors
- Oct 5, 2001
- In this excerpt from SQL Server 2000 Database Development From Scratch, author Rob Hawthorne tells you how SQL Profiler, as a problem-solving tool, can show you exactly what has been sent to the SQL Server by a client application.
|
- Using SQL Server's XML Support
- Jan 16, 2004
- SQL Server is an XML-enabled DBMS, which can read and write XML data, return data from databases in XML format, and read and update data stored in XML documents. In fact, SQL Server has eight different ways to use XML. Learn how each of them works, and how they interoperate.
|
- Using XQuery to Manage XML with SQL Server 2005
- May 12, 2006
- Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.
|
- VB.NET and SQL Server 2000: One Controlling Part of a Transaction
- Jun 14, 2002
- If you follow the recommendation to use local transactions when you only have one Resource Manager, but want to prepare for a possible future change to distributed transactions and have as few programming changes as possible, there are a couple of issues to consider. Jimmy Nilsson describes useful ways to attack the issue of having only have one controlling part for the transaction.
|
- What Is Integration Services and Why Do I Need It?
- Mar 9, 2009
- Kirk Haselden provides a brief introduction to SQL Server 2008 Integration Services.
|
- What's New in SQL Server 2000
- Aug 6, 2001
- Expert Alison Balter highlights SQL Server 2000’s notable new features.
|
- What's New in SQL Server 2000 - Second Edition
- Feb 14, 2003
- Discover the enhancements and long-awaited features now available in SQL Server 2000, along with how it interacts with the .NET framework.
|
- What’s Going On? Using SQL Server Web Wizard to Display Maintenance Results
- Jan 25, 2002
- Is there a way to check the status of maintenance plans from afar? The answer is yes; you can use the Web Assistant Wizard, a helpful SQL Server feature.
|
- What's New in SQL Server 2000
- Mar 1, 2002
- This sample chapter explores the new features provided in SQL Server 2000, as well as
many of the enhancements to previously available features.
|
- Working with Analysis Services Cubes in SQL Server
- Oct 1, 2004
- Data warehousing is not for the faint of heart; it takes much diligence and dedication to learn the various tools of the trade. In this article, Baya Pavliashvili details some features available with Microsoft Analysis Services, whose Analysis Manager allows you to create and modify cubes to suit your end users' needs.
|
- Working with MDX Queries
- Oct 18, 2002
- Make the jump from MDX expressions into MDX queries with this tutorial. Bill Pearson explores rudimentary MDX queries, the basics of MDX sets and set functions, and introductory dynamic calculated members.
|
- Working with SQL Server 2000 Management Tools and Utilities
- Dec 6, 2002
- Check out the new toolset that comes with SQL Server 2000. You can administer your entire organization from a single graphical management console, with tools to run queries, examine performance information, and monitor your SQL Server services.
|
- XML Handling in Microsoft SQL Server 2005
- Oct 19, 2007
- Increase the speed of your SQL queries and updates.
|
- XML Support in Transact-SQL
- Jan 18, 2002
- Want to know more about XML? Read this article by Baya Pavliashvili for a brief overview of XML components and an introduction to Transact-SQL XML extensions.
|