(Joél Contreras) Managing multiple versions of the same database across different environments (i.e. Development, Test, Production, and Disaster Recovery site) is perhaps one of the most important and least favorable Database Administrative duties. Whether it’s synchronizing database objects or actu
Other News
Time is Right for Database Encryption
(Don MacVittie) Are data-privacy regulations and dreams about stolen employee data keeping you up at night? It may be time to protect your data where it lives–in your database. Database-encryption technology isn’t new. Ingrian Networks’ DataSecure Platform, which lets you encrypt certain fields
Open Integration and Security – XML firewalls provide ease of integration and security
(John Lilly) The superb new development tools from companies like Microsoft, BEA, IBM, and others, combined with the simplicity and openness of the standards, are providing real dividends to enterprises today. The examples are numerous: financial services companies outsourcing employee compensation,
How To: Stop a Server-Side Trace in SQL Server 2000
In Microsoft SQL Server 2000, you can trace SQL Server events by using a server-side trace that is performed by system stored procedures or by using a client-side trace that is performed by SQL Profiler. After you start a server-side trace, the trace continues to run and generates output until you s
Moore’s Law and the Myth of Open-Source Savings
(Erika Morphy) The announcement that SuSE Linux and IBM are establishing a joint Software Integration Center at IBM’s Toronto Lab in order to develop deeper integration between DB2 Universal Database and SuSE Linux technology was hardly unexpected, given the relationship between the two companies.
Using XSLT with PHP
(Shylon Ray Hunter) XSLT(XSL Transformations) plays a vital role in the transformation and presentation of XML documents. Though the primary intent of XSLT was in fact to perform complex styling operations, it has expanded past those boundaries into a general purpose XML process transformation langu
ExamXML Visual XML files comparison tool
The ExamXML was specially developed for comparing XML files. It produces comparisons very quickly and provides several options for comprehensive comparison. Reloading files after changing any of these options is not necessary. There are possibilities to save differences and common elements after com
A Potluck Party for XML
(Clint Boulton) How can XML applications written by disparate parties work in harmony? The answer may come n a flurry of demonstrations by top-tier vendors. The foundation language for Web services, which allow applications to talk to one another, Extensible Markup Language (XML) serves as the b
Oracle Warns of ‘High Risk’ Product Flaws
(Ryan Naraine) Data management heavyweight Oracle has issued an alert for “high risk” security flaws in several server products, warning that the vulnerabilities could lead to system access. The Redwood City, Calif.-based firm said a range of the server products was affected by vulnerabilities in
Writing Better SQL Using Regular Expressions Part Two
(Alice Rischert) A useful feature of regular expressions is the ability to store subexpressions for reuse later; this is also called backreferencing (summarized in Table 10). It allows sophisticated replace capabilities such as swapping patterns in new positions or indicating repeated word or letter