Installation, setup and configuration

Nisarg Upadhyay
Database Mail configuration: Email with high priority and confidential

Database Mail configuration in SQL Server Express edition

January 21, 2020 by

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 »
Nisarg Upadhyay
Query SQL03 to verify the data

Configuring SQL Server Express edition as SQL witness server in Database Mirroring

January 20, 2020 by

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 »
Esat Erkec
Downloading the SQL Server 2019 Express install package

How to install SQL Server Express edition

January 16, 2020 by

What is SQL Server Express edition?

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 »
Nisarg Upadhyay
Database install script

Install and configure the AdventureWorks2016 sample database

January 9, 2020 by

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 »
Nisarg Upadhyay
SQL Server version number in ERRORLOG file

Different methods to identify the SQL Server version number

December 11, 2019 by

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 »
Marko Zivkovic
Find and start PuTTYgen

Using SSH keys to connect to a remote MySQL Server

November 28, 2019 by

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 »
Rajendra Gupta
SQL Server 2019 features

Overview of SQL Server 2019 General Availability and installation

November 19, 2019 by

Introduction

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 »