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 Named Instance

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

Renaming or Changing SQL Server Standalone Named Instance is almost same as SQL Server Standalone Default Instance. You can change a SQL server named SQLServerinstance1 to some other name, such as SQLServerNewinstance1, but… Read more

0 comments, 153 reads

Posted in MSSQLFUN on 29 July 2014

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

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

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

0 comments, 105 reads

Posted in MSSQLFUN on 27 July 2014

SQL Server 2012 with SP2 Slipstream ISO images fixed

Microsoft fixed SQL Server 2012 with SP2 Slipstream ISO images do not install SP2 issue. The new ISOs have been posted on their respective release channels (MSDN…) and are now available.

Refer : http://support.microsoft.com/kb/2984316

Source : http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/18/sql-server-2012-with-sp2-slipstream-iso-images-fixed.aspx

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

Reference :… Read more

0 comments, 134 reads

Posted in MSSQLFUN on 23 July 2014

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

The 11th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 11 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, 96 reads

Posted in MSSQLFUN on 23 July 2014

Steps to install Service Pack for SQL Server 2005 – Multiple Instances

Steps to install Service Pack for SQL Server 2005 on multiple instances in one go :-

Step 1 : First page of Service pack setup. Informatory details only.

Step 2 : Confirm EULA (End User License Agreement) to move ahead.

Step 3 : Select instance & features you want to… Read more

0 comments, 4,644 reads

Posted in MSSQLFUN on 21 July 2014

How to Check SQL Server Installation Date Time ?

You need to run the following query and it will give you the date of your SQL Server Installation.

SELECT @@SERVERNAME SERVERNAME, CREATE_DATE ‘INSTALALTIONDATE’

FROM SYS.SERVER_PRINCIPALS

WHERE SID = 0X010100000000000512000000

SID 0X010100000000000512000000 is belongs to user "NT AUTHORITYSYSTEM". This user create at the time of installation only.

If you liked… Read more

0 comments, 114 reads

Posted in MSSQLFUN on 17 July 2014

Mainstream Support End || SQL Server 2008 and SQL Server 2008 R2

Mainstream Support for SQL Server 2008 and SQL Server 2008 R2 was ended on July 8th 2014. This will result no enchantment or no future release of SPs. Somehow, Critical bug fixes may be release as QFE etc.

This sequence stop with SQL Server 2008 Service Pack 3 CU16 and… Read more

0 comments, 108 reads

Posted in MSSQLFUN on 14 July 2014

How to restore MSDB & MODEL database – SQL Server System Databases?

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. Issues in MSDB restore that may result loss of all scheduling information, as well as the backup and restore history. You… Read more

0 comments, 232 reads

Posted in MSSQLFUN on 14 July 2014

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :-

1) Check current file location of TempDB

Exec SP_helpDB TempDB

You can use below query as well for file location details.

SELECT name, physical_name AS CurrentLocation, state_desc

FROM sys.master_files

WHERE database_id = DB_ID(‘TempDB’);

2) Execute Alter Database command with Modify Filename… Read more

0 comments, 134 reads

Posted in MSSQLFUN on 7 July 2014

Cumulative Update – 2 for SQL Server 2014 RTM Is Now Available !

The 2nd cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

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

0 comments, 204 reads

Posted in MSSQLFUN on 2 July 2014

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

The 13th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 13 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

1 comments, 155 reads

Posted in MSSQLFUN on 2 July 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

0 comments, 246 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, 246 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, 174 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, 616 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, 175 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, 357 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, 160 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, 247 reads

Posted in MSSQLFUN on 9 June 2014

Older posts