Today, I will describe the SQL SUM () function along with its use cases in this article. There are various mathematical calculations we need to do in day-to-day business requirements. SQL Server offers various system functions which I have listed below to get these mathematical calculations easily by using them. One such requirement is to get the sum of values stored in a numeric column. We can use SQL Server system function SUM () to easily get the sum of the values stored in a numeric column of the table.
Read more »Why do we need Correlated Subqueries in SQL
December 9, 2022This article speaks about correlated subquery and why we need it when querying a SQL database.
Additionally, we are going to understand the difference between simple subqueries and correlated subqueries with the help of some easily understandable examples.
Read more »Understanding business continuity solutions for Azure SQL PaaS services
December 7, 2022This article will explain various business continuity options available for Azure SQL PaaS services (SQL databases and SQL managed instances). Today we will learn about several options so that you can choose a suitable business continuity solution for your SQL databases provisioned in the Azure cloud.
Read more »Implementing Row-Level Security in Azure Synapse Serverless SQL pools using TSQL
December 5, 2022Row Level Security is a very key requirement for most database or data lake applications. Most of the databases are having natively build row-level security but Synapse serverless SQL pool doesn’t support this inbuilt functionality. In this article, we will see how to implement it.
Read more »PostgreSQL Join overview with examples
December 2, 2022In this article, we will learn about different types of PostgreSQL joins with examples.
Read more »Control Retention of items using TTL in Azure Cosmos DB
November 30, 2022This article will provide a detailed walkthrough for retaining items in Cosmos DB for different durations and on different levels.
Read more »SQL Boolean Tutorial
November 28, 2022The SQL Boolean data type is not included in SQL Server. Other databases like Oracle and MySQL include the Boolean data type that accepts the values of TRUE, and FALSE.
Read more »Different SQL TimeStamp functions in SQL Server
November 25, 2022This article will show different SQL timestamp functions available with examples.
Read more »INT vs BIGINT in SQL Server with Examples
November 22, 2022SQL Server provides int, bigint, smallint and tinyint data for storing exact-number data. In this article, we will focus on int and bigint data types.
Read more »Using parameterized queries to avoid SQL injection
November 18, 2022In this article, we will explain what the SQL injection attack is, why it could be hazardous, and how to defend our SQL database from this attack using parameterized queries and some third-party tools.
Read more »How to migrate Periodic backup to Continuous backup for Azure Cosmos DB
November 17, 2022Today, I will demonstrate migrating or switching the backup policy from periodic to the continuous backup policy of an existing Azure Cosmos DB account. I have explained Cosmos DB backup policies in my last few articles which are given below for your reference to understand the topics.
Read more »How to configure Continuous backup for Azure Cosmos DB account
November 14, 2022This 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 »Getting started with MySQL on AWS: Costs, Setup, and Deployment options
November 11, 2022This article will show the basics of hosting MySQL databases in Amazon Web Services (AWS).
Read more »ODBC drivers for Azure SQL
November 9, 2022Introduction
In previous articles, we saw how to connect with ODBC to SQL Server using the ODBC Data Source Administrator in Windows. This time, we will connect to Azure and export the data from one table in Azure to SQL Server on-premises using SSIS.
Read more »SQL Subtract dates
November 7, 2022In 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 »Enable Global Distribution to replicate data across regions in Azure Cosmos DB
November 2, 2022This 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 »Access Azure Cosmos DB using Data Explorer
November 1, 2022This 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 »How to identify suitable SKUs for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM
October 28, 2022The database migration from on-premises to Azure cloud can be complicated in choosing the best SKU for Azure SQL Database, Managed Instance (MI), or SQL Server on Azure VM. Every database might have different resource requirements, and we need to choose the correct DB sizing based on the current workloads.
Read more »Getting started with procedures in Azure Database for PostgreSQL
October 26, 2022In this article, we will learn how to work with procedures in Azure Database for PostgreSQL.
Read more »Managing schema in Azure Database for PostgreSQL using pgAdmin
October 25, 2022In this article, we will learn how to use the features of pgAdmin for tasks like schema comparison and schema management.
Read more »Copy data from AWS RDS SQL Server to Azure SQL Database
October 21, 2022This blog will share with you a way to copy data from an AWS RDS SQL Server database to an Azure SQL database.
Read more »Copy SQL Databases between Windows 10 and CentOS using SQL Server data tools
October 19, 2022In 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 »Rename on-premises SQL Server database and Azure SQL database
October 18, 2022This article explores how to rename Azure SQL Database and on-premises SQL instance database.
Read more »Changing the location of FILESTREAM data files in SQL Database
October 14, 2022This article explains different ways to change the location of the FILESTREAM data files. The FILESTREAM feature was introduced in SQL Server 2008 version. We can efficiently store the BLOBs in the SQL database using FILESTERAM.
Read more »Reporting data from Azure Database for PostgreSQL using Power BI
October 12, 2022In this article, we will learn how to use Power BI to source data from an instance of Azure Database for PostgreSQL, transform this data and load it into Power BI for reporting.
Read more »