If you've been working with databases for a while, chances are you've heard the term normalization. Perhaps someone's asked you "Is that database normalized?" or "Is that in BCNF?" All ... Read More

In a recent forum message, dmcv wrote: "I have converted from Access 2003 to 2007. I have forms that have been successfully used since Access 97. In Access 2007 ... Read More

SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center. Read ... Read More

A recent CNN/CareerBuilder.com story highlighted database administration as one of the most promising career fields for new graduates. Their study showed that the DBA field is growing extremely quickly, ... Read More

Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of ... Read More

The TRY…CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and ... Read More

In a recent forum message, Marilena wrote: "I have created a database for new orders and recurring invoicing. The problem is I've tried many ways and I still can't do ... Read More

The Payment Card Industry Data Security Standard (PCI DSS) sets forth the security requirements for organizations that store, process and/or transmit credit or debit card transactions. These requirements stem ... Read More

Database professionals around the world are heralding the release of MySQL 5, just in time for the holiday season! This major release of the popular open-source database packs in quite ... Read More

Looking to shave some time off your daily Microsoft Access administration and design tasks? There are many great, little-known features of this program that you can use to improve the ... Read More

In a recent forum post, Sherald2000 wrote: "I'm using the 2003 Classroom Management template converted to 2007. Everything works fine, but I do not understand the Grade(%);. How is ... Read More

In our Databases for Beginners section, we provide a series of articles introducing you to the basic principles of relational databases. You'll learn how to select, design, manage and ... Read More

SQL Injection attacks pose tremendous risks to web applications that depend upon a database backend to generate dynamic content. In this type of attack, hackers manipulate a web application ... Read More