A database rename operation in Microsoft SQL Server may fail due to multiple reasons - the most common of all being an open connection to the database. Often this is because of the SSMS itself. In this post, I present a simple script that can be used to...

A database rename operation in Microsoft SQL Server may fail due to multiple reasons - the most common of all being an open connection to the database. Often this is because of the SSMS itself. In this post, I present a simple script that can be used to...

...

...

In this post, we take a look at the Dynamic Management Vies, functions and Catalog Views related to AlwaysON! - the High Availability & Disaster Recovery [HADR] enhancements introduced in SQL Server 2012....

In this post, we take a look at the Dynamic Management Vies, functions and Catalog Views related to AlwaysON! - the High Availability & Disaster Recovery [HADR] enhancements introduced in SQL Server 2012....

When recovering from a database crash, an understanding of the backup timeline and restore sequence is essential. Full, differential and transaction log backups need to be restored in a specifc order. The system stored procedure sp_can_tlog_be_applied h...

When recovering from a database crash, an understanding of the backup timeline and restore sequence is essential. Full, differential and transaction log backups need to be restored in a specifc order. The system stored procedure sp_can_tlog_be_applied h...

When recovering from a database crash, an understanding of the backup timeline and restore sequence is essential. Full, differential and transaction log backups need to be restored in a specifc order. The system stored procedure sp_can_tlog_be_applied h...

In this post, we take a look at the Catalog Views related to columnstore indexes introduced in SQL Server 2012: sys.column_store_segments and sys.column_store_dictionaries....