Database

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 »

Help! My SQL Server Log File is too big!

Overgrown transactional log files can turn into real problems if they are not handled properly. This article discusses the perils of not handling SQL Server log growth properly, and what can be done to correct the problems. Read more »

Move SQL Tuning Sets between Oracle instances

SQL Tuning Sets (STS) capture the workload of an Oracle instance. Starting in Oracle 10g Release 2, these tuning sets can be transported from one instance to another to facilitate testing. Read more »

Audit data using SQL Server 2005's COLUMNS_UPDATED function

This article looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. 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 »

Gather query tuning data via Oracle's dynamic performance views

The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS. Read more »

Tags: oracle, sql, views

Using Mirrored Media Sets in SQL Server 2005

Mirrored Media Sets is a new feature in the Enterprise Edition of SQL Server 2005. It enables the creation of redundant copies of a backup file to reduce the possibility of a backup device malfunction. Here's how you make it work. Read more »

Running totals in SQL Server queries

This article demonstrates how running totals are simple to create in SQL Server queries once you understand the requirements. 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 »

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 »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff XP stays on life support for longer

    This week's Roundup looks at Microsoft's decision to extend the life of Windows XP, the release of Microsoft Surface SDK, Firefox's new Geode plug-in, Yahoo's new tool -- Smush It and more. Read more »

    -- posted by Staff

  • Chris Duckett The good and truly awful celluloid depictions of computers

    Ever wonder why your lawyer uncle leaves the room whenever you turn over to Boston Legal? Or why your forensic science cousin can't stand crime drama? You know the answer: it’s the horrid trivialisation and dumbing down of an occupation to make it appear entertaining. Sometimes it is so unbelievable that it actually hurts and yelling at the screen is the only outlet. Read more »

    -- posted by Chris Duckett

  • Brendon Chase Apple's iPhone engineers to tour Sydney, Melbourne

    Aussie developers will be able to get up close and personal with some of the iPhone engineers in November to learn how to build applications for the platform. Read more »

    -- posted by Brendon Chase

What's on?