sql server auditing best practices

I recently saw a small example of SQL Server, and found that it can be used as an introductory question for SQL server. The questions are as follows: For example, there is a Contract Table Contract Id Name Total buget 1 contract name 100 2 contract name 2 300,102, 22, 3 Contract name 3 200,103, 23, Requirement: use an

First, backgroundPreviously wrote an article about backup: SQL Server maintenance plan to implement database backup, the above article using full backup and differential backup basically can solve the problem of database backup, but in order to protect the data more secure, we need to perfect our backup plan again;The following article mainly joins the log backup, and the design of the frequency of backup a

Label: [Top] SQL Server more than 2008 error-handling Database recovery Method--Log tail backup Category: Database management logs Best Practices FAQ Backup Restore misoperation Integrity SQL Server Databases Enterprise Management DBA security 2013-01-10 20:48 34970 people

. Practice shows that a reasonable index design is based on the analysis and prediction of various queries. Only by correctly combining the index with the program can the best optimization solution be produced. This article analyzes and practices the performance of SQL Server indexes. I. Use of clustered Indexes A clustered index sorts the actual data on a disk

accelerate the Data Query Process. However, indexing does not always improve the system performance. In addition, deletion, and modification operations, the existence of indexes increases the workload. Therefore, adding appropriate indexes at the right place and deleting sub-optimal indexes from unreasonable places will help optimize SQL Server applications with poor performance. Practice shows that a reas

　　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 as a DBA we have to perform a series of additional steps to harden our

StatementINSERT into dbo. Orders (OrderID, OrderDate, Empid, CustID) EXEC@country='France ';SELECT into statementSELECT OrderID, OrderDate, Empid, CustID into dbo. Orders from TSQLFundamentals2008.Sales.Orders;The SELECT into statement copies the underlying structure of the source table (including column names, data types, whether null and identity attributes are allowed), and data. Constraints, indexes, and triggers are not copied from the source table.BULK INSERT statementBULK INSERTDbo.

, external fragments exist.AVG. bytes free per page-average number of available bytes per page:The average number of available bytes on the scanned page. The higher the description, the more internal fragments are. But before you use this number to determine whether there are internal fragments, consider the fill factor ).AVG. Page density (full)-average page density (complete ):The opposite of the percentage of available bytes on each page. A low percentage indicates that internal fragments exi

This second article, starting from 0, builds SQL Server AlwaysOn, which focuses on how to build a failover cluster because AlwaysOn is a Windows-based failover clusterBefore you explain the steps, you need to understand the failover cluster quorum configurationThe following image is from the Windows Server2012 System Configuration GuideQuorum configuration for four clusters:1, most nodes: This configuration

modification operations, the existence of indexes increases the workload. Therefore, adding appropriate indexes at the right place and deleting sub-optimal indexes from unreasonable places will help optimize SQL server applications with poor performance. The practice shows that a reasonable index design is based on the analysis and prediction of various queries.ProgramIn combination, the best optimization

performance. In addition, deletion, and modification operations, the existence of indexes increases the workload. Therefore, adding appropriate indexes at the right place and deleting sub-optimal indexes from unreasonable places will help optimize SQL server applications with poor performance. The practice shows that a reasonable index design is based on the analysis and prediction of various queries.Progr

In the design of database application, we often need to get the total number of records of some tables, to determine whether the total number of records in the table is too large, the need to back up data and so on. Our usual practice is to select COUNT (*) as C from TableA. However, these practices can be time-consuming for a large number of records. Experimenting on the Dell 4400 server, the MS

So far, we have finally completed the SQL Server video and PPT review. Looking back on the long video path over the past 10 days, I always thought that the more things I talked about later, the more I thought, the more I rushed down. Of course, the 40 sets of videos have gained a lot. I have a more detailed understanding of SQL

recommendations and commonly used recommendation algorithm. About this competition, I think of two points, one is big data, the other is recommended, for granted, I think of Mahout. Carefully understand that Mahout has integrated a lot of recommended algorithms for distributed implementations such as USERCF, ITEMCF, Slopeone and so on.Then the first step is to configure the mahout environment, my environment is such, the virtual machine in the Hadoop, window under the Cygwin, there are myeclips

Original: SQL Server log file large shrinkage method (measured and useful)These two commands are executed consecutively, with less time and more apparent (multiple runs) until the effect is reached-- truncate BACKUP LOG to DISK = ' NUL ' -- Shrinkage DBCC Shrinkfile ('cloudmonitor_log')You can use regular regular backup logs (such as once an hour) to prevent the log file from growing indefinitely.The large

SQL Server Performance Optimization (1) Database Design Can you refer to the recent forum on the emergence of an excellent post http://topic.csdn.net/u/20100415/10/a377d835-acbd-4815-8bcb-b367f88ac8b5.html? 92227Database design includes physical design and logical design:Physical DesignYou can use the raid hardware architecture.To put it simply, the usage policy is as follows:A. raid0 can be used in a read

server|sqlserver| data February wrote a SQL Server optimization method for massive queries http://blog.csdn.net/great_domino/archive/2005/02/01/275839.aspx Recently, some colleagues have encountered SQL Server statistics millions above the number of record bar too slow prob

SQL Server in the eyes of programmers-what does non-clustered index bring to us ?,Zookeeper I will not talk about some database concepts, so I can only use some practices to understand the meaning of these concepts. The use cases in the following application scenarios are virtualized and used only for personal research. Programmers should be curious, though this

Tags: des style blog color using OS io fileI used to interview a DBA, "Why is tempdb faster than other databases?" So that more than 95% of the candidates have a blank face. tempdb, as an important feature of SQL Server, has long been familiar and unfamiliar to it. Familiarity is that we are always in use, unfamiliar may be very few people pay attention to its operating mechanism. This time I will introduce

recommendations and commonly used recommendation algorithm. About this competition, I think of two points, one is big data, the other is recommended, for granted, I think of Mahout. Carefully understand that Mahout has integrated a lot of recommended algorithms for distributed implementations such as USERCF, ITEMCF, Slopeone and so on.Then the first step is to configure the mahout environment, my environment is such, the virtual machine in the Hadoop, window under the Cygwin, there are myeclips