Tags: code, database, procedures
News (6)
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 »
Security group names top software risks
A security organisation published its fourth annual list of the most vulnerable software on Wednesday, putting network administrators on notice that they need to check their systems. 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 »
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 »
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 »
Features (118)
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 »
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 »
Create ActiveX servers for PL/SQL packages
When you're tuning database applications, your first impulse may be to follow the manuals' examples and start coding database logic directly into your code. Find out a better approach. Read more »
Diagnose SQL Server performance problems
Usually, the hardest part of database tuning is finding the code bottlenecks. SQL Profiler's traces can help you locate your sluggish code. Read more »
Diagnose SQL Server performance problems
Usually, the hardest part of database tuning is finding the slow part. SQL Profiler's traces can help you find your sluggish code. Read more »
Access and reusable ASP code
Take a look at six reusable ASP code functions that will help you quickly build database-enabled Web sites using Microsoft Office technologies. 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 »
Blog (5)
Google destroys Security Through Obscurity
-- 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 »
Database pros get tools in the know
-- 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!
-- 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
-- INAccess: Tales of woe revolving around the Access Database system 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.
