SQL Server

Comparing cursor vs. WHILE loop performance in SQL Server 2008

This article discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. Read more »

Setting up Change Data Capture in SQL Server 2008

Change Data Capture (CDC) is a new native feature in SQL Server 2008 Enterprise Edition. This article shows how to use CDC to easily set up data auditing on your SQL Server system. Read more »

Filtered Indexes in SQL Server 2008

Filtered indexes are a neat feature in SQL Server 2008 that allows you to define indexes on subsets of data. Read more »

10+ tips for working smarter with SQL

The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started. Read more »

Installing Data Protection Manager 2007 as a VM in a lab environment

This article describes how to install DPM 2007 as a virtual machine in a lab environment. Here are the gotchas to look out for and an explanation of the benefits you can realise. Read more »

Avoiding cursors with SQL Server 2005

Sometimes cursors are necessary when executing queries in SQL Server, but most of the time they can be avoided entirely. This article shows where cursors can traditionally be used, and how you can use features packaged in SQL Server 2005 to avoid them. Read more »

Perils of adding fields to database tables

If you're not careful, when you add a field to a database table, you may cause all sorts of problems. This article looks at two such scenarios, and how you can plan for their occurrence. Read more »

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 »

What is in your toolbelt?

As a DBA, you probably have several tools to help you in a bad spot. Have you heard of SQL Professional Toolbelt? It can be a handy addition to keep your SQL Server humming. Read more »

Backup compression in SQL Server 2008

New to SQL Server 2008 is the native ability to compress database backups. This great new feature results in a smaller backup file, which saves disk space and can lessen the time latency. Here's how it works. 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!