When you use an ALTER CUBE statement to update a write-enabled dimension in Microsoft SQL Server 2000 Analysis Services, the value that is written to the source column in the relational data souce may be incorrect if the updated value contains an embedded single quotation mark. The value that is wri

(Jeffrey Yao) Having been a DBA for about 9 years, I am frequently asked by some programmers, “I am tired of coding, now I want to switch my career to be a DBA, so where should I start?” I promised that I would write an article to answer these questions based on my experience, so this article is mai

(Muthusamy Anantha Kumar) SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn’t arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. T

When moving a cluster group containing both Microsoft Distributed Transaction Coordinator (MS DTC) and SQL Server resources between nodes, it takes several minutes to take the resources offline and move the group to the other node. However, if the MS DTC resource is taken offline before moving the g

(Don Schlichting) This article will explore the use of Distributed Partitioned Views for accessing multiple MS SQL Severs when configured as a Federated Database.

This article describes how to retrieve the descendants of all the members of a dimension at a specific level or a specific distance by using an enhanced feature of the Descendants function in Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3).

(Jean-Luc David) Web developers must constantly cope with the pitfalls of integrating multiple platforms and technologies to produce seamless software solutions. PHP is an easy-to-learn and powerful open source scripting language. Microsoft SQL Server is a robust database product which can handle te

(Robin Back) As many articles have covered SQL passwords are very easy to figure out. SQL passwords are stored in the sysxlogins table in master database. To access this table you have to be a member of the fixed role sysadmin or sysadministrator. Still there are programs out there that use the lack

(Robert Westervelt) Microsoft informed some of its customers yesterday that the newest version of SQL Server, code-named Yukon, had been delayed for security reasons — and many analysts say the new release date is proof that the massive database project lacks focus.

(William Pearson) This article continues the series, MS Access for the Business Environment. The primary focus of this series is an examination of business uses for the MS Access relational database management system. The series is designed to provide guidance in the practical application of data an