Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Archives: June 2014

Rename or Change SQL Server Standalone Default Instance

Today, We will go through with the steps of renaming or changing SQL Server Standalone Instance.

Step 1 : Check Current Instance & host name

Current Host Name : admin-0783e4076

Current SQL Instance Name : admin-0783e4076

Select @@ServerName ServerName, Host_name() HostName

Step 2 : Rename Host name & reboot the… Read more

6 comments, 278 reads

Posted in MSSQLFUN on 30 June 2014

SQL Server 2014 – How to add features to existing instance ?

SQL Server 2014 – How to add features to existing instance ? :-

1) Start installation center

2) Run Global Rule, You need to fix if any failure occur

3) Microsoft update option (Enable windows updates to search & install SQL updates as well)

4) Include product update with installation,… Read more

0 comments, 274 reads

Posted in MSSQLFUN on 26 June 2014

Fix for index corruption issue || SQL Server 2012 Service Pack 2

ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012

Microsoft release a fix for above issue and now available for download for SQL Server 2012SP2.

Refer Article :

http://support.microsoft.com/kb/2969896

Download Link :

http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2969896&kbln=en-us

If you liked this post, do… Read more

0 comments, 187 reads

Posted in MSSQLFUN on 24 June 2014

SQL Server 2012 || Contained Database

Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :

A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. SQL Server 2012 helps user to… Read more

0 comments, 648 reads

Posted in MSSQLFUN on 23 June 2014

ColumnStore Indexe with SQL Server 2012 & 2014

ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :

“An xVelocity memory optimized ColumnStore index, groups and stores data for each column and then joins all the columns to complete the whole index. This differs from traditional indexes which group and store data for… Read more

0 comments, 217 reads

Posted in MSSQLFUN on 16 June 2014

SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !

SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack 2 contains all the hotfixes released since the initial release of SQL Server 2012 RTM.

Whether You are facing issue in your environment or not, It’s Recommended to install in… Read more

1 comments, 389 reads

Posted in MSSQLFUN on 12 June 2014

Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.

Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 about to end on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow,… Read more

3 comments, 171 reads

Posted in MSSQLFUN on 12 June 2014

SQL Server 2014 – How to Add node to failover cluster ?

Steps for SQL Server 2014 Cluster Installation – Add Node to Failover Cluster:-

1) Lunch SQL Server Installation Center

2) Enter Product Key

3) Accept License

4) Check Global Rules, Need to rectify if any failure occur

5) Check Software upgrade to install (Enable windows updates to search & install… Read more

2 comments, 280 reads

Posted in MSSQLFUN on 9 June 2014

SQL Server 2014 Cluster Installation Steps

Steps for SQL Server 2014 Cluster Installation :-

1) Lunch SQL Server Installation Center

2) Enter Product Key

3) Accept License

4) Check Global Rules, Need to rectify if any failure occur

5) Check Software upgrade to install (Enable windows updates to search & install SQL updates as well)

6)… Read more

2 comments, 287 reads

Posted in MSSQLFUN on 3 June 2014