This article is a SQL Server Tutorial. If you want to learn how to install and start with SQL Server from 0, this is the place to start. We will teach you to install SQL Server, start your first queries, and explain the basics to start with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Quality Services (DQS), Master Data Services (MDS) and Azure and more.Read more »
In this article, we will understand how we can manage a SQL Database in CentOS 8.0. This article is the first article on the topic Manage SQL Server on CentOS.Read more »
In this article, we will answer the most common questions related to SSMS 2016 like these ones:
- What is SSMS 2016?
- How to install SSMS 2016?
- What SSMS versions exist?
- Is SSMS 2016 compatible with any SQL Server version?
- What changes were made in SSMS 2016?
- How to uninstall SSMS 2016?
The SQL Server Data Tools for Visual Studio 2015 are tools used for different purposes like:
- Working in relational database projects.
- Creating multidimensional or tabular databases in Analysis Services.
- Using Integration Service projects to import and export data.
- Building Reports in reporting services.
This article explores the database-level roles in the Azure SQL Database.Read more »
This article is for discussing fixed server roles in Azure SQL Database Server.Read more »
The 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 »
The 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 »
This article explores an alternative solution for SSDT using Azure Data Studio for both Windows and Linux SQL Server.Read more »
In this article, we will cover the most common questions about this nice SQL Server Developer Edition.Read more »
This 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 »
In 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 »
In 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 »
In 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 »
In 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 »
This article covers an overview of SQL Server logs for monitoring and troubleshooting issues in SQL Server.Read more »
This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances.Read more »
In 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 »
This article explores relationships and comparisons between SQL Server TempDB and Model databases in a unique way.Read more »
This article will explore the right way of moving integration services (SSIS) catalog SQL Database to a new instance.Read more »
This article will show how to create an Azure SQL database using Azure PowerShell.Read more »
In 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 »
In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.Read more »