SQL Server

You can use different environment variables to configure SQL Server 2017 on Linux. These variables are used in two scenarios: Use the mssql-conf Setup command to configure initialization settings. Configure SQL Server in a new Docker

This series of articles from Sqlservercentral, please refer to the original text for details. SQL Server Agent is the job scheduling and alerting service for SQL Server, which can greatly simplify the workload of the DBA if used properly.The

Text: Third--Part II--the fourth article configuring SQL Server Mirroring--Non-domain environmentIn this paper, the non-domain environment to build a mirror demonstration, for the domain environment, can be referenced above: http://blog.csdn.net/dba_

Original: SQL Server 2012 exception Issue (i)--failover cluster + mirroring environment causes job execution to failFirst of all, thank you. My colleagues first found this issue, thanks: Xiangfei, Zhi-Gang, Hye-youngRecently found a strange problem

database parameterized ModeThere are two ways to parameterize a database, simple and mandatory (forced), and the default parameterization is "simple" by default.In simple mode, if the SQL is sent every time, unless it is exactly the same, it will be

Starting with SQL Server Enterprise , you can use SQL Server Audit to set up automatic auditing.In the audit node, you can create one or more audit specifications that can be used for the server audit specification and the database audit

In SQL Server, each query will find the shortest path to achieve its own goal. If the database accepts only one connection at a time, only one query is executed. Then the query is, of course, M.F.B. s to complete the work. For most databases,

15. Can the stored procedure call itself, or may there be recursive stored procedures? How many layers can SP nesting up to? Answer: Yes. Because Transact-SQL supports recursion, you can write stored procedures that can invoke yourself. Hostility

SQL Server 2016 really makes a person's eyes shine. A few days ago Microsoft provided a download of the RCO (candidate release version). I've been watching a lap RCo version, one of the most drag features is database-scoped configuration (db Scoped

master databaseRecords all system-level information for an instance of SQL Server.The master database records all system-level information for the SQL Server system. This includes instance-scoped metadata (such as login accounts), endpoints, linked

Bit integral typeThe bit data type is integral, and its value can only be 0, 1, or null. This data type is used to store data that has only two possible values, such as Yes or No, True or false, on, or off.Note: A data type that is space-saving and

The code for modifying the database SA account name is as follows: ALTER LOGIN SA DISABLE ALTER login SA with name = [Systemaccount] "Systemaccount" is the new name of SA, refresh right after execution is done Side login name to see the name of the

Ident_current returns the identity value that was last generated for any session and for a particular table in any scope. Ident_current is not subject to scope and session restrictions, but is limited to the specified table. @ @IDENTITY Returns

The traditional relational database service engine is often not the best platform for analyzing and computing ultra-large amounts of data, so SQL Server has developed an analytics service engine to analyze and calculate large amounts of data. Of

How to resolve Sql2012windows Authentication mode to mixed authentication mode ...Because SQL Server uses Windows only authentication, users cannot connect using SQL Server's logon account, such as SA. Workaround:1. Select "Use Windows

Taking advantage of the remainder of the previous article, we continue to study how to dispatch multiple packages in SSIS, does it require a package configuration scheduler? Obviously not, so let's talk about how to schedule all of the jobs in the

2YearSQL Server DBAOptimization Summary When I was a dBA for two years, I felt that some things needed to be shared and discussed with you. Book order 1. "in-depth analysis of SQL Server 2008 series" is the technical insider series of MSSQL 2005. I

Create DatabaseAnd want to summarize different types of databases scattered in different places in this new database, especially during data validation, purification and conversion, there will be great challenges. Fortunately SQL ServerIt provides

Query a stored procedure sharing of SQL Server database deadlocks. SQL Server Stored Procedure When SQL Server is used as the database application system, it cannot avoid deadlocks. When deadlocks occur, maintenance personnel or developers only use

As follows:Copy codeThe Code is as follows:"AWU", "102300", "ZX240-3", "2609997000", "2609997000", "3016924000", "", "3091775000 ","","", "QCR0000285 ","""AYE", "001800", "ZX60", "2609997000", "2609997000", "3016924000 ","","","","","", ""Although