News (6)

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 »

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 »

Security group names top software risks

A security organisation published its fourth annual list of the most vulnerable software on Wednesday, putting network administrators on notice that they need to check their systems. 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 »

MySQL boasts might against big players

MySQL kicked off its first-ever users conference by releasing the source code of its upcoming MySQL 5.0 product and touting its reputation as the little database company that could. Read more »

How to use quality gates to guide IT projects

Many projects don't have enough quality controls in place to ensure a quality product. Here's how to use "quality gates" to monitor project progress. Read more »

Features (118)

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 »

Create ActiveX servers for PL/SQL packages

When you're tuning database applications, your first impulse may be to follow the manuals' examples and start coding database logic directly into your code. Find out a better approach. Read more »

Diagnose SQL Server performance problems

Usually, the hardest part of database tuning is finding the code bottlenecks. SQL Profiler's traces can help you locate your sluggish code. Read more »

Diagnose SQL Server performance problems

Usually, the hardest part of database tuning is finding the slow part. SQL Profiler's traces can help you find your sluggish code. 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 »

More Code, Database, Procedure Features Results

Blog (5)

Google destroys Security Through Obscurity

Chris Duckett [blogs:betaliving] -- 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 »

Database pros get tools in the know

David McAmis [blogs:theneteffect] -- 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!

Lana Kovacevic [blogs:webanatomy] -- 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

Paul Ayre [blogs:controlaltdefeat] -- INAccess: Tales of woe revolving around the Access Database system Read more »

DB2 Viper Gets A Gong

David McAmis [blogs:theneteffect] -- New DB2 tools enhance the developer experience. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff A first look at Windows 7 beta

    In this week's Roundup we show you a preview of Windows 7 beta, cover news from the annual Macworld and more. Read more »

    -- posted by Staff

  • Staff Opera's new SDK: Better browsing on the Wii?

    Opera has thrown a little more love at device developers by announcing an updated version of its software development kit on Wednesday at CES. Read more »

    -- posted by Staff

  • Staff 2008: Time to call stumps

    It's another year down but some things never change. That was shown this week as Internet Explorer remained under fire from yet another zero-day exploit. In other news, we set a hard drive on fire and Apple cans its involvement with MacWorld. Read more »

    -- posted by Staff

What's on?