Category Archives for DP-300
Long Term Backup Retention [LTR] On Azure SQL Managed Instance
In this blog, I have covered the overview of Long-Term Backup Retention [LTR] On Azure SQL Managed Instance. Also how to create, configure, restore a backup, and many more things which are essential to learn as a database administrator. What Is Long-Term Backup Retention Most of the applications have regulatory, consistency or other business purposes […]
Read More
Schedule And Automate SQL Server DB Replication
In this blog, I have covered steps to Schedule And Automate SQL Server DB Replication between different servers [SQL Server 2017 or Windows Server 2016]. We cover this in detail in our Azure Data Database Administrator [DP-300] Training program. Introduction SQL Server DB replication is a technology that is used to copy or distribute, data […]
Read More
Introduction to Azure SQL Database For Beginners & Steps to Deploy
There are very few relational database systems as established and widely used as Microsoftโs SQL Server. SQL Server on Microsoft Azure comes in 3 different types (commonly known as the Azure SQL family): 1. SQL Server on Azure VM (IaaS) 2. Azure SQL Database (PaaS) 3. Azure SQL Managed Instance (PaaS). The IaaS offering, SQL […]
Read More
Schedule Tasks Using SQL Server Agent
In this blog, we are going to cover Schedule Tasks Using SQL Server Agent In Database systems that need regular maintenance, which includes tasks like making backups and updating statistics. Maintenance may also include regularly scheduled jobs that execute against a database. What is Task Scheduling? Database systems need regular maintenance, which includes tasks like […]
Read More
Introduction to Azure SQL Database For Beginners & Steps to Deploy
There are very few relational database systems as established and widely used as Microsoftโs SQL Server. SQL Server on Microsoft Azure comes in 3 different types (commonly known as the Azure SQL family): 1. SQL Server on Azure VM (IaaS) 2. Azure SQL Database (PaaS) 3. Azure SQL Managed Instance (PaaS). The IaaS offering, SQL […]
Read More
Migrate Your Relational Database To Azure
In this blog, we are going to cover Migrate Your Relational Database To Azure. In Azure, you can migrate your database servers directly to IaaS VMs (pure lift and shift), or you can migrate to Azure SQL Database, for additional benefits. Azure SQL Database offers the managed instance and full database-as-a-service (DBaaS) options. What Is […]
Read More
Create Alerts For Azure SQL Managed Instance
This blog tells you the best way to Create alerts for Azure SQL Managed Instance Database utilizing the Azure portal. Alerts can send you an email, runbook, execute Azure Function, call a webhook, call an outside ITSM viable tagging framework, call you on the telephone or send an instant message when some metric, such as […]
Read More
Solved Azure SQL DB Connectivity Error
In this blog, we are going to cover Solved Azure SQL DB Connectivity Error You receive error messages when the connection to Azure SQL Database or Azure SQL Managed Instance fails. These connection problems can be caused by reconfiguration, firewall settings, a connection timeout, incorrect login information, or failure to apply best practices and design […]
Read More
๐๐ฎ๐ญ๐จ๐ฆ๐๐ญ๐ ๐๐๐ฌ๐ค๐ฌ ๐๐ง ๐๐ณ๐ฎ๐ซ๐ ๐๐๐ ๐๐๐ซ๐ฏ๐๐ซ
๐ In this ๐๐๐ ๐ฌ๐๐ซ๐ฏ๐๐ซ ๐ฌ๐๐ซ๐ข๐ฉ๐ญ๐ข๐ง๐ monotonous tasks in Azure SQL for regular maintenance jobs and multi-instance administration. Automation of error and resource alerts. Configuration of notifications for failures. ๐ ๐๐ง-๐ฉ๐ซ๐๐ฆ๐ข๐ฌ๐๐ฌ ๐๐ซ๐๐ฆ๐๐ฐ๐จ๐ซ๐ค๐ฌ require cabling and racks of equipment to convey another data set(database) server. With cloud computing, this isn’t needed. ๐ One of the significant […]
Read More
๐๐ฉ๐ญ๐ข๐ฆ๐ข๐ณ๐ ๐๐ฎ๐๐ซ๐ฒ ๐๐๐ซ๐๐จ๐ซ๐ฆ๐๐ง๐๐ ๐๐ง ๐๐๐ ๐๐๐ซ๐ฏ๐๐ซ
๐ Optimize Query Performance in SQL Server are potentially the most important aspect of database performance. It also provides the details on how to analyze individual query performance and also determine where improvement is needed. And the query performance also depends on the volumes of data and transaction concurrency. ๐ Executing the same query on […]
Read More