sql server dba topics

Want to know sql server dba topics? we have a huge selection of sql server dba topics information on alibabacloud.com

SQL SERVER 2005 Database Mirroring (3)

transactions may be lost. Implementing Database Mirroring You can find basic information for implementing database mirroring in the "How to" of database mirroring topics in SQL SERVER books Online. In this part of the white Paper, we examine a special example of implementing database mirroring and best practices. Monitoring Datab

Create user roles and authorizations in SQL Server

Original: http://www.cnblogs.com/xwdreamer/archive/2012/06/25/2562828.html bibliographyHttp://database.51cto.com/art/201009/224075.htmBodyTo successfully access data in a SQL Server database, we need two aspects of authorization: Get permission to connect to the SQL Server

SQL server running SQL statement

Introduction Sp_who2 is a well known utility that shows what spids are currently executing. however the information it shows is relatively limited. for example, it only shows the type of command executing as select, delete etc, with no reference to the actual underlying SQL executing. Knowing what SQL is executing can be vital in debugging why a query is taking a long time, or determining if it is being blo

How to make SQL Server efficient-T-SQL (itput discussion summary)

constant, variable, parameter, or less data side. Implicit (automatic) data type conversion determines the conversion target based on the Type priority. If the conversion operation occurs on the large data volume side, the query will be relatively poor. Discussion post Previous topics:1. What factors do you consider when designing SQL Server objects to avoid per

Ms SQL Server 2000 administrator manual series-18. creation and use of View tables

18. Create and use a view tableView tableView table conceptsCreate a viewModify and delete a tableEnhanced viewing table functionality in SQL Server 2000SummaryIn Chapter 17th, we learned about indexes. indexes are a secondary database structure independent of the database data structure, but they are related to accessing database data. In other words, an index is an independent structure, but is integrated

Remember! 21 rules for SQL Server database development (SQL favorites)

If you are in charge of a SQL Server-based project or you have just been in touch with SQL Server, you may have to face some database performance problems, this article will provide you with some useful guidance (most of which can also be used for other DBMS ).Here, I am not going to introduce the tips for using

SQL Server Automation Operations series-about data collection (multi-server data collection and performance monitoring)

systems of the DMV .... Various log lookups .... You look at them. MySQL's powerful graphical interface hints give you a glimpse of the current database's problems.Indeed, take a look at the graphical operational interface provided by MySQLIs his Niang handsome, the overall platform for the division is very detailed: network, instance status, storage state.And there's a graphical display interface that looks elegant.The content reflected in the above interface is very convenient for finding the

SQL Server Virtualization (2)--Ideal SQL Server virtual machine architecture

, and memory management is not as good as the first one, and there may be a performance penalty.If a SQL Server virtual machine requires 16 virtual CPUs to cope with the workload. So, what is the optimization of the following configuration options? 1 Virtual Slots (16 virtual cores). 2 virtual slots, 8 virtual cores per second. 4 virtual slots, 4 virtual cores per second. 8 virtual slot

Chapter 1 Securing Your Server and Network (1): select the SQL Server Running Account and chaptersecuring

Chapter 1 Securing Your Server and Network (1): select the SQL Server Running Account and chaptersecuringSource: http://blog.csdn.net/dba_huangzj/article/details/37924127, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349 Without the consent of the author, no one shall be published in the for

First SQL Server Agent overview

Label: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 core of

Ten secrets of SQL Server experts

Over the past few years, many companies have streamlined their IT departments. Many database administrators (DBAs) have to manage a large amount of SQL Server databases. What's worse is that there is often no real DBA, but you can find someone to act as a real DBA. In addition, sometimes DBAs become fire fighters and a

Basic SQL Server connection knowledge

, you can quickly resolve the problem to a specific TCP/IP factor. On the other hand, if the same problem persists after switching to the Net Library, You can exclude the Net-Library problem. The cause may be that the server is shut down or the network infrastructure between you and the server cannot work properly. Finally, you can easily change the Net-Library used by the application without changing the a

Quickly locate and attack the SQL Server in the domain

the real environment I often find hundreds of thousands of servers. For your interest, I suggest you run this script with a domain account. Use unzip xec.exe-s-I cmd.exe "to start a LocalSystem shell and run the preceding script. I think you will be surprised at how many SQL servers can be accessed by the current domain account (I still remember how surprised I was ...). The following is an example of an attack.Attacker Cases There are many attack me

SQL Server Enterprise Platform Management Practice book notes--about how SQL Server databases are backed up

Tags: style blog http io color OS using SP strongOriginal: SQL Server Enterprise Platform Management Practice reading notes--about how SQL Server databases are backed upData backup has always been considered a database of life, that is, one of the main skills of a DBA, this

Troubleshooting SQL Server 2008 Performance (i)--Introduction

Label:Original: SQL Server 2008 Performance Troubleshooting (i)--IntroductionRemark: I spent a lot of work time translation, no plagiarism, allow reprint, but please indicate the source. Because of the length, not a post all finished, but also not so fast all translated, so according to the chapter published. Due to my limited level, translation results must be problematic, in order not to mislead, at the e

ASP database Server SQL Server

, the number of data per table is not limited, each table can define 250 indexes, one of which can be clustered index. SQL Server uses the database query language known as Transact-SQL, which is the core of the SQL Server, and Transact-

Memory misunderstanding of SQL Server

in this article .) If a DBA determines that the memory is under pressure due to the high memory usage on the database server, this person is not comprehensive enough. As mentioned above, it is natural for databases to "like" The memory. Almost all DB servers have high memory usage (unless the maximum memory is set and the maximum memory is much lower than the server

SQL Server 2008 database management system uses SQL statements to create logged-in user detailed steps

Tags:--pad permissions back Active state upd let SQL--Server role:Fixed server roles have a fixed set of permissions and apply to the entire server scope. They are dedicated to managing SQL Server and cannot change the permissions

Create an Oracle Link Server in 64-bit SQL Server

Create an Oracle Link Server in 64-bit SQL Server Sometimes we want to access data from another SQL Server database or data from other Oracle databases under one SQL Server. to complete

Configure SQL Server 2005 to allow remote connections _mssql

not discuss how to go directly to an instance of SQL Server through a TCP port. For more information about SQL Server Browser services and connecting to instances of SQL Server, see the following

Total Pages: 15 1 .... 5 6 7 8 9 .... 15 Go to: Go

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.