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 »
News and features
- Latest
- Popular
- Features
- Most Discussed
-
Microsoft shows off IE9 previewThis week, highlights from Microsoft's MIX10 conference and more in the Roundup. Read more »
-
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 »
-
Google launches Apps MarketplaceGoogle 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 »
-
Filter protesters brave Vic weather
2010/03/08 13:35:35
-
CNET first look at Google Buzz
2010/02/11 10:42:51
-
Disable Flash on your web browser
2010/02/05 09:35:57
Most popular tags
What's on?
-
Broadband + home phone + PlayStation®3 in a single package price!




