Articles

In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-11-01 (first published: 2002-08-01)

39,004 reads

Discuss

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

by Yakov Shlafman

SQLServerCentral.com

SQL Server 7

In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2007-11-01

1,697 reads

Discuss

Using DMO to Restore a Database

by Andy Warren

SQLServerCentral.com

SQL-DMO

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-11-01 (first published: 2001-05-07)

24,624 reads

Mirrored backup and restore commands in SQL Server 2005

by Additional Articles

SQLServerCentral.com

SQL Server 2005

Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-11-01

2,367 reads

The Subsystems of ETL Revisited

by Additional Articles

Intelligent Enterprise

Extract, Transform, Load (ETL)

These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.

2007-11-01

3,164 reads

XML Workshop IX - Mixed Types

by Jacob Sebastian

SQLServerCentral.com

Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2007-10-31

3,648 reads

Discuss

Featured Blog: What happens to non-clustered indexes when the table structure is changed?

by Additional Articles

SQLskills

SQL Server 2005

Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.

2007-10-31

3,156 reads

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 10

by Additional Articles

Database Journal

PowerShell

This installment of the series illustrates how to use PowerShell scripts in conjunction with SMO and parameters to Generate an SQL Server Script.

2007-10-31

2,702 reads

SQL Server Integration Services Automation

by Gulappa Vijaya Kumar

SQLServerCentral.com

Integration Services (SSIS)

After completing a project with SQL Server 2005 Integration Services, author G Vijayakumar brings us his technique for an automated scheduling of various source data into a data warehouse with multiple packages.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2007-10-30

12,075 reads

Discuss

Service Broker Advanced Basics Workbench

by Additional Articles

SimpleTalk

Service Broker (SSSB)

SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we design and run distributed applications. Adam Machanic once more makes it all seem so easy in Part 2 of his epic series

2007-10-30

1,587 reads

Articles

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

Reverse Engineering Alias Data Types in SQL Server 2000 - Part IV

Using DMO to Restore a Database

Mirrored backup and restore commands in SQL Server 2005

The Subsystems of ETL Revisited

XML Workshop IX - Mixed Types

Featured Blog: What happens to non-clustered indexes when the table structure is changed?

Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 10

SQL Server Integration Services Automation

Service Broker Advanced Basics Workbench

Blogs

Monday Monitor Tips: Virtual Machine Usage and Cost

Advice I Like: Respect

Blue Sky Programming – The Optimism Trap

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

SQL Server Still Wins

DBCC CHECKDB Limits I

Question of the Day

DBCC CHECKDB Limits I