Home » 2014 » May

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

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

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

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 validate cluster settings or not … Continue reading

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/)

%d bloggers like this: