(Baron Schwartz) If youfve used MySQLfs mysqlbinlog tool, youfve probably seen something like the following in the output: gexec_time=0 What is the exec_time? It seems to be the queryfs execution time, but it is not.
Other News
SQL Server: Natural Key Verses Surrogate Key
(Gregory A. Larsen) When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when
IBM Cognos Proven Practices: Dynamic Sorting of a List within IBM Cognos 8 Report Studio
(François DeGuire) This document describes a technique which applies dynamic column sorting on a list using custom IBM Cognos 8 Report Studio toolbox items.
How to setup and manage shared schedules for SQL Server Agent Jobs
(Atif Shehzad) I have configured a few SQL Server agent jobs for different purposes on my database server. Some jobs are required to run at the same time. In other words I am required to configure the same schedule for multiple SQL Server agent jobs. Is there any way to share a single schedule among
Database Controls – History Tables
SSWUG Free Expo Event: Real-World SharePoint Administration – Two More Days Friday, February 11, 2011, 9 a.m. – 1 p.m. PST Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership […]
Database Controls Revisited
SSWUG Free Expo Event: Real-World SharePoint Administration Three More Days February 11, 2011, 9 a.m. – 1 p.m. PST Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG […]
The New Normal, Part 2: the Second Uptake of XML, HTTP, and URI
(Bill Blondeau) We have pretty much come to think of XML, HTTP, and URI as old friends, reliably understood and fully assimilated. This is both true and untrue.
What’s next for XML accelerators?
(Steve Craggs) XML can be a bit of a power-eater – its verbose nature and constant switching between XML and non-XML formats can really be a drain on precious processing power.
Displaying XML data using XSLT transformations in an ASP.Net site
(Nikolaos Kantzelis) In this post, I will try to show you how to display xml data in asp.net website after making some xslt transformations.
Server-side installation of Optim Query Workload Tuner for z/OS
(Leif Pedersen) Hi, my name is Leif Pedersen, and one of my responsibilities is helping customers learn about and use Optim products, including Optim Query Workload Tuner for DB2 for z/OS.