(Kurt Cagle) Once again into the breach, dear friends. I’ve made it a habit over the last several years to put together a list of both my own forecasts for the upcoming year in the realm of XML technologies and technology in general and, with some misgivings, to see how far off the mark I was from t
Other News
Globalization and Localization
Applications must be designed to accommodate users from various cultures. Users in different parts of the world use different languages and different formatting standards for numbers, currency, and dates. International applications should be customizable according to the preferences of users belongi
Where is my WHERE?
(Alex Nuijten) Sometimes I encounter query which have a WHERE clause that starts with:
BACKUP compression in SQL Server 2008
(Muthusamy Anantha Kumar) After a long wait, SQL Server 2008 is going to be released with inbuilt compression for backups. Until the release of SQL Server 2005, compression was only available via third party backup software such as SQL LiteSpeed, SQLZip, etc.
CASE statement
The CASE statement selects an execution path based on multiple conditions. This statement should not be confused with the CASE expression, which allows an expression to be selected based on the evaluation of one or more conditions.
Working with TextBox Watermark Extender
(Nidal Arabi) Sometimes when you deal with textboxes you may need to specify more information than the description. The TextBox Watermark extender is just the control you need.
MySQL Architecture using MOCA
(George J. Trujillo Jr.) Proper installation of a MySQL database environment will make a tremendous difference in the management of the MySQL database server. This image shows key areas that need to be considered in defining the MySQL configuration. MOCA is used to demonstrate important points to co
Web Application Security: It’s Every Developer’s Problem
(Allan McNaughton) The importance of building secure Web applications is rising daily. CEOs are falling all over themselves to assure customers (and Wall Street) that appropriate measures are being taken to prevent unauthorized access to confidential data. The cost of a security breach can be mind-b
Oracle Database 11g: SQL Performance Analyzer, Part 3
(Jim Czuprynski) Oracle Database 11g Release 1 (11gR1) features the new SQL Performance Analyzer that promises to ease significantly the workload of busy Oracle DBAs because it provides a way to accurately evaluate complete database workloads for “before versus after” performance changes. This artic
HierarchyID Data Type in SQL Server 2008
This is another blog entry in the series of SQL Server 2008 posts. In this post, we will cover the basics of one more data-type: hierarchyID. This data-type, as the name suggests, can be used to store hierarchical data structures like organizational trees, file system structures or any other type of