I’m very thrilled to announce that I will be participating as speaker in this year’s SQL Saturday #828 event in Guatemala city!
This will be my first time as a speaker on a SQLSaturday.
Event will take place on February 16 at Universidad Francisco Marroquin, Calle Manuel F. Ayau (6 Calle final), zona 10, Guatemala
Here are the details of the session I will be presenting (at 3:15 PM CST in Dev Room)
T-SQL Basics: Coding for performance
It is very common in the IT field for a developer to switch to database developer or administrator, even when the programming concepts are the same, the skillset required to code T-SQL is different.
In this session, we will learn some basic tips to improve our code and improve database performance from early application planning stages to already deployed applications.
We will also see some demos about:
- Compatibility level and deprecated features
- Filtering basics: SARGABLE arguments
- Covering indexes
- Indexed views
- Implicit conversions
- Memory Grants
- Joining records with NULL
- DMOs to find top resource intensive queries
- Collation: considerations when working with multiple databases
I will show you execution plans using an excellent tool called Plan Explorer from SentryOne, best thing is that is free.
You can download it from here
As any SQL Saturday event organized by SQLPass you can register for free, it takes less than 5 minutes to get in and sign up.:
Hoping to see you there!