Monday, February 12, 2018

Transparent Data Encryption (TDE)

›
Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without th...
3 comments:
Friday, December 1, 2017

TLS 1.2 enabled issue with sql server 2012 and 2014

›
When you try to install Microsoft SQL Server 2012 or SQL Server 2014 on a server that has Transport Layer Security (TLS) version 1.2 ena...
Thursday, November 30, 2017

Slipstream service pack, patch or cumulative updates with sql installation for 2012 and 2014

›
Slipstream service pack, patch or cumulative updates with sql installation for 2012 and 2014: There are two scenario when we want to ins...
Thursday, November 23, 2017

Find service account and status of SQL Service using TSQL

›
Since SQL server 2008R2 we can use DMV (sys.dm_server_services) to get service account   information, It gives us information about t...
Monday, June 20, 2016

Install SQL Server using configuration file?

›
SQL Server allows to generate configuration file and using this file we can deploy sql instance with same configuration for different se...
Tuesday, June 14, 2016

Page File for SQL Server

›
Page File for SQL Server Page file is space allocated on system drive as a file and its functionality is: operating system works with ...
1 comment:
Friday, May 20, 2016

Database Backup Myth

›
1.        backup operations cause blocking No. Backup operations do not take locks on user objects. Backups do cause a really heavy read...