Dear DPG Member

DataPlatformGeeks wishes you & your family, a very warm & prosperous New Year!

We are starting 2018 with a big bang! The month of January 2018 is now lined up with back-to-back learning events (in-person & webinars). Please note that the events are absolutely free to attend. You, your teams and managers are cordially invited.

Event Calendar

Free Events (In-person sessions)

City / Venue / Date / Time	Topics	Speakers
Bangalore Microsoft Office (EGL, Domlur) Jan 20, Full Day 9.30 AM to 5 pm (Lunch will be served)	Spark your Data to Build Intelligent Systems Azure SQL Database Managed Instances SQL Server Memory Power BI Report Server Advanced Query Performance Troubleshooting	Sudhir Rawat & Abhishek Kabra Tejas Shah (Microsoft) Amit R S Bansal (SQLMaestros) Kane Conway (Microsoft) Sravani Saluru & Swetha S (Microsoft)
Hyderabad Microsoft Office (Gachibowli Campus) Jan 20, Half Day 9.30 AM to 1 pm	Scale Out for SSIS What’s New for Database Developers in SQL Server 2017 Azure Analysis Services Real-World Query Tuning Examples (Video Recorded session by Amit Bansal)	Muthukumaran Arumugam (Microsoft) Sandip Pani (DataPlatformGeeks) Rahulinder Singh & Mohammed Malik (Microsoft)
Mumbai Microsoft Office (Windsor Building, Kalina) Jan 20, Half Day 9.30 AM to 1 pm	Adaptive Query Processing Feature in SQL Server 2017 Introduction to MySQL & PostgresSQL as a Service in Azure Real-World Query Tuning Examples (Video Recorded session by Amit Bansal)	Haseeb Hamdule (Microsoft) Avanish Panchal (DataPlatformGeeks)
Gurgaon Microsoft Office (Epitome, DLF, Phase 1) Jan 20, Half Day 9.30 AM to 1 pm	Getting Started with Power BI SQL Server Always Encrypted Feature Real-World Query Tuning Examples (Video Recorded session by Amit Bansal)	Arjun Rajagopal (Microsoft) Prince Rastogi (DataPlatformGeeks)
Pune e-Zest Solutions Ltd (Rajiv Gandhi Infotech Park, Hinjawadi Phase-1) Feb 3, Half Day 9.30 AM to 1 pm	SQL Server Memory Internals Real-World Query Tuning Examples	Amit R S Bansal (SQLMaestros)

Free Webinars (Online sessions) @ US time zones (11:00-12:00 PST / 14:00- 15:00 EST)

Day / Date	Session	Speaker
Wednesday, 17th January 2018	SQL Server Memory – Part 1	Amit Bansal (SQLMaestros)
Tuesday, 23rd January 2018	Adaptive Query Processing and Automatic Tuning in SQL Server 2017	Nagaraj Venkatesan (Singapore)
Monday, 25th January 2018	Real-Time Analytics with Power BI	Manohar Punna (DPG, Australia)
Wednesday, 30th January 2018	DevOPS and the Data Professional	Hamish Watson (New Zealand)
Wednesday, 31st January 2018	Cloud based Integrations using Azure Data Factory	Anupama Natarajan (New Zealand)

How to register for DPG Events? Navigate to www.DataPlatformGeeks.com (DPG), login with your credentials, go to the Events section and block your seat

New Labs on Azure Machine Learning, BI & SQL Server – All Free:

· If you have already practiced hands-on with our existing labs, here is something new. We have added four new labs as our year-end bonanza to the community:

o Deploying Predictive Model as Web Service with Azure ML Studio

o Calling Web Service From SSIS

o Clustered Index Internals

o Extended Events - Part 1

• To access the free labs, log-in to your DPG account and navigate to Hands-On-Labs section.
• Our mentors/speakers use these labs to show you their demos. For example, the demos used by Amit Bansal for his Query Tuning & SQL Server Memory are based on these labs. To access the full Library with 100+ labs (paid), visit http://hols.sqlmaestros.com

SQL Videos

• A new video has been added on “SQL Server Query Cost, Memory Grant & SQLRESERVATIONS” in the Video Library.
• The following free Videos by Amit Bansal are already available for members
• SQL Server Wait Types
• Troubleshooting a Slow Running Query (Using Waits & Extended Events)
• Session Level Waits & Task Level Waits
• And a few more…
• All videos are available in the Videos Library

We Are Mobile Now

• DPG members can now connect on Telegram App. Join us there and get to know about DPG activities right on your mobile.

Event Resources

• All event resources like presentations, demos, etc can be found here. (You must be logged in to download the resources)

New Blog Content

• Check out our recent technical blogs on SQLServerGeeks.com
• Avanish, Sandip & Prince have blogged about SQL on Linux & SQL 2017 New Features.

Event/Session Feedback

• Did you give us your feedback about the sessions/events you attended. If not, please do that ASAP. Your feedback helps us improve. Click Here.

What Do You Want To Learn Next?

• Give us suggestions on topics/subjects that you wish to learn and we will try to deliver those.

Do forward this communication to your friends and colleagues so they too can access all the learning resources.

Thanks & Regards

DataPlatformGeeks

(unit of eDominer Systems)

Is your DPG profile up-to-date?

Login with your credentials and update your profile by clicking on ‘Profile’ on top right corner. This will help us send you relevant communications based on your profile.

SQLMaestros Hands-On-Labs*

Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere.

Advanced SQL Training (On-site)*

Want your team to experience Amit Bansal's Advanced SQL Training? Email contact@SQLMaestros.com or Call 9606482133

Corporate Training*

Looking for any other high-end technology training for your team? Email enquiry@PeoplewareIndia.com or Call 8217320907

*A word from our sponsors

PS: You are receiving this email since you are a registered member with DataPlatformGeeks. If you do not wish to receive these bulletins, you can delete your user account from DPG. If you delete your user account, you will not be able to join our free events or access any learning resource.