Regular Expression Transformation

The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows are passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.

Extreme SQL Server

Clustering, partitioning, database snapshots, database mirroring, SQL Server SAN storage design and more are all in the September issue of the SQL Server Standard.

No Outlook for Alerts!

SQL Server 2000 has a fantastic subsystem for alerting the DBA and keeping him or her informed as to the state of the server. However the email subsystem introduces a dependency on Outlook for alerts that can be a problem for some environments. Author Roy Carlson brings us an ingenious method for reading logs and sending alerts without Exchange or Outlook.

Reporting Services Part I: Overview, Architecture and Installation

Hopefully you've heard about Reporting Services. But have you tried it? James says you'll be sorry if you don't read the docs first! Reporting is something every enterprise struggles with, maybe this will make things better? Here's how to get started.

Software patents: stupid or insane?

Lest the headline mislead you as to my biases, I consider software patents to be both stupid and insane. I raise this issue because it is currently rearing its ugly mug in the world of open source software, but it has affected much development in the proprietary worlds of Windows as well.

First of all, patent laws were created long ago, which is not to say the thinking was correct then either, but we have to recognize the intellectual and technological climate back then.

SQL Server Spotlight on Shyam Pather

We have a few interviews of the SQL Server team and this time we talk with the lead for Notification Services. Get some insight into Shyam Pather and and this add on for the SQL Server 2005 platform.

Living the "Least Privilege" Lifestyle: Don't Run Every Day Logged In

Don Kiely contends that exercising administrative rights over our computers is a major cause of insecure systems. In the first of five articles, he explains the concept of "least privilege" and shows why software developers should be happy to operate as "mere users."

Employee Retention From the Managers Perspective

Part 3 of Steve Jones' series on employee retention, this one focused on the manager's point of view in keeping employees around. Gain some insight into how the manager may view your situation and understand why he or she may act as they do.

So you want to be a DBA...

Written by an Oracle guy, but it's still some good advice for people that want to be DBAs. If you're experienced, pass it along to others that are looking to move into this role.

SSIS - Code Reuse and Complex Control Flows

SQL Server 2005 Integration Services is an incredibly powerful, but complex environment for creating ETL packages. Kristian Wedberg brings us a new article on reusing some of your code and some complex looping structures that you might want to use in your applications.