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.

Install SQL Server 2014 Step By Step Guide for DBAs

Microsoft SQL Server 2014 RTM (Release to Manufacturing) was released on 7th April 2014. There are different versions of SQL Server 2014 available such as Enterprise Edition, Enterprise Core Edition, Business Intelligence Edition, Standard Edition, Web Edition, Express and Developer Edition. You can download Microsoft SQL Server 2014 Evaluation Edition from the following link and you can download SQL Server 2014 Express Edition from the following link.

Install SQL Server 2012 on Windows Server 2008 R2 Service Pack 1

Microsoft SQL Server 2012 Release to Manufacturing (RTM) was released on 7th Mar 2012. There are different versions of SQL Server 2012 available such as Enterprise Edition, Business Intelligence Edition, Standard Edition, Web Edition, Developer Edition and SQL Server Express LocalDB a new lightweight deployment option for Express. You can download Microsoft SQL Server 2012 Evaluation Edition from the following link and you can download SQL Server 2012 Express Edition from the following link.

SQL Server 2008 R2 August Technical preview Installation Guide

I have decided to install the SQL Server 2008 R2 August technical preview (aka CTP2) on Windows Server 2008 R2.  On this new OS there is a specific role the application sever role that you should setup before installing SQL Server

Install Windows Server 2008 R2 x64 On VMware 7

Installing a 64-bit operating system on virtualization applications has never been free of obstacles. In the initial days of virtual machines, this was in fact not even possible. In this post we will tell you how to install Windows Server 2008 R2 x64 on VMware 7.0. Note: These instructions can also help in the installation of the 32-bit version of Server 2008.