(Gregory A. Larsen) Have you ever needed to write some code that would process through all the tables in a database? What about running some code against each database on a SQL Server instance? If so, did you know there are a couple of different ways to accomplish this? Either you can create a curso
Other News
The Top Seven MySQL Licensing Questions
(J.A. (Zak) Greant) This article aims to clearly answer seven of the most common questions asked by PHP users about MySQL’s licensing. For each question, this article attempts to provide a simple and direct answer that focuses on the intent of the question, rather than its literal meaning. Additiona
Which Document Management Solution is Right for You?
(Ian Altman) With the release of IBM Lotus Workplace Documents 2.0, and its recent acquisition of Aptrix and Green Pasture, IBM now has five distinct offerings for document and content management. So, how do you decide which product(s) is/are right for you? If you have four discussions, you’ll proba
The Search Path Less Traveled
(Michelle A. Poolet) You’ve been using keywords to help you locate data since you were a kid. Maybe you used a card catalogue the first time you went to your local library, or maybe the nuances of online search engines taught the youthful you about keywords. However you learned about them, you proba
Parlez-Vous BI?
(Robert Catterall) Does this scenario sound familiar? You’re a DB2 DBA with years of experience managing operational database systems. You’re in a meeting in which some business intelligence (BI) experts – your colleagues or consultants – are discussing various aspects of a new DB2-based decision-su
Playing .NET Doctor: Diagnose Application Hiccups with .NET Classes
(Mark Strawmyer) This month’s .NET Nuts & Bolts covers the different .NET Framework options for diagnosing issues within your applications. It touches on a couple of the classes available in the System.Diagnostics namespace and the functionality they provide for debugging and tracking an application
Partitioning in Oracle. What? Why? When? Who? Where? How?
(Pavi Agrawal) Business applications are growing at a faster rate than salaries, and so is the data supporting them, especially e-business applications where the data growth has been around 20-30 percent or more annually. Oracle came up with the idea of Partitioning the Tables.
Hooking Up with IBM DB2 Universal Database Version 8 Using Java (Sample Chapter)
(Kulvir Bhogal and Grant Hutchinson) Need a jump start on using DB2 with JDBC technology? Database programming with JDBC lets Java programmers interact programmatically with database systems. Kulvir Bhogal and Grant Hutchison discuss the subject of programming with JDBC when the target database is t
SQL Server Views
(Scott) In SQL Server a view represents a virtual table. Just like a real table, a view consists of rows with columns, and you can retrieve data from a view (sometimes even update data in a view). The fields in the view’s virtual table are the fields of one or more real tables in the database. You c
Selecting data by using LIKE with ESCAPE
(Hubli Sunil) This article explains about how to use ESCAPE keyword with LIKE to filter the data in a SQL query.