(Steven Warren) In my last article, we went over how to install SQL Server 2005 and what it entailed. In this article, we will continue by giving you an overview of what the new interface looks like. Let’s begin by exploring the menu bar as shown in Figure A.
Other News
Backup and Recovery with Unicenter Database Management r11 for DB2 for z/OS
This is the final of four technical updates for Unicenter Database Management r11 for DB2 for z/OS. We will discuss how the enhancements in this release can benefit the backup and recovery plan for your DB2 for z/OS environment. (R)
XML Options in Microsoft SQL Server 2005
Three options for handling XML data in the Visual Studio 2005/SQL Server 2005 environment are discussed, including usage scenarios and guidelines to help you choose between them.
SQL Server 2005: Two Little Known Features That Matter Big!
(Ravindra Okade) SQL Server 2005 brings a host of new features to the table. Ravindra Okade details a couple of nuggets that are not easy to find but can be very useful to every developer and DBA. Synonyms are very handy for managing database objects. And non-clustered index included columns, althou
Porting to DB2 UDB Version 8.2 from Microsoft SQL Server 2000
(Amyris Rada) Learn all about the DB2 UDB product family in this article that discusses porting databases and applications and describes the most important aspects of porting applications from Microsoft SQL Server 2000 to DB2 UDB V8.2. You’ll discover the differences between the two products in data
Managed C++: Authenticating Users via Hash Codes
(Tom Archer) A previous article covered how to use the .NET encryption classes to compare string values using hash codes. Another usage of hash codes is in situations where a system needs to authenticate a user without storing the user’s password. This is especially useful in situations where a
FIX: A 17883 error is written to the SQL Server 2000 error log and the LogWriter component does not yield correctly
The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: You experience one or more of the following symptoms on a computer that is running Microsoft SQL Server 2000: • SQL Server 2000 stops responding to incoming logon requests or to query execution requests. • You exp
Is Web services truly a reality or not? – Interview with Jean Paoli
Jean Paoli is a senior director of XML architecture at Microsoft Corporation and one of the co-creators of the XML 1.0 standard with the World Wide Web Consortium (W3C).
Status of XQuery in the .NET Framework 2.0
(Soumitra Sengupta and Charlie Heinemann) Microsoft has decided not to ship a client-side XQuery implementation in the final version of .NET 2.0 Framework (“Whidbey”). After talking to customers, we realize that our customers expect us to ship an implementation that meets the following criteria:
HOW TO: Install MySQL as Part of a UNIX-to-Windows Migration
MySQL is an open-source relational database management system (RDBMS) that supports the SQL query language. MySQL is available for most UNIX and Windows platforms, and it is typically used in combination with languages such as Perl, Python, and PHP. This article describes how to install MySQL on