Upcoming SQLMaestros Events by SQLMaestros

Event Name/Type City/Location Date & Time More Details
Sample Master Class (SQL Server Performance Tuning) Online 1st March, 2017
(10 am – 11 am EST)
Click Here
Sample Master Class (Advanced SQL Developer) Online 2nd March, 2017
(10 am – 11 am EST)
Click Here
Sample Master Class (Advanced SQL Database Administration) Online 21st March, 2017
(10 am – 11 am EST)
Click Here
Sample Master Class (SQL Server 2014/2016) Online 22nd March, 2017
(10 am – 11 am EST)
Click Here
Sample Master Class (Azure Data Platform) Online 28th March, 2017
(10 am – 11 am EST)
Click Here
Sample Master Class (Microsoft Business Intelligence and Analytics) Online 18th April, 2017
(10 am – 11 am EST)
Click Here

Recent & Past Events

Session Title: Advanced Aggregations in SQL Server
 
Abstract:
Aggregating and summarizing data is required in almost every domain. Aggregations can be as simple as calculating maximum/minimum/average or as complex as calculating sliding aggregations. Knowing how to write efficient aggregate queries is important to learn for every T-SQL developer. In this Advanced Aggregation session, Ahmad will talk about using Grouping Sets, ROLLUP and CUBE for aggregation and using OVER Clause with aggregate functions. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code, you won’t want to miss this session.
 
Event Resources | Orginal Emailer
Session Title: Advanced Pivoting in SQL Server
 
Abstract:
Pivoting is a technique to reorganize rows to columns to get an aggregated or summarized view of a possibly a large dataset. Pivoting is used in large number of applications and helps solve many reporting needs. In this all-demo Pivoting session, Ahmad will present advanced pivoting real life solutions involving relational division, data aggregations and dynamic pivoting. He’ll also talk about Un-Pivoting, which is the reverse of pivoting. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.
 
Event Resources | Orginal Emailer
Session 1:Stored Procedure Optimization
Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Abstract: Stored procedures in SQL Server provide multiple benefits such as encapsulating complex business logic, easy deployments and maintenance, data accessibility to name a few. Store Procedures are essential for any database deployment. Optimizing Stored Procedure performance is critical to increasing your application performance. Did you ever come across a situation when a stored procedure, working perfectly the other day, suddenly takes longer to execute? Did you ever come across a situation where a procedure takes longer time to execute for certain set of parameter values? If yes, then this session is for you. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.


Session 2:SQL Server Index Tuning
Amit R S Bansal (MCM, MVP, SQLMaestros)
Abstract: Having the right indexing strategy is super-critical to SQL Server performance. Join Microsoft Certified Master Amit Bansal in this demo-packed session and learn how to tune SQL Server Indexes. Both clustered and non-clustered indexes will be covered extensively and you can take the learnings back to your environment and apply immediately. Time to become an indexing hero!

Here is the photo collection!

Event Resources | Orginal Emailer

Session Title: In-Memory for Developers
 
Abstract:
Microsoft introduced In-Memory OLTP in SQL Server 2014. We all know about the technology and how it improves the performance, however how can a developer efficiently use in-memory tables and natively compiled stored procedures to get the blazing fast performance that the technology has to offer. In this demo heavy session, you’ll learn to create and access memory optimized tables and indexes and the latch and lock free new transaction model. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.
 
Event Resources | Orginal Emailer

Session Title: SQL Server Concurrency Problems
 
Abstract:
Well these are not SQL Server’s Concurrency Problems, there are concurrency problems that can happen in SQL Server 🙂 – Come to this session if you want a deep dive in concurrency problems that are causing performance issues in SQL Server. You are investigating everything else, but the problem lies in concurrency. We will go very deep into the nuts-and-bolts of how SQL Server handles concurrency.
 
Event Resources | Orginal Emailer | Blog

Session Title: Data Cleansing With SSIS
 
Abstract:
No one likes dirty data, especially business. Analysing dirty data can result in business disasters. Join Ahmad Osama, Microsoft Data Platform MVP & world renowned BI Expert, and learn advanced data cleansing techniques in SSIS. Clean the data so that it make business sense. Ahmad will show you how!.
 
Event Resources | Orginal Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server
 
Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.

Event Resources | Original Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server
 
Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.
 
Event Resources | Orginal Emailer | Blog

Session Title: Troubleshooting Common Performance Issues in SQL Server
 
Abstract:
Learn some internals and a few tips & tricks to solve common SQL performance issues. Take the learnings and apply back to your SQL Server Environment straight-away to improve performance. The content of this session is an extract from SQLMaestros Performance Tuning Master Class. And because this is a SQL Special Event, it will be a two-hour deep dive session.

Event Resources | Original Emailer | Blog

Session Title: Deadlocks – Everything You Need to Know
 
Abstract:
Whether you are a developer or a DBA, deadlocks bother everyone. So much so, deadlocks give sleepless nights even to the Chief Technology Officer. How? Well, how many times you tell your manager that “this is because of the deadlock” and you cannot do anything about deadlocks. And your manager vomits the same story up the chain.

Come to this session and learn the internals of deadlocks in SQL Server. Why they happen. Different types. Troubleshooting. How to minimize. Best Practices. Deadlock Internals. And much more, everything you want to know about deadlocks. This will be an extended two hour spotlight session with some awesome demos. Well, all SQLMaestros Special In-Person Events are deep-dives and each session is at least two hour of content followed by Q&A

Here is the photo collection!



 
Event Resources | Original Emailer | Blog

Session Title: Deadlocks – Everything You Need to Know
 
Abstract:
Whether you are a developer or a DBA, deadlocks bother everyone. So much so, deadlocks give sleepless nights even to the Chief Technology Officer. How? Well, how many times you tell your manager that “this is because of the deadlock” and you cannot do anything about deadlocks. And your manager vomits the same story up the chain.

Come to this session and learn the internals of deadlocks in SQL Server. Why they happen. Different types. Troubleshooting. How to minimize. Best Practices. Deadlock Internals. And much more, everything you want to know about deadlocks. This will be an extended two hour spotlight session with some awesome demos. Well, all SQLMaestros Special In-Person Events are deep-dives and each session is at least two hour of content followed by Q&A.

Here is the photo collection!



 

Event Resources | Original Emailer | Blog

Session Title: Back-to-Indexes, The Original Culprit
 
Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Event Resources | Original Emailer | Blog

Session Title: Master The Art of Public Speaking – Part 1
 
Abstract:
Yes We Can! Remember this? Good oratory skills can land you the top job, be it the President of the United States or the Prime Minister of India – public speaking skills is indeed that important today! Even if you don’t need to make regular presentations in front of a group, there are plenty of situations where good public speaking skills can help you advance your career and create opportunities. In fact, top jobs need those skills. And don’t you want to climb the ladder for that top job? Come to this session if you want to get a kick-start in public speaking. Amit Bansal, who has learnt the art of public speaking the hard way, will teach you these skills, step-by-step. Amit has delivered a number of sessions at international conferences like TechEd, PASS Summit, SQL Bits, GIDS, Economic Times – Power of Ideas, Images Retail Confernce, etc – and he will bring all his experiences in a series of sessions, starting from March 29, Part 1 of “Master The Art of Public Speaking”. These sessions are unmissable.

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit
 
Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!



 

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit
 
Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!



 
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: SQL Server 2014 Cardinality Estimator
 
Abstract:
Join SQL MCM, SQL MVP & Microsoft Regional Director, Amit Bansal, in this intriguing session that demo’s the new Cardinality Estimator in SQL Server 2014. Learn how calculations and assumptions are made inside the black box using statistics. Watch the old and the new cardinality estimator in action, you will love it!
 
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Dealing with Parameter Sniffing
 
Abstract:
Parameter Sniffing is a technique by which SQL Server query optimization engine sniffs the parameter value from the query and generates an optimized execution plan based on that value. A good thing? Or a bad thing? Well, not so easy to jump to an answer and that is why you should attend this session!
 
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Back-to-Indexes, The Original Culprit
 
Abstract:
Yes, indexes still remain the main bottleneck when it comes to performance; especially when your data grows big. In this demo-heavy session, Amit will take you through real-world scenarios of bad indexing designs and how they can be rectified to improve performance. Focus will remain on clustered and non-clustered indexes and the esoteric combinations of them. If you think you know everything about indexes, think again !

Here is the photo collection!



 

Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Mind Your IO: Resource Governor Shows You How
 
Abstract:
Resource Governor was introduced in SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, you will learn to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQLServer:Resource Pool Stats.
 
Here is the photo collection!



 
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments

Session Title: Tracking Page Splits with Extended Events
 
Abstract:
What are Page Splits? How do they cause index fragmentation? How to track them? How to fix them? Get your answers to all such questions! Microsoft Certified Master and MVP, Amit Bansal will take you through a demo-oriented session explaining all the concepts and show you a practical way to deal with page splits, a technique that you can take you your environment and get instant performance boost!
 
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments (Part 1) | Attendee Feedback & Comments (Part 2)
Session Title: Simplifying SQL Server Performance Tuning
 
Abstract:
SQL Server Performance Tuning is no rocket science! It’s a simple methodology that one needs to follow. And if you follow a methodological approach, you will be able to solve almost 90% of performance issues. Join Microsoft Certified Master & MVP Amit Bansal in this demo-oriented session and learn a troubleshooting methodology that can be put into production right-away!
 
Event Resources | Orginal Emailer | Blog

 
 

Past SQL Server events sponsored by SQLMaestros

We sponsor SQLServerGeeks SQL Server Day events in India. This is our contribution towards SQL Server community. We have been sponsoring SQL Server Day events since last 3 years have sponsored more than 40+ events including in-person events and web casts.

You will love watching the SQL Server Day collection:

Check out SQL Server Day albums on Facebook

 

Do you want to be notified of future classes and events? Click Here
 
 
 

Leave A Comment


*