Grzegorz Łyp
Department Head at Asseco Business Solutions, optimizer, problem solver
Warsaw, Poland
Actions
Department Head at Asseco Business Solutions. Enthusiast of low-level programming, data analytics and optimization. Architect and optimizer of the MS SQL Server database engine.
Links
Area of Expertise
Topics
Parallel Database Index and Statistics Maintenance in 24/7 Production Environments
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
SQL Server 2025 - new and changed features
The session covers new and changed features, Starting from theory to practical demos we will go through and observe the benefits they provide.
The power of LLM in T-SQL coding
In this session we will try to use LLM models to perform some T-SQL coding tasks like converting code, extracting parts of the code, and many others.
Key performance metrics of MS SQL Server performance
Session covers most important MS SQL Server performance metrics. We are going to talk about deep meaning of each of them with examples. This will allow DBAs to understand the meaning of most typical performance problems.
Let's create MS SQL Server monitoring tool in a day
We are going to build a fully working tool for monitoring, visualising and alerting performance of MS SQL Server. Only free tools are going to be used. During this session many aspects of necessary metrics will be covered that are important for DBA and DB Developers. We are going to use windows metrics and SQL Server administrative and analysis tools. Session covers not only MS SQL details but also document databases and data visualization and alerting tools.
Execution Plans - from beginner to professional
The session is a walk through execution plans starting from the basic concepts. The journey continues with more details and stops with the newest execution plan features implemented in the latest SQL Server versions
Hash Partitioning
Session describes the use case of hash partitioning technique. Starting from the PAGELATCH live case we go deep into partitioning details. Finally the pagelatch problem is solved with live experiment. Database stress test will give us the true comparison of time wasted on pagelatches.
DIY: T-SQL code analysis
Important part in any code development nowadays is to analyse code. This allow us to get rid of typical bugs, performance issues, security problem, etc. Session shows how to build such tool by yourself.
Developing business logic applications with SQL Server
With the business application implementation comes the problem with data storage and business logic implementation. In this session the approach of storing data and business logic will be presented with details on interfacing that logic with classic and web applications.
Deadlock Monitoring
Session is about ways of gathering information about deadlocks that occured. Depending on this data we walk through details of deadlock like blocked queries, SQL call stack, blocked resources and chain of deadlock. Additional differences between SQL Server versions will be presented.
Contained Availability Groups (SQL 2022)
The meeting aims to introduce new Always On Availability Groups (AG) features in SQL Server 2022, specifically focusing on Contained AG technology and its ability to simplify the synchronization of system databases.
Common Missing SQL Server Features Implemented as CLR Modules
Overview of many typical not implemented in SQL Server features that are easily implementable in CLR. We start from the one-liners to more complete task using global objects and multithreading.
Be better than SQL Server scalar UDF Inling
The great new tool in SQL Server 2019 named Scalar UDF Inling changes Scalar UDFs into inline functions that can be processed more efficiently. But not all functions can be inlined including Multi Statement Table Valued Functions. During this session I will present techniques of changing Scalar UDFs and MSTVFs into inline functions in common and less common situations.
AI Agent in assistance of your data
AI Agents are coming to use in many aspects of life. The session will provide step by step guide on how to build such agent, consider pros and cons and show possible future of such solution.
Grzegorz Łyp
Department Head at Asseco Business Solutions, optimizer, problem solver
Warsaw, Poland
Links
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