SQL Server

Original: Chapter 1 securing Your Server and Network (7): Disable SQL Server BrowseSource: http://blog.csdn.net/dba_huangzj/article/details/38227187, Special catalogue:http://blog.csdn.net/dba_huangzj/ article/details/37906349No person shall,

Introduction Change tracking is a lightweight solution that provides an efficient change-tracking mechanism for your application. Regular, custom change tracking and read tracking data, which uses triggers, stored procedures, and user tables that

During installation, the SQL Server database engine is set to either Windows Authentication mode or SQL Server and Windows Authentication mode. After the installation is complete, you can change the authentication mode at any time. If Windows

Original address: Http://zhidao.baidu.com/link?url=Ndav32DO9zL5XnltqoqlhvKHbJv_ N3zwihhw4cwf9ffnq8hb8z7h7n3vjvfoewxzgorh1qczcvls-ojqdduxdq1, start-"All Programs-" Microsoft Visual Studio r2--Configuration Tool--"SQL Server Configuration Manager2.

--Open Ole Automation proceduressp_configure'Show advanced Options',1;GORECONFIGURE;GOsp_configure'Ole Automation Procedures',1;GORECONFIGURE;GOEXECsp_configure'Ole Automation Procedures';GO--Close Ole Automation proceduressp_configure'Show advanced

Getting Started with SQL Server replication (i) Introduction to----replicationIntroductionReplication in SQL Server (Replication) is one of the core features of SQL Server high availability, which in my view is not just a technology, but a

Exception Description:System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section system.servicemodel.

SQL Server Extended events (Extended events)-Performance considerationsWhen you use the CREATE event session to place extended event sessions together, you need to carefully configure some settings as they may inadvertently affect performance. You

CREATE event SESSION [test] on SERVER ADD EVENT sqlserver.sql_statement_completed (SET collect_statement= (1) ACTION (sq Lserver.client_app_name, Sqlserver.client_hostname, sqlserver.database_id, Sqlserver.database_name, Sqlserver.sql_

Original: SQL Server Tuning Series Basics (Index operations Summary)ObjectivePrevious articles we introduced how to view the query plan, the introduction of common operators, the way of parallel operations, interested can click to view.This article

　　SQL Server is a sensitive repository for organizations, and managers need to ensure that only authorized users can access this sensitive information. However, it is not easy to make SQL Server configuration secure without generating an error, and

The database is installed and the connection string is required for use in the program. How to write it? Take SQL Server R2 as an example.1, after installing SQL Server R2, similar to Oracle's Plsql tool. SQL Server R2 also has tools, that is, SQL

I've been very busy lately and haven't written a blog for a long time. Today, let's explain how to import Excel data into Excel in C #, and at the end of the article, how to import data using SQL Server and MySQL tools.The import process is broadly

The following issues were encountered:On-line Server A, brokered server B, local server CThe data is above a and wants to operate on a B like select * FROM [a]. [database].table Such SQL, do not have to link the server, directly import the

A common performance counter for SQL Server servers, in this flag. Performance object Counter Description Processor %processor time%privileged time Recommended value: lasts less than 80Recommended

In the initial SQL Server performance issue (2/4), we discussed the list of waiting resources or running session scripts. In this article we will look at how to list blocked sessions with specific information.1 /**************************************

Processing of date and time data.(1) String date' 20080301 ', which is a string date, but must be guaranteed as a four-bit year, two-bit month, and two-bit date. For example, the Query order table date is greater than ' 20080301 '. It can be written

Original: SQL Server 2012 AlwaysOn--a problem caused by a hardware upgrade This is a case of last week: The problem caused by the upgrade of the existing hardware, but also triggered a more serious bug, is disastrous, but fortunately, in a

SQL Server database management common SQL and T-SQL statements 1. view the database version Select @ version 2. view the operating system parameters of the machine where the database is located Exec master .. xp_msver 3. view database startup

4 methods for backing up databases from SQL Server and 4 methods for SQL Server 1. SQL server maintenance plan Here I will not explain it. This is relatively simple. It is nothing more than dragging two 'backup database' tasks and one 'clear