by Michael Balloni – Relational databases like Microsoft’s SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data a
Other News
Restoring Your Database Safely
By Joe Lax – As I’ve shown in my previous 10-Minute Solution, “Choosing the Right Backup in SQL Server,” SQL Server provides you with numerous ways to back up your database, allowing you to choose the options that best suit your situation. However, the best backup solution comes to naught if you don
XML Programming (Core Reference)
Learn how to use XML and the Microsoft® .NET Framework to build extensible, end-to-end applications that work seamlessly across the Internet. Check out the book.
XML-RPC for Scheme
Pete Hopkins has released the amusingly-christened CapnRPC, an XML-RPC implementation for PLT Scheme implementations MzScheme and MrEd.
XML and Databases? Follow Your Nose
by Leigh Dodds – Following a recent XML-DEV discussion on how to choose the most appropriate database for your XML application, the XML-Deviant captures the indicators that will help bring you closer to a decision.
Finding and Eliminating Duplicate Data
During my years as a database developer I have often faced the task of finding and deleting duplicate data in a database. Duplicates impact data accuracy and credibility, and they can also affect database performance if they’re too numerous compared to the total number of rows in the table. The solu
Check for Oracle availability and tablespace capacity
By Rick Stehno – Checking Oracle for availability requires more than just a ping or a ‘ps -ef | grep oracle’ command. I believe it requires a test accessing Oracle using SQL*Net to verify that the listener is also up and running — this would be the access that a user would normally use. By actually
Watch the Latch
Latch is a low level locking mechanism provided by oracle. In this article we will look at the latch concept and how to tune the server to reduce latch contention. Check out it out here.
Tracking Down Event Clues – Tracing the server side of SQL Server 2000
By Kalen Delaney – The SQL Server Trace tool lets you keep track of all the operations that SQL Server performs. For SQL Server 7.0, Microsoft completely rewrote the Trace tool. Microsoft dubbed the new incarnation SQL Server Profiler. However, the SQL Server 7.0 documentation never made it complete
Choosing the Right Backup in SQL Server
By Joe Lax – When I started using SQL Server in version 4.2, backups were relatively simple. There were only two possibilities: a full backup or a transaction log backup. Starting with SQL Server 7, additional choices have proliferated. You now have four ways to back up your database.