This article talks about the next version of SQL Server which is SQL Server 2022. This will cover the latest announcement, release, and all the exciting features SQL Server 2022 offers.
Read more »SQL Azure
Copy Data tool to export data from Azure SQL Database into Azure Storage
October 29, 2021DBA may import, export regularly within a different environment. You might receive data in a specified format for importing it into database tables.
Read more »Automatic Index advisor in Azure SQL database
October 26, 2021This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database.
Read more »Introduction to Azure Time Series Insights
October 7, 2021In this article, we are going to learn in detail about Azure Time Series Insights. Microsoft Azure is one of the leading cloud providers these days. With a lot of companies adopting or migrating to the cloud these days, it has become a usual trend to convert existing technologies into cloud-based services and consume them. This not only helps the companies to reduce their cost but also in turn allows them to focus on more business-related problems rather than concentrating on infrastructure costs.
Read more »Custom Azure Policy definitions for Azure SQL Databases backup retention periods compliance
September 22, 2021This article uses Azure policies to check compliance of Azure SQL Databases against the backup retention period.
Read more »Azure Alerts for creating, modifying and deleting Azure SQL Databases
September 13, 2021This article will explore the Azure alerts configuration to audit Azure SQL Database creation, modification, and deletion activities.
Read more »Azure Automation: Automatic scaling Azure SQL databases based on CPU usage threshold
September 10, 2021This article will explore Azure automation for scaling up Azure SQL Databases based on the CPU usage threshold.
Read more »Auto Update SQL Server Statistics Asynchronous configuration for Azure SQL Database
September 7, 2021This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance.
Read more »Importing data from OData APIs using Azure Data Factory
September 6, 2021In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories.
Read more »Grant, With Grant, Revoke and Deny statements in SQL Server and Azure SQL Database
September 6, 2021This article will walk you through Grant, With Grant, Revoke and Deny statements for both on-premises and Azure SQL Database.
Read more »How to change an Azure SQL Database Collation
August 24, 2021This article explores the Azure SQL Database Collation configuration and how to change it while importing the database from a BACPAC file.
Read more »Configure the Max Degree of Parallelism (MAXDOP) in Azure SQL Database
August 20, 2021This article explores the Maximum Degree Of Parallelism (MAXDOP) for the Azure SQL Database.
Read more »Filtering data in Azure Database for PostgreSQL
August 18, 2021In this article, we will go over some of the most fundamental ways to filter data hosted in PostgreSQL.
Read more »AutoML in Azure Machine Learning for Regression and Time Series
August 16, 2021Introduction
AutoML in Azure Machine Learning is used to build machine learning models on its own as we discussed in the previous article. Over there, we discussed what AutoML is and how to develop classification models in AutoML using Azure Machine Learning. This article will be dedicated to the discussion about building machine learning models using AutoML for Clustering and Time Series tasks.
Read more »Deploy SQL Server on Azure VM using Jupyter notebooks in Azure Data Studio
August 16, 2021This article will deploy SQL Server on Azure VM using a Jupyter notebook in Azure Data Studio.
Read more »Validating data ingestion with Postgres check constraint
August 12, 2021In this article, we will learn how to create a simple PostgreSQL server on the Azure platform and learn how to use the Postgres check constraint to implement data validation.
Read more »Deploy SQL Server on Azure VM using the Azure Portal
August 11, 2021This article guides you for deploying your first SQL Server on Azure VM using the Azure portal.
Read more »Deploying Azure SQL Database using Azure Data Studio
August 10, 2021This article guides you to create a Jupyter notebook for Azure SQL Database deployment using Azure Data Studio.
Read more »AutoML in Azure Machine Learning
August 10, 2021Introduction
In this article, we are going to discuss AutoML in Azure Machine Learning Service. During our previous discussions, we had discussed features of Azure Machine Learning (Classic) and in this article, we are moving our discussion to Azure Machine Learning service.
Read more »Integrating APIs into data pipelines with Azure Data Factory
August 9, 2021In this article, we will learn how to invoke an API and process the data returned by the API using Azure Data Factory.
Read more »Access Azure SQL Database from On-premises SQL Server instance
August 4, 2021This article explores OPENROWSET, OPENDATASOURCE and Linked Server to connect Azure SQL Database from on-premises SQL Server.
Read more »Web scraping data with Azure Data Factory
August 3, 2021This article will show you how to web scrape data using Azure Data Factory and store the data on one of the Azure data repositories.
Read more »Safeguard your Azure SQL Database to prevent unexpected changes
July 30, 2021This article explores locks to prevent unexpected changes in Azure SQL Database resources.
Read more »Getting started with Azure Database for PostgreSQL – Citus server
July 30, 2021This article will show how to deploy the Hyperscale (Citus) server group of Azure Database for PostgreSQL and explore its configuration options.
Read more »DDL triggers in Azure SQL Database
July 28, 2021This article explores database DDL triggers for auditing Data Definition Language (DDL) on Azure SQL Database.
Read more »