sql server hardening

Original: SQL Server 2012:SQL Server architecture--The life cycle of a query (part 2nd)Planning cache (Plan caches)If SQL Server has found a good way to execute a piece of code, it should be reused as a subsequent request because

Label:Sqlserver2005 occurs when a subscription is copied:　　"Microsoft SQL Server cannot access these components because replication components are not installed on this instance of SQL Server, see SQL Servers ..."Workaround: 　　 Due to the need to configure a publication subs

Introduction to the outsetJanuary 1, 2015, the beginning of the new year, should have done some meaningful things to cross the years. As a result, the old habit-to go to bed before going to toss a computer, say dry, to new to the DELL computer installed virtual machine, download SQL Server 2014, install SQL Server 2014

High-version SQL server data backup is restored to low-version SQL Server Data Backup Recently encountered a problem: If you want to restore the data backed up by Sqlserver in a later version to an earlier version of SqlServer, you cannot restore the database directly in SqlServer. Therefore, after a series of question

August 6, 2017 21:12 minutes, today is the third week of my 10 blog plan! Today I finished a big event, I think years later, this thing will make me proud and proud, specific I do not want to say here, cut a few pictures to understand the peopleToday I would like to share about the SQL Server database installation and uninstallation steps, online about this kind of diagram is also more, here I only accordin

SQL Server database email, SQL Server database The mail sending function provided by SQLserver allows you to easily send information in the database to relevant personnel. For example, you can send the warning information to the management personnel in conjunction with the monitoring event, and send a report to the rel

As SQL Server 2008 gets more and more into the spotlight, there's a growing number of voices saying that SQL Server 2008 (Kaitmai) is just a patch pack for SQL Server 2005. That's what I thought, too, because we put too much atten

Misunderstanding #13. DMV cannot be used in SQL Server 2000 compatibility mode Error There are many misunderstandings about the compatibility mode. Does the database in the compatible mode of 80 mean that it can be attached or restored to the SQL Server 2000 database? Of course not. It just means some T-

Misunderstanding #13. The DMV cannot be used in SQL Server 2000 compatibility mode Error There has been a lot of misunderstanding about compatibility mode. Does the 80 compatibility mode database imply the ability to attach or recover to a SQL Server 2000 database? Of course not. This simply means some T-

Today in order to experience the new SQL Server 2005 features, the heart of the local SQL Server 2000 killed, installed a SQL Server 2005, experience a lot of new features, then suddenly think of some of the DTS improvement work i

SQL Server transaction operation Isolation Mode introduction, SQL Server In general, it is recommended that SQL Server isolate transaction operations in the default form. After all, isolation is one of the basic principles of the

How to send HTML-format mails in SQL Server, SQL Server SQL server sends an html-format email. The reference code is as follows: DECLARE @ tableHTML NVARCHAR (MAX); -- get the current system time and data statistics time set @ d_n