SQL Server events India
Announcement: SQLMaestros Master Classes are not happening at the moment. We are focusing on Video Courses, Hands-On-Labs, Learning Kits & Electronic Books.
SQL Special Events are free community events from SQLMaestros. Why Special? At these events, we deliver deep-dive sessions on Microsoft Data Platform technologies including but not limited to SQL Server, Azure Data Services, Machine Learning & Artificial Intelligence. Sessions are at least two hour in duration and covers a topic end-to-end. Comprehensive coverage, advanced-to-expert level content & justified duration make these events special. We conduct in-person events as well as webinars. In most cases, the session content is an extract from our advanced trainings. So if you are looking for some advanced training, free of cost, check-out the schedule below. Spread the word, events are absolutely free.
Starting from Nov 2017, SQLMaestros Special Events are being delivered via DataPlatformGeeks (DPG) Community (Asia’s Largest Data/Analytics Community). This means that you have to be a registered user with www.DataPlatformGeeks.com. Registration is absolutely free and there are loads of membership benefits.
Here are the benefits of one-time registration with DPG and its free:
- You will be able to attend all events hosted by SQLMaestros & DataPlatformGeeks
- You don’t have to re-register for every event. Just login with your credentials and select the event you wish to attend
- Get access to free videos, labs, magazines and host of learning resources
- Gain new skills, Sharpen existing skills
- Download all our events & conference material
- Immense technical & professional development
Upcoming FREE SQLMaestros Special Events (In-Person & Webinars)
Recent & Past Events
Abstract:
In this session by Microsoft Certified Master Amit Bansal, will take a deep-dive into SQL Server In-Memory OLTP. This will be a demo-packed session. Amit will show where and how exactly In-Memory OLTP help improve SQL Server performance. Many SQL Server professionals do not have the right understanding of these technology. In this session, all myths will be busted. The content presented in this session is from Amit’s Master Class. Make sure you do not miss this.
Event Resources
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
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
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1789194364684005.1073741908.1396871917249587&type=1&l=7e63febdb6″ limit=10]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
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.
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
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.
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1631681623768614.1073741893″ limit=10]
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1631681823768594.1073741894″ limit=10]
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 !
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1559052364364874.1073741881.1396871917249587&type=1″ limit=10]
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1556306061306171.1073741880″ limit=10]
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1538592286410882.1073741878.1396871917249587&type=3″ limit=10]
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!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1539421722994605.1073741879.1396871917249587″ limit=10]
Event Resources | Orginal Emailer | Blog | Attendee Feedback & Comments
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)
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
Leave A Comment