(AshishChaudha) This article talks about a small project that presents the idea of having a GridView which facilitates the addition and removal of rows dynamically at run time.
Author: SSWUG Research
MySQL binlogs – Don’t forget to do your homework!
(Phil Hildebrand) Now that I’m back doing just database stuff, I’ve come to realize I’ve gotten a little sloppy about doing my homework. Homework’s never been my favorite thing in the world, but it often reduces stress when your under the gun during an outage or upgrade…
SQL*Plus tips #6: Colorizing output
(Sayan Malakshinov) If you have seen a colored scripts like a fish from gSession Snapper v.4 by Tanel Poder or OraLatencyMap by Luca Canali, you may be also want to colorize your scripts.
Reading XML Data
(Alan Burstein) In this post I will demonstrate how to query XML data. This is one of those things that is much easier to learn by example so I provided five examples. I won’t get into how to get the data in or out of SQL Server because that topic is outside the scope of this article.
Rolling DB2 tablespace location change using HADR
(Brian Fairchild) One of our Virtual-DBA clients has a small DB2 environment with version 9.7 on Linux and HADR connecting a primary and standby system. When the application team created the database, it was created using Automatic Storage on the /home filesystem.
Handling DateTime Data Type in C# : Part 1
(Vo Ducthanh) You can see that Datetime is a data type in C# with library support including methods for accessing time on the computer, such as: take time, current date, yesterday, tomorrow and this year.
Index-only queries for Prefix indexes
(Harrison Fisk) MySQL has two great features which historical haven’t played well together:
Stop showing row count information for the current session – SET Statements – SQL Server
(Ayyappan Thangaraj) SET NOCOUNT: This set statement tells SQL Server to show or hide the number of row affected by the transact SQL or stored procedure or any other statement that returns rows affected by the last executed SQL statement.
DROP TABLE … PURGE
(Andrew Reid) I tested this on Oracle 11.2.0.2.7. If the recyclebin is in use:
IBM Updating z/OS for Java 7, Aims for the Cloud
(John K. Waters) IBM wants to give customers using its System z mainframes the ability to extend their important business applications to the Web, the cloud and mobile environments, the company says. Toward that end, the company has updated its Enterprise COBOL for z/OS compiler to support XML Serve