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 »

More Database, Procedures News Results

Features (151)

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 »

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 »

Finding dependencies in SQL Server 2005

This tutorial will show how you can write a procedure that will look up all of the objects that are dependent upon other objects. Read more »

Extend the reach of SQL Server with SQLXML classes in .NET

SQL Server 2000 provides XML features called SQLXML classes that are readily available without drastic changes to database design or related stored procedures. Here are a couple of examples of how to use these powerful features. Read more »

Passing table valued parameters in SQL Server 2008

I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions. Read more »

Configuring the corporate development environment

Builder.com looks at the three key elements of every .NET development environmentâ€"development workstations, development servers, and development procedures. 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 »

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 »

More Database, Procedures Features Results

Blog (5)

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 »

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 »

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

What's on?