This is the first of three articles by Herts Chen on overcoming the inability of calling stored procedures in UDFs and SQL statements by using OPENQUERY.

Two new computer attacks are wreaking havoc with PC users this week, clogging email systems and overwhelming corporate networks. The first, which oddly enough seeks to undo the damage from the infamous MSBlaster worm, is a worm called W32.Welchia or W32/Nachi; it aggressively looks for new hosts tha

By Robert Westervelt – A session at The Data Warehouse Institute (TDWI) 2003 conference was dedicated to establishing a code of ethics for database administrators, a sign that DBAs are more likely than ever to be held accountable by outside regulators.

Microsoft has released four Analysis Services-related hotfixes. The supported fixes are intended to correct only the problems described in the following articles. Microsoft recommends applying the fixes only to systems that are experiencing these specific problems.

Learn how to limit the number of detail rows for an order to a maximum of four.

by Neil Raden – A jumbled array of disjointed analytic, reporting, and alert tools exists in most enterprises, unconnected to a unifying enterprise BI architecture. The situation has to, and will, change.

BMC Software, Inc. (NYSE: BMC), a leading provider of enterprise management, announced new SmartDBA data management solutions for Sybase and SQL Server databases. With the addition of SmartDBA Performance Monitoring Solutions for Sybase and SQL Server, BMC Software is providing DBAs with a single co

My high-dollar consultants can get a basic SQL Server 7.0 Data Transformation Services (DTS) job set up and working. But they claim they can run the job only from the computer they built the job on. They tell me that If they run the job on a different computer, all the saved settings have to be rese

By Alexander Chigrik – Permissions are the rights to access the database objects. Permissions can be granted to a user or role to allow that user or role to perform operations such as selection, insertion or modification of data rows.

By Dennis Fisher – Security experts are now tracking a new variant of the Blaster worm, only this one attempts to patch vulnerable systems. Known as Blaster.D, the worm acts much like the original Blaster in that it infects machines that haven’t yet been patched against the RPC DCOM vulnerabi