(William Pearson) In this article, we will introduce conditional formatting, once again, in a basic application – this time a sort in each of the two “directions,” and practice the creation of parameterized conditional sorting that will allow users to make runtime decisions surrounding the sorting o

(Arthur Fuller) Imposing security on a database typically involves use of three database objects—logins, users, and roles. It’s ingrained in the minds of SQL Server developers to think about the following tools in this specific order: logins, users, and roles. However, every time I used logins, user

(Steve Friedl) A customer asked that we check out his intranet site, which was used by the company’s employees and customers. This was part of a larger security review, and though we’d not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concepts.

(Pablo Castro) Using the new SQLCLR feature, managed code can use ADO.NET when running inside SQL Server 2005. Learn about SQLCLR via basic scenarios of in-process data access, SQLCLR constructs, and their interactions.

(Philip Howard) SQL Server 2005 will have a lot of good stuff in it. One of the things I particularly like is the BI Development Studio, which is effectively an extension to Visual Studio for developing BI applications. One of the features of this product is its support for building virtual cubes –

(Muthusamy Anantha Kumar) SQL Server Database administrators often copy(refer Fig 1.0) huge files, such as Full backup files and transaction log backup files from production to QA or from production to development environment and so on. Sometimes they need to copy source data files for importing. If

(Gianluca Nuzzo) This article will describe how to design a data access layer for a set of entities. You’ll learn how to write an XSD schema and design two simple helper classes — one for reading an XML stream from SQL Server using SQLXML and another for deserializing the XML stream.

(Adam Machanic) How does failover clustering work in SQL 2005? And how does it compare with the failure support in Oracle and DB2? (R)

This article describes how to migrate your Microsoft Provisioning Server (MPS) databases from a stand-alone Microsoft SQL Server 2000 instance to a clustered virtual SQL Server 2000 named instance.

The SQL Server Desktop Engine (also known as MSDE 2000) does not have its own user interface because it is primarily designed to run in the background. Users interact with MSDE 2000 through the program in which it is embedded. The only tool that is provided with MSDE 2000 is the osql utility. The ex