(Susan Visser) DB2 has six current certification exams that each lead to a different certification role. The most common certification is IBM Certified Database Administrator. Here are the exams that cover DB2 9 content: * Exam 730 – DB2 9 Fundamentals * Exam 731 – DB2 9 DBA for Linux, Unix, a
Other News
Selecting Checkboxes inside the GridView Control
(Mohan Kumar Rajasekaran) The ASP.NET GridView control is the successor to the ASP.NET DataGrid control which has many built in functionalities like paging, sorting, editing or deleting data. In this article I will explain how to select checkboxes inside the GridView control.
XML data type in SQL Server 2005 vs. VARCHAR (MAX)
(Michelle Gutzait) As a database administrator, I tend to look closely at performance issues and how to make sure the use of XML does not affect SQL Server performance. In this tip, I’ll take you through an example using two tables, one inserted and queried with XML and the other with the VARCHAR (M
Using Events to manage Table Partitioning by Date: wrap-up
(Jay Janssen) As a follow up to the series of posts I’ve been making, I wanted to post what I ended up with. Thanks to everyone who posted comments, your help was extremely useful. To recap, I have a working pair of events to add and remove partitions to this table:
Oracle BI EE 10.1.3.3/2 – Executing Stored Procedures/Functions before Reports – Before Report Triggers and Global Temporary Tables
(Venkatakrishnan J) All users who have used BI Publisher or Oracle Reports would be aware of the fact that you can execute stored procedures as before report triggers and after report triggers. Lets look at a similar feature in BI EE today. Though i have discussed about this earlier in the VPD relat
SQL Server 2008 – iFTS Transparency – dm_fts_parser
(Simon Sabin) In the next in this series of posts on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser.
DB2 Recovery Basics – Part 1
(Chris Eaton) Previously I posted about the basics of Backup in DB2 (part 1, part 2 and part 3). Now I’ll write about some recovery basics. I’m going to assume that you are using log archiving (otherwise you must be using offline backups and the simple restore command is all you get to get yourself
Use Xerces-J to Obtain a Serialized DOM Tree
(Leonard Anghel) Suppose you need to serialize a DOM tree, with the result being an XML document. Xerces-J allows you to specify a maximum line length and an indent value
Microsoft’s Lineup of SQL Server Related Webcasts for March 2008
Fourteen new webcasts are scheduled for March, covering such topics as “24 Hours of SQL Server 2008”, “BI PerformancePoint Server Webinar” and more.
Using Connection Pooling in ADO.NET
(Bipin Joshi) Performance is an important consideration in modern software systems. Developers look for each and every opportunity to fine tune their applications for performance. To that end, ADO.NET connection pooling can significantly help you to write data access code that is performance oriente