Dear Readers, In this article, we will see the following Backup Details of SQL. SQL Server offers many options for creating backups. As we discussed what types of backups can be performed based on the recovery model of the database. Here different types of backups… Read More
Hello Readers, In this article, we will see Recovery models in SQL Server. SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database… Read More
Dear Readers, In this article, we will see SQL Server Database Architecture. SQL Server MDF Files In the SQL Server Primary Data Files are the basic data files which are related to the database for the storing and supervision of the information. MDF file in… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. We have to download the Sql server patches from Sql server Builds site. (https://sqlserverbuilds.blogspot.com/) What is Cumulative updates (CU) 👉 Each new CU contains all the fixes that were… Read More
Dear Readers, In this article, we will see the Upgradation and Data Migration in SQL Server. Version upgradation 2014 to 2016 SQL 2014 evaluation edition….. Enterprise edition. In SQL server 2014 standard edition to enterprise edition The upgrading the version in SQL server 2014 it… Read More
Dear Readers, In this article, we will see the following Installation of SQL Server On AWS Cloud. This provides a step by step procedure for installing a new instance of SQL server 2014 by using the SQL server setup installation wizard. Now I will show… Read More
Dear Readers, In this article, we will see the following Introduction to SQL Server. DBMS: Human needs have increased tremendously. Now people are doing much more composite tasks than ever before. Society has become very complex if a person has to work in a huge… Read More
Dear Readers, In this article, we will discuss Roles (L1,L2,L3) in SQL Server DBA. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/roles L1 Roles: ➼Check to… Read More
Dear Readers, In this article, we will discuss Tools for Administering the SQL Server. Please Fill below Google Form (If we missed any Products, Tools, and Utilities that you use in achieving your goals as a SQL Server Administrator.) 👇🏻👇🏻👇🏻👇🏻👇🏻 https://forms.gle/sqlserver SQL Server Supported Platforms… Read More
SQL SERVER –Transparent Data Encryption (TDE) Dear Readers, In this article, we will learn about SQL SERVER –Transparent Data Encryption (TDE) Transparent Data Encryption (TDE) performs real-time I/O encryption and decryption of the data and log files, thereby, protecting data at rest. When SQL Server 2008… Read More
