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
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
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
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
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?
Added by Deemo on Fri, 09 Aug 2019 14:58:05 +0300
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
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
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
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 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