Depending on your database server, including its configuration and maintenance, you may or may not be able directly restore a database to any previous point in time. However, even with applications to help with log file management and presentation it is not practical to use restored copies of a data
Author: SSWUG Research
SQL Server DTS Book Raffle
Enter to win a FREE copy of SQL Server DTS from New Riders Publishing!This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another.
Identifying Unnecessary Tables
by Robert Ware – Description: Recently I was asked to determine which tables of a very large data warehouse instance were still being used. This instance has been around for quite a few years, and the concern was that several tables were not needed anymore. I created the following method to aid in t
Oracle’s High-Priced Database Strategy Under The Microscope
By Barbara Darrow – Aside from stagnant IT purchasing, Oracle faces strong price pressure from IBM’s DB2 and Microsoft’s SQL Server databases. An eight-CPU version for Oracle9i costs 53 percent more, or $183,000 more, than IBM’s DB2 and a whopping 75 percent more, or $480,008 more, than SQL S
SVG 1.1, SVG Mobile Profiles reach Candidate Recommendation
The W3C has released Candidate Recommendations of Scalable Vector Graphics (SVG) 1.1 Specification and Mobile SVG Profiles: SVG Tiny and SVG Basic along with Working Drafts of An XHTML + MathML + SVG Profile and SVG 1.1/1.2/2.0 Requirements.
Transforming ADO Recordsets to XML with XSLT
(Jody Ansley) Whether or not it’s crept its way into any of your projects yet, eXtensible Markup Language is the data transport medium of choice for the foreseeable future. What’s so great about XML? For one, XML is self-describing. This means that the data itself contains metadata, or information a
Introduction to XQuery (Part 1 of 4)
by Srinivas Pandrangi and Alex Cheng et al. – XML blurs the distinctions between databases, documents, and messages, but it needs a powerful and elegant query language to reach its full potential. XPath does not go far enough. XQuery intends to be that language.
Testing SQL Server 2000: Inspecting Configuration Information
SQL Server installations can have differences in configuration settings and server properties, which can lead to subtle changes in code behavior. Therefore, you should inspect the configuration before beginning to code to a given SQL Server 2000 server. Ron Talmage provides tools and techniques for
Provide Feedback About SQL Server Documentation
By Brian Moran – Here’s how to provide feedback to Microsoft about the code snippets in SQL Server “Books Online” (BOL) and other SQL Server documentation sources.
Get your databases together
By Jon Rubin – The typical midsize-to-large enterprise today has a number of relational database management system (RDBMS) products, running on multiple platforms, with dozens of distinct instances–some of which host multiple database applications.