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.

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, 310 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, 299 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, 207 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, 687 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, 266 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, 429 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, 187 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, 329 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, 459 reads

Posted in MSSQLFUN on 3 June 2014

How Database Mail works in SQL Server ?

Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification, reports etc.

Requirements for Setting up Database Mail :-

1) Details of SMTP server

2) Connectivity with SMTP server

3) Access to SMTP server to send e mails

Components of… Read more

1 comments, 223 reads

Posted in MSSQLFUN on 26 May 2014

Cumulative Update – 10 for SQL Server 2012 Service Pack 1 Is Now Available !

The 10th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 10 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 316 reads

Posted in MSSQLFUN on 21 May 2014

Database Backup Encryption with SQL Server 2014

A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS summit & from then users are waiting for this. Currently backup encryption supporting four encryption algorithms: AES 128, AES 192, AES 256, and Triple DES (3DES).

Currently, User are… Read more

0 comments, 1,044 reads

Posted in MSSQLFUN on 19 May 2014

Add Node to Windows Server 2008 Cluster

Steps : Add Node to Windows Server 2008 Cluster

1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node

2) Add Node Wizard appears, Click Next to start

3) Browse Node to add, We select Node 3 to add

4) Select if you want to… Read more

0 comments, 402 reads

Posted in MSSQLFUN on 12 May 2014

Thanks to Toadworld.com team for recognition !

Thanks to Toadworld.com team for recognition !

Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx

If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun

Reference : Rohit Garg (http://mssqlfun.com/)


Read more

0 comments, 147 reads

Posted in MSSQLFUN on 11 May 2014

Cumulative Update – 12 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

The 12th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2008 R2 SP2.

Those who are facing severe issues with their environment,… Read more

4 comments, 508 reads

Posted in MSSQLFUN on 5 May 2014

Cumulative Update – 1 for SQL Server 2014 RTM Rollback by Microsoft !

The 1st cumulative update release for SQL Server 2014 RTM was released by Microsoft.

But due to issues in setup Microsoft Rollback the release of CU1 of SQL Server 2014 RTM.

KB Article For CU1 of SQL Server 2014 RTM

Image Source : http://blogs.msdn.com/

If you… Read more

0 comments, 313 reads

Posted in MSSQLFUN on 5 May 2014

How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps : How to add node to SQL Server Failover Cluster from SQL Server 2008 onwards ?

1) Open SQL Server Installation Center > Click Installation from Left > Click Add node to a SQL Server Failover Cluster from right

2) Click Run to start setup

3) Click Ok to… Read more

0 comments, 213 reads

Posted in MSSQLFUN on 28 April 2014

How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :-

1) Open SQL Server Installation Center > Go to Installation from Left > Click on New SQL Server Failover installation from right

2) Click RUN to start setup

3) Click ok after validation check. In case of… Read more

1 comments, 1,316 reads

Posted in MSSQLFUN on 22 April 2014

SQL Server 2000 || Disable sa login

Question : How to disable sa user in SQL Server 2000?

Reason : Due to Security requirement of audit, We have to disable sa user for all SQL instances in environment having SQL 2000 \2005\2008 & 2008 R2.

Answer : We can disable sa user from SQL Server 2005 onwards… Read more

1 comments, 189 reads

Posted in MSSQLFUN on 15 April 2014

Newer posts

Older posts