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.

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, 204 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, 204 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, 287 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, 929 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, 317 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, 130 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, 378 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, 281 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, 190 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,261 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, 145 reads

Posted in MSSQLFUN on 15 April 2014

Antivirus Exclusion Policy for SQL Server

Anti-virus & SQL Server on one system together are friends not enemies, if configured properly.

Anti-virus are very useful programs from security, audit & venerability detection & removal point of view. But if team managing anti-virus server did not configure anti-virus policies properly then your SQL Server is going to… Read more

0 comments, 214 reads

Posted in MSSQLFUN on 8 April 2014

Wishing You a Very Happy Holi

0 comments, 114 reads

Posted in MSSQLFUN on 17 March 2014

Steps for Windows Cluster Installation on Windows Server 2008

Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008.

Step 1: Validate Cluster Configuration

a) Open Cluster Administrator & click on “Validate a Configuration”

b) Wizard for cluster validation appears, click Next

c) Add Node to create cluster

d) Select Type of test… Read more

0 comments, 208 reads

Posted in MSSQLFUN on 17 March 2014

ERROR || The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

Table with clustered index is totally depended on index accessibility.

ERROR : The query processor is unable to produce a plan because the index ‘IND_TABLE’ on table or view ‘Table’ is disabled.

REASON : We find that some disable the cluster index due to which issue occur. Clustered index physically… Read more

0 comments, 323 reads

Posted in MSSQLFUN on 25 February 2014

System Configuration Check – Without Starting SQL Server Installation

Question : Can we do system configuration check with starting SQL Server installation? One of my friend need to submit it to get installation approval. This is to ensure that no configuration issue occur at time of installation.

Answer : Yes, We can do it.

Step 1: Run Setup.exe

Step… Read more

0 comments, 243 reads

Posted in MSSQLFUN on 13 February 2014

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

The 8th cumulative update release for SQL Server 2012 Service Pack 1 is now available. Cumulative Update 8 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 plan to test CU8 in test environment… Read more

0 comments, 339 reads

Posted in MSSQLFUN on 3 February 2014

Cumulative Update – 15 for SQL Server 2008 Service Pack 3 Is Now Available !

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

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

0 comments, 183 reads

Posted in MSSQLFUN on 3 February 2014

2013 with You & SQL Server

The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15…

Read more

0 comments, 138 reads

Posted in MSSQLFUN on 30 January 2014

Database Snapshot failed due to disk space issue

Database snapshot is really a useful feature. As we know, Snapshot database file will keep increasing parallel to the DML operations on database. But if disk containing snapshot file run out of space then what will be the impact on new transactions, database & snapshot?

Microsoft design snapshot in very… Read more

0 comments, 356 reads

Posted in MSSQLFUN on 11 December 2013

Newer posts

Older posts