Archive for January, 2017



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.]


Read Full Post »