(Michael Otey) The next release of SQL Server—formerly code-named Yukon and now officially named SQL Server 2005—will provide deep XML integration with the SQL Server database engine. This integration will go well beyond the simple relational-to-XML mapping layer that SQL Server 2000’s SQLXML Web re
Other News
SQL Server 2000 Security – Part 2 (Authentication)
(Marcin Policht) Access to SQL Server resources is controlled by two separate mechanisms. The first one is authentication, which determines the identity of a user attempting to connect, based on a verifiable identifier. The second one is authorization, which establishes the level of privileges grant
Parsing in Oracle
(Amar Kumar Padhi) Whenever a statement is executed, Oracle follows a methodology to evaluate the statement in terms of syntax, validity of objects being referred and of course, privileges to the user. Apart from this, Oracle also checks for identical statements that may have been fired, with the in
Dr. DBA takes pulse of 10g
(Robyn Lorusso) The International Oracle Users Group handed out its first “Oracle Contribution Award” at this week’s IOUG Live! conference in Canada. Ken Jacobs, Oracle Corp.’s vice president of product strategy for server technologies and the man known as Dr. DBA, was its recipient. Prior to the aw
Reducing Round Trips Part 4
(Andy Warren) Over the past couple months I’ve posted three articles on how to reduce the number of round trips between server and client (Reducing Round Trips, Reducing Round Trips – Part 2, and Reducing Round Trips – Part 3). I’m going to finish up the series by looking at how XML provides yet a
Product Review: SQL Compare by Red Gate Software
(Danny Lesandrini) My first real production experience with SQL Server came when I upsized a popular event management system written in Access 97. Since Access Data Projects (ADPs) had not been released yet, we had to use Enterprise Manager and SQL Query Analyzer to maintain the database schema. Wit
Object-Relational Programming with DB2
(Susan Lawson) Explore some of the more powerful features of DB2’s SQL language. Learn about the extended programming features, User-Defined Functions (UDFs), table functions, triggers, and user-defined data types (UDTs).
FIX: You may receive incorrect results when you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause
When you run a query that contains a UNION ALL operator, a TOP clause, and an ORDER BY clause to retrieve data from a SQL Server database, you may notice that the data that is returned in the result is not consistent. The result you receive when the query is run the first time differs from the resul
The DB2 UDB DBA Checklist
(Dwaine R Snow) While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally. This document is broken down into checks or ta
Recover Dropped Tables in DB2
(Kulvir Singh Bhogal) A lot of ugly things can happen in the early morning hours when you are frantically trying to meet a deadline. For example, your mind can falter for a split second and you might accidentally drop an IBM DB2 Universal Database table. Before your stomach starts twisting in knots