This white paper on the Microsoft TechNet site provides a detailed explanation of the migration process and explores the improved database functionality of SQL Server.
Other News
Project management: A simple plan
By Ellen O’Brien – Why do so many data warehousing projects fail? Michael Corey says it’s because so many project managers lack clarity, and a commitment from the top. And he ought to know. Corey, a relational database expert, is the founder of Ntirety Technologies, an IT consulting agency, and is t
Decrypt encrypted stored procedures
(Joseph Gama & ShoeBoy) This code presents a stored procedure called sp_decrypt_sp that is used to decrypt T-SQL stored procedure compiled with the ENCRYPTION option. (R)
A Comparison of SQL Server 7.0 with SQL Server 2000
by Sergey Vartanyan – Are you still using SQL Server 7.0 and considering upgrading to SQL Server 2000? If so, this article may help.
Remove the Duplicate Rows from a Table
by Madan Patil – This script will remove duplicate rows. Even if you suppose one record is duplicated more than 2 times, the script will keep only one record and delete the others.The advantage of this script is that if you have loaded data from SQL*LOADER or from other databases or data imp
Java XML Pack Summer 02 Release
The latest release of the Java XML Pack, Summer 02, includes the Java API for XML Messaging (JAXM) v1.1, the Java API for XML Processing (JAXP) v1.2, the Java API for XML Registries (JAXR) v1.0_01, Java API for XML-based RPC (JAX-RPC) v1.0, and the SOAP with Attachments API for Java (SAAJ) v1.1.
Mozilla’s Potpourri of Rendered XML
by Nigel McFarlane – HTML and XHTML are no longer the only game in town—Mozilla has direct support for other XML languages, such as MathML (mathematical equations) and SVG (two dimensional vector diagrams). Learn about Mozilla’s fresh approach for rendering Web page content onto the screen. Be sure
Not My Type: Sizing Up W3C XML Schema Primitives
by Amelia Lewis – Since the application of XML to data representation first gained public visibility, there has been a movement to enhance its type system beyond that originally provided by DTD. Several attempts were made (SOX, XML Data and XML Data Reduced, Datatypes for DTDs, and others) before th
WhiteHat Arsenal Tool Set Aims to Knock Off Web Site Black Hats
By Michael Ross and Jeffrey H. Rubin – Only a handful of tools can assist with QoS (Quality of Service) testing before applications go live. Enter WhiteHat Security’s WhiteHat Arsenal 2.0, a collection of basic tools that help security professionals test Web applications for common security vulnerab
Query to show duplicate customers only once
By Jorge Cano – I would like to know how I can write a query that would only show my customers once, even though they are in the database more than that. Check out the solution.