Category: Azure
-
Migrate MongoDB To CosmosDB
Pre-requisites- Steps to perform backup and restore- Step-1: Connect to the source MongoDB server and take a data dump using the mongodump utility. mongodump \ –uri=”mongodb://mongoadmin:Password@Server_IP:27017/mydocument?authSource=admin” \ –out=/root/ Step-2: Install AzCopy on Linux by using a package manager. Download the repository configuration package. curl -sSL -O https://packages.microsoft.com/config/<distribution>/<version>/packages-microsoft-prod.rpm Install the repository configuration package. sudo…
//
-
About Us
At CLOTA Technology, we provide innovative solutions in database technologies, web development, cloud maintenance, and software support to help businesses achieve their goals. Our services include expert SQL and NoSQL database design, implementation, and maintenance with certified DBAs boasting 15+ years of experience. We specialize in custom website and app creation, cloud services for migrations,…
//
-
Provisioning a First Azure SQL Database
In this section, we’ll learn: Provisioning Azure SQL database: Provisioning an Azure SQL database refer to creating a new and blank Azure SQL database. We’ll create new SQL database in Azure using the Azure portal: 1. Open a browser and log in to the Azure portal: https://portal.azure.com 2. On the left-hand navigation pane, select Create a resource: 3. On the New page, under Databases, select SQL…
//
-
Azure Azure SQL Database DBA Worries Continued High Availability Installation and Configuration SQL Server
Cloud Witness in Azure
Cloud Witness is a type of Fail-over Cluster quorum witness that uses Microsoft Azure to provide a vote on cluster quorum. There are significant benefits which this approach: Problem with traditional cluster setup Lets consider a typical cluster setup which is shown in below diagram. Here we have file share witness in primary DC and unfortunately…
//
-
Provisioning a SQL Managed Instance Using the Azure Portal
Azure SQL Managed Instance is intelligent, scalable cloud database service. SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. To create a SQL Managed Instance, follow these steps: 1. Log in to https://portal.azure.com using your Azure credentials. 2. In the top search box, type SQL Managed…
//
-
Azure Azure SQL Database Azure SQL Database Backup and Recovery Backup Tools for SQL Server DBA Worries Continued DBMS Concepts DBMS Concepts DBMS Concepts High Availability L1 DBA Monitoring My SQL Performance Tuning PostgreSQL Security SQL Scripting SQL Server
Important SQL Server Scripts…
Restore Progress Check… ========================================================================== DECLARE @DBName VARCHAR(64) = ‘ODS’ DECLARE @ErrorLog AS TABLE([LogDate] CHAR(24), [ProcessInfo] VARCHAR(64), [TEXT] VARCHAR(MAX)) INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery of database’, @DBName INSERT INTO @ErrorLog EXEC master..sp_readerrorlog 0, 1, ‘Recovery completed’, @DBName SELECT TOP 1 @DBName AS [DBName] ,[LogDate] ,CASE WHEN…
//
-
Azure Azure SQL Database Azure SQL Database High Availability L1 DBA Monitoring pg_ High Availability PostgreSQL SQL Server
New features of SQL Server 2022
Hello guys, hope you are doing well. In this blog I’m going to discuss about the “New features of SQL Server 2022” The release of the SQL Server 2022 is much anticipated by the audience since the announcement of it being in the works on November 2nd, 2021. Although the complete details of this brand-new version will…
//
-
AOG on Azure Blob with a different region SQL Server instance
Hello there, everyone! I hope everything is going well for you. Today, I’ll show you AOG on Azure Blob with different region SQL Server Instance. Ø Created SQL disk layout and formatted with 64K- · Disk E: SQL Binaries · Disk T: TempDB · Disk R: User Databases · Disk L: User DB transaction logs Ø SQL Server Memory Configuration as…
//