Practical Real-World SQL Server Performance for Everyone

Are you working with SQL Servers?  Join this day 13.5 with Pinal Dave who will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization in this demo-oriented real-world storytelling session. Final seats are sold now – get yours!

Vaativuus
Arvostelut
290,00 
+ alv./VAT

Pahoittelemme mutta tiedossa ei ole seuraavia kurssipäiviä.
Ole hyvä ja ole yhteydessä myyntiin: 020 7776 670 tai myyntipalvelu@sovelto.fi

One day action-packed with SQL Server

In most of the organizations, accidental DBAs are the individuals who are often responsible for the SQL Server Performance. In the real world when we face any performance problems, we do not have the luxury to open PowerPoint and study theory. What helps us during the time of crisis are handy scripts which help us fix our performance problems. In this quick paced, demonstration-oriented learning session, we will see how we can immediately help our application with performance if we just know what exactly to do.

This demo-oriented real-world storytelling session will answer the questions which DBA and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straightforward answers, but there are some problems which are often invisible or needs attention without even a problem statement.

Our 1-day long session (13.5.2019) will be divided into the following two major components.

Section 1: Server and Database Tuning and Optimization

In this section, we will primarily focus on all the basics to advanced concepts which are related to SQL Server and Database. There are quite many tips and tricks which are extremely easy to implement but not commonly known. We will discuss each of them in great details with examples.

We will be discussing many different topics along with the following important concepts:

  • Server Configurations
  • Database Configurations for
  • Index Analysis and Optimizations
  • SQL Server Resource Wait Stats Analysis
  • SQL Server Best Practices
  • SQL Server Upgrade Path
  • What’s in Version Next?

Section 2: Query Tuning and Optimization

In this section, we will primarily focus on how to write efficient queries. Everybody knows how to read the basics of the execution plans but not everyone knows how to interpret them as an expert and how to get maximum out from them. We will learn how to write efficient and optimal queries with the help of execution plans.

We will be discussing many different topics along with the following important concepts:

  • Query Life Cycle
  • Joins and Queries
  • Functions and Queries
  • Multi CPU Queries
  • Data Types and Performance Impact
  • Advanced Execution Plans

Day End Quiz and Bring Your Own Questions

 

About Pinal Dave and sqlauthority

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4500 articles on the database technology on his blog at sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

Pinal Dave sqlauthority

 

 

 

Avainsanat: , ,

 

Paikkoja jäljellä:
Ei paikkarajoitusta
290,00  + alv./VAT

Vastuuhenkilö


Pekka Korhonen

Pekka Korhonen

Pekka Korhonen on tunnettu SQL Server-, SQL- ja Business Intelligence -tekniikoiden asiantuntija, arkkitehti, kouluttaja ja konsultti. Hänelle on kertynyt kokemusta parikymmentä vuotta. Soveltossa Pekka toimii senior-konsulttina ja partnerina. Pekka on suorittanut harvinaisen SQL Server Master -sertifikaatin, joita on maailmassa vain noin 150 kpl. Pidettyjä kursseja Pekalle on kertynyt jo yli tuhat!

SQL Server Master, Master Certified (MCSM: Data Platform), MCSE: Data Platform, MCSE: Business Intelligence, MCSA, MCTS, MCT, MCITP.