(Lee Siegmund) Years ago, I heard a product developer describe his experience in creating a DB2* product feature by stating that “the solution was intuitively obvious after studying the problem for several years.” I can make the same statement relative to tuning DB2 SQL queries – I find tuning DB2 q
Author: SSWUG Research
Oracle Announces GRC Suite
(Renee Boucher Ferguson) Oracle is honing its focus on an area that is becoming near and dear to many corporations facing a daunting list of mandates and regulations: governance, compliance and risk.
Breaking Out of the Browser
(Steve Muench) In previous columns, I have focused on the basics of creating Web applications by using Oracle Application Development Framework (Oracle ADF). However, the Oracle JDeveloper environment is also great for creating applications that have a polished desktop look and feel. These desktop a
MySQL Multi-Master Replication
(Patrick Galbraith) I have put on the hat of a MySQL user, a customer, as opposed to a developer (Federated Storage Engine, DBD::mysql) these last couple months with my new employer, Grazr. One of the things we need is a whole replication set-up, with read-only slaves, and write masters. Thats maste
Using Asymmetric Encryption and Digital Signatures in a SQL Server 2005 Database
(Erich Peterson and Siqing Li) Two previous article of ours, An Overview of Cryptographic Systems and Encrypting Database Data and Using Symmetric Encryption in a SQL Server 2005 Database, explored cryptosystem fundamentals and looked at encryption support in Microsoft SQL Server 2005. We compared a
Forging Transact SQL Code with CodeSmith
(Jeffrey Juday) Coding Transact SQL (TSQL) can be tedious and repetitive. Often, a TSQL statement or stored procedure is a one-off variation of a program you may have written just yesterday. Nothing excites a developer more than eliminating unnecessarily tedious or repetitive work. Face it: We’re la
Using SMS 2003 SQL Views to Create Custom Reports
Microsoft Systems Management Server (SMS) 2003 Reporting uses Microsoft SQL Server views to provide access to data from the tables in the SMS site SQL database and to offer an efficient reporting option. The SMS site SQL database contains a large collection of information about the network, computer
FIX: The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005
In Microsoft SQL Server 2005, you run a warm query to obtain information from the Microsoft Search service. When you do this, the operation may take longer than you expect, and you may notice increased CPU usage. This problem occurs if the query is designed to perform a full-text search.
Hashing Credit Card Numbers: Unsafe Application Practices
Cryptographic hash functions seem to be an ideal method for protecting and securely storing credit card numbers in ecommerce and payment applications [1]. A hash function generates a secure, one-way digital fingerprint that is irreversible and meets frequent business requirements for searching and
DB2 9 Application Development exam 733 prep, Part 6: .NET programming
(Peter He) Learn about writing .NET applications that interface with IBM DB2. Get an introduction to the ADO.NET object model and see how to execute SQL statements with ADO.NET. This is the sixth in a series of nine tutorials that you can use to help prepare for the IBM DB2 9 Family Application Deve