Tags: database, statements
News (84)
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 »
Sun releases MySQL 5.1
Sun Microsystems has released the updated 5.1 version of the MySQL open source database software it recent acquired, promising improved performance and management of larger database applications. Read more »
Microsoft releases SQL Server 2008
Microsoft said on Wednesday in the US that it had finished work on SQL Server 2008, the latest version of its database software. 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 »
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 »
MySQL backtracks on closed-source plan
Sun has backtracked on previous plans to release important backup features for its MySQL database under a proprietary licence, following widespread criticism from the open-source community. Read more »
Embarcadero embarks on a new journey with CodeGear
Embarcadero Technologies, a provider of professional database tools has signed a deal to acquire CodeGear, currently a part of the Borland Software Corporation for approximately $23 million. Read more »
Oracle buys open-source database firm
Database heavyweight Oracle has acquired Innobase Oy, a privately held Finnish company with close ties to open-source database company MySQL. Read more »
Oracle tool to rein in database admins
Database administrators don't always need access to the information in the databases they're managing, so Oracle has created a tool to protect it. Read more »
Big Blue DB2 Viper database will feature data-compression technology, code-named Venom, imported from mainframe.
Big Blue DB2 Viper database will feature data-compression technology, code-named Venom, imported from mainframe. Read more »
Features (169)
Generate dynamic SQL statements in SQL Server
When you need to solve a tricky database problem, the ability to generate SQL statements is a powerful tool -- although you must be careful when using it. This article explores how you can use this functionality to generate SQL statements on the fly. Read more »
Create a VS.NET add-in to write SQL statements
Visual Studio .NET allows you to create an add-in to write all of those tedious SQL statements for you. We'll show you how step-by-step. Read more »
SQL basics: Query multiple tables
Learn when to use SELECT, JOIN, subselects, and UNION to access multiple tables with a single statement. Read more »
Using SQL statements with ASP
Using ASP and SQL together can be confusing. Help ease he confusion with the help of these 12 SQL tips for ASP. Read more »
Execute SQL statements in Integration Services
This tutorial walks you through the process of adding SQL statements to your SSIS packages and bundling them into logical units of work if necessary. Read more »
SQL basics: SELECT statement options
Master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Read more »
Using SQL Server 2008's MERGE statement
SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement. Read more »
More New SQL Server 2008 Features
Microsoft updates SQL Server on a pretty regular basis. Its newest version, SQL Server 2008, includes some new features not found in older versions. Here's a list of some of them. Read more »
Create cross-platform database-driven applications with JDBC
The Java Database Connectivity (JDBC) API offers a unified interface to different databases, providing a series of generic functions that are internally translated into native function calls. This makes it extremely easy to create database-driven applications that work across different RDBMS types. Read more »
New Date Datatypes in SQL Server 2008
SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Heres how you can use these new data types to your advantage in SQL Server 2008. Read more »
Blog (3)
The 2008 Trends and Threats to Internet security
-- I recently came across the IBM Internet Security Systems X-Force 2008 Mid-Year Trend Statistics report, which outlines issues affecting internet security, including application vulnerabilities, phishing, malware and spam. Read more »
Is public domain software open-source?
-- When writing earlier this week about Adobe's sponsoring of the SQLite project, I ran into a complicated issue: is software released into the public domain also open-source software? Read more »
CodeGear ready Ruby release
-- 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 »
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.
