(Tim Chapman) All competent DBAs and developers should possess the ability to logically define constraints in the database, as well as define those constraints via TSQL code. This article explains how to define constraints with TSQL and explores different ways to define these constraints via TSQL.
Other News
MySQL Table Checksum 1.1.0 released
(Xaprb) MySQL Table Checksum 1.1.0 adds many improvements, but the most important is a new way to ensure slaves have the same data as their master. Instead of checksumming the slave and the master, it can now insert the checksum results directly on the master via an INSERT.. SELECT statement. This s
IBM System Storage N series Best Practice Guidelines for Oracle
(Alex Osuna, Eva Ho, Eric Barrett, Bikash R. Choudhury, Bruce Clarke, Ed Hsu, Blaine McFadden and Tushar Patel) This IBM Redbooks publication describes best practice guidelines for running Oracle databases on IBM System Storage N series products with system platforms such as Solaris, HP/UX, AIX, L
Future SQL Server to add policy management
(Margie Semilof) There won’t be any sweeping architectural changes or big promises for the next generation of SQL Server. Instead the company will stick to the basics in hopes that IT shops will recognize its value in helping to control the mounds of data in corporate data warehouses today. (R)
Microsoft says support for Open XML is growing
(Eric Lai) Citing statements of support from more than 300 companies and organizations, Microsoft claimed on Tuesday that interest in its Office Open XML file format continues to grow.
IDUG recap – Day 3, Monday, May 8, 2007
(Willie Favero) IDUG’s second full day is in the books. From an attendee’s point of view, this was a very, very good day for presentations.
Testing for DW/BI – Current State and a Peep into the Future
(Arun Sundararaman) Just as with any other software application involving different technologies (such as the mainframe, Java or Microsoft), testing is a very crucial phase in the software development lifecycle for data warehouse/ business intelligence (DW/BI) projects. Testing for DW/BI carries uni
The issue with FillSchema
(Reggie Burnett) Connector/Net’s MySqlDataAdapter class has a method named FillSchema. This method is intended to populate the metadata for a given query without actually returning any of the data from the query. The only syntax that MySQL has to help with this is SQL_SELECT_LIMIT which limits the
Oracle Extended RAC: Stretching your RAC to the limit
(Tarry Singh) Network cards are getting faster, internet connections are increasingly becoming faster. There are even talks of 1Gbps internet and faster coming available. Oracle RAC can benefit from such developments, but did you know that you could stretch your RAC geographically (well almost) if y
Bridge the Legacy-to-Java Transition with DB2 for i5/OS Distributed Transactions
(Jarek Miszczyk) In my 20+ years experience in the software development field, I’ve met only a few (lucky) system architects who had the luxury to design new software solutions from scratch. More often, a system architect faces a challenge of integrating existing software components developed in leg