(William Pearson) This is the twelfth tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (“Analysis Services,”); our primary focus is the manipulation

(Brian Kelley) ApexSQL Log is a new product from ApexSQL, formerly LockwoodTech Software. ApexSQL Log provides the capability to passively review the contents of database transaction logs and transaction log backups. For databases prepared beforehand (more on this under installation), ApexSQL Log gi

(Steve Jones) Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This art

(Muthusamy Anantha Kumar) In the typical IT department, an un-avoidable task is to monitor the Event Log on all of the servers. It is tedious to go through all the logs one by one, on a daily basis. In this article, the methods presented will help in monitoring the Event Viewer on many servers from

(Darren Green) This is a very short article as it is really a demonstration of concepts explained elsewhere, although quite a useful implementation in it’s own right. The export itself is done with the Bulk Export Task, and this is wrapped in a recordset driven loop as covered in the article How to

(Paul Sanders) The next release of Analysis Services, coming in SQL Server Yukon, will combine the best aspects of traditional OLAP-based analysis and relational reporting into one dimensional model—the Unified Dimensional Model (UDM)—that covers both sets of needs. Compared to direct access of a re

(David Sumlin) Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. (I’ll use these two terms interchangeably) These tables are those small tables that you maintain your list of States, or CustomerTypes or JobStatus or any number of valid domain values

(Bruce Szabo) Can you have books online (BOL) on your bookshelf? Well not quite but if you put The Transact –SQL Desk Reference by Daec Lancaster on your shelf it may be pretty close. This book is a reference book for the DBA who wants to have a lot of information at his or her fingertips without ha

(Muthusamy Anantha Kumar) This article provides a guide on how to explore any Internet web page and store partial or complete information to either an HTML file or Microsoft SQL server table. In addition, the method presented here will aid you to scan a webpage for a particular string and then send

(Gregory A. Larsen) I don’t know if you are like me but I like to have document and coding examples to help me manage applications and Microsoft SQL Server. I am not sure what I would do without good documentation and a few code examples to help me maintain my SQL Server environment. Microsoft has d