Monthly Archives: August 2013

Setting up clustering in SQL Server 2012 step by step process

In this post I would like to discuss about setting up SQL Server 2012 Clustering on Windows Server 2008 R2. This includes setting up windows clustering as well. 1)      I first went to windows server manager and expanded features and … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , | Leave a comment

SQL Server 2008 Performance troubleshooting basics

In this post I would like to mention the basics of troubleshooting performance issues in sql server. When a customer calls to inform that the database is slow one of the first things the dba’s do is verify if this … Continue reading

Posted in SQL Server DBA Stuff | Tagged , | Leave a comment

Error: Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

I came across this error on a test database server when I launched the SSMS. The version of SQL Server I was using was 2008 R2 SE. A dialog box with following message would prompt whenever I click on anything … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , | 10 Comments

Implementing Transparent Data Encryption Part-2

In this post I will show how the encryption actually works. I have backedup theAdventureworks2008R2 database on which I performed encryption. Now I will login to another instance of SQLServer and will try to restore the database that I just … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , , , | Leave a comment

Implementing Transparent Data Encryption Part-1

Transparent data encryption (TDE) is available only in SQL Server 2008 R2 Enterprise Edition. This mechanism is used to encrypt/decrypt data and log files in real time. The set up involves: 1) Creating a master key 2) Creating a database … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , , , , | 2 Comments