Mirrored backup and restore commands in 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.
2007-11-01
2,367 reads
Additional Articles
The Subsystems of ETL Revisited
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
Featured Blog: What happens to non-clustered indexes when the table structure is changed?
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
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
Service Broker Advanced Basics Workbench
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
SQL Server 2005 Express Edition - Part 9 - Managing User Instances
SQL Server 2005 Express Edition's unique functionality allows you to distribute and implement single-user databases, without the dependency of having administrative privileges or the need for a cumbersome configuration. This article illustrates the practical use of this feature, known as XCopy deployment.
2007-10-30
1,438 reads
Aggregating Correlated Sub-Queries
Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:
2007-10-29
4,862 reads
Data is at the Heart of Enterprise-Wide BI and DW, Part 3
My online series of articles has been focused on the need for businesses to "get serious" about their approach to developing an enterprise business intelligence (BI) and data warehousing (DW) capability. When pursuing this capability it is important to adopt a holistic view, followed by disciplined investment and execution.
2007-10-26
2,267 reads
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 9
Learn how to use PowerShell in conjunction with SMO to Generate an SQL Server Script.
2007-10-26
2,873 reads
Celko on SQL: Natural, Artificial and Surrogate Keys Explained
SQL programming guru Joe Celko offers a classification scheme and advice on using the right keys.
2007-10-25
3,595 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers