(Srik Raghavan) Get a detailed look at how to set up SQL Server 2005 for Web service access in a heterogeneous environment, and learn more about key scenarios for Web services in SQL Server 2005.

(Stephen Swoyer) The Common Language Runtime is at the heart of Microsoft’s .NET vision. It promises to co-opt the benefits of Java–it’s a run-time environment that features a just-in-time compiler and built-in management services–with the bonus that (unlike Java) it’s language-independent.

(Brian Walker) In the coming months, I will present a series of tips that present SQL code for a variety of utility stored procedures. These stored procedures are intended primarily for administrative purposes, and they are designed to be installed as system stored procedures. A system stored proced

(Larry Chesnut) The other day I pointed all of you to Robert Dorr’s new paper titled, “Detecting and Resolving Stalled and Stuck I/O Issues in SQL Server 2000 SP 4”. The paper describes the introduction of a new feature for detecting stalled I/O. For SQL Server 2000, this feature is turned on with t

In Microsoft SQL Server 2000, when you try to run a script that was generated by SQL- Distributed Management Objects (DMO) for an Operators object or an Operator object, you may receive an error message that is similar to the following: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorre

(Douglas Reilly) In a recent article, I noted that I have had great success in using stored procedures to isolate client applications from database changes. Ensuing reader comments make it clear, however, that using or not using stored procedures to isolate applications from database changes is a ho

When the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer, you may receive the following error message every 24 to 120 hours: Old format or invalid type library error when processing MOM data

In Microsoft SQL Server 2000, you experience non-convergence in a replication topology. This issue occurs when you unpublish and drop columns from a dynamically filtered merge publication.

(Ashvini Sharma) Adjusting the following properties can have an impact on parallelization during execution.

(Luis Martin) Among the regular tasks of any DBA, there’s one thing that we all must find time for: research. In my case, I concentrate my investigation into new tools that streamline the tasks that I already do.