(Robert Westervelt) As a Yukon beta user, which features have you found to be exciting? Randy Dyess: Security has become more of a focus with this version. They have given the DBA the ability to tie in the SQL Server password with the Windows password policies. It gives the DBA a little more cont
Community
Understanding SQL Server Yukon Service Broker
(Jesus Rodriguez) The new version of Microsoft SQL Server “Yukon” comes together with a set of technologies capable of enlarging the horizon for database applications. One of the most remarkable technologies is the Service Broker that makes it possible to build database-intensive distributed applica
Compressing Data for Space and Speed
(Sanjay Mishra) Most decision support systems usually involve large amounts of data stored in a few very large tables. As these systems evolve, the demand on disk space can grow quickly. In today’s environment, data warehouses of hundreds of terabytes have become increasingly common. To help man
Yukon, Whidbey Delayed Until 2005
(Scott Bekker) Microsoft officials said on Wednesday that the next version of SQL Server, code-named “Yukon,” and the next version of Visual Studio, code-named “Whidbey,” will be delayed until the first half of 2005.
New DB2 vulnerability discovered
(Robert Westervelt) A vulnerability in IBM’s DB2 could allow attackers to gain administrative privileges on systems running version 8.1 Enterprise Edition of the database on Windows. (R)
A Practical Guide to DB2 UDB Data Replication V8
(Lijun Gu) IBM DB2 Replication (called DataPropagator on some platforms) is a powerful, flexible facility for copying DB2 and/or Informix data from one place to another. The IBM replication solution includes transformation, joining, and the filtering of data. You can move data between different plat
Force off applications connected to a specific database
(Dan Tuck) This quickly generates a command to force off applications connected to a specific database. The DB2 command “force application all” is too wide in its effect. This tip provides the needed command for a specific database. Just cut-and-paste the command to execute it. It has been tested on
Choice and Identification of XML Character Encodings
(Dan Chiba) When text is stored, transferred or processed, it is essential that the character encoding be known. This principle also applies to XML, because XML is text based. Despite the fact that XML may be encoded in various ways, there are no guidelines about which encoding to use and how to
Monitoring Failed Job Steps
(Leo Peysakhovich) One day I became tired of doing a manual procedure to check every morning to see if nightly backup, data transfer, and other jobs have failed. I decided to develop code that will automatically verify if jobs have failed and email the results to me. (R)
Date/Time from Substraction of Two Date Values
(Galina Petrenko) This technique presents conversion of the result of subtraction between dates. For example, I am looking for how many days, hours, minutes, etc. elapsed between two dates. Oracle Database is returning the result in days (such as 2.23456). The result is not exactly readable and has