In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.
Read more »
In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
Read more »
In this article, I am going to explain how we can install SQL Server 2012 express edition using the SQL Server installation center. Additionally, I will also explain how we can use the SQL Server installation configuration file to perform an unattended (silent) installation. First, download the SQL Server express edition from this location. Once the installation file is downloaded, let us begin the installation process.
Read more »
SQL Server Log shipping provides a DR (disaster recovery) solution for the SQL Server databases and it can be configured at the database level. In a specific time-gap, SQL Server Transaction Log backup will be taken and copied to the destination site and will be restored. This complete activity or solution will be done by SQL Server job and each step is configured by the user. The learner may confront the difficulties in a couple of steps or while troubleshooting but for the experienced user, it is too easy to set up and handle the SQL Server log shipping set up errors.
Read more »
In this article, I am going to explain step by step process to perform Database Mail configuration in SQL Server Express edition using the T-SQL script. As we know, SQL Server Express edition does not provide the SQL Server Agent Services; hence we cannot perform Database Mail configuration or SQL Jobs or maintenance plans using SQL Server Management Studio. To configure the Database Mail feature in the SQL Server Express edition, we must use CLR integration or using stored procedures within the MSDB database.
Read more »
In this article, I am going to explain how we can use the SQL Server Express edition for the SQL witness server of the database mirroring setup. Database mirroring is a cost-effective and easy to configure high availability solution. Unfortunately, this feature has been deprecated, but still, some organizations use database mirroring as a high availability solution.
Read more »
In this article, I am going to explain how to install the SQL Server Express edition. We will download the SQL Server 2017 Express edition and perform the custom installation. Before we dive-in into the installation and configuration process, let me introduce you to the SQL Server Express edition.
Read more »
SQL Express is a free and feature-limited edition of SQL Server that has been being published since the SQL Server 2005 version and it still continues to be published by Microsoft. Nowadays, Microsoft has released the Express edition of SQL Server 2019. We can use this edition for lightweight data-driven mobile, desktop or web applications. However, when we decide to use this edition, the supported features have to be checked in the Editions and supported features of SQL Server 2019. For example, the database size can not exceed 10 GB and the SQL Server Agent feature is not supported by the Express editions. As a result, we must take the limited features into consideration before planning to use the SQL Express Editions.
Read more »
This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.
Read more »
This article explains the process of installing the AdventureWorks2016 and AdventureWorksDW2016 sample database on a stand-alone instance of SQL Server and Azure SQL Server. The sample databases were published by Microsoft to demonstrate how to design a database using SQL Server. Microsoft has also published another lightweight database named AdventureworksLT, which can be used as a sample database on Azure SQL Server.
Read more »
This article explains how we can fix SQL Server error “Agent XPs Disabled”. Before we dive into troubleshooting and methods for fixing the error, let me explain about Microsoft SQL Server Agent and the Agent XPs configuration parameter.
Read more »
In this article, I am going to show different methods to identify the SQL Server version number and its edition. Also, I have included the list of known SQL Server version numbers, Service Packs (SP), and Cumulative Updates (CU of MS SQL Server 2019, 2017). I have not included the hotfixes and CUs of SQL Server 2008 R2 and earlier versions.
Read more »
In this article, it will be described how to connect to remote MySQL Server on Linux OS using SSH key pairs. Windows OS will be used as a host from which will be established a connection using PuTTY as a client. Besides using PuTTY as a client for establishing the connection to remote machines, it will be used to generate and use secure shell – SSH keys as well.
Read more »
On November 4th, 2019, during the Ignite conference at Orlando, Microsoft released the General Availability of its flagship product Microsoft SQL Server 2019. SQL 2019 provides various enhancements to its core database engine and offers integration with Big data (Apache Spark, Data Lake), Machine learning, Linux/container compatibility with Kubernetes.
Read more »
This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.
Read more »
In this article, we will explore how to find the SQL Server version details with various methods.
Read more »
This article gives an overview of SQL Server Alias and its usage for connecting with SQL Server.
Read more »
This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »
This article gives an overview of Instant File Initialization and its benefits for SQL Server database creation, restoration and file growth.
Read more »
In this article, we will review different ways to start SQL Server in single user mode.
Many DBA’s might have a situation like restoring a master database or other system databases from the backup that needs SQL Server to be started in single user mode. There are different ways to start SQL Server single user mode. Let us discuss them one by one.
Read more »
This article gives an overview of different editions in SQL Server and also explains the process to upgrade SQL Server editions.
Read more »
Database administrators should be aware of the internal SQL Server processes such as the dirty pages, SQL Server CHECKPOINT, Lazy writer process. This is a very common question that you might come across in SQL DBA technical interviews as well on all levels such as beginner, intermediate and expert level.
Read more »
Replication is a process to manage multiple copies of the same data at a different node. Microsoft SQL Server supports Merge Replication, Transaction Replication, Peer to Peer Replication and Snapshot Replication.
Read more »
This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server
Read more »
A couple of years ago, Microsoft announced that SQL Server would be available on Open Source (Linux). In this article, we will go through the installation of Microsoft SQL Server on Linux (Ubuntu) and each step in detail.
Read more »© 2020 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
