(Tim Chapman) Last week, I wrote an introduction to message-based applications in SQL Server 2005. In the article, I briefly mentioned Service Broker, the new component in SQL Server 2005 for building asynchronous message-based applications. A Service Broker application is a collection of one or mor
Author: SSWUG Research
XML for Perl developers, Part 1: XML plus Perl — simply magic
(Jim Dixon) This series is a guide to those who need a quick XML-and-Perl solution. In a surprisingly large number of cases, you only need one tool to integrate XML into a Perl application, XML::Simple. Part 1 tells you where to get it, how to use it, and where to go next. Once you whet your appetit
Two ways to build Apache Derby database applications in JRuby
(Robert Thornton) JRuby is an implementation of the Ruby programming language that runs in the Java Virtual Machine (JVM). This tutorial demonstrates how to install and configure JRuby to connect to the Apache Derby database. As Ruby and Ruby on Rails become more popular, JRuby becomes an interestin
Managing SQL Server using PowerSMO
(Dan Sullivan) PowerSMO combines two new Microsoft technologies: PowerShell – an object based scripting engine and command-line shell SMO – SQL Server Management Objects, a .NET based object model, which can be used in the management of SQL Server.
db2pd to monitor bufferpools
(Chris Eaton) One nice feature of db2pd that you can’t easily get from any other monitoring tool is the contents of your bufferpools. You can see bufferpool hit ratios with just snapshots but if the hit ratio is lower then you expect it may be difficult to find out what is in the bufferpool that is
Dealing With Upper and Lower Case Data
(Gregory A. Larsen) When working with data in SQL Server you might run across different needs to change the case of the data. For instance, you might want to convert all the characters in a varchar column to upper case, lower case, or change only the first character of a column value to upper case.
Understanding Directives and More with the Oracle HTTP Server
(Sam Alapati) Web servers can serve static and dynamic content, with most of the static content being stored on the server (corresponding to the default htdocs directory) and the dynamic content being generated on the spur of the moment, usually with the help of data from databases, for example. Con
Move and resize controls on a VB.NET form
(Irina Medvinskaya) There may be times when you need to move and appropriately resize the controls on a form. In this quick tip, I show how to set the controls in VB.NET forms so you can properly resize the controls based on the size of the form.
A Quick Intro to DB2 SQL Functions
(Craig Mullins) The last post I made to this blog used functions to translate data from one form to another. Functions frequently can be used to overcome issues when you are reading data from your DB2 tables. With that in mind, I thought it might make sense to go over DB2 SQL functions at a basic le
Sequences in Oracle 10g RAC
(Christo Kutrovsky) Just recently I got a call from a developer. He had a table with a primary key populated by a sequence, a timestamp column with the current date and some other columns. He had a specific set of data that, when ordered by the primary key had out of order timestamps. He was puzzled