This article explores the database-level roles in the Azure SQL Database.
Read more »
Installation, setup and configuration
Fixed Server Roles in Azure SQL Database Server
April 6, 2022This article is for discussing fixed server roles in Azure SQL Database Server.
Read more »
Azure SQL Database Connectivity architecture
March 24, 2022The article Configure IP firewall rules for Azure SQL Databases, discuss the configuring server and database IP firewall rules for Azure databases. In this article, we will explore setting applicable to Azure databases that control connectivity to the database.
Read more »
Configure IP firewall rules for Azure SQL Databases
March 18, 2022The Azure SQL Database provides high performance, secure and reliable managed relational database service. Security is the prime focus area in both on-premises and cloud infrastructure while designing the database infrastructure.
Read more »
Deploy SQL Database projects using Azure Data Studio
February 22, 2022This article explores an alternative solution for SSDT using Azure Data Studio for both Windows and Linux SQL Server.
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 »
Configure a Linked Server between SQL Server and PostgreSQL using ODBC drivers
December 6, 2021This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. We also learned how we could download, install, and configure it. In this article, we will explore how we can utilize the ODBC driver to access the data of the PostgreSQL from SQL Server 2019.
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 »
Configure ODBC drivers for PostgreSQL
October 22, 2021In this article, we are going to understand the process to configure the ODBC driver for PostgreSQL. For the demonstration, I have installed PostgreSQL on my workstation. The details of the server and database are following:
Read more »
Creating databases in Oracle 19c using the Database Configuration Assistant
October 19, 2021In this article, we understand how to create a new database in Oracle 19c using a database configuration assistant. The database configuration assistant allows us to create a new database using a pre-defined template or create a database with various configuration options. In this article, we are going to learn both methods.
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 »
How to manage SQL Server logs effectively
October 8, 2021This article covers an overview of SQL Server logs for monitoring and troubleshooting issues in SQL Server.
Read more »
Min and Max memory configurations in SQL Server Database instances
October 6, 2021This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances.
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 »
Relationships and comparisons between SQL Server TempDB and Model databases
August 17, 2021This article explores relationships and comparisons between SQL Server TempDB and Model databases in a unique way.
Read more »
Moving the SSISDB Catalog on a new SQL Server instance
March 30, 2021This article will explore the right way of moving integration services (SSIS) catalog SQL Database to a new instance.
Read more »
Provisioning Azure SQL database using Azure PowerShell
March 10, 2021This article will show how to create an Azure SQL database using Azure PowerShell.
Read more »
Lease Timeouts and Health Checks in SQL Server Always On Availability Groups
March 8, 2021In the 42nd article for SQL Server Always On Availability Groups, we are going to explore lease timeouts and health checks.
Read more »
Synchronize logins between Availability replicas in SQL Server Always On Availability Groups
January 21, 2021In this 40th article on SQL Server Always On Availability Group series, we will discuss logins synchronization between replicas.
Read more »
Import data from MongoDB to SQL Server using SSIS
December 25, 2020In this article, we will explain how to install MongoDB on the Windows operating system, how to install and configure the ODBC driver and connector that allows us to import data from MongoDB to SQL Server using SSIS.
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 »
Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance
October 26, 2020In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.
Read more »
Explore failover types in SQL Server Always On Availability Groups
September 29, 2020In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.
Read more »
Exploring AG dashboards for monitoring SQL Server Always On Availability Groups
September 11, 2020In this 21st article on SQL Server Always On Availability Group series, we will explore the AG dashboard and its various options for monitoring purposes.
Read more »
Deploy MSDTC for distributed transactions in SQL Server Always On Availability Groups
September 7, 2020In this 19th article for SQL Server Always On Availability Groups, we configure MSDTC for distributed transactions in an availability group.
Read more »