By Lisa Vaas – BMC Software Inc. on Monday plans to announce new SmartDBA data management tools for Microsoft Corp. SQL Server databases.
Author: SSWUG Research
Ensuring All Non-NULL Values Are Unique
SQL Server has no built-in mechanism to prohibit duplicates except NULLs, so you need to implement a custom CHECK constraint to enforce this restriction. For example, the following code snippet enforces the kind of integrity you’re looking for.
Scripting SQL Server 2000 Indexes
SQL Server 2000’s Enterprise Manager contains a scripting tool that you can use to extract basic index drop and create commands. However, to create such a script you’ll have to painstakingly cut and paste, and the result will not have any error checking. In this article you’ll see how to construct S
Oracle ups Linux efforts with ISV program
By James Niccolai – Oracle is launching a program to encourage its software partners to offer versions of their applications for Linux, and it will pay out some $150 million a year as part of the initiative to help with their marketing and development efforts.
MySQL or SQL Server: Look beyond politics and hype when deciding which to use
By Sanders Kaufman, Jr. – Aside from the obvious difference of price, what distinguishes these two products from each other, and how do you choose between them? Let’s take a look at the core differences between these two products, including licensing costs, performance, and security.
Office 2003 may pose antivirus problem
By Patrick Gray – The problem centers on macros embedded in documents in the Office 2003 beta, or test, version. When saved as an XML (Extensible Markup Language) file, the macros can more or less wind up anywhere. This means that scanners must search the entire contents of a file, rather than exami
Architectural Design Patterns for XML Documents
by Kyle Downey – This pattern contains XML untyped by DTD or schema, but follows accessors for underlying program objects. It allows for unlimited extension by multiple, uncoordinated parties at the cost of lack of type-checking; and is simple to implement, with supporting libraries abounding (e.g.
XQX Version 1.0-Beta, an XML interface to relational databases
XQX is the innovative product which enables companies to make available, their data, in an easy and effective manner. With the power of XQX companies can allow people, both within and outside their organization, to retrieve important information, and deliver that information to a variety of endpoint
Create Your Own SQL Server Job Management System
by Randy Dyess – If you don’t have the ability to easily manage the jobs on your SQL Server, then you may want to consider writing your own SQL Server job management system, like the one described in this article.
Standards: Optional Features or Law?
by Dimitris Dimitriadis – In an earlier article, I argued that providing uniform test frameworks and detailed specification formats would enhance interoperability of specification implementations. Technical issues aside, some of which I discussed in that article, there are a few important reasons wh