|
|
-
|
|
Microsoft installers have generally been a source of inspiration for all product development teams. Here is one installation check that I believe should be common to all product installers - the long path name check....
|
|
-
|
|
If you ever need to get a list of installed SQL Server features and their respective patch levels, the Installed SQL Server Feature Discovery Report bundled with the SQL Server installer can be used. This post gives a step-by-step guide about using this handy utility....
|
|
-
|
|
In this post, I present an alternate to Table Valued Parameters for SQL Server 2000. Support for Microsoft SQL Server 2000 ends this year and yet, one can find systems (production or otherwise) that continue to run on and support SQL Server 2000. The solution presented in this post might be useful to such products....
|
|
-
|
|
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....
|
|