Configure SQL Server 2019 AG in Azure CentOS VM-

Preceding text Assume you have basic knowledge of Azure and SQL Server HA Assume you have basic knowledge of Azure Cli The goal is to create an availability group with three replicas on Azure Linux VM and implement listener and Fencing configuration Environmental Science SQL Server 2019 Developer on Linux Azure VM Fencing agent Azure Cli imp ...

Added by Trey395 on Wed, 29 Apr 2020 12:50:01 +0300

Using SMO to programmatically generate SQL Server table data

As a part of ETL, sometimes you need to generate the Insert script of the data, and then copy the human flesh to another place for execution. Students who are familiar with SMSS all know that there is a task of generating scripts, which can generate database create scripts, and in fact can also produce data in tables. Automatic ETL can't even e ...

Added by michalchojno on Mon, 06 Apr 2020 17:33:04 +0300

sql server writes archive generic template script to automatically delete data in batches

The blogger has written archive scripts for many projects. For the script development of deleting data, it must be the simplest delete statement at the beginning. Then, because of the large amount of data in some tables and the large number of indexes, it will be found that deleting data is very slow and affects the normal use of the system. Th ...

Added by hori76 on Sun, 06 Oct 2019 13:21:46 +0300

sql server writes scripts to solve the problem of equal-ratio series, which lasts for one month twice a day after the first day of 1 cent

I. Questions Question 1 Scene: If your future mother-in-law asks you to give her one cent on the first day, two cents on the second day and four cents on the third day, and so on, twice as much as the previous day and one month (30 days) is enough.Question: How much is it for the 30th day and how much is it altogether? Questio ...

Added by Deemo on Fri, 09 Aug 2019 14:58:05 +0300

Using Extended Events to Get Session Level Waiting Information in SQL Server and Enhancement of Session Level Waiting Information in SQL Server 2016

The source of this paper is: http://www.cnblogs.com/wy123/p/6835939.html    What is waiting Briefly explain what waiting is:When an application initiates a Session request to SQL Server, the Session request requests the required resources during execution in the database.For example, you may apply for memory resources, locks on tables, physi ...

Added by iffy on Tue, 02 Jul 2019 02:01:23 +0300

Introduction and Summary of MS SQL Batch Generation Job Script Method

When migrating or upgrading SQL Server database servers, we cannot restore msdb in many scenarios, so we have to migrate SQL Server related jobs manually. If it is time-consuming and laborious to manually generate scripts for each job, there are actually several methods in SQL Server that can generate job scripts in batches. Here are some of th ...

Added by rachybaby on Mon, 10 Jun 2019 22:26:19 +0300

Set Operations

1) Overview The following articles have been published [SqlServer Series]: [SqlServer Series] SQLSERVER Installation Tutorial  [SqlServer Series] Three Database Paradigms [SqlServer Series] Form Query [SqlServer Series] Table Connections [SqlServer Series] Subquery [SqlServer Series] Turn on Sqlserver remote access This article ...

Added by ambo on Sun, 09 Jun 2019 20:37:23 +0300

How does SQL Server Locate Custom Scalar Function Called by that SQL at Most

Recently, we encountered a very difficult problem. The monitoring system DPA found that a custom scalar function was invoked very frequently, which was beyond the scope of spectrum. Then when Troubleshooting is a problem, I do encounter some problems that make me very confused. Here is a little thought and try to solve the problem. If you have ...

Added by cybtec on Sun, 26 May 2019 22:32:46 +0300

General database role privilege handling in SQL Server

General database role privilege handling in SQL Server   Recently, we have been doing database privilege cleanup with colleagues, mainly by deleting some accounts, removing the larger privileges of some accounts, etc. For example, some have db_owner privileges, we remove the database role db_owner of the accounts and grant the minimum required ...

Added by Karpathos on Wed, 15 May 2019 18:59:55 +0300