This article explores the scalar UDF performance issues and improvements in Azure SQL Database using UDF Inlining.
Read more »SQL Server versions
Setting up customized SQL Server images using Azure Container Registry and Azure Container Instances
January 25, 2022This article will walk you through the process of creating, importing a customized SQL Server image into Azure Container Registry and finally deploying an Azure Container instance using it.
Read more »Deploying Azure Container Instances using YAML
January 21, 2022The Azure Container Instances provides a flexible solution for implementing container-based images in Azure infrastructure quickly. It does not require building the virtual machine, installing applications like Microsoft SQL Server, or configuring the software. You can choose the container images from the libraries and build solutions. You can use non-persisted(default) and persisted storage to avoid losing container data if your container status changes to Stopped and restarted.
Read more »SQL Server Developer Edition – a FAQ article
January 5, 2022In this article, we will cover the most common questions about this nice SQL Server Developer Edition.
Read more »Use ARM templates to deploy Azure container instances with SQL Server Linux images
December 21, 2021The Azure Resource Manager (ARM) template is a JavaScript Object Notation (JSON) file for deploying Azure resources automatically. You can use a declarative syntax to specify the resources, their configurations. Usually, if you need to deploy Azure resources, it might be a tiring experience of navigating through different services, their configurations. With the ARM templates, you no longer need to click and navigate around the portal. For example, you can use configure the template for Azure VM or Azure SQL Database deployment.
Read more »Store SQL Server files in Persistent Storage for Azure Container Instances
December 10, 2021In the articles, Deploying Azure Container Instances for SQL Server 2019 and Create Azure Container Instances for SQL Server 2019 using Azure CLI, we explored Azure Container Instances for SQL Server on Linux. These containers are stateless. Therefore, if you stop or restart container instances, you lost your data. Suppose, being a developer, you created a new container database, deployed a few tables, and stored procedures for testing purposes. You do not want to lose these objects or databases even if you destroy your container. Similarly, you also want to reuse those databases if you create a new container instance.
Read more »Create Azure Container Instances for SQL Server 2019 using Azure CLI
December 8, 2021This article explores Azure CLI scripts for deploying Azure Container Instances with SQL Server 2019 image.
Read more »Deploying Azure Container Instances for SQL Server 2019
December 3, 2021This article will show how to deploy SQL Server 2019 on the Azure container instances using the Azure portal.
Read more »How to download and install SQL Server 2016 express edition
December 2, 2021In this article, you are going to learn about SQL Server 2016 express download and installation process. The SQL Server 2016 express edition is a free version of SQL Server that offers limited features. The express edition of SQL Server can be used in any of the following scenarios:
Read more »Hybrid Buffer Pool in SQL Server 2019
November 23, 2021This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019.
Read more »SQL Server 2022 Private Preview announcement
November 3, 2021This 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 »Install and configure SSDT 2017 on Windows 10
October 28, 2021In this article, we are going to learn how we can install and configure the SSDT 2017 on Windows 10. The SQL Server data tools 2017 (SSDT 2017) is a development tool used for database development, SQL Server analysis service data models, SQL Server report service reports, and Integration service packages.
Read more »Installing Oracle 19c on Windows Server 2019
October 13, 2021In this article, we understand the step-by-step installation process of Oracle 19c on Windows Server 2019. The minimum hardware requirement to install an Oracle database server is following:
Read more »SQL queries to change the column type
September 22, 2021This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the following databases:
Read more »How to install SQL Server developer edition
August 31, 2021In this article, we are going to learn how we can install the SQL Server developer edition. We are installing the SQL Server 2017 developer edition on my workstation.
Read more »Managing SQL Server Express databases
May 11, 2021Introduction
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.
Read more »Different approaches to execute Python in SQL Server
May 10, 2021This article briefly explains how to execute scripts written in Python in SQL Server and how Machine Learning services facilitate this process.
Read more »Migrating SQL Server graph databases to Neo4j
March 9, 2021This article provides a step-by-step guide for migrating SQL Server graph databases to Neo4j using C#.
Read more »Move SQL database files in SQL Server 2019 on Linux
February 26, 2021In this article, I am going to explain how we can move the SQL database files to another location in Ubuntu 18.04. For the demonstration, I have installed Ubuntu 18.04, SQL Server 2019 on Linux on my workstation. You can read SQL Server 2019 on Linux with Ubuntu to understand the step-by-step installation process of the SQL Server 2019 on Linux. We will move database files of AdventureWorks2019 and Wideworldimportors database. To move the databases, we can use any of the following methods:
Read more »Performing minor and major version upgrades for AWS RDS SQL Server
January 29, 2021Usually, database administrators upgrade the SQL Server versions for on-premise infrastructure. The AWS cloud infrastructure for SQL Server supports two flavors for database deployments.
- SQL Server deployed on the AWS EC2 instance
- An AWS managed instance relational database service
Getting started with Data-Tier applications in Visual Studio
January 15, 2021In this article, I am going to talk about creating a data-tier application using Visual Studio. In my previous article An introduction to Data-Tier applications in SQL Server, I have explained in detail what a data-tier application is all about. I have explained what the different types of data-tier applications are available and how can we create such applications from existing SQL Server databases. In this article, the primary focus would be to create data-tier applications from scratch using Visual Studio. For this article, I am going to use Visual Studio 2019, however, the technique will remain similar for other editions of SQL Server as well.
Read more »SQL Server PolyBase external tables with Azure Blob Storage
January 15, 2021In this article, we will explore SQL Server PolyBase external tables with Azure Blob Storage.
Read more »How to install SQL Server 2019 on RedHat Linux 18
December 9, 2020In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.
Read more »An overview of SQL Machine Learning with R scripts
November 25, 2020In this article, we will focus on SQL Machine Learning using R scripts and the use of external packages.
Read more »Query Tuning with SQL Server 2019
November 23, 2020In this article, we will talk about the query tuning features that were announced with SQL Server 2019.
Read more »