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: May 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, 215 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, 309 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,003 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, 370 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, 142 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, 460 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, 307 reads

Posted in MSSQLFUN on 5 May 2014