SQL Server 2016 Always Encrypted

Introduction SQL Server 2016 is yet to be released, but you can download the CTP versions. The mostly anticipated and marveled feature is Always Encrypted. Let me discuss few bits of this feature before getting into the technical side of it. I got to know this right after reading an article about Microsoft had applied … Continue reading SQL Server 2016 Always Encrypted

Advertisements

How to Upgrade SQL Azure Database to V12

Before upgrading we should check the the current SQL Azure version. Connect to your SQL Azure server and execute the following command to get the version and other information. I got the below results Note the version shows 11.0.9229.2, considering the major version number  (in this case 11) we know that this SQL Azure Server … Continue reading How to Upgrade SQL Azure Database to V12

How to create code snippets in SQL Server Management Studio (SSMS)

Recently I’ve been working on a project which requires plenty of stored procedures and custom logging. For error handling I don’t want to repeat my logging TSQL statements for each and every SP I write. I created a code snippet and let the IDE code for me. Follow these simple steps to create code snippets … Continue reading How to create code snippets in SQL Server Management Studio (SSMS)

Recovering a SQL Server database from Suspect Mode

Yesterday my SharePoint environment didn’t respond I checked the DB server and got to know few SharePoint databases were in suspect mode. Now I want to make the databases up and running as usual in order to get my work done. This is a SQL Server thing. There could be several reasons for a database … Continue reading Recovering a SQL Server database from Suspect Mode

The database is in single-user mode, and a user is currently connected to it.

Sometimes you might get the above error message from SQL Server when you try to change the user mode from MULTI to SINGLE. You have to explicitly kill the connection in order to solve the problem. First you need the dbid of your database. Run the following command. 1: SELECT name, database_id 2: FROM sys.databases … Continue reading The database is in single-user mode, and a user is currently connected to it.

Hierarchy in TSQL – step by step guide

Hierarchy data type is introduced in SQL Server 2008. It is a CLR data type. This post gives a simple step by step guide to implement HierarchyID data type Hierarchical navigation or simply the navigation between nodes could happen in 2 ways. Depth First Breadth First Having said that, we’ll start the tutorial. Create a … Continue reading Hierarchy in TSQL – step by step guide

Installing SQL Server 2012 on Windows 8

Installing SQL Server 2012 on Windows 8 is a pain, because SQL Server 2012 needs .NET 3.5. The problem is activating .NET 3.5 in Windows 8 via Turn On/Off Windows features won't help because .NET 3.5 is considered as an on demand installation feature. Windows Update also fail to address the need. There are good … Continue reading Installing SQL Server 2012 on Windows 8

SQL Configuration Manager WMI Error–Remote Procedure call failed [0x800706be]

  I got the above error in the SQL Configuration Manager and googled for a solution. Unfortunately first few links were not satisfying, then I tried with some extra effort and found these details. My box is running on Win 7 x64 and SQL Server 2008. It is said that this error can occur in … Continue reading SQL Configuration Manager WMI Error–Remote Procedure call failed [0x800706be]