Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skills and capabilities of great programmers in this essay.

XML Workshop XIX - Generating an ATOM 1.0 Feed

by Jacob Sebastian

SQLServerCentral.com

Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.

A Worthwhile Goal

by Steve Jones

SQLServerCentral.com

Editorial - WMV

Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.

A Worthwhile Goal

by Steve Jones

SQLServerCentral.com

Editorial - iPod

Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.

Finding dependencies in SQL Server 2005

by Additional Articles

Builder.com

SQL Server 2005

Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.

Using DDL triggers to audit events

by Additional Articles

SearchSQLServer

Auditing

Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.

Encrypting Data

by Steve Jones

SQLServerCentral.com

Editorial

Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.

Overview of SSIS

by Amit Lohia

SQLServerCentral.com

Integration Services (SSIS)

SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package.