News (17)

Samba prepares 3.2 launch under GPLv3

Samba will release the next version of its server software under the General Public License version 3 (GPLv3), which was launched by the Free Software Foundation last month. Read more »

Oracle gives SQL developers a helping hand

The release of the database giant's free development tool could make designing and debugging database code much faster and easier, but only for those using recent versions. Read more »

MySQL worm halted

A worm exploiting weak database passwords on Windows computers had essentially stopped spreading on Friday, after the systems infected with the program were cut off from the control of several central computers. Read more »

Script kiddies learn grown-up hacking techniques

Hackers with relatively few skills are using online guides to learn how to launch SQL injection hacking attacks. Read more »

Sun: MySQL buy 'most important in software history'

The company says its acquisition of open-source database provider MySQL will enable it to dominate in open-source server software. Read more »

Apple takes Safari to Windows and iPhone

Apple plans to ship a version of its Safari Web browser for Windows, and third-party developers will be able to get a piece of the iPhone, the company announced on Monday. Read more »

MySQL issues security fix

MySQL has issued a security update to address flaws in its client-server protocol that could allow a malicious attacker to exploit buffer overflow vulnerabilities and gain access to sensitive information. Read more »

Cisco patches security-monitoring system

Networking giant Cisco Systems has fixed several flaws in a security monitoring product meant to protect networks against attacks. Read more »

OpenScape builds presence

Electronics giant Siemens released the first major update Monday for OpenScape, a business application that manages communication via e-mail, instant messaging and telephone. 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 (189)

Delegate privileges to users with sudo

One of my favourite tools is sudo, a program that many users will be familiar with. Both Ubuntu and OS X popularised sudo by making efficient and default use of the program. Sudo allows regular users to perform commands as other users. 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 »

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 »

Choose the right JDBC driver for your database interface

Picking the right driver can optimise connectivity between your Java apps and database. Read more »

Copy legacy Oracle tables with SQL*Plus

Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how. Read more »

Creating and managing a Mysql database with phpMyAdmin

phpMyAdmin is a graphical user interface (GUI) developed in PHP, for creating and managing MySQL databases. Read more »

Bulk importing data into SQL Server

If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data. Read more »

Put some magic into your database

In this article from Oracle expert Scott Stephens, learn how to determine the type of object stored in Oracle BLOB fields. 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 »

Handle errors in the data tier with SQL Server

Exception handling is a standard part of every .NET application. The try/catch block allows you to catch exceptions and control application execution from that point. Many errors occur during database interaction, but a lot of developers are unaware of handling errors within the database tier. This week we examine error handling in your database code with SQL Server and T-SQL. Read more »

Blog (1)

CodeGear ready Ruby release

Brendon Chase [blogs:codemonkeybusiness] -- CodeGear have announced this week they will be releasing an integrated development environment(IDE) for Ruby on Rails developers in the second half of 2007. Read more »

Log in


Sign up | Forgot your password?

What's on?