How to Installation of Spotify client on Ubuntu 14.04 LTS Linux

This short config will show you how to install Spotify client on Ubuntu 14.04 LTS Linux. Let's start by adding a spotify repository:

Repair Suspect Database, Steps to Repair Suspect Database in SQL Server

There can be a possibility that when you connect to an SQL Server Instance you will find the database being marked as SUSPECT. During such scenarios, you will not be able to connect to the database. In this article we will go through the steps which you need to follow to recovery a database which is marked as SUSPECT. The steps mentioned in this article works on SQL Server 2005 and higher versions.

How to Get Exclusive Access to SQL Server Database

There are scenarios when database administrator needs to disconnect all the connected users from a SQL Server Database to get exclusive access of the Database. The exclusive access is needed before restoring a database, before a database can be detached, to perform critical maintenance tasks, to recover a database which is in Suspect Mode etc. In this article we will take a look at how database administrator can leverage ALTER DATABASE Commands to disconnect users from a database.

Detach SSAS Database in SQL Server

In this article we will take a quick look at How to Detach Analysis Services Database. The steps mentioned in this article are applicable on SQL Server 2008 and Higher Versions.

Contained Databases in SQL Server 2012

Contained Databases is a new feature which is available in SQL Server 2012. A contained database is a database that will store all its metadata within the database thereby not storing any configuration information within the master database of the SQL Server Instance where the Contained Database is created. A contained database is isolated from other databases which are available on the instance of SQL Server.

How to Enable Database Users in SQL Server

During a recent Production Database refresh we encountered a strange problem where all the Windows Groups/Users along with SQL Server Users within the Database were disabled.

How to Backup and Restore Resource Database in SQL Server

Microsoft SQL Server 2005 introduced a new system database namely Resource database. It’s a read-only system database which is hidden from users and in this article we will discuss how to backup and restore Resource Database in SQL Server. DBA should backup Resource Database along with other System Databases in SQL Server as part of Disaster Recovery and most importantly document the location of each and every system and user databases.