(Steve Callan) As mentioned in a previous article, there is more than one approach or tool to use in a “tuning opportunity.” Ideally, the opportunity occurs before code has gone into production, but as we’re all aware of, a lot of time spent on tuning code takes places in production. Context is alwa
Other News
Introduction to Simple Oracle Auditing
(Ayyappa Yelburgi) This article will introduce the reader to the basics of auditing an Oracle database. Oracle’s RDBMS is a functionally rich product and there are a number of auditing alternatives available to the reader. Because auditing Oracle is such a huge subject, doing all of it justice would
Getting exclusive access to restore databases
A task that you may be faced with as a DBA is the need to refresh a test or development database on a periodic basis. This may be a scheduled process or it may be an ad hoc process. One of the things that you need to do when restoring a database is to ensure you have exclusive access to […]
New SQL on Call Show Posted
New SQL on Call Show Posted [Watch Now] Your Questions – the show today is all about answering viewer questions about SQL Server! Interview questions, what are the top 10 SQL Server tasks, working with management and more. Featured Article(s) Tips for using SQL Server 2005 constraints (Part 1) Here are some helpful tips to performance tune and optimize SQL […]
SQLonCall: Your Questions – the show today is all about answering viewer questions about SQL Server!
Pro-Center Video Programming for IT Professionals
SQL Server BI Marketplace – Headed for Consolidation (and stagnation?)
Featured Article(s) Using Oracle 11g Invisible Indexes This article describes how to use Oracle 11g’s new invisible indexes to prevent the accidental use of an index by a production system. We’ve Found Your SQL Assistant Just imaging having a good friend check your SQL code, help as you type, show you statement syntax and the like. This, versus having to […]
Aggressive DB2 Disaster Recovery
(Robert Catterall) Back in the mid-1990s, when I was on the DB2 for z/OS National Technical support team at IBM’s Dallas Systems Center, I did some consulting work for a major insurance company. For most of one day during an on-site working session, we reviewed the company’s documented disaster reco
Get namespaces from an XML Document with XPathDocument and LINQ to XML
(Scott Hanselman) A fellow emailed me earlier asking how to get the namespaces from an XML document, but he was having trouble because the XML had some XML declarations like .
Q+A: Locking
(Craig Mullins) I get questions e-mailed to me all the time. Although I try to read and answer them all, sometimes I don’t. I hope those whom I’ve ignored over the years will forgive me, but I can’t always answer everything (not enough time/energy) and sometimes things get lost or drop through the c
The Mystery of Removing XML DOM Nodes
(Dave Johnson) I was reviewing some code today and came across something that seemed very strange. There is a method we use for removing all the child nodes of a parent node in an XML document and it looked like this: