Tags: data, procedures
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)
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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.