|
|
-
|
|
Although one of the most robust change and tamper detection mechanisms available in Microsoft SQL Server, HASHBYTES suffers from a limitation that it cannot handle more than 8000 bytes of input, which translates to 4000 NVARCHAR characters....
|
|
-
|
|
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or restart a local or remote machine via the command prompt....
|
|
-
|
|
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 rename a SQL Server database if open connections are preventing the operation....
|
|
-
|
|
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 helps administrators in determining the restore sequence for transaction logs....
|
|
-
|
|
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....
|
|
-
|
|
As new features are added to products, the underlying database objects undergo changes. Whenever such changes are made, the underlying meta-data for the dependent objects also needs to be updated. The meta-data for non-schema bound views can be refreshed using a system stored procedure - sp_refreshview....
|
|
-
|
|
In this post, we take a look at the Dynamic Management and Catalog Views related to FileStream and FileTables introduced in SQL Server 2012: sys.database_filestream_options, sys.filetables, sys.filetable_system_defined_objects and sys.dm_filestream_non_transacted_handles....
|
|
-
|
|
ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the database to SIMPLE. In this post, we attempt to explore why the recovery model is reset....
|
|
-
|
|
In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...
|
|