MSSQL Database Administrator
Azure SQL DBA Training Videos: Find the below Azure SQL DBA DP300—Day 1 Azure SQL DBA DP300—Day 1 Azure SQL DBA DP300—Day 3-Part 1 Azure SQL DBA DP300—Day 3-Part 2 Azure SQL DBA DP300—Day 4-Part 1 Azure SQL DBA DP300—Day 4—Part 2 Azure SQL DBA DP300—Day 5
Continue ReadingLarge-scale online transaction processing (OLTP), data warehousing, and e-commerce applications are all supported by Microsoft SQL Server. Additionally, it is a business-intelligent platform for reporting, analysis, and data integration. Introduction to Database: Data: A collection of facts, such values or measurements, is called data. It could include of words, numbers, measurements, observations, or just a […]
Continue Readingwhich stands for Structured Query Language, is a language used to add, update, and remove data from databases as well as modify the metadata related to those databases. SQL Commands or Types of languages in SQL In order to perform specific data-related tasks, SQL commands are queries sent to the database. Apart from database searches, […]
Continue ReadingSQL Server’s primary components are: • Relational Engine • Storage Engine • SQL OS Relational Engine: The Relational Engine, often known as the query processor, is a component of SQL Server that determines what your query needs to perform and how to execute it best. It oversees […]
Continue ReadingWhen we talk about any database on a SQL server, two sorts of files are created on the disc: data files and log files. The data is physically stored on data pages in a data file. Log files, often known as write-ahead logs, are used to record database transactions. There are three types of files […]
Continue ReadingRecords->Pages->Extents->Files->Database Pages:The SQL Server page size is 8 KB. This translates to 128 pages per megabyte for SQL Server databases. Each page starts with a 96-byte header that contains system information about the page. This information includes the page number, page type, page size, and the allocation unit ID of the object that owns the […]
Continue ReadingThe SQL Server Network Interface (SNI) is the protocol layer that connects the client to the server via the network. It is made up of a set of APIs that are utilized by the database engine as well as the SQL Server Native Client (SNAC). The following protocols are supported by SQL Server: • Shared […]
Continue ReadingPlanning the installation process thoroughly and having all the necessary information on hand before installing SQL Server 2005, 2008, 2012, 2016, and above is crucial. Hardware and software requirements Version and edition of SQL Server License details of SQL Server Name of SQL Server Components to be installed Authentication mode of SQL Server Service accounts […]
Continue ReadingSQL Server Service: The database engine runs under this service. Entire SQL server operations are controlled by this service. It is responsible for running databases and system stored procedures user logins information and passwords. SQL Server Agent Service: This service is responsible for automation purposes. All the scheduled jobs will be executed only if this […]
Continue ReadingACID Properties ACID (atomicity, consistency, isolation, durability) is a set of properties that guarantee that database transactions are processed reliably. Atomicity: Atomicity requires that each transaction is “all or nothing”: if one part of the transaction fails, the entire transaction fails, and the database state is left unchanged. Consistency: The consistency property ensures that any […]
Continue Reading