(Serdar Yegulalp) Just like Windows Server, SQL Server can be administered directly on the computer to which it’s installed or from a remote computer. One common remote-administration technique is to use SQL Server Enterprise Manager, which can connect to a remote SQL Server via TCP/IP, named pipes
Other News
DB2 Universal Database Multiple Vulnerabilities
Multiple vulnerabilities have been reported in DB2 Universal Database, which can be exploited to cause a DoS (Denial of Service), gain knowledge of sensitive information, read and manipulate file content, or compromise a vulnerable system.
W3C Publishes Candidate Recommendation for xml:id Universal Identifier
The W3C XML Core Working Group has released the xml:id Version 1.0 specification as a Candidate Recommendation. The xml:id CR "introduces a predefined attribute name that can always be treated as an ID and hence can always be recognized. It defines the meaning of the attribute xml:id as an ID attrib
FIX: You may receive a 3628 error in SQL Server 2000 when you query many items that have an IN clause
The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: • When you run a query in Microsoft SQL Server 2000 that has many items in the IN clause, you may receive the following error message: Server: Msg 3628, Level 16, State 1, Line 2 A floating point exception occurre
Creating a Repeater that Supports Pagination and Sorting
(Rachael Schoenbaum) ASP.NET ships with a number of controls designed for displaying data, such as the DataGrid, DataList, and Repeater. While the DataGrid is, by far, the most robust of the three data Web controls, the DataGrid’s layout of its data is fairly rigid. That is, with a DataGrid each rec
Conquering the Breakpoint
(Satadip Dutta) As software architects and developers, we do our best to deliver 100% bug-free applications. Nonetheless, more often than not, bugs slip through and end up in released applications. That’s why although debugging—the sometimes onerous task of finding and removing bugs—doesn’t stop whe
Google, HP, Novell, and Red Hat Execs to Keynote the 2005 MySQL Users Conference
The program for the third annual MySQL Users Conference continues to expand — providing IT professionals, programmers, DBAs, and other users a more comprehensive look into the solutions and opportunities offered by the world’s most popular open source database. The MySQL Users Conference will be hel
A snapshot backup may not be finished successfully when multiple VDI snapshot backups occur in SQL Server 2000
When you run a snapshot backup command from a Microsoft SQL Server Virtual Device Interface (VDI) application, the backup may not be finished successfully if the following conditions are true: • Multiple VDI snapshot backups are occurring. • The thaw command (CompleteCommand) has not been is
How to Best Implement a SQL Server Performance Audit
(Brad M. McGehee) If you have gotten this far, you have done a lot of reading. In this final article on how to perform a SQL Server Audit, we will take a look at some best practices about how to best implement a SQL Server Performance Audit. You will want to read this before you begin any actual per
Implementing and Managing APPC Protected Conversations
(Paola Bari, Mario Bezzi, Massimo Biancucci, Kenny Blackman, Graham Davis and Kim Patterson) APPC Protected Conversation is a function provided by the operating system to exploiters running on z/OS. This function improves data integrity in distributed processing environments by enabling particip