Invitation: Free Training on SQL Server (Query Tuning & Security) @ Microsoft Bangalore (Domlur), Mumbai & Gurgaon + Webinars

Dear Geek,

SQLMaestros has announced the November 2017 schedule of its free training for the community known as SQLMaestros Special Events.

Sessions are on SQL Query Tuning & New Security Features in SQL Server. The Bangalore event is happening at Microsoft Domlur (EGL), this Saturday, Nov 18. Please note that the event is absolutely free to attend. You, your teams and managers are cordially invited.

Microsoft Certified Master (MCM) & Microsoft’s Most Valuable Professional (MVP) awardee, Amit Bansal is the trainer for all these sessions. These events are known as SQLMaestros Special Events and they are special, because the sessions are advanced, deep-dive & demo-packed.

If you are not in Bangalore region, no worries, in-person events are also happening in Gurgaon & Mumbai too. If you live elsewhere in the world, there are webinars for you too. Forward this mail to your friends and colleagues so that they too can benefit from these free sessions.

How to register? Click Here – All events are absolutely FREE.

SQLMaestros Events Section: http://sqlmaestros.com/sql-server-events/

Or, simply go to http://www.DataPlatformGeeks.com and block your seat after creating your free account. Do ensure that you have received the confirmation mail/ticket for the event of your choice.

Date/Time/Venue

Event Type

Sessions

Speakers/Trainers

Nov 18, Saturday,

9.30 am– 1 pm

(Microsoft Bangalore Office Domlur)

In-Person

(powered by SQLMaestros)

Session 1: Real-World Query Tuning Examples

Session 2: New Security Features Every SQL Professional Should Know

Amit Bansal

Nov 18, Saturday,

9.30 am– 1 pm

(Microsoft Mumbai Office Windsor, Kalina)

In-Person

Session 1: Dockerize SQL Server 2017 (on Linux) using Non-Windows OS

Session 2: What’s New for Database developers in SQL Server 2017

Avanish Panchal

Sandip Pani

Nov 23, Thursday, 3 pm-4 pm

Webinar

(powered by SQLMaestros)

New Security Features Every SQL Professional Should Know

Amit Bansal

Saturday, Nov 25,

9.30 am-1 pm

(Microsoft Gurgaon Office)

In-Person

(powered by SQLMaestros)

Session 1: Real-World Query Tuning Examples

Session 2: New Security Features Every SQL Professional Should Know

Amit Bansal

Do post details about this event in your internal employee portal and spread the word. If you wish that your L & D should be regularly informed about such free events, just drop an email to mamita@SQLMaestros.com.

DataPlatformGeeks (DPG): Join Asia’s largest data & analytics community. DPG is a community of 200,000+ Data & Analytics professionals from 60+ countries. Learn & grow with our free training events, free webinars, free videos, free educational magazine & much more. Gain new skills. Sharpen existing skills. Grow professionally by building your professional network. All SQLMaestros Special Events (free training) will now be delivered via DPG platform. Explore & join DataPlatformGeeks community for free to get host of free resources/knowledge with one-time registration: http://www.dataplatformgeeks.com/

SQLMaestros Team

(Unit of eDominer Systems)

+91-9606482133 | +91-9503124667

SQLM Signature Logo

Advanced Trainings: SQLMaestros has also published the calendar for advanced trainings on SQL Server & Microsoft Data platform. Both classroom & online. There are one-day trainings (Accelerators), three-day (Master Classes) and five-day (Hackathons). These advanced training range from beginner to expert level, demo-based & hands-on. The content of these trainings are highly advanced and exclusive. Learn more here: http://www.SQLMaestros.com

Read Full Post »

SQL UG gets Support Engineering Gems (Sep 2nd 2017)

https://www.eventbrite.com/e/sql-ug-gets-support-engineering-gems-sep-2nd-tickets-37262718795?ref=enivte001&invite=MTI1MzM5MjEvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=invitemodernv2&ref=enivte001&utm_term=attend
Power BI-RS (Report that talks)
Jaideep Saha Roy (Support Engineer, Microsoft SQL Support Team)
Sam Panda (Support Engineer, Microsoft SQL Support Team)
SQL Server New Features Learnings – Automatic database tuning and Resumable online index rebuild
Ujjwal Patel (Support Engineer, Microsoft SQL Support Team)
Ghufran Khan (Support Engineer, Microsoft SQL Support Team)
AlwaysOn Connectivity – Lesson Learned and Troubleshooting
Raghavendra Srinivasan (Support Escalation Engineer, Microsoft SQL Support Team)
Dhiraj H N (Sr. Support Engineer, Microsoft SQL Support Team)
SQL Server New Features Learnings – Indirect Checkpoints and SSMS enhancements
Rambabu Yalla (Technical Advisor, Microsoft SQL Support Team)
Hemanth Tarra (Support Engineer, Microsoft SQL Support Team)
Basics of SQL Server in Azure (IaaS and PaaS)
Jerry Jacob (Support Engineer, Microsoft SQL Support Team)
Suhas P V (Support Engineer, Microsoft SQL Support Team)
SQL Server Performance (Tools used by SQL Support Team)
Balmukund Lakhani (Escalation Engineer, Microsoft SQL Support Team)
SQL Server New Features Learnings – Stretch DB and Dynamic Data Masking
Sakshi B. Gupta (Cloud Operations Engineer Specialist, Accenture)
Fee: It is Free, so bring your friend too.
Venue: Hamilton Conference Room, Microsoft India (R&D) Pvt Ltd GTSC, Signature Building Embassy Golf Links Business Park Domlur, Bangalore – 560071
Logistics: Parking will be done at Microsoft, Signature Building Visitor Parking space. Once all slots are filled, visitors will be asked to park at our Multi-Level Parking next to Pyramid Food court inside the campus.

Read Full Post »

SQL Bangalore UG Meet – Jul 29, 2017

Hello sreedhar,
You are invited to the following event:

SQL BANGALORE UG MEET – JULY
Event to be held at the following time, date, and location:

Saturday, July 29, 2017 from 9:30 AM to 1:00 PM (IST)

Embassay Golf Links Business Park
Microsoft Corporation
Hamilton Hall
Bengaluru 560071
India

https://www.eventbrite.com/e/sql-bangalore-ug-meet-july-tickets-36350840342?ref=enivte001&invite=MTIzNjMzODkvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=invitemodernv2&ref=enivte001&utm_term=attend

Read Full Post »

SQL Server Decoded – June-24 2017 (Full day UG Meet) by SQL Bangalore

https://www.eventbrite.com/e/sql-server-decoded-june-24-full-day-ug-meet-tickets-35483845136?ref=enivtefor001&invite=MTIyMjAxNDUvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&utm_term=eventpage

DESCRIPTION
We are back again teaming with Microsoft and Community teams to bring the best on Performance and SQL Server to SQL Bangalore Usergroup. Some of the best people working on Support, Escalation team members, Community are going to get deep into some of the emerging trends on SQL Server capabilities. You dont want to miss the action. Come in early and make sure to grab your seats.
Registrations start at 8:30AM.
Tejas Shah (Sr. Program Manager)
Keynote speaker
Pinal Dave (Community Speaker)
Beginning SQL Server Performance Tuning
Lohith Ks Chalam (Community Speaker)
SQL Server on Linux
Sravani Saluru (Microsoft)
SQL Server AlwaysOn AG – Common issues reported to CSS
Dapinder Arora & Suhas (Microsoft)
Black box Query Recorder – Query Store
More Surprise Sessions on Azure and SQL Server.
Fee: It is Free, so bring your friend too.
Venue: Hamilton Conference Room, Microsoft India (R&D) Pvt Ltd GTSC, Signature Building Embassy Golf Links Business Park Domlur, Bangalore – 560071
Logistics: Parking will be done at Microsoft, Signature Building Visitor Parking space. Once all slots are filled, visitors will be asked to park at our Multi-Level Parking next to Pyramid Food court inside the campus.

Read Full Post »

Data Platform Day, Bangalore – January 28, 2017, Saturday at Microsoft

https://www.eventbrite.com/e/data-platform-day-bangalore-january-28-2017-saturday-at-microsoft-full-day-in-person-event-and-the-tickets-31249335604?ref=enivtefor001&invite=MTEzODE0NjAvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&utm_term=eventpage

DATE AND TIME

Sat, January 28, 2017
9:30 AM – 5:00 PM IST

Microsoft India (R&D) Pvt. Ltd
4th Floor, Hamilton Hall, Signature Building
Embassy Golf Links Business Park, Intermediate Ring Road, Domlur
Bangalore, 560071

Data Platform Day, Bangalore – January 28, 2017, Saturday at Microsoft (Full Day In-Person Event and the official launch of Data Platform Summit 2017)

This is a free community event.
Session details are as follows:
————————————————————–
Session 1: Introducing Azure Data Lake
Abstract: This session talks about the Azure Data Lake (Store and Analytics) and their capabilities. The very open, web HDFS compatible store is a massive scale data store designed for extremely high throughput and low latency for analytics workloads. At the same time, its built in security ensures you can run even your most critical workloads on it. The session also talks about the new U-SQL language for processing (Data Lake Analytics) massive amounts of data in a very familiar environment. U-SQL is designed to be closer in syntax to T-SQL and uses C# to extend its footprint. If you know SQL, you can use U-SQL from Day 1 and process Big Data right away.
Speaker: Debarchan Sarkar (Microsoft)
Session 2: Design Awesome Visualization With PowerBI
Abstract: Let’s explore how a powerful cloud-based service helps data scientists visualize and share insights from their organizations’ data. In this session we will explore data visualization possibilities with Microsoft PowerBI. It will help an organization take advantage of its data, reduce risks, increase rewards, and unlock insights to drive more informed decisions for every department.
Speaker: Sudhir Rawat (Microsoft)
Session 3: Achieve Great Performance with Azure SQL Database using Built-in Intelligence
Abstract: Managing and tuning the performance of relational databases is a challenging task that requires significant expertise and time investment Azure SQL Database has built-in smart tuning models that help you achieve great performance for your database applications while saving you time and effort in the process.
The tips and techniques that we use to troubleshoot a customer’s issue by using the SQL DB intelligent Performance features (SQL Database Advisor , Query performance Insight , Performance Dashboard) will be discussed.
Query Performance Insight allows you to spend less time troubleshooting database performance by providing
• Deeper insight into your databases resource (DTU) consumption.
• The top queries by CPU/Duration/Execution count, which can potentially be tuned for improved performance.
• The ability to drill down into the details of a query, view its text and history of resource utilization.
• Performance tuning annotations that show actions performed by SQL Azure Database Advisor
++ Built in SQL Security intelligent feature run through.
Speaker: Pooja Kamath (Microsoft)
Lunch Break
Session 4a: Introduction: SQL Server on Linux
Abstract: SQL Server on Linux is announced in March 2016. Welcome to Open-source. Session will cover how SQL Server works on Linux. A quick snippet about installation & using different tools to manage SQL Server database hosted on Linux operating system.
Speaker: Avanish Panchal (DataPlatformGeeks)
Session 4b: Introduction to Microsoft R Services in SQL Server 2016
Abstratct: R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and data miners for developing statistical software and data analysis. Now R is integrated with SQL Server 2016. In this demo I will discuss how to configure R and How to use R from SQL Server.
Speaker: Sandip Pani (DataPlatformGeeks)
Session 5: Monitoring SQL Server Performance – Part II
Abstract: In Part I, Amit Bansal had demoed how to identify the root cause of a performance issue in SQL Server. He gave several practical examples how to identify slow running queries. In Part II, Amit will show how to fix common performance issues. He will give example related to server configuration, database tuning, indexing strategies and query tuning. And you will see instant performance improvement with SQL Server. In short, do you want to be rock star DBA? Join Microsoft Certified Master & MVP Amit Bansal in this demo-packed session where he will demo real world performance tuning cases, identify them & fix them.
Speaker: Amit RS Bansal (http://www.amitbansal.net/) (MCM, MVP, SQLMaestros)
Session 6: Using Analytic Function to solve complex analytical problems
Abstract: Analytical functions are important addition to SQL Server. One can quickly and easily solve complex analytical queries using SQL Server Analytical functions.Prior to analytical functions, Joins, sub-queries, temporary tables were used to write complex analytical queries. In this demo-heavy session, you’ll learn to solve few complex analytical problems such as moving averages, running totals, percentage or top n within a group using joins or subqueries and analytic functions. We’ll then compare the performance and usability of the analytic function solutions over the join/subqueries solutions. 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.
Speaker: Ahmad Osama (http://www.ahmadosama.net/) (MVP, Sr. Consultant, SQLMaestros)
————————————————————–
City: Bangalore
Date & Time: Saturday, 28 January 2017, 9.30 am to 5:00 PM
Venue: Microsoft Corporation, 4th Floor, Hamilton Hall, Signature Building, Embassy Golf Links Business Park, Intermediate Ring Road, Domlur, Bangalore – 560071
Parking: Parking is available at Pyramid Food Court
Note: Come by 9.00 am for registration and security formalities. Please be seated by 9.30 am.
We look forward to your participation. Please forward this email to your friends & colleagues to make them aware of the event. Your efforts in spreading the word will be highly appreciated.
Want to be notified on our upcoming free events? Subscribe: (http://goo.gl/ChYLma)
For more free events & webinars, keep checking http://www.DataPlatformGeeks.com
Learn More About Us—————————————————————-
To learn about world’s best database tools like SQL Monitor and DLM suite from Redgate, Click Here (http://goo.gl/7AmntB)
Master Class on SQL Server Performance Tuning & Advanced Developer Master Class, scheduled in Bangalore from January 30th to February 3, 2017. To learn about the most advanced and fully Hands-on SQL training in India, Click Here (http://goo.gl/7oRi6o)
Want to practice SQL concepts in a practical way? With SQLMaestors HOLs documents, you will get hands-on with hundreds of topics in SQL Server & related technologies. To learn more, Click Here (http://goo.gl/Nzck6e)
Your only chance to learn from SQL Product Team Members (from Redmond), international SQL stalwarts (from 16 countries),
SQL CAT Team (from Redmond), SQL Tiger Team (from Redmond), Global Black Belt Team (from Redmond), from Microsoft USA & India.
Data Platform Summit 2017 (DPS 2017) – The new incarnation of SSGAS, where everything about Data, Analytics, Machine Learning, Big Data & of course,
SQL Server, will be covered in-depth. 3 Days, 7 Tracks, 30+ Technologies, 80+ Subjects 100+ Speakers, 200+ Sessions, 300+ Companies, 1500+ Attendees – Need We Say More?.
Block your calendar in advance for Asia’s Largest Learning Event on Data & Analytics. For next few days, you have a super introductory offer, don’t miss it! Learn More (https://goo.gl/WA42oo)
(email dps2017@dataplatformgeeks.com or call +91 9503124667)
Need a corporate trainer for your team? Click Here (http://goo.gl/MfR4gS)
—————————————————————————————————–
[Note: Please make sure you provide correct email id. Event details will be sent to the email id you provide. This is a free community event.]
TAGS

Read Full Post »

UG MEET IN PARTNERSHIP WITH SQL TALKS (CSS) – December 3, 2016 from 8:30 AM to 5:30 PM

https://www.eventbrite.com/e/ug-meet-in-partnership-with-sql-talks-css-tickets-29694425827?ref=enivte001&invite=MTExNTc0MTcvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=invitemodernv2&ref=enivte001&utm_term=attend

We are back again teaming with CSS team to bring SQL Talks content to SQL Bangalore Usergroup folks. Some of the best people working on Support, Escalation team members are going to get deep into some of the emerging trends on Cloud and SQL Server capabilities. You dont want to miss the action. Come in early and make sure to grab your seats.
Session Title: Predictions in the cloud
Speakers: Shaurabh Thapa, Pradeep Adiga
Session Title: Acquaintance of R & Polybase with SQL Server
Speakers: Amit Khandelwal, Vikas Rana
Session Title: Microsoft BI Unleased
Speakers: Selvakumar Rajakumar, Kane Conway, Chetan KT
Session Title: Introducing Azure Data Lake
Speakers: Debarchan Sarkar, Amarpreet Singh Bassan
Session Title: Performance tuning recipes for your intelligent Cloud Database- Azure SQL DB
Speakers: Pranab Mazumdar, Pooja
Session Title: Go speed racing with columnstore and in-memory improvements
Speakers: Tejas, Balmukund Lakhani
Fee: It is Free, so bring your friend too.
Venue:
Hamilton Conference Room,
Microsoft India (R&D) Pvt Ltd
GTSC, Signature Building
Embassy Golf Links Business Park
Domlur, Bangalore – 560071
Logistics: Parking will be done at Microsoft, Signature Building Visitor Parking space. Once all slots are filled, visitors will be asked to park at our Multi-Level Parking next to Pyramid Food court inside the campus.

UG MEET IN PARTNERSHIP WITH SQL TALKS (CSS)
Event to be held at the following time, date, and location:

Saturday, December 3, 2016 from 8:30 AM to 5:30 PM (IST)

Embassy GolfLinks Campus, Domlur
Microsoft Signature Building
Hamilton Hall, 4th Floor
Bengaluru, 560071
India

Read Full Post »

SEPTEMBER UG MEET: RELIVING SQL SATURDAY AT SQLBANGALORE Sep 17 2016

SEPTEMBER UG MEET: RELIVING SQL SATURDAY AT SQLBANGALORE
divider
https://www.eventbrite.com/e/september-ug-meet-reliving-sql-saturday-at-sqlbangalore-tickets-27634772348?ref=enivtefor001&invite=MTA3MTMxMjQvYW1iYXRpc3JlZWRoYXJAZ21haWwuY29tLzA%3D&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&ref=enivtefor001&utm_term=attend

Event to be held at the following time, date, and location:

Saturday, September 17, 2016 from 9:30 AM to 12:30 PM (IST)

Embassy Golf Links Business Park
Domlur
Bengaluru, 560043
India

Read Full Post »

April UG Meet: SQL Server 2016 Decoded (Apr 2, 2016)

https://www.eventbrite.com/e/april-ug-meet-sql-server-2016-decoded-tickets-23030213990?ref=enivte001&invite=OTcwNTA3MC9hbWJhdGlzcmVlZGhhckBnbWFpbC5jb20vMA%3D%3D&utm_source=eb_email&utm_medium=email&utm_campaign=invitemodernv2&utm_term=eventpage

SQL Bangalore Usergroup brings together the best of SQL Server 2016 in a FULL Day event again. Dont miss to come to meet and greet the speakers early and to network with your peers from industry. The experts will be around to interact with each of you during the whole day.
Doctor in the house: Query Data Store
By: Pranab Mazumdar, Escalation Engg. Microsoft
I am lost: What NoSQL to Choose?
By: Manas Ranjan Dash, Tesco
Hyper-Scale Analytics With SQL Server 2016
By: Sourabh Agarwal, Senior PFE – Microsoft
SQL Quiz: Tips and Tricks About Performance Tuning
By: Pinal Dave, Independant Consultant – SQLAuthority.com
Top 10 lesser known capabilities with SQL 2016
By: Balmukund Lakhani, Support Escalation Engg. Microsoft Vinod Kumar, Solutions Architect – MTC
Fee: It is Free, so bring your friend too.
Venue: Hamilton Conference Room, Microsoft India (R&D) Pvt Ltd GTSC, Signature Building Embassy Golf Links Business Park Domlur, Bangalore – 560071
Logistics: Parking will be done at Microsoft, Signature Building Visitor Parking space. Once all slots are filled, visitors will be asked to park at our Multi-Level Parking next to Pyramid Food court inside the campus.
WHEN
Saturday, April 2, 2016 from 9:30 AM to 4:30 PM (IST) – Add to Calendar
WHERE
Embassy GolfLinks Campus, Domlur – Microsoft Signature Building Hamilton Hall, 4th Floor, Bengaluru 560071, India – View Map

Read Full Post »

SQLGeeks Meet-Up, Bangalore – February 13, 2016, Saturday at Microsoft (Half Day)

SQLGeeks Meet-Up, Bangalore – February 13, 2016, Saturday at Microsoft (Half Day)

Event Details:
Event Type Free In-Person Event (Half Day)
Event Theme Business Intelligence
Session 1 Data Services on Microsoft Azure
Data is growing and so as business needs. You know data services running on on-prem world but do you know how many data services are there in Azure and why? If not or somewhat then join me in this ride and we’ll explore such services and need for such services. I am sure it will be an eye opener for you. See you there!
Speaker: Sudhir Rawat (Microsoft)

Session 2 Understanding SparkSQL
This session will Introduces how with Spark SQL you can query structured data. Showcase how data pipelines can be expressed with a combination of both relational queries and procedural algorithms.
Speaker: Sunil Kumar C (Microsoft)

City/Location Bangalore
Date & Time Saturday, 13 February 2016
10.00 am to 2.00 pm
Note: Come by 9.30 am for registration and security formalities. Please be seated by 10.00 am.
Venue MPR Krishna Room, 3rd Floor
Microsoft India (R&D) Pvt. Ltd.
Global Technical Support Centre, Embassy Building
Level 3, Block B, Embassy Golf Links Business Park, Off. Intermediate Ring Road,
Bangalore – 560 071
Note: This is not Signature Building. This is Embassy building immediately on the right of the park entrance.

Parking Parking is available at Pyramid Food Court
Registration Click here to register

Read Full Post »

SQL Server 2016 Community Launch with SQLTalks (Jan 30, 2016)

SQLTalks and SQL Bangalore Usergroup brings together the best of SQL Server 2016 in a FULL Day event. Dont miss to come to meet and greet the speakers early and to network with your peers from industry. The experts will be around to interact with each of you during the whole day.

PolyBase – Access data stored in Hadoop or Azure Blob Storage
by Rishi Maini & Akbar Farishta– Escalation Engineer
Improvements in In-Memory OLTP in SQL 2016
by Sumit Sarabhai – Sr. Support Escalation Engineer and Amit Khandelwal – Support Escalation Engineer
Stretch Database with SQL Server
by Vijay Rodrigues
Supportability Enhancements on SQL Server 2016
by Tejas Shah – Sr. Escalation Engineer
AlwaysOn Enhancements on SQL Server 2016
by Vinod Kumar M – Technology Architect and Balmukund Lakhani – Sr. Support Escalation Engineer
BI Enhancements on SQL Server 2016
by Sunil Kumar BS – Sr. Escalation Engineer and Kane Conway – Support Escalation Engineer
PowerBI for Enterprise
by Kane Conway – Support Escalation Engineer and Sumit Ghosh – Support Engineer
Introduction to Spark
by Amarpreet Bassan
JSON – Building blocks with SQL Server 2016
by Basavaraj Biradar
Fee: It is Free, so bring your friend too.
Venue: Hamilton Conference Room, Microsoft India (R&D) Pvt Ltd GTSC, Signature Building Embassy Golf Links Business Park Domlur, Bangalore – 560071
Logistics: Parking will be done at Microsoft, Signature Building Visitor Parking space. Once all slots are filled, visitors will be asked to park at our Multi-Level Parking next to Pyramid Food court inside the campus.

WHEN
Saturday, January 30, 2016 from 9:00 AM to 5:30 PM (IST)
WHERE
Embassy Golf Links Business Park – Microsoft Signature Building. 4th Floor, Hamilton Hall. Bengaluru, KA 560071 IN

https://www.eventbrite.com/e/sql-server-2016-community-launch-with-sqltalks-and-sql-bangalore-ug-tickets-20831258856?ref=enivtefor001&invite=OTAzMjk2NS9hbWJhdGlzcmVlZGhhckBnbWFpbC5jb20vMA%3D%3D&utm_source=eb_email&utm_medium=email&utm_campaign=inviteformalv2&ref=enivtefor001&utm_term=attend

Read Full Post »