Features (9)

Introduction to Change Data Capture in SQL Server 2008

This article takes a look at the great new auditing features available in SQL Server 2008. Read more »

Comparing SQL Server constraints and DML triggers

This article sheds some light on when to use constraints and when to use DML triggers. Read more »

Optimise SQL Server queries with these advanced tuning techniques

Now that you know how to speed up your SQL Server database queries, you can start delving into some of the more advanced tuning options. Read more »

Four cool new features slated for SQL Server 2008

SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008 to the community for preview. Read more »

Preserve log table entries using autonomous transactions in Oracle

Developers can use autonomous transactions in Oracle to "step outside" the main transaction and do work that commits independently. A stored procedure for logging errors to a database table demonstrates this feature. Read more »

Using SQL Server 2005 to document Sarbanes-Oxley compliance

SQL Server 2005 can wear many hats, and built-in tools help make it easy to build a home-grown auditing system. 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 »

SQL Server tips: nested triggers and dump files

These SQL Server tips will help you detect when a trigger inadvertently fires other triggers and teach you to read backup info stored in the msdb. 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 »

Blog (1)

Opera Widget SDK released

Staff [blogs:syslog] -- Opera has announced the release of Opera Widgets SDK beta, that allows Web developers to create Web applications capable of running on all devices. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Microsoft shows off IE9 preview

    This week, highlights from Microsoft's MIX10 conference and more in the Roundup. Read more »

    -- posted by Staff

  • Chris Duckett IE9's H.264 vote killed Ogg

    In a split decision by the judges, the winner of the W3C/WHATWG video codec consensus is H.264, taking home the future of video playback on the internet while loser Ogg goes home with nothing but thoughts of what might have been. Read more »

    -- posted by Chris Duckett

  • Staff Google launches Apps Marketplace

    Google launches and app store, while Mozilla plans to re-write its open-source license. More of this week's news in the Roundup. Read more »

    -- posted by Staff

What's on?

  • Optus Deal

    Broadband + home phone + PlayStation®3 in a single package price!