How I use AI on a daily basis, in my Professional and Personal life
Artificial intelligence (AI) has quickly evolved from last year's buzzword to being integrated in some way into almost every tool we use in our daily lives. While marketing narratives often sell AI as a one-size-fits-all solution, the real question remains: How can we extract real value from AI?
I'm excited to share my personal experience in using AI to not only enhance efficiency but also to bring speed without loosing quality in my professional life.
In this session we will go through the use of AI in:
1. Collaborative Coding: Learn how I leverage Language Models (LLMs) to guide the development process from the initial coding phase to the final review, ensuring a smooth and efficient workflow.
2. Mastering Technical Documentation: Every expert needs a reliable reference. I'll reveal my techniques for not only creating but also comprehending detailed technical documentation.
3. Enhancing Meeting Efficiency: Discover how to streamline and capture the key points of meetings by analyzing transcripts with AI, ensuring no important detail is overlooked.
4. Effective Communication Strategies: Navigating complex technical communications can be challenging, but with AI assistance, every message is delivered clearly and accurately.
Please join me as we explore practical applications of AI in the professional sphere, but we also touch a few subjects how it helped me in my personal life.
Waitstats for the accidental DBA
Do you wear many hats at work and sometimes find yourself playing the role of a DBA? When SQL Server performance issues arise, finding, understanding and resolving wait statistics can be your secret weapon. This session explain wait statistics and provides actionable insights for improving query performance.
In this session, you will:
Learn what wait statistics are and why they matter.
Discover the most common wait types and what they reveal about your SQL Server's health.
Dive into real-world scenarios to identify and resolve common performance bottlenecks.
Gain tips to distinguish critical waits from those you can safely ignore.
Whether you're a developer, IT generalist, or accidental DBA, you’ll leave equipped with practical tools and knowledge to keep your SQL Server running smoothly.
Even though is goes about basics of wait statistics, it would be good to have the following knowledge.
A basic understanding of SQL Server concepts
This session is aimed at accidental DBAs, Developers and other professionals who need to deal with SQL Server performance as part of their job.
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
SQLBits 2024 - General Sessions Sessionize Event
Data Left Unattended - Nuernberg Sessionize Event
SQL Saturday Oregon/SW Washington 2023 Sessionize Event
New Stars of Data #5 Sessionize Event
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