News (15)
Drizzle: MySQL slims down on Aker's diet
Brian Aker, MySQL's director of architecture, has unveiled Drizzle, a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL. Read more »
Most Oracle database admins don't apply patches?
Around 70 percent of Oracle database professionals say they have never applied a security patch, according to database security firm Sentrigo. Read more »
New hacker trick may expose Oracle databases
A new attack technique increases the risk of commonly found bugs in Oracle's database software, a security researcher has warned. Read more »
Firebird database readies SMP release
The open source project, which was created when Borland open sourced Interbase in 2000, is due to release a version of its database with full SMP support allowing enterprises greater scalability. Read more »
MySQL 5 reaches beta
The open source database company says it is 'fixing 10 years of criticism in one release'. Read more »
Microsoft wants to help reduce medical mistakes
By standardising on a common way to display medical data, Microsoft hopes to reduce the 600,000 errors that take place in US hospitals each year, many of them from medication mix-ups. Read more »
PostgreSQL gets enterprise backing
Pervasive Software has decided to offer commercial support and services for the open source database, due to the strength of PostgreSQL's technology and its choice of licence. Read more »
US Senate moves to legalise 'illegal NSA spying'
Google, Yahoo, MSN along with other search and e-mail companies may no longer be acting illegally if they spy on their customers and then share that information with the National Security Agency. Read more »
MySQL 4.1 moves in on Oracle
The open-source database is edging closer to parity with commercial databases with functionality such as binary prepared statements. Read more »
Ruby on Rails chases simplicity in programming
Can one man and a mantra of "radical simplicity" change the world of Web development? Read more »
Features (151)
Iterating through tables and databases in SQL Server
We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. Read more »
Take advantage of undocumented SQL Server iteration procedures
Here's a look at how you can use two built-in system stored procedures -- sp_msforeachdb and sp_msforeachtable -- to iterate through SQL Server tables and databases. Read more »
Write your own sp_lock system stored procedure in SQL Server 2005
The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. Read more »
Sending blob attachments in e-mail with utl_smtp
Last time, I showed how to send an HTML-formatted e-mail from an Oracle PL/SQL application using utl_smtp. I promised I would extend the package a little with a second method that allows you to send Binary Large OBject (blob) attachments in the e-mails. Read more »
Preserve log table entries using autonomous transactions in Oracle
Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently. A stored procedure for logging errors to a database table demonstrates this feature. Read more »
MySQL and stored procedures
Some people resisted using MySQL because it had no support for stored procedures. But starting with MySQL 5.0, that changed--now you can do stored procedures in this popular database. Read more »
Understanding roles in Oracle-stored procedures
Permissions in Oracle granted indirectly via roles are not available when compiling stored procedures, functions, and packages. Direct grants are required when creating these objects in the database. Read more »
Introduction to Policy-Based Management in SQL Server 2008
New to SQL Server 2008 is Policy-Based Management. This new technology allows for defining polices to ensure your database guidelines are met. This article gives an overview of this new technology. Read more »
Using Object Dependencies in SQL Server 2008
Tracking object dependencies has always been difficult with SQL Server. SQL Server 2008 makes it easier because it tracks dependencies by the object's name rather than ID. Here's how it works. Read more »
Moving the Tempdb and Master Database in SQL Server
This article walks you through the process of moving the Master and Tempdb databases to different drives. Read more »
Blog (5)
Database pros get tools in the know
-- Microsoft has just released the eagerly anticipated Visual Studio 2005 Team Edition for Database Professionals (TEDB) which allows developers to build database applications in a team environment. Read more »
Lets Shindig!
-- At this year's Google Developer Day in Sydney, Dan Peterson and John Hjelmstad talked about Apache Shindig, an open source implementation of OpenSocial and gadgets. Read more »
InAccess: Querying .Net
-- INAccess: Tales of woe revolving around the Access Database system Read more »
Google destroys Security Through Obscurity
-- Google Labs' new Code Search makes it easier for hackers to find database
username and password details by entering strings that are commonly used
within configuration files. Read more »
Filter Tags
News and features
- Latest
- Popular
- Features
- Most Discussed
-
This blog post covers some of the technologies available for creating applications for the Semantic Web. Read more »
-
Bridging the gap between programmers and the visionA successful project will have a hard time flying if you don't walk through the game plan before writing a line of code. Read more »
-
Social news start-up Streem shuts downSydney social news start-up Streem will shut down this afternoon, according to a heartfelt notice posted on the site this morning by its founder Elgar Welch. Read more »
-
How to Reset Windows passwords
2008/10/01 14:31:09
-
Five things to consider when choosing a Linux distribution
2008/10/01 15:50:33
-
Cyber-terrorism 'a big threat'
2008/12/01 12:43:32
What's on?
-
Space pr0n, patent karma and Yang out -- Club Builder
On Club Builder this week: how NASA plans to get the Internet into space, Jerry Yang is out the door at Yahoo and Brendan Eich discusses javascript engine competition.