(Eli Leiba) This article describes how to implement a flexible backup strategy for all databases in a given SQL server. All databases are backed up completely or differentially by using a backup strategy control character depending on the database name and the day in the week. The control character
Other News
INF: SQL Server Hotfix Installer
Microsoft SQL Server 2000 hotfixes will be packaged and delivered to users as a self-extracting executable file. The Hotfix installer helps you install hotfixes by using a GUI based setup program. By using the Hotfix installer, you can also automate the hotfix installation process across your whole
Patching Oracle, IBM For The Holiday
(Clint Boulton) Security experts at U.K.-based Next Generation Security Software brought tidings of security vulnerabilities in Oracle and IBM software in time for the Christmas holiday.
SQL Server 2005’s Snapshot Isolation
(Ravindra Okade) Now that SQL Server 2005 is almost here, it is time for you to read up on and apply some of its new features to your databases. Many of the new features are pretty straightforward (synonyms, for example), but some are less so.
Laying Out the Foundations (Sample Chapter)
(Cristian Darie and Mihai Bucica) This chapter lays down the foundations for the future TShirtShop web site. We will talk about the technologies and tools you’ll use, and even more importantly, how you’ll use them. Your goals for this chapter are to • Analyze the project from a technical point o
PeopleSoft, Oracle User Groups Have Their Own Merger Issues
(Charles Babcock) When PeopleSoft agreed to be acquired by Oracle, Charles Phillips put in a call to Quest, the J.D. Edwards applications user group, to assure the organization that Oracle wanted to work with the group. But by singling out Quest to contact, Oracle’s president stepped into the middle
Oracle 10g Availability Enhancements, Part 2: Flashback Database
(Jim Czuprynski) Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This article – part two of a series – explores one of the most intriguing new features of Oracle 10g: Flashb
X12 EDI: It’s Not Dead Yet
(Michael Jones) In an article published last week on DevX entitled “Why EDI Must Die”, the author, Jeremy Jones, gives several reasons why he believes XML is superior to the X12 format for electronic data interchange. He points out several shortcomings of X12 and several arguments as to why XML is a
Passing parameters using simple T-SQL XML parsing
(Eli Leiba) This article describes an alternative way of passing a varying number of input parameters from one T-SQL stored procedure to another by using the built-in OPENXML T-SQL row set statement in order to parse a given XML string. (R)
Verity HIPAA Compliance Solutions
Complying with the Health Insurance Portability and Accountability Act (HIPAA) is a significant undertaking that can test the mettle of even the most seasoned data-security professional. With unmovable deadlines, thousands of stringent new regulations and severe penalties for non-compliance, HIPAA l