Implementing Failover in MS SQL Server 2017 Standard

Implementing Failover in MS SQL Server 2017 Standard
Rate this post

Introduction

Often, we need to ensure fault tolerance of MS SQL Server DBMS, especially, when there is no Enterprise edition, but only the Standard one.

We would like to note that we are not going to examine the Express edition because there are significant restrictions to this instance. Sure, we can bypass some of them. For example, to resolve the issue with the database size of 10 GB, we can split a large database into smaller ones. To do this, we can create a new database based on a certain property, and combine the selections from the same tables of different databases in the views in the principal database. However, fault tolerance in the Express edition will be performed either by a system administrator or by using your own or third-party software.

In this article, we are going to explore all existing standard fault-tolerance technologies for MS SQL Server 2017 and an example of implementing the most suitable unified standard of fault-tolerance in the Standard edition.

Read More

Implementing a Common MS SQL Server Performance Indicator

Implementing a Common MS SQL Server Performance Indicator
Rate this post

Introduction

There is often a need to create a performance indicator that would show database activity related to the previous period or specific day. In the article titled “Implementing SQL Server Performance Indicator for Queries, Stored Procedures, and Triggers”, we provided an example of implementing this indicator.

In this article, we are going to describe another simple way to track how and how long the query execution takes, as well as how to retrieve execution plans for each time point. 

This method is especially useful in the cases when you need to generate daily reports, so you can not only automate the method but also add it to the report with minimum technical details.

In this article, we will explore an example of implementing this common performance indicator where Total Elapsed Time will serve as a metric.

Read More

Implementing Automated Database Backup and Recovery with built-in Tools

Implementing Automated Database Backup and Recovery with built-in Tools
5 (100%) 3 votes

Introduction

There are quite a lot of examples on the web for creating database backups and recoveries. We are going to provide another example of the built-in tools in MS SQL Server.

In this example, we collected several approaches, including the database integrity check before creating a backup and restore it from the previously created backup.

Read More

Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET

Sending a Query to All Databases of All Specified Servers in MS SQL Server and C#.NET
Rate this post

Often, it is necessary to send a query to all databases of all specified servers. Many DML-queries can be created with built-in tools. However, what about DDL-queries?

In this article, we are going to explore an example of implementing the application that sends a query to all databases of all specified servers, using MS SQL Server and C#.NET.

Read More

Configuring Database Mail Notifications in MS SQL Server

Configuring Database Mail Notifications in MS SQL Server
Rate this post

Introduction

Often, there is a need to somehow inform administrators about the problems with a server. Notifications are generally divided into 2 types:

1) real-time notifications, i.e. those that must come immediately when a problem occurs

2) delayed notifications, i.e. those that come after a fairly long time (more than 1 hour) after a problem occurs. Read More

Automatic Data Collection: Database Files and Logical Drives in MS SQL Server

Automatic Data Collection: Database Files and Logical Drives in MS SQL Server
Rate this post

Introduction

It is important for a database administrator to know when there is no space on a disk. Thus, it is better to automate the process in order for them not to do it manually on each server.

In this article, I am going to describe how to implement automatic daily data collection about logical drives and database files.

Read More

Automatic Data Collection of Database Schema Changes in MS SQL Server

Automatic Data Collection of Database Schema Changes in MS SQL Server
Rate this post

Introduction

Have you ever faced a situation when you need to make changes in a stored procedure or a view very quickly? I have, very often, especially at the implementation stage. Unfortunately, a version control system cannot help in this case. Still, how could I understand that something has been modified, and when?

This article describes a possible solution for automatic data collection about database schema changes in MS SQL Server. As usual, I will be glad to hear any alternative solutions.

Read More