Ramesh Satya
Sr.Consultant, SQLMaestros
Bengaluru, India
Actions
Satya Ramesh has credible experience working with SQL Server. As a Senior Consultant for SQLMaestros (a business unit of eDominer Systems), he has worked on countless projects involving SQL Server & Azure SQL Database. He has presented numerous webinars and delivered multiple sessions as part of his community work with DataPlatformGeeks. He was also a speaker at Data Platform Summit 2018 & 2017 edition, New Stars Of Data and about to speak in SQLSaturday. Satya frequently records SQL videos for the community and hosts them on SQLMaestros YouTube channel.
Links
Area of Expertise
Topics
SQL Server Indexes - Back To The Basics
Here are some suggestions on the abstract:
If you are a SQL Server Developer, DBA, Architect or you are someone working with SQL Server in any other capacity, it is very important to understand how indexes work. and how Creating proper indexes can boost your SQL Server performance considerably. Experts, often say 70% of performance problems can be treated by having proper indexing strategy. Even though the concept of indexing existed for years, still people have some misconceptions. This session is to take you back to the basics and help you understand the indexing structures from grass root level and to clear all the misconceptions you might have along the way. As most of the indexes found in OLTP are row-based, our concentration in this session will be completely on row-based indexing structures. We will be discussing the following topics along with supported demos.
1. How to create indexes and some best practices to follow.
2. What is a covering index and how is it useful.
3. What is fragmentation and how to defrag indexes
4. What is the fill factor and how is it useful.
Understanding NULLs in SQL Server
SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this session, we will try to go through different test cases to understand NULLs properly.
Understanding SQL Server Views - The Right Way
VIEW is one of the programmable objects often used by Developers to build solutions to business problems but if not used without complete implications, there will be data inconsistency issues. This session focusses on how to create VIEWs, what are issues while doing DML operations through the VIEWS and how does INDEXED VIEWs help us.
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