by Randy Dyess – Tracking stored procedure versions is not easy with SQL Server. In this article, learn how the author wrote his own SP versioning system.
Other News
XML Standards for Financial Services
by Ayesha Malik – The financial services industry spends billions of dollars on IT development to maintain its competitive edge. Most recently, banks, risk management firms, and insurance companies have been focusing on automating business processes and building systems that reduce the time from neg
Why does my SQLXML 3.0 setup fail when I have MDAC 2.7?
Answer provided by Amar Nalla – The SQLXML 3.0 install may fail on machines that have MDAC 2.7 installed on them. If this happens you can check the value for the following registry key:
Top Six FAQs on Windows 2000 Disk Performance
by Mark Friedman – In this article I’ve provided answers to the most frequently asked questions I’ve received from experienced computer performance professionals. What I’ve found is when these professionals first start to look seriously at the data available on disk performance on a Windows NT/2000/
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
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.
BMC to Roll Out New SQL Server Tools
By Lisa Vaas – BMC Software Inc. on Monday plans to announce new SmartDBA data management tools for Microsoft Corp. SQL Server databases.
Mapping XML to Relational Databases
In addition to XSLT, there are several other XML document parsing and database specific techniques that can be used to migrate XML data into a database. Rather than focusing on these solutions, this example demonstrates how native ADO.NET classes such as SqlDataAdapter and DataSet can be used along
JAX Pack! – Bridging The Gap Between Java and XML Technologies
by Hitesh Seth – Sun has launched a set of technologies collectively known as the JAX Pack. JAX Pack – essentially a bundled set of Java technologies for XML – consists of JAXP (XML Processing), JAXB (XML Binding), JAXM (XML Messaging), JAX-RPC (XML-based RPC), and JAXR (XML Registries).
Design XML schemas using UML
By Ayesha Malik – Unified Modeling Language (UML) is an industry standard that is used in modeling business concepts when building software systems in an object-oriented manner. Recently, XML has gained ground in becoming a key enabler of these systems in terms of transport of information and comman