Nobody can make a slave out of you if you don't think like a slave.
Databases
Mega Update - Part 2
In the last entry, I gave an overview of the large software update I delivered to a client, an update that should've been done incrementally over a period of several months. From database schema changes, to swapping out a reporting engine, to switching from ANSI to Unicode, I really bit off more than I could chew at once. But it's now working well and I'm once again sleeping at night!
This portion of the story deals with the database changes that were made, both the structure and the character set.
- David Cornelius's blog
- Add new comment
- Read more
- 279 reads
Mega Update - Part 1
I recently gave a client a major update to their custom application. Actually, "major" doesn't even do it justice. It was more like "mega major" and I don't think I'll take the approach I did ever again. But I wanted to move their code to the latest compilers and to support the latest operating systems. I also needed to change some low-level database constructs. Why all this? Because I'm a best-practices sort of guy.
Here's what I had to start:
- Delphi 2006 development environment
- ElevateDB database (ANSI)
- Rave Reports
- Other third-party libraries and custom components
- David Cornelius's blog
- 3 comments
- Read more
- 532 reads
ElevateDB
ElevateDB is an embedded SQL database engine that can be compiled directly into your application (when using Delphi or Visual Studio) and offers multi-user access locally or across the internet in client-server mode. ElevateDB adheres to a subset of the SQL 2003 standard. It is one of the easiest databases to code yet has many features found in much larger systems.
- Add new comment
- 316 reads
- Visit ElevateDB
Embarcedero's Blackfish SQL
The main product page for Blackfish SQL, a major database product from Embarcedero. Here you'll find an overfiew, FAQs, a feature matrix, licensing information, and more.
Developing and Deploying with Blackfish SQL and Delphi
Nick Hodges is a prominent evangelist for Delphi and related products. In this article, he explains some important concepts about developing Delphi applications with Blackfish SQL databases.
CodeGear's Blackfish SQL
When Blackfish SQL first arrived (or was repackaged), this article appeared to help introduce the "new" product.
Blackfish SQL or InterBase?
There are two very different database offerings from CodeGear, an old well-established and excellent engine called InterBase, and a newer one that is actually rewritten from JDataStore called Blackfis
Improve MySQL performance with a free Perl script
A perl script called MySQLTuner can help you optimize MySQL configurations.
SQL Server's "Flight Recorder"
SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder. It's an internal trace that has the last 5MB of various trace events and it's dumped to a file when SQL Server crashes. This
DB Data Generator
"DB Data Generator is a simple, powerful data generator that allows developers to easily populate databases with millions of rows of meaningful and syntactically correct test data for database testing
- Add new comment
- Read more
- 515 reads
- Visit DB Data Generator
DeZign for Databases
"DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases. DeZign for Databases uses entity relationship diagrams (ERDs
SQL Server Central
The largest Microsoft SQL Server community on the web. SQLServerCentral.com offers you thousands of SQL Server articles, FAQs, scripts, and forums to help your professional development as a DBA, developer or user of SQL Server.
- Add new comment
- Read more
- 605 reads
- Visit SQL Server Central
Oracle PL/SQL Sudoku Solver
There comes a time when the monotony of work needs a little refreshing diversion. Some of us like to relax (or frustrate) the time a way with a Sudoku puzzle which is fast becoming pandemic craze.
I enjoy solving these puzzles myself, but with a lust for a challenge, I could not resist the opportunity to develop a Sudoku puzzle solver written entirely in Oracle SQL and PL/SQL.
Top 10 Free MySQL Tools
Here are some of the best free MySQL tools out there. The descriptions are not a review of the product, but simply what the developers say about their tools.
- Add new comment
- 433 reads
- Visit Top 10 Free MySQL Tools
Powerful, Flexible Text-Formatting Solutions in SQL Server
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
Is a Temporary Table Really Necessary?
Sometimes you cannot avoid the use of a temporary table. You can in most cases but sometimes they come in handy. This article discusses the use and the alternatives to temporary tables from a query pe
SQL Sudoku
During a long wet May bank holiday weekend I decided to try my hand at a Sudoko puzzle in the Sunday paper. After all, how hard could it be?
Four frustrating hours later I thought "hang on, this is
- Add new comment
- Read more
- 494 reads
- Visit SQL Sudoku
SQL Server 2000 Maintenance Resources
Operate and manage SQL Server 2000 with the help of these resources.
SQL Server Baselining Tips: Lessons From the Field
"A known value against which later measurements can be compared" is one of many definitions for SQL Server baselining. In this article, the author shares his findings on this subject.
SQL Server 2000 Operations Guide
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.