Declarative Database Development in Azure Data Studio

May 19, 2021 by Haroon Ashraf

This article is all about declarative database development using Azure Data Studio for both beginners and professionals who are new to it.

Working with SQL NULL values

May 19, 2021 by Esat Erkec

This article will explain what problems can occur when working with SQL NULL values and it also gives some solution recommendations to overcome these issues.

SQL GO command in SQL Server

May 18, 2021 by Daniel Calbimonte

Introduction

If you are using SQL Server and saw a GO command in a T-SQL script and you do not know what that GO is used for, this article is for you. In this article, we will explain what the SQL GO command is when to use it, and some tips about using it.

Azure Automation: Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage

May 17, 2021 by Rajendra Gupta

This article uses Azure Automation techniques to import data into Azure SQL Database from Azure Storage container.

Different ways to change database owners in SQL Server

May 17, 2021 by Nisarg Upadhyay

In this article, we will explore different ways in SQL Server to change the database owner. We can use any of the following methods in SQL Server to change the database owner.

Learn SQL: How to prevent SQL Injection attacks

May 17, 2021 by Emil Drkusic

In the previous articles we’ve talked about SQL injection and dynamic SQL but we lacked an answer on how to prevent SQL injection attacks. Today we’ll do exactly that and show you one possible approach to how to do it. We’ll also mention other possible threats and approaches you could take.

Azure Database for PostgreSQL Cost Optimization

May 14, 2021 by Gauri Mahajan

This article will walk you through the process to optimize the cost of Azure Database for PostgreSQL.

Working with Regular Expressions in PostgreSQL

May 14, 2021 by Aveek Das

In this article, I am going to talk about using regular expressions in a Postgres database. Regular Expressions, also known as RegEx are pattern matching criteria that can filter data based on the pattern. It is heavily used to match string values to a specific pattern and then filter the results based on the condition. From a beginner’s perspective, these regular expressions can seem to be quite complex in the first, however, as you will start using these on a daily basis, you will come to the underlying logic, and then you can start writing your own RegEx statements.

Azure Automation: Analyzing Twitter sentiments using Azure Logic Apps

May 14, 2021 by Rajendra Gupta

This article configures Azure Automation for Analyzing Twitter sentiments using Azure Logic Apps and stores them into Azure SQL Database.

An overview of the VS_NEEDSNEWMETADATA SSIS exception

May 13, 2021 by Hadi Fadlallah

In this article, we will briefly explain the VS_NEEDSNEWMETADATA SSIS exception, one of the most popular exceptions that an ETL developer may face while using SSIS. Then, we will run an experiment that reproduces this error. Then, we will show how we can fix it.

Azure Machine Learning: Named Entity Recognition in Text Analytics

May 13, 2021 by Dinesh Asanka

Introduction

After starting our discussions into Text Analytics in Azure Machine Learning from the last article, we will be discussing the Named Entity Recognition control in Azure Machine Learning in this article.

Getting started with Azure Database for PostgreSQL

May 13, 2021 by Gauri Mahajan

This article will get you started with Azure Database for PostgreSQL and understand various options offered by this.

SQL Server Performance Tuning tips for beginners

May 12, 2021 by Esat Erkec

This article intends is to give helpful SQL Server performance tuning advice to those who want to learn performance tuning.

Azure Automation: Auto-scaling Azure SQL database with Azure Logic Apps

May 12, 2021 by Rajendra Gupta

Azure SQL Database supports DTU-based and vCores based purchasing models for deploying your databases in the Azure managed service.

Azure Automation: Building approval-based automated workflows using Azure Logic Apps

May 11, 2021 by Rajendra Gupta

In the Azure Automation article, Azure Automation: Automate data loading from email attachments using Azure Logic Apps, we did the following tasks:

Azure Automation: Automate data loading from email attachments using Azure Logic Apps

May 11, 2021 by Rajendra Gupta

This article will explore Azure automation for automatic data loading into Azure SQL Databases using the Azure Logic App.

Managing SQL Server Express databases

May 11, 2021 by Dinesh Asanka

Introduction

If you are not able to spend money on your small databases, SQL Server Express edition is the solution for you. This edition will provide you with a basic storage option and this article is to examine what maintenance tasks you need to perform to manage SQL Express effectively.

Impact of SQL Variables on Performance

May 10, 2021 by Esat Erkec

In this article, we are going to learn how SQL variables negatively affect query performance and also examine the causes of this issue.

Different approaches to execute Python in SQL Server

May 10, 2021 by Hadi Fadlallah

This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.

An introduction to Power BI Dataflows

May 7, 2021 by Aveek Das

In this article, we are going to understand what the Power BI Dataflows is all about and how we can get started by building dataflows in Power BI Service. A dataflow can simply be considered as an extract transform and load pipeline that can be used to connect to source data, transform the data by applying business rules, and then finally preparing the data to be available to visualize. In a general data architecture, a dedicated ETL tool is used to prepare and transform the data, which is then loaded into a data warehouse. Power BI was used to connect to this data warehouse and visualize the data from here on.

Resolving SQL Server errors: The Primary Filegroup is full

May 6, 2021 by Nisarg Upadhyay

In this article, we are going to understand SQL Server error: The Primary filegroup is full and how we can fix this error.

Generating Azure SQL Database Classification and Sensitivity reports

May 5, 2021 by Gauri Mahajan

This article will show how to use Azure SQL Database to classify and tag data with sensitivity labels to generate reports out of it.

Azure Automation: Export Azure SQL Database to Blob Storage in a BACPAC file

May 5, 2021 by Rajendra Gupta

Azure SQL Database supports exporting schema and data in a compressed format BACPAC. We can store this BACPAC file into an Azure storage account. Later, this BACPAC file can help restore the Azure SQL database, and Azure managed SQL instance or on-premises SQL Server.

How to use SQL Server DACPAC extensions in Azure Data Studio

April 29, 2021 by Haroon Ashraf

This article is focused on installing and using SQL Server DACPAC Extension in Azure Data Studio.

How to set up and run SQL Server Docker image

April 28, 2021 by Aveek Das

In this article, I am going to discuss in-depth setting up docker and running a SQL Server Docker image. SQL Server, as you might already be aware that it is one of the most popular relational database technologies in today’s world. SQL Server is widely used in various applications that support transactional and analytical workloads. Docker, on the other hand, is a containerization technology using which you can bundle your applications within a container and distribute them. Docker helps users to build applications independent of the underlying operating system. We will learn more about Docker and using the SQL Server Docker image in this article.