Database

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 »

Firewall MySQL with GreenSQL

GreenSQL is a "firewall" for MySQL databases that could help protect your database from SQL injection vulnerabilities. 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 »

How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server. Read more »

How do I run code automatically when SQL Server starts?

The need to run a stored procedure or SQL Agent Job when SQL Server or SQL Agent starts is a common requirement in the world of SQL Server administration. This article gives an overview of the ways to execute SQL stored procedures or SQL Agent jobs on startup. Read more »

Log in


Sign up | Forgot your password?

Blogs

RSS feed

  • Staff Aussies to pay more for Win 7

    If you are looking to make some money in these troubled times, perhaps importing copies of Windows 7 could be for you. Read more »

    -- posted by Staff

  • Staff Firefox: Greens want it, 3.5rc2 not up to par

    This week's roundup looks at the situation surrounding a campaign to change Outlook HTML renderer, a Greens MP wants to install Firefox but is restricted and all the photos from the iPhone 3GS launch. Read more »

    -- posted by Staff

  • Chris Duckett Microsoft misses the Outlook point

    Ask designers which mail program is the bane of their existence, and you'll find that Outlook tops the list. The reason why the most popular email reader is also the most painful is simple: it uses Word to render HTML emails. Read more »

    -- posted by Chris Duckett

What's on?