SQL Server

Recently a friend consulted the SQL Server upgrade issue, in the test environment to upgrade SQL Server R2 to SQL Server SP1, because it is in the test environment, so before the upgrade of the database server is not backed up, It is recommended

This article focuses on SQL Server 2012 cannot connect to the WMI provider (cannot connect to WMI provider) solution, the required friends can refer to the followingToday, a colleague encounters the following error when starting SQL Server 2012

13.1 Log Shipping Overview13.1.1 How log shipping worksLog shipping is a transaction log backup delivery technique. Log shipping allows you to automatically send transaction log backups from one database (the primary database on the primary server)

13.2 Deployment of log shipping13.2.1 system requirements for deployment log shippingThe deployment of SQL Server 2014 log shipping requires a hardware infrastructure that outlines these system requirements.InternetLog shipping does not necessarily

SQL Server Ring buffer--ring_buffer_security_error diagnosing security-related errorsThe ring buffer stores a large number of security error messages over a period of time that can help you analyze SQL Server security issues.For example, when you

Shenzhen team to develop a system in the North China side to push customers, in a patch, due to changes in the data dictionary, but the Shenzhen team did not give the database update script, only to the new version of the database creation script,

Theoretical background1. sql:structured Query Language is the standard language for querying and managing data for RDBMS (relational Database Management Systems).2. Understanding set theory and predicate logic, RDBMS is based on these two

Recently my two library appeared, appeared more Cxpacket waits, looked for the information on the net. One of the SQL Server columnist's articles is good, but also solves some of my doubts, translation here.Translation is used only for the purpose

Manage SQL Server on Windows Azure with SQL Manage SutudioWhen it comes to SQL creation on Windows Azure, which we've covered in our previous article, what we're going to cover today, we found that there is no SQL Server Agent option feature under

Both cast and convert in SQL Server convert an expression from one data type to another data type. Because SQL Server provides two features, it can be confusing to choose which feature should be chosen or in which case the feature should be used.

This article is reproduced from the busy CuckooHow do I connect to a database using connection objects?For the different. NET data provider, ADO. NET uses different connection objects to connect to the database. These connection objects shield us

Shanghai Microport Software Co., Ltd. Xiaoguidongfor readers: Microsoft SQL Server, advanced usersIntroduction to Meta datametadata (metadata) is most commonly defined as "structural data about data", or, more simply, "information about data", which

First, the operating environmentSystem: Windows 10Database: SQL Server 2014Database name: App new user name: AppSecond, the Operation procedure1. Open MS SQL Server Management Studio and log in as Windows authentication.2. Under Object Explorer,

Original article: http://blogs.msdn.com/ B /askjay/archive/2010/02/05/how-can-i-create-a-dump-of-sql-server.aspx You can create a memory dump of the SQL Server process space in several ways. there are using external tools that can help you

First, describe the memory used by SQL Server. The memory occupied by SQL Server is mainly composed of three parts: Data Buffer, Procedure Cache, and SQL Server engine program. The cache occupied by SQL Server engine programs is generally relatively

A pivot table is a method for analyzing data. It contains a powerful data pivot function in Excel. What is data pivoting? It may be easier to give an example. Assume there is a data table: Sales volume of books ---------------------------------------

SQLBackupAndFTP is mainly used to automatically back up the database, restore the database with one click, send the backup database log report to the mailbox, automatically compress the backed up database, and regularly execute Database Backup tasks

Test condition: one public IP address and two static IP addresses.Procedure: 　　I. Can I ping the Server IP address? Check whether the physical connection of the Remote SQL Server 2000 Server exists. If not, check and view the configuration. Make

SQL statement to query the SQL Server name and IP address, SQL Server Get Server Name: SELECT SERVERPROPERTY('MachineName')select @@SERVERNAMEselect HOST_NAME() To obtain the IP address, run the ipconfig command in xp_cmdshell: -- Enable

Example of deleting duplicate records in a data table in SQL Server, SQL Server [Project] The users table in the database contains the u_name and u_pwd fields. The u_name contains duplicate items. Now we need to delete duplicate items! [Analysis] 1.