(Paul Sanders) 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.

(Steve Warren) Do you need the ability to manage your SQL Server data wherever you are? Microsoft released a Web interface that can help you manage your SQL Server databases. With this tool, called the SQL Server Web Data Administrator, you can: –Perform ad-hoc queries against databases and sav

There are times when you want jobs to be scheduled through the Windows NT Server AT scheduler rather than scheduled through the task scheduling manager used by the SQL Executive service. For example, you may want to schedule a job to stop SQL Server so that you can do a Windows NT Server backup of a

(Martin LaMonica) Will the software industry’s wave of open-source databases spill onto Microsoft’s turf? Perhaps. The software giant is considering making the source code for its SQL Server database available to customers, according to Tom Rizzo, director of product management in Microsoft’s SQ

(Marcin Policht) After discussing authentication and authorization behavior of SQL Server 2005 Beta 2 in the previous two articles of this series, it is time to look into other security-related changes. In particular, we will focus on the freshly introduced native database encryption capabilities. W

(Buck Woody) On April 25, 1986, reactor No. 4 at the Chernobyl nuclear plant was to be shut down for routine maintenance. Sensing a good opportunity, junior-level personnel decided to run a test of the diesel engines that would provide power to the critical cooling system in the event of a power fai

When you try to perform an UPDATE operation or a DELETE operation against a remote OLE DB provider in Microsoft SQL Server 2000, a deadlock condition may occur when the following conditions are true: • The remote OLE DB provider is configured as a linked server that has the Index as Access Path o

When you run a query against a SQL Server 2000 database, you may receive incorrect results when SQL Server 2000 uses loop joins in the execution plan.

Want to get the most out of SQL Server 2000? We’ve collected more than two dozen tips and techniques that can make any DBA’s life easier.

(William Pearson) Our focus in this article will be an examination of some of the uses to which the new Execution Log database might be put. Our examination will consist of hands-on publication of the sample reports provided with Reporting Services as a “starter set;” and then go beyond that set