(aasim abdullah) Recently, I have received a mail from my friend who was angry that, the defragmentation script that I have mentioned in my post Simple Method to Resolve All Indexes Fragmentation is not working properly, even he executed said script multiple times. sys.dm_db_index_physical_stats is
Other News
Linked servers: how long do they stay connected?
(Linchi Shea) I was looking at some of my old notes on linked servers and found a tidbit on how the linked server connections are managed by SQL Server. I’m posting it here because I don’t think the information is widely known.
How to add IDENTITY column to existing table
(Radim Kolar) Every DB2 admin discovers sooner or later that DB2 can not add identity column to existing table easily. Following statements fails due to syntax error: alter table public.clicks add column id integer generated always as identity.
Budgeting for IDUG North America conference as viewed by the DB2 Locksmith
I’ve asked my good friend (and Information Champion) Rebecca Bond to write a guest blog entry for me. She chose to write it about the upcoming IDUG conference that is taking place May 2-5, 2011 in Anaheim California. As you will see, Rebecca is a gifted writer and I’m hoping she’ll write another b
Checked that MySQL backup log lately?
(Ronald Bradford) Running a MySQL backup and ensuring it completed successfully and backup files exist is not enough. In my B&R Quiz from Checked your MySQL recovery process recently? one important step is “Do you review your backup logs EVERY SINGLE day or have tested backup monitoring in place?”
RPG in an XML World
(Jon Paris) Whether using XML for web services or data interchange, dealing with XML documents from RPG presents some new and unfamiliar challenges.
Using XML/XSLT for Dynamic User Access Protocols
(Martin P) I have a small role in the setting up of the Irish national RIS/PACS system. I hope I provide more solutions than problems but I’m sure that could be debated. One of the questions that has appeared is of a category that appears in the implementation of pretty much any clinical system:
Create an adaptable phone book and contact list for your phones with XML and PHP
(Colin Beckingham) You need to keep in touch with contacts, even when you’re on the road. When desk-bound, you call with your desktop VoIP phone; when travelling, you use your smart phone. But each device requires that its phone list be in a particular format, each with its own distinctly formatted
ADF 11g : UI Designer meets ADF Developer
(Luc Bors) For years, creating a UI design for ADF Faces pages has been a pain in the ***. I have seen UI designs created in excel, powerpoint, and even photoshop. Designs looking great, however, nine out of ten couldn’t be realized using the ADF Component stack. Either because ‘non-existing’ compon
Oracle11g: Analyze Table Validate Structure Cascade ‘FAST’ (Slow Burn)
(Richard Foote) I always take notice when Oracle introduces a new “FAST” option, so it was with some excitement when I first noticed in Oracle 11g Rel 1 there was a new FAST option when running the ANALYZE TABLE CASCADE VALIDATE STRUCTURE command.