Featured Article(s) How to Hire a DBA? Your Questions Answered. Chris Shaw – Recently I posted an article on How to hire a DBA, I followed that up with a sample of questions that I would ask a DBA during an interview. I have presented the How to Hire a DBA as a 60 min session and I the questions […]
Other News
How to Read and Write RSS Feeds
(Laura Lemay and Rogers Cadenhead) Really Simple Syndication (RSS) is a popular way to publish web content and share information on site updates adopted by millions of sites. Because RSS is an XML dialect, it is structured under the rules of XML. In this chapter, you’ll learn how to represent data a
Accessing 32-bit DLLs from 64-bit code
(Mike Becker) Microsoft’s 64-bit technology first appeared with Windows Server 2003 for Itanium 2 (also known as IA64 Architecture) and for eXtended technology CPUs (also known as x64 Architecture). It offers many advantages but also raises new issues for the software developer. For example, you may
Getting Started with SQL Server 2005 Full Text Searching: Part 2 – The Indexes
(arcanecode) Yesterday I introduced you to full text searching, and covered the basics on creating catalogs to hold your full text indexes. A full text search index is a little different than a regular index. First, each table can only have one full text search index created for it. Next, the create
New db2diag.log formatting tool
(Chris Eaton) New in DB2 Viper 2 is a tool that lets you format and filter information that is in the diagnostic log (db2diag.log). Typically this log file is full of diagnostic information and in many cases the information in the file is intended for IBM Support personal to help them diagnose probl
Oracle 11g: New sql.bsq structure
(Marco Gralike) Probably one of the oldest database scripts around is the sql.bsq file. First comments described in the heading of this file date from 1994 (“anori – 11/17/94 – ADT support tables and columns”). In the “old days”, the days when I started (Oracle version 6, 7), it was common to alter
Reload data quickly into MySQL InnoDB tables
(Partha Dutta) As DBAs that manage large quantities of database servers, we are always looking for the fastest or most efficient way to load data into the database. Some DBAs have quarterly maintenance periods where they reload data into a database to refresh the indexes.
A Closer Look at Styles and Control Templates
(Chris Sells and Ian Griffiths) Picking up from where we left off last week, you’ll learn how to override style properties, set styles programmatically, and more.
.NET Serialization to a SQLite Database
(brettg) Most non-enterprise applications need the capability to store data locally. Some need only simple storage for things such as settings, whereas others need a full SQL database capability for various needs. I have written many such applications over the years. Until I found SQLite, I had to u
Understanding SQL Injection
(Hardik Shah) The basic idea behind this technique is to run the SQL query, something not intended by the programmer. SQL injection relies heavily on logical operations such as AND, OR, UNION, etc. If this technique is used properly, a malicious user can gain complete access to a web server. If the