Some time ago, I worked on a team that was attempting to define an IT strategy for a large multinational company. Management incorrectly thought the company was unique in that it had a high number of failed IT projects. In fact, only one in four IT projects can be termed successful, if the benchmarks of success are adherence to scheduled completion time and budget, and realization of the project goal, whether that be saving money, growing the business, or what have you. I have to explain this because many of you may never have come across one.

An Elegant ETL Solution: Except for Lost Data

by David Russell

SQLServerCentral.com

Integration Services (SSIS)

An early adopter of SQL Server 2005 found some issues with Integration Services. And he shows how it was debugged and the issue solved. This is a great look at some of the helpful parts of Intration Services in solving problems as well as a few places it falls short.

Using SQL Server 2005 sqlcmd Utility

by Additional Articles

Database Journal

Administration

SQL Server 2005 provides some new command line utilities. One such utility is "sqlcmd". The sqlcmd utility is used to run adhoc queries interactively from a command prompt window, or can be used to execute a script containing T-SQL statements. The sqlcmd utility is a great improvement over osql and isql of older releases of SQL Server. In this article, I will explain some of the features this new command line utility brings to administering SQL Server.

XML Indexes in SQL Server 2005

by Additional Articles

MSDN Communities

Administration

Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.

SQLDBControl BETA Testers Wanted

by Press Release

SQLServerCentral.com

Product News, Releases, and Upgrades

A new product has just been released in Beta to help you with source control for your SQL Server development. Beta testers are wanted, so if you're interested, read on.

Starting and Stopping SQL Server Part 2

by Andy Warren

SQLServerCentral.com

Administration

Continuing with his series, Andy Warren looks at what it means for SQL Server 2000 to run as a service and some of the options you have for starting, stopping, and restarting your server.

SQL Server Notification Services Architecture

by Joe Webb

SQLServerCentral.com

SQL Server 7

Most SQL Server 2000 DBAs have heard of Notification Services, but are they aware of how it works and what it's capabilities are? This is a great platform on which to build any type of messaging/notification/subscription application. New author and PASS board member Joe Webb brings us a look at this add on for SQL Server.

Using CLR Integration in SQL Server 2005

by Additional Articles

MSDN Communities

SQL CLR

This paper describes the new CLR integration features of SQL Server 2005 and how database application developers and architects can take advantage of them to write user-defined procedures, functions, and triggers, as well as define new types and aggregates

DBGhost Review

by Jeremy Brown

SQLServerCentral.com

Product and Book Reviews

The integration of SQL Server 2000 with version control is basically nonexistent. Managing and keeping track of your changes and files is a cumbersome task, and prone to have mistakes occur. There is a product that can help you with this called dbGhost and Jeremy Brown takes a look at this product and how it works.

Triggers for Auditing

by Tiago Andrade e Silva

SQLServerCentral.com

Triggers

Have you ever needed to audit your SQL Server 2000 database for changes to a table? A simple auditing solution is presented here by new author Tiago Silva using an INSTEAD OF trigger.

Secrets of successful IT projects

An Elegant ETL Solution: Except for Lost Data

Using SQL Server 2005 sqlcmd Utility

XML Indexes in SQL Server 2005

SQLDBControl BETA Testers Wanted

Starting and Stopping SQL Server Part 2

SQL Server Notification Services Architecture

Using CLR Integration in SQL Server 2005

DBGhost Review

Triggers for Auditing

Blogs

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

Prepping for Certification, Part 4 of 4

Flyway Tips: Automation Assistance in Flyway Desktop

Forums

CAST datetimeoffset(7) as a datetime in UK format

what are the downsides of TDE not running vs running?

Help! MEMORY_ALLOCATION_EXT wait stalls

Question of the Day

Putting the Player with the Number