News (23)
Procedure hides data in images
Steganographic innovation can render 12-digit number invisible to eyes, clear to camera phone or PDA. Read more »
UK government in massive personal data loss
The UK government has admitted that its Revenue & Customs department has lost the details of 25 million individuals after two disks went missing in the mail. 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 »
Security spend triples, breaches fall 30 percent
A UK government-sponsored security survey reports that security breaches have fallen by a third in the past two years but spending on security has increased significantly. Read more »
Accenture: Embrace Web 2.0 cautiously
IT consultancy Accenture has advised businesses to accept Web 2.0 working practices but to beware of possible impacts on the IT department. 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 »
AFL teams a danger on the Web: Google
Google has flagged the Web sites of 10 AFL clubs as potentially dangerous, preventing visitors from accessing the teams' sites via the search engine. Read more »
IBM explores biological binary for chip refinery
Can scientists use the binary of biology, DNA, to grow carbon nanotubes into more efficient circuits? IBM thinks so. Read more »
PHP-based content management programs under threat
Popular free and open source blogging, wiki and content management programs face a security threat in the way PHP programs handle XML commands. 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 »
Features (184)
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 »
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 »
Serialise data with ANYDATA columns
With the ANYDATA data type and some dynamic SQL, it's possible to serialise as many tables as you wish into a single backup table using a single serialisation stored procedure. Find out how in this hands-on tip. Read more »
Advantages of using the ADO Command object
The Command object offers several unique advantages over the ADO Recordset object for programmatic data updating. This article gives specific code examples that display the Command object's flexibility. Read more »
Simplify .NET SQL queries with the DAAB
Microsoft's Data Access Application Block (DAAB) makes connecting .NET applications to SQL databases easier--if you know how to use it. Read more »
Tactical data access and analysis should be your BI design drivers
The implementation of a business information data warehouse can have a profound impact on an enterprise's decision making processes. A BI warehouse transforms data into a tactical tool, increasing efficiency and enabling better decisions. Read more »
Blog (5)
Daylight saving changes are standard procedure
-- Timezone data changes all the time, it's what governments do -- probably to keep the populace on their toes -- and yet we still survive. This time will be no different. Read more »
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 »
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 »
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 »
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.