Speaker

Peter Kruis

Peter Kruis

SQL Server Consultant

Middelharnis, The Netherlands

Working and learning in SQL Server.

Area of Expertise

  • Information & Communications Technology

Topics

  • MSSQL
  • performance tuning
  • SQL
  • Microsoft SQL Server
  • SQL Server DBA
  • T-SQL
  • Database
  • Databases
  • Database Administration
  • SQL Server
  • DBA
  • Query
  • Query Tuning

An introduction to Extended Events

Are you ready to dive into the awesome world of MSSQL Extended Events! In this presentation, we'll explore this great feature in Microsoft SQL Server that helps you monitor and troubleshoot database performance.

We'll start by understanding what Extended Events are and when they come to the rescue. You'll learn how to set them up step-by-step, customizing them to capture the data you need and show you how to look into the results.

But wait, there's more! We'll also compare Extended Events with the traditional SQL Server Profiler, so you'll know which one to pick for different situations. Plus, we'll share some nifty scripts to start with them right away.

SQL Bad practices caught in the wild

Who are you?

You are a SQL developer, but when you handover your code to your senior, you sometimes might hear: “Don’t do this anymore, it’s a bad practice!”. If you want to learn more about those bad practices which I see are being used a lot, this session is for you!

How is this session going to help you?!

In this session you will learn about some of those "code smells". I will show you an example of the bad practice, explain why it should be avoided and give a possible solution for them. We are going to talk about: Functions in the WHERE clause, Implicit casting, SELECT * and some others. This knowledge will help you make your queries run faster, need less resources and therefore will make your DBA and users happy.

SQL Bad practices caught in the wild

Who are you?

You are a SQL developer, but when you handover your code to your senior, you sometimes might hear: “Don’t do this anymore, it’s a bad practice!”. If you want to learn more about those bad practices which I see are being used a lot, this session is for you!

How is this session going to help you?!

In this session you will learn about some of those "code smells". I will show you an example of the bad practice, explain why it should be avoided and give a possible solution for them. We are going to talk about: Functions in the WHERE clause, Implicit casting, SELECT * and some others. This knowledge will help you make your queries run faster, need less resources and therefore will make your DBA and users happy.

SQLBits 2024 - General Sessions Sessionize Event

March 2024 Farnborough, United Kingdom

Data Left Unattended - Nuernberg Sessionize Event

December 2023

SQL Saturday Oregon/SW Washington 2023 Sessionize Event

November 2023 Vancouver, Washington, United States

New Stars of Data #5 Sessionize Event

May 2023

Peter Kruis

SQL Server Consultant

Middelharnis, The Netherlands

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top