Kč3,990

SQL Saturday Prague 2018 Pre-Con: The Best SQL Server Practices

Event Information

Share this event

Date and Time

Location

Location

Place to be defined

Praha

Czechia

View Map

Refund Policy

Refund Policy

No Refunds

Event description

Description

SQL Saturday Introduction

On December 08, 2018 we are organizing SQL Saturday Prague 2018 - a Microsoft Data Platform conference, where you can register for FREE!

If you want to gain deep knowledge in one specific topic, don't hesitate and register for one of our full day in-depth workshops held by the best experts in our data engineering industry!

So, are you ready to get cool insights from SQL Server internals to help your solutions run smoothly? Choose this one!

Pre-Con: The Best SQL Server Practices

Presenter: Data platform MVP Guy Glantser

Guy Glanster

@guy_glantser

SQL Server is an enterprise level data platform with so many components and features. As a DBA or developer, you already know how to configure, troubleshoot, design and program in SQL Server. But there are so many hidden gems and less known features that have a great impact, either on performance, availability or security.

Guy Glantser, with 20 years of experience in the field, collected 30 tips and best practices you may not be aware of, which will help you in your daily work with SQL Server.
Here are a few examples:

  • What is trace flag 3226 and why should you be using it?
  • How to troubleshoot tempdb space usage?
  • How to efficiently manage nested transactions?
  • Why you should avoid using table variables?

The topics in this session are relevant for SQL Server versions 2005 through 2016. We will also demonstrate some of the new features introduced in SQL Server 2016. At the end of the session, you'll have a long list of tips and techniques to apply in your environment.

Goals

Learn features and tips for better configuring and troubleshooting SQL Server
Learn how to avoid common mistakes when designing SQL Server databases
Learn how to write efficient and durable code in SQL Server

Agenda

  1. SQL Server Setup Best Practices
  2. Don’t Use Table Variables
  3. Don’t Use Cursors with Data
  4. Don’t Use Scalar User-Defined Functions
  5. File Sizing
  6. Choosing the Right Indexes
  7. Refactoring Opportunities
  8. Contention on Allocation Pages in tempdb
  9. The ARITHABORT Problem
  10. Cost is Always Estimated
  11. How to Read Execution Plans
  12. Query Hints and Plan Guides
  13. Parameter Sniffing Issues
  14. Parameters vs. Local Variables
  15. Simple vs. Forced Parameterization
  16. LOB Storage
  17. Monitor Query Statistics
  18. The Ascending Key Problem
  19. Delayed Durability
  20. Remove an IDENTITY Property
  21. Dynamic Stored Procedure Execution
  22. Logon Triggers
  23. Server Properties – Processors Page
  24. Managing Hierarchies
  25. Row Identifier Design Best Practices
  26. Managing Nested Transactions
  27. Update Top N Rows
  28. Transaction Log Internals
  29. Troubleshooting tempdb Space Usage
  30. How to Investigate Dropped Objects

Prerequisieties

At Least 3 Years of Experience with Database and Instance Maintenance and Administration
At Least 3 Years of Experience with Database Design
At Least 3 Years of Experience with T-SQL Programming
At Least 3 Years of Experience with SQL Server Troubleshooting

Bio

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused around data for the past 20 years, performing various roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the data community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

Find more at http://www.madeiradata.com/author/guy/


logo


SQL Saturday Prague 2018 sponsors

Share with friends

Date and Time

Location

Place to be defined

Praha

Czechia

View Map

Refund Policy

No Refunds

Save This Event

Event Saved