sql server dba introduction

principles and considerations. Principle: The SQL Server service inherits the permissions of the Windows account on the underlying operating system (that is, Windows OS). It does not necessarily require administrator privileges on the machine.It is only necessary to have permissions on the data file/transaction log file, the error log file, the folder where the backup file resides, and a small amount of sy

applications, data validation addresses, and database lock Publishing. This article is intended for the following professionals: 1. network application developers dealing with databases 2. Security experts with audit responsibilities for network applications. [Introduction] Structured Query Language (SQL) is a structured language used in combination with related databases. there are many types of

This article belongs to the managing SQL Server AlwaysOn series articleObjective:The previous series has covered SQL Server AlwaysOn knowledge points, installation demos, and considerations. But this is not the end, but more is the starting point. It's like you can't give birth to a child, you have to keep it (manageme

Brief introduction The nature of the SQL statement we write is simply the logic to get the data, not the physical path to get the data. When we write SQL statements to SQL Server, Query Analyzer parses statements sequentially (Parse), bindings (BIND), Query optimizations (o

ignored, and SQL Server 2000 is automatically assigned a value. If the data file does not contain values for computed columns or timestamp columns in the table, the available format files specify that computed columns and timestamp columns in the table should be skipped when the data is imported; SQL Server will autom

, including me, will encounter the same thing during his or her development process. I know why this happens, and I know how to overcome it. II. Scope of reading Note that the main focus of this series of articles is "optimizing the performance of transactional SQL Server database data access", but most optimization technologies are also applicable to other databases. The optimization technology I will disc

Myth #1: After a server failover, a running transaction continues to execute Of course it's wrong! Each failover is accompanied by some form of recovery. However, if a connection is disconnected because of a server or instance crash that occurs when a transaction is not being executed, SQL Server has no way to re-e

Myth #1: After a server failover, a running transaction continues to execute Of course it's wrong! Each failover is accompanied by some form of recovery. However, if a connection is disconnected because of a server or instance crash that occurs when a transaction is not being executed, SQL Server has no way to re-est

function can beView, the trigger doesn't have a small lock iconOther featuresThe show DDL script shows the object's creation script, and decrypt In-place I won't say it.Note that the following interface is the interface in the Dbforge SQL decryptor tool, not the interface in SSMs, although the interface of this tool is much like the SQL2012 SSMs interfaceSummarizeOnce the DBA has this tool, it is not afrai

Introduction: SQL Server and Microsoft Access are both Microsoft products. The former is used for medium-sized enterprise applications, and the latter is representative of small databases, which is easy for beginners to master. When developing general information systems, especially the standalone version, most of them use access. Although

finished, close the window, pop-up prompts need to restart the program to complete the update, click "Yes". After the program restarts. When the environment is ready, start to get to the topic transplant database. Establishment of a repository (migration Repository) One, connect to Oracle In the connection window to the left of the program, click the Plus button to add a DBA connection to the Oracle database, such as: After the configuration is comp

complexity. So it needs to be considered carefully.Transaction log: This section also has a separate introduction, where only the introduction, all SQL Server databases, all recovery models, there is at least one transaction log file. Although there is a special article in the following, but here to take pains to re

database to a compressed database by restoring or restoring a database backup using a T-SQL. The following is a test I conducted, which is compressed by about 50%. The operation interface is as follows: After a data test, it took six minutes to insert 1000000 of the data and enable the compressed database. The database that didn't enable the compression did not even run for six minutes. It may be because my Io is not good enough, using