(William Pearson) Many businesses that use MS Access databases eventually push to the limits the multi-user applications they have purchased or developed internally, and find the “upsize” path to MSSQL Server to be attractive. Common scenarios that have driven this sort of upgrade include the desire

XPDTC provides a way to retrieve information about the fact if the current context in which the extended stored procedure (xp_dtc_tx_info) is executed, is part of a distributed transaction or not. When part of a distributed transaction, the XP can retrieve the transaction object and return the trans

This article demonstrates how the Office Chart component can be bound to an Office PivotTable component at run time. The sample code uses data from the FoodMart sample provided with Analysis Services for Microsoft SQL Server 7.0 and SQL Server 2000.

When you run a long running MDX query against an Analysis Services server through an HTTP or HTTPS connection, the client may never receive the results of the query. However, if you run the same query from a standard TCP/IP connection to the server, the results are returned to the client. This pr

(Robert Pearl) I recently attended a seminar at MS NYC HQ, discussing in-depth, the release of Microsoft’s powerful 64-bit SQL Server, and wanted to share my thoughts with your readers. In what is being described as a watershed event, Microsoft is clearly aiming its sights on the enterprise clas

SQL Client Tools are not part of the Microsoft Data Engine (MSDE) installation. Therefore, to back up an MSDE database, you can use the Transact-SQL BACKUP DATABASE statement, which is discussed in this article.

(Brian Connolly) Most large businesses have an untapped asset: their warehouses of data about individual customer purchases. Market research firms, for example, will pay for this information because they forecast future buying trends based on demographic analysis of past activity. But while this

(Itzik Ben-Gan) Common table expressions (CTEs), a new T-SQL feature in SQL Server 2005 (formerly code-named Yukon), give you expressive powers for writing T-SQL queries to manipulate hierarchies easily and efficiently. Some major advantages of CTEs are that they’re ANSI SQL-99 compliant, they l

BulkXML is a command line wrapper around the XML bulk load interface SQLXMLBulkLoad, which was introduced in SQLXML.

After you install a SQL Server 2000 virtual server instance, you may want to create databases, or move existing data or log files onto a secondary shared cluster disk. To create databases, or move existing data or log files, the other disk that SQL Server is to use must be added as a dependency