(John Ferguson Smart) Writing consistently clear, high quality, maintainable code is an art that requires a certain amount of discipline at the best of times. Coding standards lay out rules and recommendations about the way code should be written and also enshrine good coding habits. Recently, codin
Author: SSWUG Research
FIX: Error message when you try to install SQL Server 2000 Service Pack 4 on a SQL Server 2000 cluster
When you try to install Microsoft SQL Server 2000 Service Pack 4 (SP4) on a SQL Server 2000 cluster, the installation may fail. Additionally, an error message that is similar to the following may be logged in the SqlspX.log file: C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetup Binscm.exe -Silent 1 –
Learning Oracle RAC with the NetApp Simulator
(Sachin Garg) Oracle Real Application Clusters (RAC) is a fascinating technology that can enhance system scalability, availability, and performance in many different ways. However, evaluating or getting hands-on experience with RAC requires expensive hardware to which most DBAs do not have access.
Optimizing Queries with Operators, Branching and Functions
(Jon Stephens and Chad Russell) In this chapter, we’re going to explore the central premise of this book: It is almost always the best course of action to make the database perform as much work as possible, thus minimizing the amount of filtering and manipulating data that you do in your programming
httplib2: HTTP Persistence and Authentication
(Joe Gregorio) Last time we covered HTTP caching and how it can improve the performance of your web service. This time we’ll cover some other aspects of HTTP that, if fully utilized, can also speed up your web service.
SQL Server Performance: Query Tuning vs. Process Tuning
(Nils Bevaart) In the different projects where I perform a performance audit or am involved in performance tuning, I often find that while queries and stored procedures function correctly, they are not efficient in processing larger data sets. Many OLTP databases are set up as OLAP databases to hand
SCXML: State machine notation and voice application development
(Peter V. Mikhalenko) Digital telephony is spreading wide and fast, entailing new technologies for voice communication. In this article, I’ll review a new XML language intended for usage in the telecommunications industry.
Oracle’s Acquisition Binge: Trying to Cover All Its (Data) Bases
(Knowledge@Wharton) For Oracle, the past few months have been one big shopping spree. On January 31, 2006, the enterprise software giant purchased longtime rival Siebel Systems, the leading provider of customer relationship management software. On February 14, it acquired Sleepycat, an “open source”
Deploying Oracle 10g with Altiris Deployment Solution on Dell PowerEdge Servers
(Chethan Kumar, Eric Szewczyk and Mahmoud Ahmadian) Altiris and Dell offer an integrated solution for bare-metal Adeployment of Dell PowerEdge servers that leverages the Dell OpenManage Deployment Toolkit (DTK). Altiris Deployment Solution for Dell Servers, a component of the Altiris Server Manageme
Check the validity of your backups
(Chris Eaton) Are you the kind of person that can’t sleep at night because you don’t know for sure if you turned the lights off in your living room? So you get up and go downstairs just to make sure only to find out they are already off. And then you get into the office and see that your previous […]