(Ben Johnson, Leilei Li and Jack Yuan) IMS, IBM’s hierarchical database-management system, continues to improve its availability and performance with enhancements specifically designed for z/OS Sysplex Distributor. This article explores some of those enhancements made available with Version 9 as wel
Author: SSWUG Research
Using XML Data Services in distributed Applications
(Rick Strahl) XML is driving the distributed application revolution on the Web today and more and more generic XML services are becoming available. In previous articles, Rick has discussed custom XML messaging solutions. In this article, he describes generic XML data services that can simplify and o
Retrieving environment variables with VB.NET
(Irina Medvinskaya) Windows stores some important information (e.g., computer name and user name) in the environment variables. The ability to access these variables to retrieve their values comes in handy in many applications. In this tip, I look at how you can use VB.NET to retrieve the informatio
Get Information on Current Queries
(Laurent Leturgez) This script provides information about the queries that are currently using temporary segments.
Step-by-step Guide: Test for a Trojan horse on your SQL Server
(Kevin Beaver) Has your SQL Server been acting up lately? No, I’m not referring to the typical database and operating system issues we all must endure. Rather, are you experiencing server sluggishness, erratic behavior, heavy network traffic, or an increase in server processor or memory utilization?
PostgreSQL vs. SQL Server, Oracle: Enterprise-ready and able to compete
(MiMi Yeh) Why are you paying so much in licensing costs and annual maintenance when you could use PostgreSQL for free, and get community support and upgrades for free as well? This is the question that Neil Matthew and Richard Stones pose to smaller companies regarding their less critical applicati
Demystifying VSAM Performance
Underlying all great powers is a little bit of mystery — and VSAM is no different. It’s a powerful system for accessing System z data, and yet if you have struggled with VSAM performance, it may seem slow and mysterious. Learn how to unlock the mystery of VSAM performance. (R)
SQL Server 2005 adoption rates, SQL Connections and more
Pro-Center Video Programming for IT Professionals
Enabling a Business Intelligence Self-Service Platform Across the Enterprise
(Noe A. Gutierez) Throughout the years, I have been witness to many Data Warehousing projects that started as an effort to help the business users make business decisions using information and along the way transformed into data centralization exercises. Somewhere during the project execution, the t
Encrypting Connection Strings in ASP.Net 2.0
(Dipal Choksi) ASP.NET 2.0 allows storing connectionString elements within the connectionStrings section in web.config. The web.config section containing connection strings can be encrypted for security. The connectionStrings section is commonly used in most applications as the intuitive location fo