Category Archives for Microsoft Azure

Migrate SQL

Migrate SQL Server To an Azure SQL Managed Instance [Online]

In this blog, we are going to cover the steps to Migrate SQL Server To An Azure SQL Managed Instance [Online] using a database migration service (Adventureworks2016 database ) with minimal downtime and these roles are mainly performed by the database administrator. What Is Azure SQL Managed Instance? SQL Managed Instance is a PaaS deployment […]

Read More
AZ-303

Azure Solutions Architect | Day 3 Review and Q/A

Implement VMs for Windows and Linux [AZ-303/304] Azure Virtual Machines (VM) is one of several types of on-demand, scalable computing resources that Azure offers. Typically, you choose a VM when you need more control over the computing environment than the other choices offer. Azure virtual machines can be used in various ways. Read Our Blog […]

Read More

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

Azure Solutions Architect | Day 1 Review and Q/A

Azure Active Directory [AZ-303/304] Azure Active Directory ➪ is a cloud-based identity and access management service offered by Microsoft that helps employees sign in and access resources. Azure AD Join ➪ lets you join the devices directly to Azure AD without joining on-premises Active Directory. At the same time, it is user productive and secure. […]

Read More
Azure

Azure RBAC vs Azure Policy vs Azure Blueprints

➽ The blog post – https://k21academy.com/az30419 will cover an overview of azure governance and its services and their differences. ➽ What comes to your mind when you see the word Governance? Is it a rule, or is it policy? Whatever it may be, don’t you think the company needs Governance to run effectively and efficiently. […]

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

Everything you need to know about Power BI Service

This blog walks you through the Power BI Service and everything you need to know about Power BI Service Microsoft Power BI Service The Power BI Service is a cloud-based☁️ service where users view and interact with the reports. The Microsoft Power BI service, also referred to as Power BI online, is the SaaS (Software […]

Read More

DevOps for Data Science

✔️DevOps is a set of practices that combines software development (Dev) and IT operations (Ops). It aims to shorten the systems development life cycle and provide continuous delivery with high software quality. DevOps is complementary to Agile software development. ✔️Data Science is a discipline relying on data availability, while business analytics does not completely rely […]

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
1 5 6 7 8 9 19
Not found