(Vinod Kumar) In many of the sessions and usergroups I’ve been asked by many for the best or rather should I say better practices of coding while using SQL Server 2000. The views listed below are mine and I’am sure any SQL Server Guru might not argue it otherwise. Just thought of adding sections for
Other News
Useful Trace Flags in SQL Server 2000
(Vinod Kumar) In this article, I will walk you through what trace flags basically are and how you can use some useful trace flags in SQL Server 2000 for administering and monitoring. Trace flags are used to temporarily set specific server characteristics or switch off a particular behavior, You will
DB2 Version 6 stored procedures migration issues, part 1
(Antonio L. Salcedo) In recent months I had the opportunity to be the technical team leader on a project for upgrading DB2 OS/390 from Version 5 to Version 6. In preparing for this project, my team studied many of the DB2 V6 manuals, attended the DB2 Technical Conference in New Orleans, participated
Converting Oracle Pro*C Programs to DB2 Universal Database
(Marina Greenstein) While many aspects of IBM DB2 Universal Database application development have undergone changes in recent years (stored procedures from C/COBOL/Java to SQL Procedure Language, support for SQL PL in User-Defined Functions, triggers and in-line SQL, enriched set of built-in functio
That Darn Alert Log
(James Koopmann) Until Oracle decides to give DBAs built-in direct access to the alert log, it will always be our responsibility to continually check and maintain it. Here is a simple solution that will help with this most basic of DBA task. The Oracle alert log file is a chronological log of imp
What is a cluster table?
A cluster is a schema object that contains one or more tables that all have one or more columns in common. Rows of one or more tables that share the same value in these common columns are physically stored together within the database. Generally, you should only cluster tables that are frequentl
Transferring data between XML documents and relational databases
(Robert Bourret) In this paper we will discuss strategies for transferring data between XML documents and relational databases according to two mappings (a table-based mapping and an object-based mapping) commonly used to map DTDs to relational databases. Although the discussion largely focuses on t
xmltramp and pxdom
(Uche Ogbuji) In this article I cover two XML processing libraries with very disjoint goals. xmltramp, developed by Aaron Swartz, is a tool for parsing XML documents into a data structure very friendly to Python. Recently many of the tools I’ve been covering with this primary goal of Python-friendli
Converting XML into a PHP data structure
(Dante Lorenso) In the last few years, XML has received great media attention, and most languages support the parsing and extraction of data from XML documents. Besides being a great three-letter anacronym to sprinkle on your resumé, XML is actually a useful data storage structure for PHP programmer
Who’s Afraid of Profiler?
(Brian Moran) “First, do no harm” is the essence of the Hippocratic oath, which physicians adhere to when caring for patients. It’s also good advice for DBAs. When you’re trying to fix a problem, a misstep that accidentally brings down a server might also bring down your career. I use SQL Server Pro