Consider the following scenario. In Microsoft SQL Server 2000 Service Pack 4 (SP4), you perform one of the following tasks: • You use the sp_addalias procedure to add an alias in the user database. • You use the sp_dropalias procedure to remove an alias from the user database.
Other News
Master Data Management
(Daniel Druker and Robert Rich) Businesses have long known that a single system of record can mean higher profits and faster time to market. Most just haven’t been able to provide one. That’s about to change, thanks to a new approach to managing “master” data.
Security Firm: Oracle Opatch Leaves Firms Uncovered
(Lisa Vaas) Think you’re patched? Think you’ll get the thumb’s-up from the auditor when she comes knocking on your door to make sure you’re in compliance with HIPAA (Health Insurance Portability and Accountability Act), or GLBA, or Visa CISP and MasterCard PCI?
Truncate SQL Server Transaction Log
(lintom) This article explains how you can easily truncate a transaction log file without knowing the logical log file name. The code explains a very easy way to truncate the transaction log file by looking into the sysfiles table.
Initiatives Ramp Up Work on XML Naming and Design Rules Specifications
Several industry and government initiatives are now gaining momentum in their goal to craft guidelines and rules for naming XML components: XML namespace names, types, elements, attributes, code list enumerations, domain models, etc.
IBM and Oracle: Love at First Fight
(Joshua Greenbaum) There’s an interesting subtext to this year’s spate of acquisitions by Oracle, a sub-text that will shortly move front-and-center in the software industry. The subtext is the IBM connection, and in a fascinating case of opportunity creating strange bedfellows, Big Blue’s latest ro
Stored procedures: Perform specified operations on tables and objects
(Brian Walker) Here I will describe two simple routines. In the first, the SQL code creates a system stored procedure named sp_FixTables, which performs a specified operation on a specified set of tables. The second is a system stored procedure named sp_FixObjects, which performs a specified operati
How does migrating to Version 8 affect DSNZPARM: More planning stuff!
(Willie Favero) I know, you’ve been holding your breath wondering when I was going to get around to a discussion on DSNZPARM. Well, the wait is over. In today’s entry, I will take a look at a few DSNZPARM changes that I believe have the potential of affecting you after you complete your Version 8 mi
Move Data from an XML String into a DataSet
(Ken Getz) I have an application in which I need to take XML data that’s handed to me as an XML string, and import it into a DataSet. I get the data as a String containing the XML, and really don’t want to save it to a file before loading it. I checked out the DataSet class, and found that […]
SQL Server 2005 XQuery and XML-DML – Part 3
(Alex Homer) This is the third and final article in a series of three that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and