SQL Server

The interconnection of different database platform is commonly called the heterogeneous service of the database, now each big database can realize such heterogeneous interconnection, but the specific implementation technology of each vendor is not

When a user database is available and TDE is enabled, encryption is implemented at the page level when it is written to disk. Decrypts when the data page is read into memory. If a database file or database backup is stolen, the original certificate

Generally speaking, there are two ways to connect SQL Server, one is to take advantage of SQL Server's own client tools, such as Enterprise Manager, Query Analyzer, transaction Profiler, and so on, the second is to use the user's own development of

The "IT168 Technology" cursor (cursor) is a data buffer that is opened by the system to the user and holds the execution result of the SQL statement. Each cursor area has a name. The user can use SQL statements to retrieve records from the cursor

The following are only references, and may be slightly different if there are multiple instances: This environment is SQL Server Standard version 64-bit and SQL Server 2008 Standard version 64-bit dual instances installed simultaneously in a On

server|sqlserver| Triggers | creating The following describes how to create triggers using SQL Server Administration Tools Enterprise Manager and Transaction_sql in MS SQL Server.You must consider the following aspects before creating triggers:The

Establishing a connection through a tool We've all established the connection by command, and now we will use the connection designer provided by Visual FoxPro to establish the connection. As we mentioned above, there are two types of connection

Install SQL Server 2008 in one virtual machine, then copy the virtual machine file one out, then revert to another virtual machine, so that you can use 2 virtual machines for replication experiments. To do database replication experiments on SQL

I. OverviewThe simple recovery model and the bulk recovery model are described earlier, and this article continues to write backup and restore under the full recovery model. The biggest advantage in the full recovery model is that as long as the

(excerpt from) http://jxlearnew.blog.163.com/blog/static/549786592007102451431413/ Here is a method of using Delphi to achieve dynamic registration, I hope to help you. Here we directly use the SQLConfigDataSource function provided in ODBCCP32.DLL,

Source: Configuring Resource Governor for SQL Server 2008 for load BalancingTransferred from: http://www.ithov.com/server/93267.shtml1. Why the introduction of "Resource Governor"?　　Prior to SQL Server 2008, the database engine tried to provide

1. Deadlock PrincipleAccording to the definition in the operating system: A deadlock is a permanent wait state in which each process in a set of processes occupies a resource that is not freed, but is placed in a form that is not freed by other

The collation of SQL Server is roughly divided into Windows collation and SQL Servers collation. When the data is installed, defaults to Sql_latin1_general_cp1_ci_ai are not set by default. When the database is created, if you do not set a collation

Records reprinted from: Http://www.cnblogs.com/suruozhong/p/5974595.htmlall data for today: SELECT * FROM table name where DateDiff (dd,datetime Type field, GETDATE ()) =0 all data for yesterday: SELECT * from table name where DateDiff (DD, DateTime

Original: SQL Drip 38-sql Server 2008 and SQL Server R2 options for exporting data are slightly differentDescriptionpreviously, to export data from a table as a script, only with stored procedures. A new feature is now added in SQL Server 2008,

As a database administrator the most painful is that when the database is down to need to find a backup, but at this time suddenly found that the backup file is also bad, which means that the data will be lost, this may lose the position, the job is

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 in a project, the database for the project was Microsoft's SQL Server, the database was installed on a different Windows servers, and the project was deployed on Ubuntu server. So how do you link SQL Server to your project on Linux? Here I

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 purpose of disseminating information. I started learning

After the installation is complete, how can I retrieve the serial number of the SQL Server instance during installation? When you need to install SQL Server again, if the serial number cannot be found, you can try to retrieve the serial number from