SQL Pass Beijing held the sixth offline activity. Welcome to sign up

Activity topic: Analysis of waiting events and execution plans

Location: Beijing Microsoft (China) Co., Ltd. [Wangjing Xingxing], room 316, L3

Time: June 15, 2013-

Registration URL on Office 365: https://skydrive.live.com/survey? Resid = AAB70D7F52E488C3! 1431 & authkey =! AONBLYwItGlj5dY

SQL PASS Beijing QQ group: 2435349

Sina micro group address: http://q.weibo.com/2064799 strongly recommended to join the Sina micro group, after a lot of activity announcements will first in the micro group

The full name of PASS is Professional Association for SQL Server. As an independent and non-profit-oriented Association, PASS aims to provide a platform to support mutual sharing and learning and promote exchanges between the global SQL Server community.

 

 

Course Introduction

Gao Jiwei @ shenwu xiangks
DBA
Mainly engaged in Database System Architecture Design and Implementation, performance optimization, and daily maintenance.
Understand the internal mechanism of MSSQL and be good at optimization and high availability.
Focusing on virtualization technology, we are currently building a private MSSQL cloud.

Course name: SQL Server Execution Plan Analysis and Practice
The execution plan of SQL Server is an indispensable part of statement optimization. The execution plan after the query optimizer parses and binds the lock generation is crucial to the statement performance.
This topic will explain how to read and analyze execution plans, basic operators, algorithms, understanding, application, and evaluation of execution plans. At the same time, we will also discuss some related database management and hardware content. This topic will give you a deeper understanding of the implementation plan.

Song xiaojian @ CareySon

DBA of a large state-owned enterprise, the most valuable expert of Microsoft SQL Server. SQL Server Technology enthusiasts.

Course name: what are we waiting for?-SQL Server-based Optimization

SQL Server wait is one of the most misunderstood concepts. Relying solely on scattered knowledge will often be partial and clear, and then make wrong decisions. This course will begin with the SQL Server thread model to describe the meanings, common mistakes, and possible solutions of different wait types.

 

 

PASS Introduction :

SQL pass (http://www.sqlpass.org) is a non-profit independent organization designed to share experience and technical exchange with Microsoft SQL Server. SQLPASS is a global interest group based on the us sqlpass Seattle headquarters, and actively organizes a variety of forms of communication, including the annual SQLPASS Conference (http://www.sqlpass.org/sqlrally/2012/dallas ), organize technical exchange activities in each Chapter to enhance the connection, sharing and learning between Microsoft SQL Server and the business intelligence community through knowledge sharing, it also affects the development direction of the Microsoft SQL Server data platform.