This new high-performance platform enables you to build scalable notification applications on SQL Server that generate custom messages.

By Heather Harreld – UNISYS WILL WORK together with Microsoft, SAP, SAS, ProClarity, and others to build an integrated BI ( business intelligence) solution designed to further leverage the massive amounts of data companies collect and need to analyze, according to an announcement from Unisys on Wedn

By Kalen Delaney – When you move a backup of a SQL Server database from one server to another, you encounter some specific challenges. A common problem is that in the restore process, usernames and login names can be mismatched. Let’s look at why usernames and login names are important, why mismatch

LearnKey’s SQL Server 2000 for Developers offers developers, programmers, webmasters, and managers an in-depth look at this powerful product. Experts Mary Chipman and Andy Baron show you the essentials of using the Transact-SQL language and SQL Server’s graphical tools to perform all the tasks neces

Since SQL Server provides so many options for copying data between different databases and servers, novice/inexperienced DBAs often get confused, as to which option to go with, for maintaining a standby server. Some of those options include Data Transformation Services (DTS), BCP, Replication, Clust

By Tim DiChiara – On Friday, August 16 Craig Mullins, one of the world’s top database experts, examined each of the components that comprise the discipline of database administration. Whether you’re a newbie or guru-level database administrator, analyst, architect, or application engineer, this webc

By Michael Otey – Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.

SQLUP! clusters SQL Server databases over LAN or WAN, with no shared storage device. The software automatically synchronizes the clustered databases in real time and continuously monitors the servers and databases statuses and update levels, directing traffic to those databases that are available to

By William R. Stanek, Chapter 4: Core Database Administration – Core database administration tasks involve creating, manipulating, and supporting databases. In Microsoft SQL Server 2000, a database is a collection of data and the objects that represent and interact with that data. Tables, views, sto

To access the Microsoft OLE DB Provider for SQL Server (SQLOLEDB), the consumer must first create an instance of a data source object by calling the CoCreateInstance method. A unique class identifier (CLSID) identifies each OLE DB provider. For SQLOLEDB, the class identifier is CLSID_SQLOLEDB.