By Greg Robidoux – In this article, Greg talks about implementing and controlling all aspects of change management in SQL Server.
Other News
IBM to Offer DB2 Mastery Exam
By Lisa Vaas – IBM is launching a mastery exam to help database administrators identify and resolve thorny issues, the company announced last week. The DB2 Problem Determination Mastery Exam will give DBAs the skills to investigate and isolate database issues.
Creating Web services on Windows to access DB2
By Quentin Presley – This tutorial shows how to make your DB2 data accessible through Web services using the Application Developer configuration of WebSphere Studio v.5 on the Windows platform to develop and test Web services for DB2 data.
Data Placement (v8.1 DBA Certification Prep – Part 2 of 6)
By Dwaine Snow – This tutorial discusses the creation of DB2 databases as well as the various methods used for placing and storing objects within a database. This is the second tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Databa
Using ORDER BY in a View
Q. Why doesn’t SQL Server permit an ORDER BY clause in the definition of a view? A. SQL Server excludes an ORDER BY clause from a view to comply with the ANSI SQL-92 standard.
Tip: Avoid Auto-Growing Tempdb When SQL Server Starts
By Brian Moran – Many DBAs forget the performance impact of auto-growing files when managing space for tempdb. (R, $)
Implement Web Services Securely
by Andrew Yang – Web services have the potential to create a revolution in the IT industry, but only if security issues are addressed properly first.
Using XML to build an ASP+ config.web Editor
by Adam Cartwright – ASP+ configuration information is stored in XML-based configuration files. Using built-in features of IIS 5.0 and IE 5.0 such as the FileSystemObject, the XML Document Object Model (DOM) and XML Data Islands, we can easily develop a rich tool for modifying and editing these conf
Oracle Ships Collaboration Suite 2 With iMeeting But Not Instant Messaging
By Paula Rooney – Oracle Collaboration Suite Release 2 officially hit the streets without instant messaging, but that realtime feature will be delivered in yet another upgrade during the first half of 2004, Oracle executives said.
Critical Flaw Leaves Windows Server 2003 Vulnerable
(Dennis Fisher) Microsoft Corp. has issued a patch for the first serious vulnerability to be found in the Windows Server 2003 software, which company officials have said is their most secure OS yet.