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 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

"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

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.

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.

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.

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.

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

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

An embedded application is one in which the entire technical architecture (hardware, application software, and DBMS) is installed completely at the customer site. Although the challenges of designing and developing an embedded software package are obvious, the effort of providing remote support for the deployed application is often underestimated.