SQL Server

Original: SQL Server audit feature Getting Started: CDC (change Data Capture)IntroductionSQL Server 2008 introduces CDC (Change Data Capture), which can record:1. What data lines have changed2. The history of data row changes, not just the final

First, you need to install Microsoft OLE DB Provider for DB2: Http://download.microsoft.com/download/B/B/2/BB22098A-C071-415F-9269-2EB26CEFB562/DB2OLEDB_CN.exeAfter installation, the menu has one more item:Next, run the data Access tool to configure

SQL ServerAudit (Audit)--to create a server-level audit Task 1: Create an audit Step 1 : open SSMs, log on to the specified instance, expand the "Security", "audits" node.Step 2 : on the audits node, right-select the "New Audit ..." option.Step 3 :

SQL Server Performance Counter schema Introduction to Windows Performance counters The operating system can use the Performance Monitor graphical tool to measure performance information for systems, applications, services, and drivers.

First, what is log shipping?The principle is simple, three action six words: Copy------Restore with backup.If a person completes this three action, it can only be called a log porter, and the SQL Server job automatically completes, called log

1 /**2 * Calculate the difference of two time, the number of days, years, months, minutes, number of seconds3 * 4 * @paramDatetype The type of difference between two times to get, for example, the number of days to get a two time difference? or

Ext.: http://blog.csdn.net/jackychu/article/details/4183118Http://www.cnblogs.com/jhxk/articles/1633578.htmlMany developers in the database design often do not have much to consider char, varchar type, some do not pay attention to, because the

The lock partitioning technique allows SQL Server to better handle concurrency scenarios, but it can also have a negative impact, as described in this example, to analyze the deadlock situation caused by lock partitioning.Previous Time Park friends @

In development and enterprise applications, several versions of SQL Server are linked to each other. Distributed reading and storage requires implementation of sp_addlinkedserver. SQL Server, SQL Server 2012, and SQL Server 2014:But today in the

Status: Install SQL SERVER 2008 earlier, check Normal, and then install VS2010 and VS2012. Yesterday, copying the data on the server to the local test, the results found that can be connected to remote, unable to open the local real example.First

Description:Install SQL SERVER 2012, install TFS 2013, configure TFS, roll up your sleeves, get ready to gosteps:1. Open Hyper-V Manager, refer to [Hyper-V] to create a new virtual machine using the operating system template, first complete the

A network-related or instance-specific error occurred while establishing a connection to SQL Server. Server _mssql2008_ script Home not found or unreachableHttp://www.jb51.net/article/59352.htm A network-related or instance-specific error occurred

Remote procedure call failed in SQL Server 2008 Administration Tool 0X800706BE Solution-MSSQL-Cube Network-Computer knowledge and technology interactive exchange platformHttp://www.it165.net/database/html/201305/3884.htmlWorkaroundThis issue occurs

Due to work needs, long time not installed SQL Server2005, today installed a bit, hereby write down the installation steps to leave notes.Preparation before installation:Install IIS first, and then install SQL Server2005First, installationClick

This problem was encountered by many people on the Internet. A netizen appeared in the morning and searched for it, Google has been around for a long time, and many solutions won't work, This error may occur in many cases. The answer is as

During the work period, the problem of exporting and importing data between databases of different versions is often involved. Simply sort it out and compare the performance. You are welcome to discuss and supplement some methods that are missing.

No nonsense.CodeThe comment is very detailed. It is certainly okay to understand it! Declare @ date datetimeSet @ date = getdate ()-The previous day, the previous day of the given dateSelect dateadd (day,-1, @ date) as 'previous Day'-The next day,

I have read it in detail before, but when I look back today, I find that I forgot about it. It is a tragedy. It seems that it is better to record it. SQL Server zone management (GAM, SGAM) We all know that the smallest unit of data file storage

Database Administrators familiar with SQL server 2000 know that DTS can import and export data. In fact, we can also use Transact-SQL statements to import and export data. In a Transact-SQL statement, we mainly use the OpenDataSource function and

Graphic tutorial on restoring database backup in SQL server 2000, MySQL Database Backup MSSQL is a database management system of Microsoft. This document describes the backup and restoration functions of databases in MSSQL2000. 1. Ensure that your