(Alan Fisher) Most database developers dread including such navigation features as paginated reports, hierarchical navigation, filtering, and full-text search because the amount of time they take to develop is not proportional to the utility or interest they create. In addition, connecting individua

(Don Schlichting) Many times, new database applications are written and developed on test machines. Once completed, these new databases must somehow be moved or transferred to a production server. Moreover, while there are currently no Microsoft tools to handle SQL database source control automatica

(Paul Ibison) Many previous articles on log-shipping and replication have concentrated on solving set-up and configuration issues. This article outlines the differences between them, for the purposes of maintaining a standby server. To put this in context,log-shipping and replication are two met

(Mark Strawmeyer) Clustering is a technology solution that combines hardware and software to provide high availability and scalability to infrastructure items such as Web, e-mail, and database servers. In this article, we’ll examine the types of clusters and then focus on establishing a Microsoft-ba

(John C. Hancock) Flexible reporting capabilities are a requirement for most business applications and their integration into Web apps makes them more versatile than ever. With the recent release of SQL Server 2000 Reporting Services, you can easily add reporting from diverse data sources. In this a

(Bob Beauchemin, Niels Berglund and Dan Sullivan) Sql server 2005 includes new Transact-SQL (T-SQL) functionality. The enhancements span the range from an alternative mechanism for transaction isolation to declarative support for hierarchical queries. And statement-level recompilation even improves

(William Barton) Whether we like it or not, the modern office information environment isn’t a tidy place. We would all like to imagine paperless offices in which executives and workers access information through engineered software and in which MCSAs manage information that flows through MCSE-design

(Steven Warren) The Bulk Copy Program (BCP) is a command-line utility that ships with SQL Server 2000. With BCP, you can import and export large amounts of data in and out of SQL Server 2000 databases. Having BCP in your arsenal of DBA tools will add to your skill set and make you a better-rounded D

(Vinod Kumar) XML has become an first class datatype in SQL Server 2005 . You can check my previous articles for an idea of XML features introduced. In this article we will take a look at how we can alter a XML Schema attached to an Typed XML data. XML’s can be caegorized into two categories, typed

(Rod Paddock) SQL Server Reporting Services provides a comprehensive platform for creating, managing, securing, scheduling, and outputting data from SQL Server, Oracle, OLE DB and ODBC data sources. When Microsoft created SQL Server Reporting Services they created it as an extendable platform. You c