By Brian Moran – Microsoft is relaunching a controversial licensing model called Licensing 6.0 that will change the way you buy and license SQL Server. The company is offering deeply discounted promotional prices during the transition period, which ends July 31, so you have about 7 weeks to decide w
Other News
Inside SQL Server Maintenance Plans
by Andrzej Kozlowski – Like a lot of database administrators who manage many SQL Server databases, I have problems with maintenance and administration tasks. Some of these are massive jobs, which have to be created and maintained to be sure that databases are robust and reliable. One of the tools I
SQL Server Log Shipping Overview
This article by SSWUG columnist Don Hite will describe the SQL server 2000 enterprise editions log shipping process and provide you with a quick background on it. Log shipping is particularly useful when a primary SQL server’s database or the server itself fails. Such failures can greatl
List the KEPT status for PL/SQL objects in your database
By Robert R. Blizard – This SQL*Plus script lets you list the KEPT status for PL/SQL objects (Packages, Procedures, Functions, and Triggers) in your database. You can show objects with a KEPT status of YES, NO, or both, and select the schema to show using standard Oracle wildcards. The script also l
Oracle joins with Sun to create system build-to-order programme
Oracle opened its OpenWorld European user conference in Copenhagen by announcing that it was joining forces with Sun Microsystems to provide customers with a system build-to-order scheme.
Update Your Data in Smaller Bites
By Brian Moran – Eating a steak in multiple, smaller bites is easier, safer, and tastier than trying to gulp it down all at once. The same advice holds true when modifying massive amounts of data.
MS SQL Server 7.0/2000 Extended Stored Procedure component for Delphi
This library implements a Delphi class for easy writing of Extended Stored Procedures for the Microsoft SQL Server.
Xml Validation Interoperability Framework 0.1
by Eric van der Vlist – Xml Validation Interoperability Framework (xvif) is a proposal to embed pipe definitions in grammar based schema languages such as Relax NG (and probably W3C XML Schema). The current implementation is built on a partial implementation of Relax NG, supporting the features need
Exams That Test Your XML Expertise
by Michael Domingo – July will be a busy month for Microsoft’s certification group and potential MCAD/MCSD.NET candidates. Microsoft recently updated exam guides for two MCAD/MCSD exams that test XML-based Web development:
PDF Presentations Using AxPoint
by Kip Hampton – This month, we will be examining AxPoint, Matt Sergeant’s Perl/XML-based tool for creating visually rich presentations and slideshows in PDF. Originally designed for use exclusively within the AxKit XML publishing environment, AxPoint has recently undergone a major facelift a