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
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
XML Workshop IX - Mixed Types
Continuing on with his great series on XML, Jacob Sebastian looks at elements of mixed types.
2007-10-31
3,669 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
SQL Server Integration Services Automation
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.
2007-10-30
12,106 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
Microsoft BI Certifications or Why SQL is a 4-Letter Word
A look at the BI certification experience of a senior consultant and developer. New author
2007-10-29
13,363 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
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
Alamat BCA KCP Tmn. Harapan Indah Telp:0821°8200°233
Telp/Wa 628218200233 Komp. Taman Harapan Indah Blok EE No.1, RT.14/RW.7, Jelambar Baru, Kec. Grogol...
Alamat BCA KCP Rajawali Telp:0821°8200°203
Telp/WA 628218200203 Rukan Multiguna, Jl. Rajawali Selatan Raya Blok C5. 2, Blok 2, Pademangan...
Alamat BCA KCP Mangga Dua Mal Telp:0821°7555°651
Telp/Wa 628217555651 Mal No. RM, Jl. Mangga Dua Raya No.49, RT.1/RW.12, Mangga Dua Sel.,...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers