I thought you might be interested to know that I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:
As a speaker, I can extend $600 savings on the 5-day package. Register here: and use code LSPK22.
I’ll be presenting the following sessions:
Secrets of SQL Server: Database Worst Practices
Abstract: Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. Shedding light on some of these perils and the tricks to avoid them may even save your current job. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their SharePoint implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session. Additionally, all attendees of the session will have access to learning material presented in the session.
Workshop: Performance Tuning Best Practices – Every DBA and Developer MUST Know
In this session we will try to bridge the gap between DBA and Developer. We will approach performance as a whole subject rather than dividing them into DBA or Developer problems.
Performance Tuning is a tricky subject, but not as difficult as we think. It is very common to see in this industry that the DBA believes the performance issue is due to bad code and the Developer believes it is due to the bad deployment of the database server.
In this session, we will try to bridge the gap between DBA and Developer. We will approach performance as a whole subject rather than dividing them into DBA or Developer problems.
We will have very different approaches to solving the performance problems of SQL Server – we will have stories related to real world scenarios and practical approach of solving performance problems.
We will primarily discuss:
- Best Deployment Practices
- Indexes, Best Practices and Maintenance
- Identifying slow running queries and Tuning
- Identifying resource bottleneck with the help of SQL Wait Stats
- Optimizing Resources – CPU, IO, Memory
- Best Practices to Resolve ad-hoc issues
You will learn:
- Performance Tuning
- Best Practices
- Index and Query Tuning
SPECIAL OFFER:
As a speaker, I can extend $600 savings on the 5-day package. Register here: and use code LSPK22.
Get better at what’s available, and get ready for what’s coming. We delve deep into the topics that matter most in your world today, covering practical knowledge, fundamentals, new technologies, and futures. Register now:http://bit.ly/LSPK22REG
Reference: Pinal Dave (https://blog.sqlauthority.com)
