(Dan Benjamin) This article is a major update to the older (but tried-and-true) post, Building Ruby, Rails, LightTPD, and MySQL on Tiger. Both Ruby, Rails, and their underlying infrastructure have come a long way in recent months, and this article will get you to a leaner, meaner Rails install in le
Author: SSWUG Research
SQL Server 2005 Integration Services – Part 42 – XML Task continued
(Marcin Policht) In the previous article of our series dedicated to SQL Server 2005 Integration Services, we started discussing various types of actions that can be performed using XML Control Flow task, covering its Validate and XSLT options. We will continue this subject by focusing our attention
Persisting Your Visual Basic .NET Objects with .NET Serialization
(Jeff Cogswell) If you’re developing a standalone .NET application, more than likely you’ll need to provide your users with the ability to save and later load data. There are many ways to approach such a task. The wrong way to do it is to open a binary file and write the individual data strings and
Trade risk for speed with Oracle 10g’s asynchronous COMMIT
(Bob Watkins) One thing that Oracle DBAs know for a fact is that a transaction isn’t committed until it is written to the online redo log files. If a COMMIT statement in an application completes, the application can trust that the data is protected against instance failure, and can be recovered by ”
IBM XQuery Whiteboard for DB2
IBM XQuery Whiteboard for DB2 is a graphical tool that extends the XQuery capabilities in IBM DB2 Version 9.1 for Linux, UNIX, and Windows. A user can enter an XQuery expression and see the result after it has been executed. The XQuery expression can refer to information in the database, in local do
Forms Services and multiple IIS Web Applications
(Alexei Levenkov, Nicholas Lovell and Balbir Singh) We often get questions asking if the XmlFormView control can be used in a particular environment. Usually you will use it on a regular page that belongs to a WSS Site or on a page in _layouts folder of a WSS site. These scenarios are supported and
Show 54: Security, DST changes, better searches, Day 1 as DBA, hot topics on the discussion lists
Pro-Center Video Programming for IT Professionals
PlanetMySQL Fixed (And How I Fouled It Up)
(Jay Pipes) OK, so a number of you may have noticed some major gumming up of PlanetMySQL over the last week or so. Some feeds were not appearing at all, and yet other feeds were inserting entries that had nothing to do with MySQL — entries that previously never made it into the PlanetMySQL database.
FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement
Consider the following scenario. You start the SQL Server 2000 service. You execute the BACKUP DATABASE statement or the BACKUP LOG statement at least one time. In this scenario, CPU utilization may approach 100 percent. After approximately 15 minutes or less, CPU utilization decreases.
New Isolation Levels Available in SQL Server 2005
(Brad M. McGehee) One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. The isolation level directly impacts the performance of SQL Server, along with the integrity o