sql server dba introduction

Many developers want to be a DBA, and a lot of people start by positioning themselves as a dba,dba. What kind of knowledge and skills do you need to know? Here's myWhile doing DBA work and interviewing DBAs, some of the 30 DBA issues that have been collated, as well as the s

Why does the SQL Server DBA learn PowerShell? From: http://www.simple-talk.com/ SQL /database-administration/why-this-sql-server-dba-is-learning-powershell/ Joe. TJ is used only for the

| RESUME | SAFETY {Full | OFF} | SUSPEND | TIMEOUT integer } WITNESS {= ' witness_server '}| OFF} Service Broker option (Service Broker options) Enable_broker | Disable_broker New_broker Error_broker_conversations Change tracking options (Tracking option) change_tracking {= on [ Database encryption option (encryption options) Encryption {ON | OFF} Snapshot isolation option (Snapshot isolation options) allow_

Tags: organize return index blog SQL Server point ref href 64 bitOriginal link: http://www.cnblogs.com/fygh/p/3288701.htmlFrom the initial release of SQL Server DBA Eve asked for more than a year, you have some of the issues discussed more intense, to answer these questions

Many developers want to be a DBA, and many people first position themselves as a DBA. What knowledge and skills do DBAs need to master? Below are my During DBA work and interviews with DBAs, there were thirty questions about DBAs. Among the thirty questions, there were many minor questions, covering the skills of SQL

Many developers want to become a database training, and many people first position themselves as a DBA. What knowledge and skills does DBA need to master? Below are myDuring DBA work and interviews, there were thirty questions about DBAs and many minor questions about the thirty major questions, it covers many technical knowledge points of

a diagram of the MySQL database structure:MySQL database in the storage engine part of the implementation of pluggable design (pluggable Storage Engines), you can choose different types of storage engine implementation according to the requirements. Feature InnoDB MyISAM Memory Storage Limits 64TB 256TB Ram Transactions Yes No No Locking Granularity Row Table

Tags: structure resource partition table cannot dba resolves emergency temp SQL1. Talk about the difference between clustered index, nonclustered index, hash index and their merits and demerits, include covering index's function, relative to the advantage of composite index; 2. What is the structure of the log file, what is the difference between the data written to the log file and the data file, the reason why the log file cannot be shrunk, what the

concerned about those indicators (including SQL Server and Windows), how to develop performance baselines, which monitoring software you have used;26. Database migration steps; rebuild a larger set of test systems (minimum of 10 db instances), if the original DB data volume is not large, but DB is more, the new system data are not needed, how to quickly achieve;27. Create cluster brief steps, require a min

10 errors that SQL Server DBA can easily commitTranslated from: http://sqlsentry.tv/top-10-administrative-mistakes-on-sql-server/In addition to the top ten mistakes, other top-ranked errorsAside from SQL

a lot of time, and the speed is slow 2. MASTER: it contains a system table set, which is the central repository of the entire instance. It maintains logon accounts, other databases, file distribution, system configuration settings, disk space, resource consumption, endpoints, andLink to the server. It records sql2005 initialization information, so it is extremely important to the instance. In the process of creating, modifying, or deleting a user dat

The only reason for backupThe only reason for the backup is that we can restore when I first became a SQL Server database administrator, as long as the backup work can run successfully, I feel that everything is fine. I'll look at the SQL Server Agent to make sure those jobs are running, and that's it.I think as long a

Map location.If you want to query the definition of a catalog view, you can use the Object_definition function or sp_helptext to query.SELECT object_definition (object_id('sys.tables'));EXEC ' sys.tables ' ; EXEC ' sys.tables ';There are some other ways to access SQL Server metadata information: Information Architecture view (information schema views) Systems functions (System Functions) s

TechTarget Reporter was fortunate enough to interview SQL Server consultant and popular blogger, Denny Cherry, in June. He talked about three things that SQL Server DBA needs to know, and describes the trends in SQL

to remove the space on both sides!) nvarchar (n): A variable-length Unicode character data that contains n characters. The value of n must be between 1 and 4,000. You can store up to 4,000 characters, both English and Chinese, in 2 characters. varchar: If the possible value of a field is not fixed length, we only know it cannot exceed 10 characters, it is the most advantageous to define it as varchar (10). Stores variable-length data, so it does not fill with spaces, but storage efficiency i

This PPT is the course I shared at the MVP OPEN Day comunity camp. I chose this theme because a lot of people have asked this question, and there are few related topics, so I would like to share my relevant experience so that we can refer to it.In the process of summarizing PPT, I am grateful to my DBA colleague who has shared my personal experience, and I am grateful to the Microsoft China MVP team for inviting me to share relevant experience.PPT can

the view to the underlying base table. If the SELECT statement in the view definition specifies a GROUP by clause, the key for a unique clustered index can only refer to the column specified in the GROUP by clause. The SELECT statement in the view cannot contain the following Transact-SQL syntax elements:The select list cannot specify columns using the * or table_name.* syntax. You must explicitly give the dequeue name 在创建索引视图的select语句中，不能存在重复的列名 A v

A few days ago I saw an article titled "SQL Server DBA thirty questions", which is very good and pertinent. These questions can be answered only after some operation experience is required. Many of these questions can be found through books online. I am also very interested in some questions because I have also handled similar problems, so I was very impressed. N

Label:In a Microsoft SQL Server 2008 system, the database administrator, or DBA, is the most important role in the administration. The DBA's goal is to ensure that the Microsoft SQL Server 2008 system runs properly and efficiently. The DBA's work is also the busiest job, whe

As SQL Server DBA, we often complain that Microsoft's own tools are not good, but can be used to open the box is very rare. The following three separate GUI tools are included in SQL Server 2012 for use by SQL