Alexander Chigrik shares 20 tips for solving problems with Analysis Services.

When a threat "is permitted to fully and suddenly emerge, all actions, all words and all recriminations … come too late." So said President Bush in his State of the Union speech at the end of last month, in words that might well have been aimed straight at the IT community as it dug itself out fro

If you’ve applied SQL Server 2000 SP3 only to find you’ve lost features that are dependant on xp_cmdshell extended stored procedure, the cause might be a change in the way that authorization for using xp_cmdshell works after the service pack is applied. Join Andrew Novick as he explains how to fix i

By Brian Reed – Web Services applications — like all applications — require easy, consistent, reliable access to data. While some may have a utopian view — where all Web Services applications’ data would reside in XML — the reality is that trillions of bytes of corporate data are stored in exist

Q. I locked myself out of SQL Server without being able to log on with a sysadmin login. Can I fix this, or do I need to reinstall SQL Server? A. You don’t have to reinstall SQL Server. To access SQL Server, you need to use the registry key for SQL Server 2000 and SQL Server 7.0 that determin

Secure installations of Microsoft SQL Server and the Microsoft SQL Server Desktop Engine 2000 (MSDE 2000) against the Slammer worm with these software tools and other resources.

An orphan user is a user in a SQL Server database that is not associated with a SQL Server login. Learn how to identify which databases have orphan users, and how to remove the identified orphan users.

By Garet Griffin – By automating some of the documentation tasks for your databases, you are doing yourself and your sponsor/client a big favour. The procedures below are examples of simple routines that can be stored in the MODEL database, and therefore propagated to all new databases.

Michael Otey revisits SQL Server’s six major releases, then looks to the future and the upcoming Yukon release.

By Robert Lemos – After a round-the-clock weekend watch for any infection of the so-called SQL Slammer worm–also know as Sapphire and SQL Hell–that hammered other companies’ networks, the software maker apparently had escaped with only minor incidents in its international offices. Until Tue