This article will deploy SQL Server on Azure VM using a Jupyter notebook in Azure Data Studio.
Read more »
Embedding Power BI reports in Jupyter notebooks
August 13, 2021In this article, we are going to explore how to embed Power BI reports in Jupyter notebooks. Power BI is one of the most popular data visualization tools in the market that is being heavily used by Data Analysts to visualize existing data and to discover patterns lying in the data. Power BI provides a desktop application to author the reports and it can be deployed to the Power BI Service and consumed by users using a web browser.
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 »
How to gain advanced T-SQL programming skills
August 11, 2021This article aims to provide various tricks that help to gain advanced T-SQL programming skills.
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 »
Popular free SQL online compilers
August 9, 2021This article will mention some of the most popular free SQL online compilers that help developers debug and test their SQL code without installing an SQL instance locally or buying one on the cloud.
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 »
Using Stored Procedures with Return Values
August 6, 2021In this article, we will learn how we can use a Stored Procedure with return values with all details.
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 »
How to write subqueries in SQL
August 3, 2021This article briefly explains how to write a subquery in SQL by providing examples.
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 »
Understanding SQL Server DBCC DBREINDEX command and its usage
August 2, 2021In this article, I am going to explain the DBCC DBREINDEX statement, its syntax, and its usage. Additionally, I am also going to cover the differences between the DBCC REINDEX and ALTER INDEX statements.
Read more »
An overview of Analytic Functions in SQL Server
August 2, 2021In this article, we are going to talk about the various analytic functions that are supported by the SQL Server Database Engine. As it goes by the name, these are some special functions using which we can execute analytic queries on the dataset and obtain useful results. In comparison to standard SQL queries, sometimes it becomes necessary for the Data Analysts to deep dive into the data more and obtain insights from analytic perspectives. This article will discuss all the analytic functions supported by SQL Server with some details.
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 »
How to calculate Subtotals in SQL Queries
July 30, 2021In this article, we will learn how to calculate and add a subtotal in SQL queries.
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 »
Recommender Systems for Customer Reviews
July 29, 2021Introduction
Until now, we have discussed several topics in Text Analytics in Azure Machine Learning in many aspects from the last couple of articles and in this article, we will be discussing the Recommender Systems for Customer Reviews.
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 »
SSIS Lookup transformation vs. Fuzzy Lookup transformation
July 28, 2021This article will explain how to use the SSIS lookup transformation and how it differs from the fuzzy lookup. This is a continuation of the SSIS features face-to-face series that we published previously on this website.
Read more »
A deep dive into SQL Table Variables
July 28, 2021In this article, we will explore some secrets about SQL Table Variables.
Read more »
An overview of Azure Cognitive Services
July 26, 2021Microsoft Azure has been a leading cloud service provider over the past few years. In this article, we are going to look into an overview of various cognitive services offered by Azure. In simple English, the word ‘Cognitive’ means to involve in intellectual activities, such as thinking or reasoning. Similarly, Azure Cognitive Services are also related to intelligence related to the computer and the way humans behave with these computers. For example, these services allow humans to interact with the machines as if they have the intellectual ability to talk, think and respond to events accordingly.
Read more »
Getting started with Azure Database for PostgreSQL – Flexible server
July 14, 2021This article will walk you through the process to create a Flexible server model of Azure Database for PostgreSQL and learn the unique features offered by it.
Read more »
Understanding xp_fileexist and its usage
July 9, 2021In this article, we are going to learn about xp_fileexist, its usage, and alternatives. To access the file system using SQL Server queries, we can use the following extended stored procedures.
Read more »