Yearly Archives: 2014

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 SQL updates as well) 6) … Continue reading →

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) Check Product upgrade to install … Continue reading →

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 Database Mail :- 1) Configuration … Continue reading →

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 plan to test CU10 in … Continue reading →

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 using TDE or 3rd party … Continue reading →