About Srikanth

Srikanth Anne is an SQL Server DBA, Az-104 Certified professional. Srikanth focuses on helping customers to build high-available, cost-effective database solutions and migrate their large scale SQL Server databases to Azure. He is passionate about Databases and Analytics.

What are the Most Popular RDBMS

In this article, we are going to understand the most popular and commonly used database system that is called RDBMS. What is RDBMS? RDBMS stands for Relational Database Management System, in which the data is organized, assessed, and stored according to the relationships. In RDBMS, data is stored in the form of Tables. The relations [...]

By |2021-11-19T08:23:35-06:00October 3rd, 2021|Categories: Database, IBM DB2, Microsoft SQL Server, MySQL, ORACLE, PostgreSQL, RDBMS|Tags: , , , , , |Comments Off on What are the Most Popular RDBMS

Az-104 Create Custom RBAC Roles

What is RBAC? Azure role-based access control (Azure RBAC) is a system that provides fine-grained access management of Azure resources. Using Azure RBAC, you can segregate duties within your team and grant only the amount of access to users that they need to perform their jobs. Azure includes several built-in roles that you can use. The following are the [...]

By |2021-07-01T10:41:27-05:00June 15th, 2021|Categories: Az-104, Azure, Azure IAM, Azure Resource Manager, Management Groups, Microsoft Azure, RBAC|Tags: , , , |Comments Off on Az-104 Create Custom RBAC Roles

Az-104: Azure Resource Manager and Management groups

What is Azure Resource Manager? Azure Resource Manager is the deployment and management service for Azure. It provides a management layer that enables you to create, update, and delete resources in your Azure account. You use management features, like access control, locks, and tags, to secure and organize your resources after deployment. The following image shows the Azure Resource Manager role in handling Azure requests. 1.1 Azure Resource [...]

By |2021-03-22T06:50:16-05:00March 22nd, 2021|Categories: Az-104, Azure Resource Manager, Azure Resource Manager, Management Groups, Microsoft Azure|Tags: , , , , |Comments Off on Az-104: Azure Resource Manager and Management groups

Microsoft Azure for Beginners

What is cloud computing? A simple definition of Cloud computing is delivering different types of services over the internet such Compute, storage, network, databases etc.. For example, you have an health care organization that would require an infrastructure to run computer systems, databases and front-end application to enter patient details. To maintain all these, one [...]

By |2021-03-01T01:58:56-06:00March 1st, 2021|Categories: Azure, Cloud Computing, Microsoft Azure, Microsoft Windows|Tags: , , , , , |Comments Off on Microsoft Azure for Beginners

Getting started with Azure SQL

Azure SQL: Azure SQL database is a fully managed platform-as-a-service database that handles most of the database management functions such as backups, patches, and monitoring etc.. SQL database can be a right choice for modern application as it enables you to process relation and non-relations database functions History of Azure SQL: In 2008, Microsoft has [...]

By |2021-01-24T20:16:21-06:00January 21st, 2021|Categories: Azure, Azure SQL, Database|Tags: , |Comments Off on Getting started with Azure SQL

Microsoft SQL Server Database Backup Types

What is Backup & why do we need it: The backup is nothing but snapshot of a database. The purpose of the backup is to create a copy of data that can be recovered in the event of a primary data failure Before we discuss on SQL Server backups, let’s try to understand what backups [...]

By |2021-01-24T20:27:14-06:00December 4th, 2020|Categories: Database, Microsoft SQL Server|Tags: , |Comments Off on Microsoft SQL Server Database Backup Types