News (6)
Attack code raises Windows DNS zero-day risk
The public release of computer code that exploits a yet-to-be-patched Windows security hole increases the possibility of widespread attacks, security experts have warned. Read more »
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 »
Cybercrooks exploiting new Windows DNS flaw
Cybercrooks are using a yet-to-be-patched security flaw in certain Windows versions to attack computers running the operating systems, Microsoft warned late last week. Read more »
BEA woos nontechies with new software
Facing slowing sales to its traditional customers, BEA Systems is trying a new route: pitching its software to nontechnical businesspeople frustrated by the slow pace of IT change. 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 »
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 »
Features (135)
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 »
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 »
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 »
An alternative to inline SQL for ADO developers
Inline SQL statements make writing data access code easy but don't offer top performance. Stored procedures can slow development. Here's an alternative. 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 »
This pair of ADO tips will help tweak VB code
Tweak your VB code for more speed and efficiency with these two ADO tips on using a firehose cursor and raising errors from stored procedures. Read more »
Managed code in SQL Server Yukon: a big deal?
One of the big features of Microsoft's next release of SQL Server is the ability to run managed code. How does it work, and is it a good idea? Read more »
MVC design pattern brings about better organisation and code reuse
Using the MVC design pattern's three components for your development, you can open up new levels of robustness, code reuse, and organisation. Read more »
Blog (4)
The future remains yesterday
-- Remember when MySQL was blazingly fast and cared little for SQL standards? When MySQL regarded a view as something nice from your window and a trigger was treated as a weaponry component? Those days are set to return with a MySQL fork called Drizzle. Read more »
The Portal of the Future
-- At this year's Gartner Application Development, Integration and Web Services Summit, I attended Gene Phifer talk: "Portal of the Future: What's Beyond Web 2.0?". 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 »
Filter Tags
News and features
- Latest
- Popular
- Features
- Most Discussed
-
A first look at Windows 7 betaIn this week's Roundup we show you a preview of Windows 7 beta, cover news from the annual Macworld and more. Read more »
-
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 »
-
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 »
-
Ratbags burn, smash and 'nuke' hard drives
2008/12/16 14:49:30
-
2008/12/11 10:40:47
-
Five services you can turn off in Windows Server 2003
2008/10/01 13:58:07
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.