SQL Learning Resource

Http://blog.csdn.net/wltica/article/category/1324738/1

SQL Server Overall Scenario series:

1. SQL Server Data Archiving Scheme

2. SQL Server High-availability scenarios

BLOB Data Storage Scenarios

51. Database suspect processing document

52. Database Emergency Recovery Documentation

--------------------------------------------------------------------------------------------------------------- -----------------------------

the storage engine must be aware of the series:

53. The storage engine must know-checkpoint mechanism

54. Storage engine must know--recovery interval (minutes) Recovery Interval

55. Understand the job, owner, linked server, security context

84. Deep understanding of SQL Server 2008 lock mechanism

85.SQL Server R2 Transaction and Isolation level instance explained

--------------------------------------------------------------------------------------------------------------- -----------------------------

Transact-SQL series:

CHECKSUM related functions: CHECKSUM, Checksum_agg, Binary_checksum, and Hashbytes

94. The difference between CHECKSUM and Binary_checksum

application Scenarios for CHECKSUM and Binary_checksum

the choice of checksum/binary_checksum and Hashbytes

Checksum_agg Application Scenarios

98. Hashbytes and T-SQL implementations

--------------------------------------------------------------------------------------------------------------- -----------------------------

SQL Server Test IO Performance Series:

3. SQLIO simulate random or sequential ways to test disk IO performance

4. SQLIOSim Simulation of SQL Server behavior to test IO performance

--------------------------------------------------------------------------------------------------------------- -----------------------------

SQL Server Monitoring (monitoring) Topic


SQL Server Monitoring (monitoring) Architecture


SQL Trace and SQL Server Profiler series:

Introduction to SQL Trace (SQL Trace)

Introduction to the SQL Server Performance Analyzer (Profiler)

38. Server-side tracking and collection

41. Common SQL Trace event classes

SQL Server Profiler-performance tuning

SQL Server Profiler-Identify exceptions

SQL Server Profiler-Debug Deadlock

SQL Server profiler– stored procedure debugging

46. Tracking considerations and Design


SQL Server default trace series:

7. SQL Server Default Trace--Introduction

8. SQL Server Default trace--capture event details

9. SQL SERVER default tracking app 1--Delete object events

SQL SERVER default tracking app 2-audit backup and recovery events

One . SQL SERVER Default tracking application 3--Detect DDL operations on tables

SQL SERVER default tracking app 4-Detect log file autogrow

SQL Server default trace report


SQL Server black box trace (Blackbox trace) Series:

SQL Server black Box Tracing--Introduction

SQL Server black Box Tracing--How do I enable black box tracing?

SQL Server black Box tracing--How do I configure in a production environment?

. SQL Server black box Trace--Learn more about SQLdiag

SQL Server black box Trace-- advanced


SQL Server Extended Events (Extended events) Series:

75.SQL Server Extended Events (Extended events)-Architecture

76.SQL Server Extended Events (Extended events)--extended event concept resolution

77.SQL Server Extended Events (Extended events)-Performance considerations

78.SQL Server Extended Events (Extended events)--The life of the event

79.SQL Server Extended Events (Extended events)--Introduction to the default Extended events session System_health

80.SQL Server Extended Events (Extended events)--monitoring deadlocks with system_health default trace session

How to monitor deadlocks in 81.SQL server (Deadlock)

82.SQL Server Extended Events (Extended events)--monitoring deadlocks with extended event tracking

83.SQL Server Extended Events (Extended events)--using extended event tracking to monitor deadlock script implementations

86.SQL Server Extended Events (Extended events)--Using Extended Event Trace query Statements

87.SQL Server Extended Events (Extended events)--use extended events for different target examples

88.SQL Server Extended Events (Extended events)--Converting an existing SQL trace script to an extended events session


SQL Server C2 Audit mode and Common Criteria (CC) series:

C2 and general principles audit Introduction

C2 Audit Mode (C2 audit mode)

49. Compliance with Common criteria (Common Criteria compliance)


SQL Server Audit (Audit) series:

A . SQL Server Audit (Audit)--Introduction

. SQL Server Audit (Audit)--Audit Components

• SQL Server Audit (Audit)--How to create an audit

SQL Server Audit (Audit)--Auditing and application design Architecture

SQL Server Audit (Audit)-Considerations for using auditing

• SQL Server Audit (Audit)--Create a server-level audit

SQL Server Audit (Audit)--Create a database-level audit

. SQL Server Audit (Audit)--Audit access to database objects

SQL Server Audit (Audit)-Create an audit using T-SQL to audit query operations within the database


SQL Server DDL trigger (Trigger) Series:

SQL Server DDL triggers (Trigger)--Introduction

A . SQL Server DDL trigger (Trigger)--Create a database-level DDL trigger

A . SQL Server DDL trigger (Trigger)--Create a server-level DDL trigger


SQL Server Event Notification (Notification) series:

50. Event Notification Introduction

56. Event Notification (Notification) practice


SQL Server Performance Counter Collection series:

5. Capture and store SQL Server performance counter data through DMVs

6. Collect SQL Server performance counters and create reports with SSRS

--------------------------------------------------------------------------------------------------------------- -----------------------------

SQL Server Ring Buffer series:

SQL Server Ring Buffer--Introduction

SQL Server Ring buffer--type of ring buffer for SQL Server

. SQL Server Ring Buffer--application of ring buffer CONNECTIVITY

SQL Server Ring Buffer--deep understanding of ring buffer CONNECTIVITY

ring_buffer_resource_monitor SQL Server Ring buffer--Diagnostic SQL Server memory pressure

SQL Server Ring buffer--ring buffer in AlwaysOn applications

SQL Server Ring buffer--Ring_buffer_scheduler_monitor Gets the CPU utilization of the SQL process

$ . SQL Server Ring Buffer--ring_buffer_exception trace Exception

SQL Server Ring buffer--ring_buffer_security_error diagnosing security-related errors

SQL Server Ring buffer--Ring_buffer_memory_broker diagnosing internal memory pressure

--------------------------------------------------------------------------------------------------------------- -----------------------------

SQL Server Reporting Service (SSRS) 2012 Topic


Reporting Service 2012 Introduction Series:

Reporting Service 2012 Architecture

61. Install Reporting Service

62. Configure Reporting Service

Overview of the SSRS 2012 development Environment

. SSRS 2012 report basic structure and Settings

SSRS Report Items-Table class objects

SSRS report Items--matrix

SSRS Report Items--list

SSRS Report Items-Standalone reporting unit


Reporting Service 2012 parameterized Report series:

101. SSRS 2012 parameterized reports--setting report Parameters

102. SSRS 2012 parameterized report--drop-down parameter menu

103. SSRS 2012 parameterized reports--check parameters

104. SSRS 2012 parameterized reports-cascading parameter Settings

SSRS 2012 Parameterized Reports--date parameters

106. SSRS 2012 parameterized reports--use stitching strings instead of query parameters

107. SSRS 2012 Expressions--Introduction

108. SSRS 2012 Expressions--Color Management Example

109. SSRS 2012 expression--null complement 0 example

. SSRS 2012 Built-in fields--Introduction

111. SSRS 2012 built-in fields--page numbering Example

The SSRS 2012 aggregation Function--Introduction

113. SSRS 2012 Aggregation Functions--example of interlaced color change

The SSRS 2012 aggregate Function--Specify pagination example

*. SSRS 2012 Reference Functions--Introduction


Reporting Service 2012 Interactive Report series:

The SSRS 2012 Interactive Report--Interactive sorting

117. SSRS 2012 Interactive Report--Synchronizing interactive sorting

118. SSRS 2012 Interactive Reports--single-layer document structure diagram

119. SSRS 2012 Interactive Reports--Hierarchical Document Map

More . SSRS 2012 Interactive Reports-Bookmarks

121. SSRS 2012 Interactive Reports--drill -down reports

122. SSRS 2012 Interactive Reports--parent-child reports

123. SSRS 2012 Interactive Report--drill-through report


Reporting Service 2012 Chart series:

124. SSRS 2012 Chart Type--Introduction

A . SSRS 2012 Building Charts-data, categories, and sequences

126. SSRS 2012 Chart Creation--chart Properties

127. SSRS 2012 Build Chart--chart area Properties

. SSRS 2012 Build chart-sequence properties

129. SSRS 2012 Build chart-dual-axis hybrid chart

. SSRS 2012 Build chart-sequence label Properties

131. SSRS 2012 Chart Creation--Legend Properties

2012 Build chart--axis properties

133. SSRS 2012 Build chart-axis Title properties

134. SSRS 2012 Chart Creation--title Properties

135. SSRS 2012 Chart Creation--chart micro-shaping

136. SSRS 2012 Advanced Chart Type--pie chart

137. SSRS 2012 Advanced Chart Types-pie chart micro-shaping

138. SSRS 2012 Advanced Chart types-small area sector processing

139. SSRS 2012 Advanced Chart Type-side-by-round pie chart

2012 Advanced Chart types for SSRS--bubble chart and scatter plot

141. SSRS 2012 Advanced Chart Types-Stock chart

142. SSRS 2012 Management Chart--Plato

143. SSRS 2012 Management Chart--moving average chart

144. SSRS 2012 Management Charts-Bollinger bands


Reporting Service 2012 micro-graphics, gauges and indicator series:

145. SSRS 2012 Micro-graphics-data bar

146. SSRS 2012 Micro Graphics--Sparklines

147. SSRS 2012 Instrumentation-Key performance indicators

148. SSRS 2012 meters-the structure of the instrument

149. SSRS 2012 meters--pointers

SSRS 2012 Gauges-scale

151. SSRS 2012 Gauges--range

SSRS 2012 Advanced Instrumentation Settings

153. SSRS 2012 Indicator (Indicator)

--------------------------------------------------------------------------------------------------------------- -----------------------------


Ask & Answer Series:

29. "51cto/bbs" help: How to accumulate data through the stored procedures for automatic storage ...

30. The "QQ group" uses SQL Profiler for performance impact

31. How does "51cto/bbs" use SQL statements to save (fetch) files to the database?

36. Are there any commands in the "51cto/bbs" SQL statement to clear the console display (return) data??

57. "51cto/bbs" ask: Is there a string decomposition in SQL Split function??


58. "51cto/bbs" ask: SQL has no string combination join function??

the solution that SQL Server local administrator and SA cannot access

--------------------------------------------------------------------------------------------------------------- -----------------------------

51CTO Download Series:

SQL Server e-book ebook Download list

. SQL Server Whitepaper White paper Download list

http://bbs.51cto.com/viewthread.php?tid=1132297&highlight=

SQL Learning Resource