Speaker

Peter Kruis

Peter Kruis

SQL Server Consultant

Middelharnis, The Netherlands

Actions

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

How to use AI, in your professional and personal life

Artificial intelligence (AI) has transcended its buzzword status to become an integral part of professional life for many of us, especially in areas such as data analytics, code generation and semantic search. However, if you're not yet directly involved in an AI project, perhaps you feel like you're struggling to making the best use of AI tools or are still skeptical of the quality of what they can deliver.
If so, this session is for you! It will demonstrate how you can get real value from generative AI tools in both your professional and personal lives. We'll provides practical examples of how AI can improve tasks as diverse as eliminating repetitive work, performing code reviews, optimizing work emails, generating concise meeting notes and actions, and even negotiating salaries!
We'll explain techniques to 'tune' your AI input, the so-called prompt, which in turn will greatly increase the quality and reliability of what the AI Large Language Model (LLM) tools produce. We'll demonstrate how to create and refine custom models, which instruct the tool to tailor its output to your personal style, or to a set of requirements. We'll even find time to have a bit of fun with AI, showing you how to bore your spouse and colleagues with impressive AI-generated images!
The development of AI goes at rocket speed and our session is designed to help you keep up, assuming the pace of changes isn't so fast that we've been replaced by AI before the session starts!

An introduction to Query Store

In this introductory session, attendees will learn the fundamentals of Query Store in MSSQL, tailored for junior/accidental DBA's. We'll discuss its purpose, architecture, and practical applications, participants will learn how Query Store serves as a powerful tool for monitoring, analyzing, and optimizing query performance. Through clear explanations and demo's, this session equips attendees with essential knowledge to use Query Store effectively, enabling them to identify performance issues, analyze query execution plans, and optimize performance.

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.

Data Saturday Gothenburg 2024 Sessionize Event Upcoming

September 2024 Göteborg, Sweden

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

Actions

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