Manvendra Singh
New Cosmos DB account dashboard

How to configure Continuous backup for Azure Cosmos DB account

November 14, 2022 by

This article will explore Continuous backup and steps to configure it for a new Azure Cosmos DB account or an existing Cosmos DB account. Azure Cosmos DB is a fully managed and highly secure, NoSQL database service on the Azure cloud that is designed for modern-day application development. It automatically runs backup for its databases on separate Azure blob storage at regular intervals without affecting the performance, availability, and provisioned resource units (RUs) to ensure data protection from a data recovery standpoint which can be needed in case of data corruption, deletion, or wrongly data updates.

Read more »
Daniel Calbimonte
Get age in SQL Server based on bithdate

SQL Subtract dates

November 7, 2022 by

In this article, we will show how to subtract dates using SQL Server. This article will be a learn-by-example article with a problem and a solution. But first, I will add some theory to understand the syntax of the DATEDIFF function which is the base of this article.

Read more »
Manvendra Singh
Enable Global data distribution

Enable Global Distribution to replicate data across regions in Azure Cosmos DB

November 2, 2022 by

This article will explain about Global Distribution feature of Azure Cosmos DB and how to enable it to distribute data across regions. Azure Cosmos DB is developed to address modern application requirements in this digital era. There are different requirements to run web-based or online internet-facing applications smoothly. You need to cater enormous amount of data that can generate with very high velocity and this will cause huge numbers of read and write operations on the database. Your database needs to be responsive and quickly show the updated details for other customers. You might also need to address autoscale which will be used to address unpredictable workload during any discount offer, or festive seasons. These modern days applications must also develop in a way so that if you need to add another location to expand your business to the different regions so you don’t need to do many changes and it could be easily adjusted to expand the application for other regions.

Read more »
Manvendra Singh
Data Explorer page

Access Azure Cosmos DB using Data Explorer

November 1, 2022 by

This article will explore an overview of Data explorer and how to access and manage Azure Cosmos DB using Data Explorer. Azure Cosmos DB is a fully managed, highly secure, and globally distributed NoSQL database that is designed for new-age modern application development. As this is fully managed so you don’t need administrators to manage its maintenance, patching, upgrades, capacity, and space management, auto-scaling in case of workload increase, etc. It is suitable for modern digital applications like online portals based on video streaming, gaming, Internet of things applications, online retail websites, etc.

Read more »
Nisarg Upadhyay
Control flow designer

Copy SQL Databases between Windows 10 and CentOS using SQL Server data tools

October 19, 2022 by

In this article, we are going to learn how to copy the SQL database created on different instances of the SQL Server. This article is the fourth article on Manage SQL Server on CentOS topic. In my previous article, Copy SQL Databases between Windows 10 and CentOS using the SQL Server import-export wizard, we learned how to copy data SQL database between windows 10 and CentOS Linux using the wizard.

Read more »
Nisarg Upadhyay
Connect to Server

Manage SQL Databases in CentOS: Manage filegroups of user databases

October 5, 2022 by

This article explains how to manage a data file and filegroups in an SQL database created on CentOS Linux. In my previous article, Manage filegroups of SQL Databases, we learned about the different types of filegroup and data files in SQL Server 2019 on windows and how to manage them using T-SQL queries. In this article, we will learn how to manage the filegroups in SQL Server 2019 on CentOS. I am going to cover the following topics in the article:

Read more »