Important Notes. Please Read Carefully.
1. This is the final release. Release Date: August, 2017. Session Count: 200. Minor changes may happen without any prior notice.
3. Breakout sessions are of 75 minutes each. Chalk-Talks & Open-Talks are 30 mins each.
4. Use the Search box on the top right corner of the table. You can search on any keyword including session type, speaker name, session title, track, level, etc. The search is instant and also searches within the abstract.
For example, if you type “Azure”, all sessions that have “Azure” in their title or abstract will be displayed.
For example, if you type “Azure”, all sessions that have “Azure” in their title or abstract will be displayed.
5. There might be minor adjustments to the sessions & schedule without any prior notice.
6. Errors/Corrections? Write to Manu[at]sqlservergeeks.com & satya[at]dataplatformgeeks.com.
7. Learn more about DPS 2017 registration.
8. The pre-cons (full-day in-depth classroom training) has limited seats now. Learn more about Pre-Cons.
Want to browse an interactive SSRS report of Agenda & Schedule? Click Here (User Id: dps2017_user Password: D9s2017 )
| Day | StartTime | EndTime | Room | Speaker | Session_Type | Session_Title | Track | Level | Abstract |
|---|---|---|---|---|---|---|---|---|---|
| Day 1 - 17th | 10:45 | 12:00 | HYDRA | Sriharsha Narasimhan | Break-Out | DEV_B75 - Intermediate - Accelerate Your Digital Transformation – Expand Your Competitive Edge | Database Development | Intermediate | Abstract: The highly effective use of new data sources and compute models is becoming a significant competitive advantage in most industries. Mining this data by leveraging the latest server technology offers the opportunity to differentiate and accelerate success in the marketplace. Join us to know how HPE can rapidly expand your competitive leverage. Delivering new levels of agility, security and economic control, learn how HPE innovations can help you create a secure hybrid IT environment. Accelerate your digital transformation through HPE Hyperconvergence, composable infrastructure and mission-critical solutions. |
| Day 1 - 17th | 10:45 | 12:00 | SPHINX | Avinash Kumar | Break-Out | DBA_B46 - Intermediate - Managing SQL Server Database, 360 Degrees | Database Administration | Intermediate | Abstract: Your organization depends on SQL Server to support its applications, customers, and employees. But in order for you to maintain productivity, control costs and protect data, your SQL Server environment must be up and running, effectively supported, and secure. We will discuss solutions for SQL Server that can help you maintain optimal performance, minimize the TCO and maximize ROI. |
| Day 1 - 17th | 10:45 | 12:00 | SHILOH | Nikhil Patel / Sudhakar Sannakkayala | Break-Out | DBA_B60 - Intermediate - Unleash Your Data From Oracle With A Move To SQL Server And Azure Sql Database | Database Administration | Intermediate | Abstract: Customers want to move their data from Oracle and other non-Microsoft databases to SQL Server and Azure SQL Database, but they don't have details about the right methods, best practices, and tools, which creates a barrier to pursuing such migrations. In this session, we will review the migration life cycle in detail and provide prescriptive information about how to migrate your Oracle databases to Azure by using Azure Database Migration Service and related tools. We will cover some common migration scenarios and customer case studies that we have assembled based on learnings from our preview and other field engagements with large enterprises. We will also share our roadmap, which will help you plan your enterprise database migrations. Key Learning: After completing this session, you will know just how easy it is to migrate from Oracle to SQL Server and Azure SQL Database when you are empowered with right tools and services, and best practices to use during the process. |
| Day 1 - 17th | 10:45 | 12:00 | YUKON | Manish Sharma / Sudhir Rawat | Break-Out | CLOUD/IoT/NoSQL_B27 - Intermediate - CosmosDB – Let Me Connect Your Vertex | Cloud, IoT & NoSQL | Intermediate | Abstract: Azure DocumentDB which is now formally Cosmos DB completed the acquisition of all four types of NoSql by including columnar, key/value, Document & Graph API. In this session we will demonstrate the following through a Social Networking Platform application: • How to store massive graph’s vertices and edges? • How to query them within milliseconds latency (Guaranteed)? • How to evolve the graph structure & schema easily with minimum code? |
| Day 1 - 17th | 10:45 | 12:00 | KATMAI | Denzil Ribeiro | Break-Out | DBA_B52 - Intermediate - Troubleshooting Common DBA Scenarios On SQL Server On Linux | Database Administration | Intermediate | Abstract: The next version of SQL Server ( SQL 2017 ) brings all the goodness of SQL Server to the Linux ecosystem.This session will cover common DBA troubleshooting scenarios on SQL Server on Linux and an overview of the architecture. In this demo rich session, we will cover various every-day scenarios from startup and configuration to performance and bottleneck analysis. We will discuss existing and new tools that exist that will enable DBA’s to effectively troubleshoot SQL Server on Linux and focus primarily on Linux specific scenarios. Key Learning: Architecture overview Configuration best practices on SQL on Linux Performance monitoring and troubleshooting tool set Demos: 30 mins of Demos |
| Day 1 - 17th | 12:15 | 13:30 | HYDRA | Steve Jones | Break-Out | DEV_B76 - Basic - Git, Branches, And Pull Requests For Database Development | Database Development | Basic | Abstract: Many DBAs and sysadmins have never used version control for any of the the scripts and code they write. Using a version control system (VCS) is a great way to entrance to the world of DevOps. In this session we will start from the basics of git, and build a repository, storing configuration information from SQL Server and Windows in the repository. We will cover branching, merging and pull requests in this interactive look at using the git command line, SourceTree and Gitkrakken. Key Learning: Understand the basic purpose and structure of git through live demos. Become comfortable with taking scripts and storing them in a respository Learn the ways in which multiple people can edit files with branches, use pull requests to signify work is complete, and merge the results together. Demos: Most of the talk is using command line git and GUI git tools to understand how we can store and share our database code. We will look at git setup, commiting code, adding remotes, push/pull, branching, and pull requests |
| Day 1 - 17th | 12:15 | 13:30 | SPHINX | SK Thilakan | Break-Out | DBA_B32 - Intermediate - Storage – Deep Learning on the Hidden Pillar of your Data | Database Administration | Intermediate | Abstract: Storage - while we know about it, these days, its influence for your applications and architecture is becoming ever more important. Times are changing in the world of storage and we are here to help you explain the changes! This informative session is a follow up to our very successful 2015 SSGAS session “SQL and Flash, a perfect marriage”. Come understand what’s new in flash, how we are applying it to Microsoft technologies, and what’s on the horizon. Storage is the true pillar of your data – learn how to make the most of it! |
| Day 1 - 17th | 12:15 | 13:30 | SHILOH | Sanjay Mishra | Break-Out | CLOUD/IoT/NoSQL_B33 - Advanced - Pushing The Envelope: The SQLCAT Way | Cloud, IoT & NoSQL | Advanced | Abstract: At SQLCAT, our day-to-day job is to take the journey to unchartered territories with some of our biggest, most complex customer applications, pushing the envelope of our data platform. Be it on-prem or cloud or hybrid, be it SQL or extra-SQL, be it big data or bigger data, SQLCAT has been in the trenches with our customers. In this session, we bring you some of the selected episodes from those journeys, the experiences, the challenges, the learnings, and the fun. Key Learning: How to stay positive in the face of hardship How to have fun while solving complex problems How to raise bar again and again Demos: Take the road less travelled |
| Day 1 - 17th | 12:15 | 13:30 | YUKON | Parikshit Savjani | Break-Out | DBA_B61 - Advanced - Upgrade To SQL Server 2017: Intelligent Diagnostics Just Built-In | Database Administration | Advanced | Abstract: SQL Server 2016 and SQL Server 2017 Just Works! But if you are a IT Professional you want to be armed with all the right diagnostics to react to a mission critical problem or tune the engine to the needs for your business. Dev-Ops also requires the right tools to build and tune queries for maximum performance. SQL Server 2016 and 2017 have all the diagnostics you need just built-in to the product. These are the foundation for great tools from vendors such as SentryOne, RedGate, SolarWinds, and Idera. We also have intelligence built-into the engine based on these diagnostics to automate, learn, and adapt. In this session we will show you the wide variety of these diagnostics with testimonies from vendors and SQL MVPs. You will learn why SQL Server diagnostics are the best in the industry, built-in, and spans all platforms across SQL Server, Azure, and Linux Key Learning: 1. Understand the breadth and depth of built-in diagnostic choices that exist for SQL Server, Azure SQL Database, and SQL Server on Linux. 2. Hear customer case testimonies and evidence from ISV tool vendors, SQL MVPs, and Microsoft Premier Field Engineering and Support Engineering on how these diagnostics make them successful. 3. Learn new capabilities in SQL Server 2016 and 2017 that provide intelligence based on built-in diagnostics to automate and adapt reducing total cost of ownership and increasing dev-ops and IT efficiency. Demos: Demos on Smart diagnostics introduced in SQL Server 20162017 |
| Day 1 - 17th | 12:15 | 13:30 | KATMAI | Peter Myers | Break-Out | BIA_B07 - Intermediate - Power BI For The Developer: Integrate, Extend, Embed! | Business Intelligence & Analytics | Intermediate | Abstract: Integrate, Extend, Embed! In this session, you will how developers can deliver real-time dashboard scenarios, create custom visuals and embed rich interactive analytics in their apps with Power BI Embedded. This presentation specifically targets experienced app developers, and also those curious to understand what developers can achieve. Numerous demonstrations will put the theory into action. Key Learning: How do app developers can integrate, extend and embed Power BI into their apps. Demos: Real-time dashboards, custom visuals, Power BI content embedding. |
| Day 1 - 17th | 13:45 | 15:00 | HYDRA | Amit Banerjee | Break-Out | BIA_B02 - Advanced - Building 1 Million Predictions Per Second Using SQL-R | Business Intelligence & Analytics | Advanced | Abstract: Using the power of OLTP and data transformation in SQL 2016 and advanced analytics in Microsoft R Server, various industries that really push the boundary of processing higher number of transaction per second (tps) for different use cases. In this talk, we will walk through the use case of predicting loan charge off (loan default) rate, architecture configuration that enable this use case, and rich visual dashboard that allow customer to do what-if analysis. Attend this session to find out how SQL + R allows you to build an "intelligent datawarehouse". Key Learning: Deploying solutions using R with SQL Server Demos: Demo of 1 million transactions/sec |
| Day 1 - 17th | 13:45 | 15:00 | SPHINX | Rangarajan Srirangam / Mandar Inamdar | Break-Out | CLOUD/IoT/NoSQL_B31 - Basic - Enterprise Data Pipelines Using Azure PaaS Services | Cloud, IoT & NoSQL | Basic | Abstract: You might have worked with enterprise data pipelines using the SQL Server suite of products on-premise or on virtual machines on the cloud. With the recent release of Azure Analysis services, the last remaining component has fallen in place to successfully build a similar enterprise data pipeline on the Azure cloud comprised purely of PAAS services. This session, explores the services involved, how they can be put together, key best practices to be kept in mind and the benefits that can be realized. Demos: Demo/Walkthrough on realizing an Enterprise Data Pipeline using Azure PAAS Services |
| Day 1 - 17th | 13:45 | 15:00 | SHILOH | Murilo Miranda | Break-Out | CLOUD/IoT/NoSQL_B30 - Intermediate - Patterns For Building Hybrid Scenarios With SQL Server And Azure | Cloud, IoT & NoSQL | Intermediate | Abstract: SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds. For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost. In this demo-heavy session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure. SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds. Key Learning: Integrating SQL Server and Azure Scaling on-poremises SQL Server using Azure Extending on-premises to the cloud Demos: The demo will demonstrate some of the capabilities of SQL Server when integration with Azure, like backups to blob storage (with or without managed backups), low-cost DR, stretch databases, etc... |
| Day 1 - 17th | 13:45 | 15:00 | YUKON | Santosh Goli | Break-Out | BIGDATA/VLDB_B16 - Advanced - Deep Dive Into ADLA Using U-Sql | Big Data & VLDBs | Advanced | Abstract: Azure Data Lake Analytics, an on-demand analytics job service to power intelligent action. U-SQL is a language introduced with Azure Data Lake Analytics. U-SQL, a query language that extends the familiar, simple, declarative nature of SQL with the expressive power of C#. U-SQL is designed to work on any type of data and any size of data. Its dynamic scaling enables to transform and analyse terabytes and petabytes of data. U-SQL integrates with Visual Studio, the familiar tools can be used to develop faster, debug and tune the code. This session will talk about how users can start using U-SQL in Azure Data Lake Analytics to build, transform and analyse big data. This will also help you in providing you the key learnings and best practices in writing U-SQL code. Increases productivity and agility from Day 1. Key Learning: 1) Understanding the Azure Data Lake Analytics and how U-SQL helps us to transform, process and analyse petabytes of data. 2) How to extend U-SQL with custom code. 3) U-SQL for the SQL developers and common things that SQL developers encounter. Demos: 1) Integration of Azure Data Lake Analytics with Visual Studio. How to create U-SQL scripts and submit the jobs with familiar interface. How to see the physical execution plan and set the Degree of Parallelism. Debugging the U-SQL code. 2) Extending the U-SQL using custom code. 3) How to access the data from Azure Data Lake Store and blob storage. |
| Day 1 - 17th | 13:45 | 15:00 | KATMAI | Shweta Gupta | Break-Out | CLOUD/IoT/NoSQL_B37 - Intermediate - Data Analytics In Internet Of Things World | Cloud, IoT & NoSQL | Intermediate | Abstract: Internet of Things (IoT) has driven embedded technologies to the next generation. We have smart sensors, meters, devices that can send data every second. Systems are streaming in millions of data points every minute. However, true success of any IoT system is making use of its data. However, role of data processing and analytics is quite underplayed while building such systems. This data can be tapped for predictive/preventive/reactive analytics, decision making and actions, extending beyond live dashboards and reports. In addition to the large-scale ingestion, IoT data processing and analytics require non-traditional approaches. Such as time series analytics, edge and stream analytics, predictive analytics. There are several Big data options that make a good fit, Spark/Hadoop/Microservices & many more. Through this session we will walk through typical challenges, architecture patterns, demo some code and evaluate technology options available, to build a scalable IoT data processing systems. Key Learning: Through this session audience will learn key principles that they can apply to build production scale IoT System analytics. The audience will also appreciate the scale and varied nature of data that is generated by IoT systems and the fact that they need a non-traditional approach. Demos: The demo will be a micro services based device simulator that simulates 1000s of devices and is sending data on cloud at large scale. There will be a demo of edge analytics, following which the demo will depict data being run through Stream Analytics, Time series modelling , live dashboards and adhoc reporting through data lake. |
| Day 1 - 17th | 15:30 | 16:45 | HYDRA | Ajay Jagannathan / Sudhakar Sannakkayala | Break-Out | DBA_B44 - Intermediate - Digitally Transform Your Business Through Migration And Modernization Of Your Data To SQL Platform Of Your Choice | Database Administration | Intermediate | Abstract: Today’s organizations must adapt quickly to change, using new technologies to fuel competitive advantage, or risk getting left behind. Organizations understand that data is a key strategic asset which, when combined with the scale and intelligence of cloud, can provide the opportunity to automate, innovate, and increase the speed of business. Be it SQL Server, Azure SQL Database or Azure SQL Database Managed instance, learn how to migrate to any of these platforms easily using the Azure Database Migration Service and related tools. We'll cover various aspects of the migration lifecycle from assessment, remediation, data movement to validation and you will learn how easy it is to migrate and modernize your data platform when you are empowered with the right tools. Key Learning: Learn various aspects of migration lifecycle. Understand common issues encountered during a migration or modernization project. Learn and use all the tools to make the migration experience smoother. Demos: End to End migration |
| Day 1 - 17th | 15:30 | 16:45 | SPHINX | Madhan Gajendran / Guru Charan B | Break-Out | CLOUD/IoT/NoSQL_B25 - Basic - CosmosDB – SLA Based Multimodal Database | Cloud, IoT & NoSQL | Basic | Abstract: In this session, we will provide an overview of Azure Cosmos DB and its distinguished capabilities such as how it provides global distribution, multi-modal APIs, low latency access with schema free indexing, various consistency levels backed by enterprise grade SLAs. Throughout the discussion we will touch upon the architecture that power these capabilities. This session primarily targets solution architects, developers who target scenarios such as e-commerce, gaming, IoT, social media, content management etc.. Key Learning: Key takeaways about be to understand the capabilities of Cosmos DB, use cases / scenarios where Cosmos DB is generally applicable Demos: How to build your first app on top of Azure Cosmos DB |
| Day 1 - 17th | 15:30 | 16:45 | SHILOH | Chris Testa-O Neill | Break-Out | DATASCIENCE_B18 - Basic - Cortana Intelligence And Data Science For SQL Server Professionals | Data Science | Basic | Abstract: The Cortana Intelligence Suite provides an array of cloud based technologies that enable the storage, analysis and presentation of data into intelligent information. This session will explain: • What is the Cortana Intelligence Suite • The Types of Advance Analytics • The Team Data Science Process • The Cortana Intelligence Suite Platform • How can SQL Server Professional fir into Data Science At the end of this session, you will have a clear understanding of what Cortana Intelligence is, and how you can implement some of its available technologies through demos, Key Learning: Key learning points: • What is the Cortana Intelligence Suite • The Types of Advance Analytics • The Team Data Science Process • The Cortana Intelligence Suite Platform • How can SQL Server Professional fir into Data Science Demos: Machine Learning demo |
| Day 1 - 17th | 15:30 | 16:45 | YUKON | Peter Myers | Break-Out | DATASCIENCE_B24 - Basic - Azure Machine Learning: From Design to Integration | Data Science | Basic | Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions. In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications. This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished. Key Learning: Defining and demonstrating Machine Learning Demos: End-to-end machine learning and application embedding |
| Day 1 - 17th | 15:30 | 16:45 | KATMAI | Rob Farley | Break-Out | DEV_B73 - Advanced - Deep Dive Into Joins | Database Development | Advanced | Abstract: Joins are a thing you learn on Day 1 of T-SQL 101. But they are so much more involved than what you learn there. Secrets of the ON clause, logical v physical, Anti-Semi-Joins, not to mention the times when you thought you specified one kind of join and the execution plan says it's doing something else. Luckily, it's not magic - it's all very straightforward once you understand the different types of joins and how they work. This session will cover the different types of logical and physical joins – and even look at joins that don't exist at all. Key Learning: They will leave with a good understanding of what's going on with Joins and be able to approach queries with a stronger confidence. Demos: Lots of demos about joins. |
| Day 1 - 17th | 17:15 | 18:30 | HYDRA | Denzil Ribeiro | Break-Out | DBA_B53 - Intermediate - SQL Server 2017 Database Engine Features That Every DBA Should Know | Database Administration | Intermediate | Abstract: SQL Server 2017 release has generated a lot of buzz specifically about enabling choice of platform. In this session we will cover core database Engine innovations that help the life of a DBA such as enhancements on Query store, Plan Regression correction, Query processor changes , changes in index maintenance and others. Key Learning: Learn about key features that will help the life of a DBA Awareness of key features in the release that are cross platform. Demos: Most features discussed will have an associated Demo (20 mins+) |
| Day 1 - 17th | 17:15 | 18:30 | SPHINX | Subramani Paramasivam | Break-Out | DATASCIENCE_B38 - Basic - Beginning Data Science-From Novice To Professional | Data Science | Basic | Abstract: Where to begin the step 1 of data science to become a Data scientist? What are these Data Scientists up to? This is an initial data science session, for a novice and learn how easily you can step in to Data Science and start to become a professional. How can we see and try using a data scientist statistical model in our day to day familiar tool like Microsoft SQL Server? Thanks to Microsoft for integrating R Revolution within SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016 and also to utilize it for any applications and/or Reporting services. Key Learning: Data Science Basics Migration plan to Data Science Statistical analysis using Program R R visualization within SQL Server 2016 Demos: Revolution R Basics & Environment Revolution R Visualization in R Studio Revolution R within Microsoft SQL Server 2016 |
| Day 1 - 17th | 17:15 | 18:30 | SHILOH | Denny Cherry | Break-Out | DBA_B51 - Intermediate - Optimizing SQL Server Performance In A Virtual Environment | Database Administration | Intermediate | Abstract: In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be. This will include how to look for CPU performance issues at the host level. We will also be discussing the Memory Balloon drivers and what they actually do, and how you should be configuring them, and why. We'll discuss some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server. Then we will finish up with some storage configuration options to look at. Key Learning: Virtualization Demos: None |
| Day 1 - 17th | 17:15 | 18:30 | YUKON | Satya Jayanty | Break-Out | BIGDATA/VLDB_B17 - Intermediate - Big Data With Azure: Where To Begin? Concepts And Best Practices | Big Data & VLDBs | Intermediate | Abstract: An updated session and presentation on Big Data concepts. In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure. Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform. Key Learning: Big Data offerings and concepts Apache & Microsoft - best of both worlds. Best practices in keeping up their skills Where to begin their big data journey Demos: 30% |
| Day 1 - 17th | 17:15 | 18:30 | KATMAI | Amit Khandelwal / Sumit Sarabhai | Break-Out | BIA_B03 - Intermediate - Analytics Using Hadoop And Sql Server 2016 Polybase, R, SSRS & Power BI | Business Intelligence & Analytics | Intermediate | Abstract: The recent release of SQL Server 2016 provided the capability to use SQL Server as the hub in a hub and spoke model. Our hub will use a Polybase Scale out Cluster, R Services, SSRS and Power BI Reports. The technology is impressive, but data needs to be interesting. We used some public data to create a dataset of a leading sport. We used these capabilities and this data to understand how to leverage SQL Server to offer new capabilities, interact with big data, and display these results in modern visualizations. Key Learning: This session will help audience understand how to leverage these SQL Server 2016 Polybase, Hadoop basics, R services and Power BI, set up an environment like ours in Azure or on-premises, and utilize our demos and datasets. Demos: Demo for Polybase setup and implementation. Using Hadoop for big data analytics. |
| Day 2 - 18th | 08:30 | 09:45 | HYDRA | Denny Cherry | Break-Out | DBA_B50 - Basic - How To Maintain The Same Level Of Utilities In Cloud Deployments - Securability, Reliability And Scalability”. | Database Administration | Basic | Abstract: In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective. We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches. We'll review the common performance problems which people encounter, and how to resolve them. We'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines. Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016. Key Learning: Securability, Reliability and Scalability in Azure Demos: Azure portal, maybe. |
| Day 2 - 18th | 08:30 | 09:45 | SPHINX | Manish Sharma / Guru Charan B | Break-Out | CLOUD/IoT/NoSQL_B26 - Intermediate - CosmosDB – Performance Best Practices | Cloud, IoT & NoSQL | Intermediate | Abstract: In this session we will discuss best practices to ensure optimal performance of Applications developed on Document DB and detail out implementation strategy which considers them. We shall also discuss the viability and considerations of individual best practices followed by Q&A. The inception of CosmosDB was to provide born-in-the cloud high performant and scalable database. CosmosDB doesn’t restrict developer to use specific model instead let them leverage multi-model design which can span from key/value to GraphDB. It also addresses the integration & migration challenges. |
| Day 2 - 18th | 08:30 | 09:45 | SHILOH | Karthick Krishnamurthy | Break-Out | DBA_B57 - Advanced - Debugging SQL Server Memory Dumps. | Database Administration | Advanced | Abstract: SQL Server’s operating system has capability to generate memory dump of SQL Server process when it detects unusual condition in process execution, these dumps are often misunderstood as SQL Server bugs but majority of these dumps are generated because of external conditions and contains info to identify the problems in the design of SQL Server database systems and external environments like hardware, windows etc. This session will cover information about different types and conditions in which dumps are generated by SQL Server with demo’s on when the dumps are generated and how to analyze them using simple debugging techniques. Key Learning: 1. When and how SQL Server generates memory dumps. 2. How to analyze the memory dumps, identify the cause and fix them using public symbols. 3. To educate SQL Server memory dumps are generally not a SQL Server problem but an in build mechanism in SQL Server to detect problems in environment and report. After attending this session audience would be able to understand the scenarios in which SQL Server generates them, analyze the SQL Server memory and possibly fix the root cause. Demos: Demo to make SQL generates dump and analysis. |
| Day 2 - 18th | 08:30 | 09:45 | YUKON | Nagaraj Venkatesan | Break-Out | DBA_B59 - Intermediate - How To Enhance DBA Productivity Using R And SQL Server 2016 | Database Administration | Intermediate | Abstract: "R", the latest buzzword in Data Platform has all along been viewed as programming language for Data Scientists. However, "R" can be a handy tool for database administrators too. The presentation will show case how "R" can be used innovatively by Database Administrators to handle some of their common problems like tracking query regressions, capacity planning and detecting performance abnormalities. The session will introduce few algorithms of "R" and showcase how it can be used in DBA's world. The session would serve as a good starting point for DBA's exploring the world of "R" Key Learning: 1) Understanding on R and Data Science algorithms 2) Understanding on Logical Regression, Linear Regression and Time Series data science algorithms 3) Areas of application of the above data science algorithms for the DBA 4) Best practices for configuring "R" on SQL Server 2016 Demos: 1) Use Logical Regression to predict / track expensive queries 2) Use Linear Regression on "Query Store's" table / data to predict query execution times and track query regression. 3) Use Time Series algorithm to predict database growth and perform capacity planning 4) Use R Studio histograms to size maxdop setting correctly |
| Day 2 - 18th | 08:30 | 09:45 | KATMAI | Selvakumar Rajakumar | Break-Out | BIA_B10 - Intermediate - Awesomeness Of Power BI With In Reporting Services | Business Intelligence & Analytics | Intermediate | Abstract: Power BI is our cloud based reporting and analytics offering which has been the hot cake around the globe. In order to give that great experience to our on-premise customers, Microsoft has been relentlessly working to bring in that feature in to Reporting Services. In this session, we would experience that awesomeness along with other new features within the VNext of Microsoft SQL Server Reporting Services. Key Learning: What is new is Reporting Services vNext. Create and deploy Power BI reports to On-premise Reporting Services Visually experience the Power BI reports Troubleshooting approaches for common scenarios. Demos: Create and deploy Power BI reports to On-premise Reporting Services |
| Day 2 - 18th | 10:15 | 11:30 | HYDRA | Ramu Raghavan | Break-Out | DBA_B19 - Intermediate - Composable Infrastructure – How To Turn Ideas Into Value? | Database Administration | Intermediate | Abstract: Discover how HPE composable infrastructure solutions can transform Your IT and DevOps to add speed and agility for the idea economy. Use this composable infrastructure platform to configure physical and virtual compute, Storage and fabric pools for any application. |
| Day 2 - 18th | 10:15 | 11:30 | SPHINX | Ajay Jagannathan | Break-Out | DBA_B43 - Advanced - Life In The Fast Lane With SQL Server In-Memory OLTP | Database Administration | Advanced | Abstract: Learn how the "Hekaton" engine works behind the scenes to deliver the amazing 30x performance improvements seen for customers moving to In-Memory OLTP. This session will include a look behind the scenes at threads, data and index design, transactions and concurrency, logging, storage, and natively compiled procedures. We will go into detail with scenarios, architectures, and actual customer case studies. Key Learning: Explain how in-memory OLTP works to deliver upto 30x performance gains. Articulate the difference between SQL Server transactions and In-Memory OLTP transactions Understand the value and key scenarios where in-memory OLTP can be leveraged for customer applications. Demos: How to use in-memory OLTP Debugging natively compiled stored procs Inside in-memory checkpoint Customer case studies |
| Day 2 - 18th | 10:15 | 11:30 | SHILOH | Sandy Winarko | Break-Out | BIA_B09 - Advanced - Deep Dive Into SSIS 2017 And Beyond | Business Intelligence & Analytics | Advanced | Abstract: See how to use the latest SQL Server Integration Services (SSIS) 2017 to modernize traditional on-premises ETL workflows, transforming them into scalable hybrid ETL/ELT workflows in preparation for Big Data Analytics workloads in the cloud. We will showcase the latest additions to SSIS Azure Feature Pack, introducing/improving connectivity components for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), and Azure HDInsight (HDI). We will also take a deep dive into SSIS Scale-Out feature, guiding you end-to-end from cluster installation to parallel execution, to help reduce the overall runtime of your workflows. Finally, we will show you how to orchestrate/schedule SSIS executions using Azure Data Factory (ADF) and share our cloud-first future roadmap for SSIS. Key Learning: After attending this session, the audience will be able to 1) Generally use SSIS 2017 themselves or recommend/guide their customers to use it to modernize traditional on-premises ETL workflows, transforming them into scalable hybrid ETL/ELT workflows in preparation for Big Data Analytics workloads in the cloud. 2) Specifically use SSIS Azure Feature Pack to connect Azure store/compute resources, SSIS Scale-Out feature to run packages in parallel, and ADF to orchestrate/schedule SSIS executions. Demos: Running SSIS packages in parallel via SSMS and orchestrating/scheduling SSIS executions via ADF. |
| Day 2 - 18th | 10:15 | 11:30 | YUKON | Abhishek Narain | Break-Out | BIA_B01 - Basic - Build End-To-End Advanced Analytics Solution Using Cortana Intelligence Suite | Business Intelligence & Analytics | Basic | Abstract: The Cortana Intelligence Suite is a Platform and a Process you can use to create advanced analytic solutions, end to end. In this session, you will learn about the different technical component, getting started guide and end-to-end scenario showcase leveraging Cortana Intelligence suite. Key Learning: -> Building Big Data Analytics solutions -> What is Cortana Intelligence Suite Demos: -> Anomaly Detection in Real-time Data Streams -> Campaign Optimization with Azure HDInsight Spark Clusters |
| Day 2 - 18th | 10:15 | 11:30 | KATMAI | Subramani Paramasivam | Break-Out | DEV_B78 - Advanced - On-Prem SSRS 2016 For Non-Ad Users | Database Development | Advanced | Abstract: There has always been a challenge of publishing an on-prem developed reports to external clients (non-AD users) and this has been decently achieved for a very simple requirement. But how does this solution would work for a non-AD user, if SSRS 2016 Mobile Report is published to Sharepoint and then enabling ADFS & external IDaaS (Identity as a Service) to view the report and render only their own specific data. Key Learning: SSRS 2016 Mobile Reports, ADFS Configuration, IDaaS (3rd Party Authorization) Demos: SSRS 2016 Mobile Reports, ADFS Configuration, IDaaS (3rd Party Authorization) |
| Day 2 - 18th | 11:45 | 13:00 | HYDRA | Jimmy May | Break-Out | DBA_B55 - Advanced - SQL Server 2016 Always On Availability Groups Perf & Internals | Database Administration | Advanced | Abstract: Always On Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code—both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved. Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs. 1. Revealing the fantastic perf enhancements in SQL Server 2016 AGs 2. Sharing SQL Server 2016 AGs Log Transport & Log Redo improvements & internals 3. Documenting the benefits SQL Server 2016 on all flash storage environments, including how to use perform to observe µsec disk latencies |
| Day 2 - 18th | 11:45 | 13:00 | SPHINX | Amit Banerjee | Break-Out | CLOUD/IoT/NoSQL_B40 - Basic - Azure Database for MySQL and PostgreSQL | Cloud, IoT & NoSQL | Basic | Abstract: Azure Database for MySQL and Azure Database for PostgreSQL are managed database services built for developers using the community edition of MySQL PostgreSQL. Learn how you can leverage these new choices of managed database services to build scalable, secure and intelligent apps. Using insights from current customer scenarios and through live demos, we walk through the service management capabilities, best practices to move your databases to the service, and also focus on how the Microsoft Azure ecosystem of app and data services is unlocking the potential of MySQL and PostgreSQL in the Azure cloud platform. |
| Day 2 - 18th | 11:45 | 13:00 | SHILOH | Manish Sharma / Sudhir Rawat | Break-Out | CLOUD/IoT/NoSQL_B28 - Intermediate - CosmosDB – Exploring Multi-Modal Database Mongo & Table API | Cloud, IoT & NoSQL | Intermediate | Abstract: In this session we demonstrate: • How to migrate existing code using MongoDB to CosmosDB with data without making any code changes? • How to develop application using Key/Value based table API of CosmosDB? |
| Day 2 - 18th | 11:45 | 13:00 | YUKON | Deepthi Anantharam | Break-Out | BIA_B05 - Basic - Azure Ananlysis Services - Usage Scenarios | Business Intelligence & Analytics | Basic | Abstract: Azure Analysis Services, is based on the proven analytics engine in SQL Server 2016 Analysis Services. Customers can access data sources across on-premises and the cloud, model that data, and provide business users with a simplified view of their data to enable interactive self-service BI and data discovery using their preferred data visualization tool. We will delve deep into the PaaS Services understanding all facets of this service and its usage scenarios Key Learning: Usage of Analysis services in data analytics and usage scenarios; Usage of PaaS Services on Azure Analysis Services Demos: Using Analysis Services on Azure Portal Modelling and Caching Key Capabilities Consuming Analysis Services Models Scalability |
| Day 2 - 18th | 11:45 | 13:00 | KATMAI | Uwe Ricken | Break-Out | DBA_B64 - Intermediate - Inside Statistics Or… - A Guessing Game | Database Administration | Intermediate | Abstract: suffers from performance problems? What will you do in such a situation? • you may restart SQL Server (did work all the other times before) • you drop the procedure cache (has been told by a dba) • you get yourself a coffee and think about what you have learned in this session Microsoft SQL Server requires statistics for ideal execution plans. If statistics are not up-to-date, Microsoft SQL Server may create execution plans that run a query many times slower. In addition to the basic understanding of statistics, special sessions are shown in this session that are only known to a small group of experts. After a brief introduction to the functionality of statistics (Level 100), the special query situations, which lead to wrong decisions without experience, are immediately apparent. The following topics are covered by usage of large number of demos: • When will statistics get updated? • examples for estimates and how they can go wrong? • outdated statistics and ascending keys? • when will outdated statistics updated for unique indexes? • drawback of statistics in empty tables? Follow me on an adventurous journey through the world of statistics of Microsoft SQL Server. Key Learning: The audience will get familiar with the basic concepts of statistics and will see scenarios where the correct understanding of statistics will boost their queries. Demos: 70% |
| Day 2 - 18th | 13:15 | 14:30 | HYDRA | Victor Isakov | Break-Out | DBA_B65 - Advanced - Query Store: A (R)Evolution In Query Tuning | Database Administration | Advanced | Abstract: Fixing performance problems and detecting query regressions has never been easy in SQL Server as the database engine fundamentally does not capture the relevant information. With the release of SQL Server 2016, Microsoft has introduced a feature called Query Store that will help you capture vital query metrics that will help performance troubleshooting and regression detection. In this session we will examine Query Store and how it can be used in a myriad of use cases. We will examine its architecture, configuration and shortcomings. This session will help you build a comprehensive monitoring solution that will help you detect and solve real-world performance problems across your entire SQL Server infrastructure. Key Learning: Understand Query store architecture and limitations. How to configure, use and enhance Query Store. How to Force Plans. Demos: Demonstrate Query Store in action and how to force plans |
| Day 2 - 18th | 13:15 | 14:30 | SPHINX | Satya Jayanty | Break-Out | DATASCIENCE_B34 - Intermediate - Make Your Data Worth Out From Data Science And Data Analytics | Data Science | Intermediate | Abstract: The future of dataand databases - with fast pacing data analytics and data science evolution it is a big question for every data geek! In this session let us go through holistic view onto database evolution and data explosion. See the objectives with Data vs: developers, analysts, users, business and DBAs How to mode and predict like a data scientist? The key indicators in database evolution - Pre-relations, Relational and Post-relational Key Learning: Step into data science world. How helpful the latest trends and technologies Where to begin in terms of learning and skill development Demos: 20% |
| Day 2 - 18th | 13:15 | 14:30 | SHILOH | Andreas Wolter | Break-Out | DEV_B69 - Basic - SQL Server Security For Developers | Database Development | Basic | Abstract: A system is only as secure as its weakest link. In this session you will see lots of techniques and best practices which should be in every developer’s toolbox to tighten your databases' security. Among them: how to correctly use schemas to enforce and at the same time simplify security; ownership-chaining as well as its pitfalls; the use of code signing; Row level Security and Always Encrypted for even higher security needs. Security can be simple, if it is considered from the design-phase onwards and the right technique for the demands is implemented – and your Admin will be grateful, too. Key Learning: Basic security skills like how to use schemas and which techniques to use for what aim Demos: Schema-ownership chaining, RLS, Alway Encrypted |
| Day 2 - 18th | 13:15 | 14:30 | YUKON | Pranab Majumdar | Break-Out | DBA_B08 - Intermediate - Demystifying SQL Server Performance on Azure VM (IaaS) | Database Administration | Intermediate | Abstract: We can reduce the TCO of deployment, management and maintenance using Azure as a hosting environment for SQL Server virtual machines. However, we can't forsee the issues we might face. This talk covers some of the best practices and recommendations to help optimize the performance and increase the availability of SQL Server on Azure IaaS. By proper configuration we can optimize SQL Server disk performance within Azure storage by getting the right throughput (Input Output Operations/Second). This way we can optimize and use azure storage and provisioning of disks to maximize the performance of SQL Server on Windows Azure IaaS VMs..If you want to know how to enhance the performance, learn the best practices and generally soak in to how you can get the best out of the so called black box, you can join this session. |
| Day 2 - 18th | 13:15 | 14:30 | KATMAI | Murilo Miranda | Break-Out | DBA_B58 - Basic - High Availability And Disaster Recovery Patterns With SQL Server And Windows Server 2016 | Database Administration | Basic | Abstract: Cloud, cloud and cloud. That's all we hear nowadays, but there's still life out of the Cloud! Windows Server 2016 and SQL Server 2016 can together broader the capabilities of your systems. With regards to High Availability and Disaster Recovery, we have more flexibility by taking advantage of the improved AlwaysOn Availability Groups, Windows Server Failover Cluster and, of course, Azure's integration. During this session we will explore those new possibilities, checking what is new, the current limitations and what we can build by taking advantage of all the improvements. Key Learning: New HA & DR improvements on SQL Server 2016 and Windows Server 2016. Some examples of HA/DR/LB scenarios and its classification in terms of RTO, RPO and budget. Demos: Quick demo showing how the solution work in a multi-domain environment. |
| Day 2 - 18th | 14:45 | 16:00 | HYDRA | Siva Harinath | Break-Out | BIA_B11 - Intermediate - Creating Enterprise Grade BI Models With Analysis Services | Business Intelligence & Analytics | Intermediate | Abstract: Microsoft Azure Analysis Services and SQL Server Analysis Services enable you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Analysis Services enables consistent data across reports and users of Power BI. Demos: The demos will cover new features such as improved Power BI Desktop feature integration, Power Query connectivity, and techniques for modeling and data loading which enable the best reporting experiences. Various modeling enhancements will be included such as Detail Rows allowing users to easily see transactional records, deployment and application-lifecycle management (ALM) features to bridge the gap between self-service and corporate BI. |
| Day 2 - 18th | 14:45 | 16:00 | SPHINX | Hamish Watson | Break-Out | DEV_B70 - Intermediate - Making DevOps Work In The Real-World… | Database Development | Intermediate | Abstract: DevOPs allows developers and DBAs alike to streamline and automate the process of software delivery of their data platform. By using a realistic live demonstration and great technologies such as the Azure platform, Docker, Team Foundation Server, Visual Studio Team Services , SQL Server Data Tools I will show how DevOps can help you design, create, manage and automate deployments reliably and repeatedly to your production applications. You will be able to take what you learned in this session and implement it successfully in your organisation. Key Learning: The audience will learn the concepts of DevOPs and after the session know what they need to do to both implement it and the benefits from implementing it. The audience will learn how to implement Continuous Integration and Continuous Delivery in the real world and how it will make their work lives easier. The audience will learn how to deploy easily to the Azure platform using various methods. The audience will learn how SQL Server Data Tools can improve the reliability of their database deployments and also how it can be automated across a deployment pipeline. Demos: The DEMO will encompass how Continuous Integration and Continuous delivery work and how they tie back to the benefits of being able to deploy automatically, reliably and repeatably to PRODUCTION database and application systems. The DEMO will showcase how much of a game changer Azure SQL databases are and the overall Azure platform for deploying systems. The DEMO will appeal to both DEV and DBA and also operational/infrastructure people. The DEMO will be live but I always record it just in case there are any issues onsite. |
| Day 2 - 18th | 14:45 | 16:00 | SHILOH | Joe Yong | Break-Out | BIGDATA/VLDB_B15 - Intermediate - Azure SQL Data Warehouse Lessons Learned And Recommended Practices | Big Data & VLDBs | Intermediate | Abstract: Whether you just started with SQL DW or have been running your enterprise data warehouse on it for some time, you may have spent time and effort trying to figure out how to load Terabytes of data per hour or support thousands of concurrent users even though the maximum concurrent queries executed is 32. You have spent countless hours investigating why do some queries run faster than others though all are accessing the same table. This session will share some of the lessons learned from enterprise customer engagements by the SQL DW product group and SQL Customer Advisory Team (CAT). It will also provide practical recommendations on how to optimize your data warehouse design, monitoring and troubleshooting processes so you can benefit from our experience in working with some of the largest enterprise data warehouses. This session will cover some advanced topics but will be delivered in a way that anybody with intermediate database knowledge will be able to grasp. Key Learning: best practices and lessons learned from major enterprise customer deployments of azure sql dw Demos: Data loading, security, monitoring and troubleshooting. |
| Day 2 - 18th | 14:45 | 16:00 | YUKON | Hariharan Rajendran | Break-Out | CLOUD/IoT/NoSQL_B21 - Intermediate - Exploring Azure SQL Data Sync | Cloud, IoT & NoSQL | Intermediate | Abstract: Are you in a situation to replicate the data between on-premises and cloud in real time? If yes, this session is definitely for you, and if no, you still can get to know the new cloud-based data sync feature. In this session, you will also learn how to configure the data sync to replicate your databases between cloud and on-premises. It also includes the different conflict policies and directions of data movement. This session will give you the advice and best practices in terms of setting up a new Azure data sync in your environment Key Learning: The audience will be able to understand, what is Azure Data Sync and how to configure for various scenarios. Also, they will get best practices to follow while configuring the setup. Demos: As part of this demo, I will be setting up the data sync from the scratch and show the workflows with live scenarios. |
| Day 2 - 18th | 14:45 | 16:00 | KATMAI | Prince Rastogi | Break-Out | DBA_B23 - Basic - SQL Server Delayed Durability - Way to Control D of ACID | Database Administration | Basic | Abstract: SQL Server follows ACID properties and by using Delayed durability feature we can control the behavior of D. This feature can provide you the huge performance gain but at some cost. Join this Demo oriented session to enhance the performance of workload. Key Learning: 1- ACID properties 2- Full Durability and its internal working 3- Delayed Durability and its internal working 4- pros and Cons 4- Control Level 5- Limitations Demos: Delayed Durability in action |
| Day 2 - 18th | 16:30 | 17:45 | HYDRA | Steve Jones | Break-Out | DEV_B77 - Intermediate - Unit Testing T-SQL Code | Database Development | Intermediate | Abstract: Unit testing has become an integrated, expected part of most software development teams. Many database developers have yet to implement unit testing as a regular habit. In this session, we will look at two unit testing frameworks and show how we can implement tests for common types of non-trivial T-SQL queries. We will examine the tSQLt framework as well as the Microsoft Unit Testing framework for SQL Server. Key Learning: Learn how to structure and build unit tests for database code with tSQLt Learn how to structure and build unit tests for database code with database projects Understand the challenges of test data and how to solve them. Demos: Numerous demos of how to write unit tests in T-SQL. We will look at checking for coding standards, including indexes, looking for logic errors, 0-1-some testing, and mocking external calls. |
| Day 2 - 18th | 16:30 | 17:45 | SPHINX | Amit Khandelwal / Sumit Sarabhai | Break-Out | DEV_B68 - Advanced - Nuances Of Real Time Analytics With SQL 2016 For SQL DBAs | Database Development | Advanced | Abstract: This session will deal with how Columnstore indexes can be used together with SQL to unleash superior performance for the reporting and data warehouse queries at the same time how the environment can be controlled to ensure that OLTP transactions do not get affected by the Columnstore indexes created for real time analytics. This will be a session with demos to show case Real time analytics and how Columnstore indexes is the answer for reporting queries. Key Learning: SQL DBA, Developers Demos: Demo on Real time analytics using Columnstore index and if time permits using Columnstore index and in memory. |
| Day 2 - 18th | 16:30 | 17:45 | SHILOH | Anupama Natarajan | Break-Out | BIA_B04 - Intermediate - Empowering Your Business With Measure, Act And Automate Using Power Trio Tools | Business Intelligence & Analytics | Intermediate | Abstract: Flow (Automate) and Powerapps (Act) along with Power BI (Measure) caters power users to build and deliver solutions without writing any code. In this session, I will walk you through a) What is Microsoft Business Application Platform? b) What is Flow and how to use it for automation? c) What is Powerapps and how to create an app without writing code? d) How to create an business application using Flow, Powerapps and Power BI? A Demo filled session with a scenario applicable to multiple domains (Utilities, telecommunications etc) Key Learning: Audience will get to learn about Flow and PowerApps and how to use these tools in conjunction with Power BI to provide solutions for real world problems Demos: Outages information is really key for any industry e.g. network, power outages. These outages can be either planned or unplanned and industries need to be prepared to get this information instantly and act upon immediately. In this session, I am going to show a demo on capturing planned and un-planned outages using flow and using powerapps to add additional meta data to the outage and then publish the outages in a Power BI Dashboard for consumers. |
| Day 2 - 18th | 16:30 | 17:45 | YUKON | Avanish Panchal | Break-Out | DBA_B49 - Intermediate - SQL Server Capabilities Extended To Linux | Database Administration | Intermediate | Abstract: Year 2016/2017 so far proven as a data driven world and Microsoft has first ever extended SQL Server capabilities to Linux operating system. Lot of excitement around this expansion. A demo driven session talks about an industry leading, least vulnerable & intelligent RDBMS i.e. SQL Server vNext. Session goes in detail with plan, build, operate methods & features yet to be supported. Microsoft SQL Server 2017 (vNext) on Linux is planned to be launched for end of May 2017. Key Learning: - A high level architecture of SQL Server on Linux - Security - Install SQL Server on Linux - Configure SQL Server on Linux - Operate with SQL Server on Linux - Tools for day-in-day work with SQL Server on Linux. - Features not supported with SQL Server on Linux Demos: 30 minutes demo of SQL Server 2017 (vNext) on Linux, which included installation, configuration & management. Also talks in details with different tools involved for developers/dbas/IT professional to play around nicely with this new expansion of SQL Server. |
| Day 2 - 18th | 16:30 | 17:45 | KATMAI | Joey D Antoni | Break-Out | DBA_B56 - Intermediate - Using SQL Server 2016 To Accelerate Your Business | Database Administration | Intermediate | Abstract: Come to this session to learn how a leading real estate data company counts on SQL Server 2016 to run their business. In this technical session you learn from the over a year of real-world experiences with SQL Server 2016 to help you with evaluating and adopting SQL Server 2016 in your environment. Technologies they have adopted and will highlight with SQL Server 2016 include Availability Groups, Columnstore, R Services and Temporal tables. Key Learning: Key valued added features of SQL Server 2016, and which ones are now available in standard edition with SP1. Demos: Demo of temporal tables, and columnstore performance enhancements. |
| Day 3 - 19th | 08:45 | 10:00 | HYDRA | Parikshit Savjani / Tejas Shah | Break-Out | DEV_B71 - Advanced - Gems To Turbocharge Your SQL Server Query Performance | Database Development | Advanced | Abstract: As DBAs and developers, you are often tasked to tune and optimize your queries for performance, better resource utilization and improve overall scalability of your workloads running on SQL Server. In this session you will learn about SQL Server enhancements in the most recent versions that can help you troubleshoot query performance. Ranging from new xEvents to Showplan improvements, from LQS (and underlying infrastructure) to the revised Plan Comparison tool, learn how these can help you streamline the process of troubleshooting query performance and gain faster insights. The target audience for the session could be any roles that want to learn what’s available to aid in SQL Server query troubleshooting space. That can be the developer that needs to squeeze every ounce of performance from his queries, to the DBA that has to understand the problem space of an ongoing performance issue. Key Learning: The key takeaways from the session would be tips and tricks to tune your query performance to make it run faster on SQL Server Demos: Demos of poorly written or performing queries and showcasing how to troubleshoot and tune query performance leveraging the improvements in recent version of SQL Server. |
| Day 3 - 19th | 08:45 | 10:00 | SPHINX | Sourabh De | Break-Out | BIGDATA/VLDB_B13 - Intermediate - Building Robust Big Data Architectures using Azure Data Lake | Big Data & VLDBs | Intermediate | Abstract: If you don’t have a ‘Data Strategy’ for your Organization today then you do not have a strategy at all. Data Lakes are an imperative part of your data strategy. So how to architect a Big Data solution in Azure using various offerings from Microsoft as well as Open Source components. This talk prepares you with the firsthand knowledge of how to architect a big data solution on the cloud, the components to use, their advantages over each other and how to optimize the op-ex as your business grows. Key Learning: With multiple real life examples the presentation takes you through the journey of creating a robust enterprise grade solution. Demos: It has a real world demo also which showcases a big data solution in the cloud. To top it all there is a surprise element where you can do a live sentiment analysis for your tweet. |
| Day 3 - 19th | 08:45 | 10:00 | SHILOH | Hamish Watson | Break-Out | DBA_B54 - Intermediate - DevOps And The DBA | Database Administration | Intermediate | Abstract: You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration & Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery. Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline. Key Learning: This session is directed more around DBAs who have to do manual tasks and do not utilise Continuous Integration and/or Continuous Delivery. The audience will learn how important source control is for database changes - often application code is in source control but database code is not. The audience will learn how SQL Server Data Tools can optimise the efficiency of database code deployment. The audience will learn about Object Relation Mapping and how it can too assist with deploying to databases. Demos: The DEMO is in 3 parts: Creating a model of the proposed database solution. Implementing the model into Continuous Integration Deploying the changes to databases using Continuous Delivery It will involve using SQL Server Data Tools, Entity Framework, DACPACs and Azure SQL. |
| Day 3 - 19th | 08:45 | 10:00 | YUKON | Vijay Rodrigues | Break-Out | DBA_B67 - Intermediate - High Performance For SQL Server On Azure Virtual Machines | Database Administration | Intermediate | Abstract: The performance of SQL Server (and SQL Server AlwaysOn) depends on many factors such as the size of virtual machines, and the configuration of the data disks. In this session, we'll talk about higher performance with appropriate virtual machine sizes, best practice implementation through provisioning such VMs through portal with Azure Resource Manager, supporting production workloads through premium storage, temporary disk drive usage for appropriately sized VMs etc. Key Learning: The performance of SQL Server (and SQL Server AlwaysOn) depends on many factors such as the size of virtual machines, and the configuration of the data disks. In this session, we'll talk about higher performance with appropriate virtual machine sizes, best practice implementation through provisioning such VMs through portal with Azure Resource Manager, supporting production workloads through premium storage, temporary disk drive usage for appropriately sized VMs etc. Demos: virtual machine sizes, provisioning through portal, premium storage usage. |
| Day 3 - 19th | 08:45 | 10:00 | KATMAI | sravani saluru | Break-Out | DBA_B63 - Intermediate - SQL Server Replication | Database Administration | Intermediate | Abstract: SQL Server Replication 1. Different types of Replication in SQL Server 2. Transaction replication work flow and troubleshooting latency – tips 3. Merge replication workflow and troubleshooting agent failures 4. Understanding Merge replication metadata 5. Replication with SQL Server Availability groups 5. Demos for replication issues Key Learning: exploring Merge meta data and understanding how change tracking works in merge replication. Troubleshooting tips for data non convergence and latency issues . troubleshooting log reuse wait desc replication Demos: Demo on exploring merge meta data Demo on data non convergence Troubleshooting log reuse wait desc replication |
| Day 3 - 19th | 10:30 | 11:45 | HYDRA | Siva Harinath | Break-Out | BIA_B12 - Intermediate - Building Fast And Reliable Reporting With Power BI | Business Intelligence & Analytics | Intermediate | Abstract: Fast dashboards and reports are a delight to use. Slow reports languish into obscurity. How do we build dashboards and reports that are fast and reliable? Join us for a deep dive into Power BI performance tuning and optimization. We’ll cover the basic patterns for Power BI usage, performance implications and best practices, including security, workspaces, apps and content packs, as well as RLS and more. |
| Day 3 - 19th | 10:30 | 11:45 | SPHINX | Chris Testa-O Neill | Break-Out | BIGDATA/VLDB_B14 - Intermediate - Orchestrating Data With Azure Data Factory | Big Data & VLDBs | Intermediate | Abstract: The need for batch movement of data on a regular time schedule is a requirement for most analytics solutions. Within the Cortana Intelligence Suite, Azure Data Factory (ADF) is the service that can be used to fulfil such a requirement. In this session, you will see the components required within ADF to orchestrate the movement of data within the Cortana Intelligence Suite. Looking at scenarios such as moving data from on premise servers to Azure BLOB storage or a database, to invoking analytical workloads such as invoking Machine Learning model evaluations. Azure Data Factory brings all this together. Also see a real world case study from a Microsoft Partner on how they implemented an Azure Data Factory and Azure Data Lake business intelligence solution for a 1.5 billion user customer. Key Learning: The attendee can : Describe how Azure Data Factory fits into the Cortana Intelligence Suite and can locate the CIS video to refer to Describe in a sentence what Azure Data Factory does, and can explain the logical flow that Azure Data Factory performs Create an Azure Data Factory instance using the Azure Portal and PowerShell Understand the process to architect, design and execute ADF projects in the content of an end to end solution Create a linked service for SQDW. Azure Blob store and to start up a Hadoop cluster Create datasets within Azure Data Factory, and describe the options that are available within the datasets Describe the types of activities that can be performed in Azure Data Factory and create an activity to use Hive in a Hadoop cluster to transform data Describe how pipelines work within an ADF solution Demos: The demos will show haw to create an Azure Data Factory instance and the supporting objects to ingest and process data. |
| Day 3 - 19th | 10:30 | 11:45 | SHILOH | Tejas Shah | Break-Out | DEV_B79 - Intermediate - Improve Data Load Speed And Query Performance With Columnstore Indexes | Database Development | Intermediate | Abstract: Is data load performance into columnstore slowing you down? Should you drop nonclustered indexes before loading data? What batchsize should you choose? How should you handle large number of Updates/Deletes? Columnstore index can speed up the performance of analytics queries significantly but are you getting the best performance possible? Come to this session to learn the best practices and the techniques customers have used to load data in parallel with minimal or reduced logging into columnstore index. Specifically, we will cover data load using BCP, Bulk Insert, SSIS or MERGE command, concurrent trickle insert in IOT scenario as well as moving data from staging table. We will also talk about how to diagnose performance issues in queries accessing columnstore index and the steps you can take to troubleshoot. Some of the techniques we discuss here are rowgroup elimination, statistics, partitioning, improving the query plan quality, tweaking the schema, and creating one or more nonclustered btree indexes. Key Learning: Improving performance of analytics workload with columnstore indexes. Demos: NA |
| Day 3 - 19th | 10:30 | 11:45 | YUKON | André Melancia | Break-Out | DBA_B47 - Intermediate - Hacking SQL Server | Database Administration | Intermediate | Abstract: How easy is it to hack a SQL Server? In this session we'll see examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), hacking DDM, RLS, and more. Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again. Key Learning: Session Goal 1 Understanding the security risks in a normal SQL Server installation Session Goal 2 Learning how to mitigate the security risks Session Goal 3 Knowing other security risks that indirectly affect SQL Server Demos: This session is over 70% demos, showing how to exploit, and then how to secure the instalation. |
| Day 3 - 19th | 10:30 | 11:45 | KATMAI | Sheela Siddappa | Break-Out | DATASCIENCE_B36 - Advanced - Impact Of Artificial Intelligence In Business | Data Science | Advanced | Abstract: The trend is on Artificial Intelligence (AI). Big organizations have started concentrating on AI in their Research centers. What value can AI create to the business. Some of the experience we had in the implementing AI in different sectors like Retail, Health care, Manufacturing etc. The future of AI and its role in various aspects like, automation, business, revenue, portfolio of products etc. Key Learning: Audience need to know about data analytics and some of the problems that can be addressed by analytics. Knowledge of business, the importance of automation. Demos: A demo of some of the Artificial Intelligence features with respect to the IOT, Asset management domain. The benefits of implementing AI use cases or features can be clearly seen in the demo |
| Day 3 - 19th | 12:00 | 13:15 | HYDRA | Sudhir Rawat | Break-Out | CLOUD/IoT/NoSQL_B39 - Basic - IoT Design And Implementation Challenges | Cloud, IoT & NoSQL | Basic | Abstract: Connected sensors, devices, and intelligent operations can transform businesses and enable new growth opportunities. To do this, one needs to understand how to create the right architecture for the IoT solution, tradeoffs to consider, and the challenges in implementation. Key Learning: In this session, we will discuss in detail about architecting IoT solution on cloud and why it’s important. We will also see some services in action. Do join this session if you are working, planning to start in IoT field. |
| Day 3 - 19th | 12:00 | 13:15 | SPHINX | Amit Bansal | Break-Out | DBA_B35 - Advanced - Benchmarking & Testing In-Memory OLTP Performance | Database Administration | Advanced | Abstract: Not every workload can benefit from In-Memory tables. Memory Optimized Tables are not a magic bullet that will improve performance for all kinds of transactional workloads. Therefore, it is very critical that you test & benchmark in-memory performance for your SQL deployments before you decide to migrate disk-based tables to memory-optimized tables. Key Learning: In this session, you will learn: a. Baselining current performance b. How to identify the right candidates for In-Memory c. Generate sample production data d. Create simulated production workload e. Test & benchmark In-Memory performance with simulations f. Compare In-Memory performance with the baseline You will also learn about a verity of tools and techniques that can be used in our proof-of-concept. |
| Day 3 - 19th | 12:00 | 13:15 | SHILOH | Akbar Farishta | Break-Out | DBA_B45 - Intermediate - New features of AlwaysOn in SQL 2016 and SQL 2017 | Database Administration | Intermediate | Abstract: SQL Server as an enterprise product is continuously evolving and we are making changes to AlwaysOn with the same cadence. In this sessions, we will be discussing about AlwaysOn improvements in SQL 2016 and SQL 2017 (Windows and Linux) Key Learning: 1. Brief about internals of SQL Server AlwaysOn 2. SQL 2016 – • Fundamental Changes to Always On Availability Groups • Performance and Usability enhancements 3. New features in SQL 2017 (Windows and Linux) Demos: 1) Database Level health Detection 2) Always On Direct Seeding 3) Latency tracker 4) Distributed AG (if time permits) |
| Day 3 - 19th | 12:00 | 13:15 | YUKON | Victor Isakov | Break-Out | DBA_B66 - Intermediate - Mitigating A SQL Server Upgrade Disaster | Database Administration | Intermediate | Abstract: SQL Server 2016 easily represents Microsoft's biggest release ever. But with so many changes in the database engine upgrading to the latest version of SQL Server represents a larger risk as well. Many customers have upgraded to the latest version "unaware" and been caught out with degraded performance and expectations not being realised. This session will discuss the important database engine changes that will potentially directly impact your upgrade path and outcome. It will highlight the key risks, how to detect them and what mitigation techniques can be used. It will set realistic expectations to all stakeholders of what the upgrade will deliver. Finally it will present a methodology that can be used to ensure a successful upgrade project that delivers optimal performance and reliability. With plenty of real-world case studies this should prove to be a very informative and practical session. Key Learning: Understand how to drive a SQL Server upgrade project, mitigate risk, avoid common mistakes. How to best leverage new features in SQL Server. How to maximize investment in SQL Server. Demos: Demo Data Migration Assistant. Lots of screen captures of case studies to illustrate points. |
| Day 3 - 19th | 12:00 | 13:15 | KATMAI | Joey D Antoni | Break-Out | CLOUD/IoT/NoSQL_B22 - Intermediate - Who Am I? Managing Identities In Azure | Cloud, IoT & NoSQL | Intermediate | Abstract: When moving to a cloud or hybrid environment, one of the biggest challenges is maintaining a consistent login experience for users. Many firms have challenges with connecting Office 365 to their Azure infrastructure, particular in more complex designs. A bad design can raise security concerns or give users a bad experience. In this session you will learn about how Active Directory, Azure Active Directory, and Active Directory Federation Services work together to offer your users a single common logon experience. You will learn about the proper architecture for your security needs and scale. Key Learning: Understanding of how Azure Active Directory works in conjunction with your on-premises Active Directory to off a seamless login experience to services such as Azure SQL Database and SQL Data Warehouse. Demos: Demo configuring Azure SQL Database with AAD auth. |
| Day 3 - 19th | 13:30 | 14:45 | HYDRA | Rob Farley | Break-Out | DEV_B72 - Advanced - Understanding SARGbility (To Make Your Queries Run Faster) | Database Development | Advanced | Abstract: There’s so much more to SARGability than people think, and people can often miss out on significant performance benefits by not appreciating this. SARGable means Search ARGument Able and relates to the ability to search through an index for a value. Unfortunately many database professionals don’t really understand it – especially in regard to joins – leading to queries which don’t run as well as they should. This is a talk involving lots of demos, showing plenty of queries and execution plans. Key Learning: How to make faster queries!!! Demos: It's pretty much all demos. |
| Day 3 - 19th | 13:30 | 14:45 | SPHINX | Uwe Ricken | Break-Out | DEV_B80 - Advanced - Mastering DML Operations Like A Master | Database Development | Advanced | Abstract: DML operations mean lot of work for the database engine of Microsoft SQL Server. Understanding the details of a DML transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations. Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions: What is the difference of data page allocation for heaps and clustered indexes? What is the amount of transaction log when you update data in a heap and/or in a clustered index? What are the differences when data are delete from a heap and clustered index? Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES? What performance drawbacks have Page Splits and Forwarded Records for my application design? Key Learning: After this session you can rate table designs. Furthermore you'll have the ability to calculate the benefits of different scenarios for lots of workloads e.g. DWH vs. OLTP Demos: This session is based on lots of demos for different scenarios: - difference of inserting data into heaps / clustered indexes - how may updates impact your workloads - what do you have to consider, when you delete data from tables |
| Day 3 - 19th | 13:30 | 14:45 | SHILOH | Karen Lopez | Break-Out | DEV_B41 - Intermediate - The Key to Keys | Database Development | Intermediate | Abstract: Many of us have learned database design approaches from working with one database or data technology. We may have used only one design tool. That means our vocabularies around identifiers and keys tend to be product specific. Do you know the difference between a unique index and a unique key? What about the difference between RI, FK and AK? Do you know if your surrogate keys have their companion alternate keys? Do you know if your key choices, no matter where they are will perform well? Will they lead to data anomalies? In this session we’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the data modeling and database design process. We’ll also look at implementation options across a few commercial DBMSs and datastores. These concepts span data activities and it’s important that your team understand each other and where they, their tools, and approaches fit to produce a successful database design. Key Learning: 1 Attendees will understand both design and implementation terminology for designing databases that produce consistent data that performs well. 2 Attendees will learn how to best implement keys (not just primary keys) for great data quality and great database performance 3 Attendees will understand how popular methods and tools use these concepts to generate great databases. Demos: Impact of keys on data quality |
| Day 3 - 19th | 13:30 | 14:45 | YUKON | Andreas Wolter | Break-Out | DBA_B48 - Intermediate - Troubleshooting Availability Groups | Database Administration | Intermediate | Abstract: In this session, we look under the covers of availability groups. Various demos show how to analyze functionality and performance in relation to availability groups. This includes problem analysis during initial seeding and the subsequent synchronization traffic and its performance overhead on the workload. The aim is to provide a better understanding of the basic mechanisms and their impact on the cIn this session, we look under the covers of availability groups. Various demos show how to analyze functionality and performance in relation to availability groups. This includes problem analysis during initial seeding and the subsequent synchronization traffic and its performance overhead on the workload. The aim is to provide a better understanding of the basic mechanisms and their impact on the chosen high-availability infrastructure as well how to use the available, built-in tools for troubleshooting. - If there is time also a professional tool that significantly helps analyzing the state of your AG-infrastructure is shown hosen high-availability infrastructure as well how to use the available, built-in tools for troubleshooting. Key Learning: learn about importance measures to analyze AGs understand about the potential overhead of synchronization and how to measure it Demos: synchronization overhead |
| Day 3 - 19th | 13:30 | 14:45 | KATMAI | Mohammed Malik / Rahulinder Singh | Break-Out | DBA_B42 - Advanced - Building self-serve BI solutions on the cloud using Azure Analysis Services | Business Intelligence & Analytics | Advanced | Abstract: We will be presenting a case study of a self-serve BI application that we built recently using Azure Analysis Services (AAS). The sessions will cover the following: 1. Overview of AAS. 2. Connectivity to sources and consumers. 3. Security in AAS with AAD. 4. Migrating existing on premise Analysis services models to AAS. 5. Right sizing AAS infrastructure based on telemetry. 6. Cost optimization strategies using Pause/resume and scaleup/scaledown. 7. Disaster recovery using backup/restore. 8. Automation of processing and synchronization using AMO for coexistence with exiting on premise infrastructure. Key Learning: Attendees will understand 1. What is this new Azure PaaS offering AAS? 2. How AAS contrasts with SQL Server Analysis services. 3. What to expect while migrating models and infrastructure to AAS. 4. How to right size AAS infrastructure for cost optimization, utilizing the full benefits of cloud (scaleup/scaledown and pause/resume) 5. How to adopt a staged approach for migration Demos: 1. Setting up an instance. 2. Building and deploying a model with hybrid sources. 3. Processing using AMO, with Azure Functions/WebJobs as the host. 4. Telemetry setup and instance monitoring. 5. Real-time data consumption using PowerBI. 6. Dynamic scaling and pausing based on load. 7. Walkthrough of automation for co-existence with on premise models. |
| Day 3 - 19th | 15:15 | 16:30 | HYDRA | Hariharan Rajendran | Break-Out | CLOUD/IoT/NoSQL_B20 - Intermediate - A To Z On Azure Automation Services | Cloud, IoT & NoSQL | Intermediate | Abstract: In this enormous development of the technological world, we are still struggling to setup a fully working automation process. At last, we now have Azure Automation Services to get rid of manual intervention. This session covers A to Z on automation services, right from the scratch. As you know, we have been worked with an alerting system as part of automation. This session covers that how we can move forward to configure the system to react for the triggered alert with help of webhooks. This will be the great feature those who have already automated the tasks with PowerShell Key Learning: The audience will be able to understand, what is Azure Automation services and they will be able to create own custom runbooks and schedules. The audience will have a brief idea about webhook creation and use it for automating the process. Demos: As part of this demo, the creation of automation account, runbooks and webhooks will be covered. I will demonstrate the live scenario that how the real automation is possible with the help of webhooks. |
| Day 3 - 19th | 15:15 | 16:30 | SPHINX | Pooja Kamath / Hitesh Chouhan | Break-Out | DBA_B62 - Intermediate - Extended Events For Monitoring/Troubleshooting SQL Server Problems ||| Profiler No More | Database Administration | Intermediate | Abstract: Today if we have to run a profiler on a production system then it will be a challenge in terms of production impact. Profiler does cause a some amount of load on the server. Microsoft came out with Extended events to overcome this but it is not widely used due to the fact that we have to parse an XML to get the data and the absence of GUI to analyze the data the traditional way. We will be talking about these two challenges mainly in this talk and how can we unobtrusively monitor what's going on in a SQL Server instance using SQL extended events: 1. Capture query timeouts 2. Capture infra heavy queries 3. Workload change tracker and much more... along with a lot of demos Key Learning: Microsoft came out with Extended events to overcome this but it is not widely used due to the fact that we have to parse an XML to get the data and the absence of GUI to analyze the data the traditional way. We will be talking about these two challenges mainly in this talk and how can we unobtrusively monitor what's going on in a SQL Server instance using SQL extended events: 1. Capture query timeouts 2. Capture infra heavy queries 3. Workload change tracker and much more... along with a lot of demos Demos: 1. Capture query timeouts 2. Capture infra heavy queries 3. Workload change tracker and much more... along with a lot of demos |
| Day 3 - 19th | 15:15 | 16:30 | SHILOH | Manohar Punna | Break-Out | CLOUD/IoT/NoSQL_B29 - Intermediate - Azure Database Migration – Choosing The Right Tier | Cloud, IoT & NoSQL | Intermediate | Abstract: |
| Day 3 - 19th | 15:15 | 16:30 | YUKON | Sandip Pani | Break-Out | DEV_B74 - Basic - Graph Database In Sql Server 2017 | Database Development | Basic | Abstract: There are various Graph database exist in market looking into the usability and problem solving capability Microsoft added this Graph Database feature in SQL Server 2017. In this session I will will presenting architecture of Graph Database and how can we implement it using SQL Server 2017. Key Learning: What is graph database? When to use ? Why to use? How it solves business problems? Demos: Demo will consists of 2 demos one with basic to understand the feature and then a real life business problem implementation and solution. |
| Day 3 - 19th | 15:15 | 16:30 | KATMAI | Narendra Angane / Mahendraprasad Dubey | Break-Out | BIA_B06 - Intermediate - Power BI: Simplified Data Modeling | Business Intelligence & Analytics | Intermediate | Abstract: In this demo-driven session, you will learn advanced data modeling. Post this session one should be able to solve several complex modelling problems. We will also demonstrating how to call parameterized stored procedure & creating hyperlink to reporting services. |
| Day 1 - 17th | 10:45 | 11:15 | KILIMANJARO | Rob Farley | Chalk-Talk | DBA_C46 - How SQL DW Runs Your Queries | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 10:45 | 11:15 | DENALI | Chris Testa-O Neill | Chalk-Talk | BIA_C01 - Cortana Intelligence Architectures Patterns | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 11:30 | 12:00 | KILIMANJARO | Amit Banerjee | Chalk-Talk | CLOUD/IoT/NoSQL_C13 - Running Applications On Azure Using Postgres/MySQL | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 11:30 | 12:00 | DENALI | Abhishek Narain | Chalk-Talk | BIGDATA/VLDB_C07 - A Typical Enterprise Big Data Solution Architecture Pattern | Big Data & VLDBs | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 12:15 | 12:45 | KILIMANJARO | Uwe Ricken | Chalk-Talk | DBA_C56 - Benefits And Drawbacks Of Heaps | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 12:15 | 12:45 | DENALI | Joey D Antoni | Chalk-Talk | DBA_C34 - Security In Azure SQL DB | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 13:00 | 13:30 | KILIMANJARO | Muthukumaran Arumugan | Chalk-Talk | BIA_C09 - SSIS Scale Out feature in SQL Server vNext | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 13:00 | 13:30 | DENALI | Madhan Gajendran | Chalk-Talk | CLOUD/IoT/NoSQL_C19 - Scalable, Performant, Schema Agnostic Indexing In Azure CosmosDB | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 13:45 | 14:15 | KILIMANJARO | André Melancia | Chalk-Talk | CLOUD/IoT/NoSQL_C14 - Electronics For IoT | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 13:45 | 14:15 | DENALI | Nagaraj Venkatesan | Chalk-Talk | DBA_C38 - Adapative Query Processing - What, How And Why? | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 14:30 | 15:00 | KILIMANJARO | Abhishek Narain | Chalk-Talk | CLOUD/IoT/NoSQL_C12 - High Scale Data Ingestion/ Movement From On Premise To Cloud | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 14:30 | 15:00 | DENALI | Avinash Kumar | Chalk-Talk | DBA_C11 - Migrating your MS SQL Server to Cloud | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 15:30 | 16:00 | KILIMANJARO | Sudhir Rawat | Chalk-Talk | CLOUD/IoT/NoSQL_C26 - Start To Finish :- IoT Implementation | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 15:30 | 16:00 | DENALI | Hitesh Chouhan | Chalk-Talk | DBA_C33 - Monitoring The "Actual" Delay For Your AlwaysOn Secondaries | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 16:15 | 16:45 | KILIMANJARO | Sanjay Mishra | Chalk-Talk | DBA_C48 - Azure SQL Database Managed Instance | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 16:15 | 16:45 | DENALI | Manish Sharma | Chalk-Talk | CLOUD/IoT/NoSQL_C20 - AWS RDS MongoDB Vs Azure ComosDB | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 17:15 | 17:45 | KILIMANJARO | Patrick Flynn | Chalk-Talk | DBA_C41 - Database Page Internals – Why You Should Care | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 17:15 | 17:45 | DENALI | Santosh Goli | Chalk-Talk | DBA_C49 - Debugging Query Performance Issues | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 18:00 | 18:30 | KILIMANJARO | Joe Yong | Chalk-Talk | CLOUD/IoT/NoSQL_C16 - Should Your Enterprise Data Warehouse Run On SQL Server, Azure SQL Database Or Azure SQL Data Warehouse? | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 18:00 | 18:30 | DENALI | Shweta Gupta | Chalk-Talk | CLOUD/IoT/NoSQL_C24 - Scaling IoT Systems For Millions Of Devices | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 08:30 | 09:00 | KILIMANJARO | Subramani Paramasivam | Chalk-Talk | ProfessionalDev_C25 - Tips To Get Career Building Support From Your Organization | Professional Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 08:30 | 09:00 | DENALI | Karen Lopez | Chalk-Talk | DEV_C39 - Model-driven Database Design on Agile and SCRUM Projects | Database Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 09:15 | 09:45 | KILIMANJARO | Sumit Sarabhai | Chalk-Talk | DBA_C54 - Strategies For HADR On On-Prem And Azure For SQL Server And Databases | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 09:15 | 09:45 | DENALI | Satya Jayanty | Chalk-Talk | DATASCIENCE_C23 - Jump-Start: Get To Know Data Science And Machine Learning Essentials! | Data Science | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 10:15 | 10:45 | KILIMANJARO | Tejas Shah | Chalk-Talk | DBA_C55 - SQL OS Scheduling | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 10:15 | 10:45 | DENALI | Andreas Wolter | Chalk-Talk | DEV_C58 - Security In SQL Server – What’s There, What Can You Extend | Database Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 11:00 | 11:30 | KILIMANJARO | Parikshit Savjani | Chalk-Talk | DBA_C40 - Indirect Checkpointing – The Good, The Bad And The Non-Yielding | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 11:00 | 11:30 | DENALI | Joey D Antoni | Chalk-Talk | CLOUD/IoT/NoSQL_C17 - Authentication With Azure Active Directory | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 11:45 | 12:15 | KILIMANJARO | Rob Farley | Chalk-Talk | BIA_C05 - SSRS + MDX | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 11:45 | 12:15 | DENALI | Manohar Punna | Chalk-Talk | DBA_C36 - Collecting The Metrics For DTU Calculator | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 12:30 | 13:00 | KILIMANJARO | Karthick Krishnamurthy | Chalk-Talk | DBA_C35 - Inside SQL Server Memory | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 12:30 | 13:00 | DENALI | Hariharan Rajendran | Chalk-Talk | DBA_C32 - A Technology To Automate Your Data Tasks | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 13:15 | 13:45 | KILIMANJARO | Amit Khandelwal | Chalk-Talk | DBA_C29 - Troubleshooting Tips For Transactional Replication Issues | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 13:15 | 13:45 | DENALI | Peter Myers | Chalk-Talk | BIA_C03 - Delivering Mobile Reporting: SSRS Or Power BI? | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 14:00 | 14:30 | KILIMANJARO | Ajay Jagannathan | Chalk-Talk | DBA_C28 - Understanding And Troubleshooting Latches And Spinlocks | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 14:00 | 14:30 | DENALI | Patrick Flynn | Chalk-Talk | DBA_C42 - SQL Server Log File Internals | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 14:45 | 15:15 | KILIMANJARO | Avanish Panchal | Chalk-Talk | DBA_C30 - AWS RDS (SQL Server) - How Good Or Bad? | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 14:45 | 15:15 | DENALI | Sravani Saluru | Chalk-Talk | DBA_C52 - SQL Server 2016 Operational Analytics – Role Of Columnstore Indexes | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 15:30 | 16:00 | KILIMANJARO | Jimmy May | Chalk-Talk | BIGDATA/VLDB_C08 - Implementing the -k startup switch (little known, fully supported, magical) | Big Data & VLDBs | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 15:30 | 16:00 | DENALI | Sandy Winarko | Chalk-Talk | BIA_C06 - Data Quality Services (DQS) – Future Architecture | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 16:30 | 17:00 | KILIMANJARO | Pranab Majumdar | Chalk-Talk | DBA_C18 - Fighting a performance battle with your intelligent Cloud Database - Azure SQL DB | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 16:30 | 17:00 | DENALI | Shweta Gupta | Chalk-Talk | BIGDATA/VLDB_C10 - How I Converted My Petabyte Scale SQL Data Into HBase | Big Data & VLDBs | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 17:15 | 17:45 | KILIMANJARO | Peter Myers | Chalk-Talk | BIA_C02 - What Are The Differences Between Power BI Reports And Dashboards? | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 2 - 18th | 17:15 | 17:45 | DENALI | Anupama Natarajan | Chalk-Talk | DEV_C22 - Data and API: How they go hand-on-hand? | Database Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 08:45 | 09:15 | KILIMANJARO | Anupama Natarajan | Chalk-Talk | DEV_C59 - Graph Databases And SQL Server 2017 | Database Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 08:45 | 09:15 | DENALI | Sudhir Rawat | Chalk-Talk | BIA_C04 - Architecture Of Power BI Solution | Business Intelligence & Analytics | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 09:30 | 10:00 | KILIMANJARO | Steve Jones | Chalk-Talk | DBA_C53 - SQL Server Encryption | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 09:30 | 10:00 | DENALI | Yogeshwar Phull | Chalk-Talk | DBA_C57 - SQL Server Delayed Durability | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 10:30 | 11:00 | KILIMANJARO | Murilo Miranda | Chalk-Talk | DBA_C37 - AlwaysOn Availabiity Groups - Understanding The Listener And Load Balancing. | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 10:30 | 11:00 | DENALI | Akbar Farishta | Chalk-Talk | DBA_C47 - Change Tracking and Enhancements in SQL Replication | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 11:15 | 11:45 | KILIMANJARO | Vijay Rodrigues | Chalk-Talk | CLOUD/IoT/NoSQL_C27 - Azure Behind The Scenes For IaaS (Virtual Machines With SQL Server Etc.) / PaaS (Cloud Services) | Cloud, IoT & NoSQL | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 11:15 | 11:45 | DENALI | Patrick Flynn | Chalk-Talk | DBA_C43 - DBA Tools! The Reason Why You Must Use Powershell | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 12:00 | 12:30 | KILIMANJARO | Sandip Pani | Chalk-Talk | DBA_C21 - Fact About Fill Factor | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 12:00 | 12:30 | DENALI | Sravani Saluru | Chalk-Talk | DBA_C51 - SQL Server Clusters – What Is Resource Host Subsystem And Discussion On Resource Alive Checks | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 12:45 | 13:15 | KILIMANJARO | Deepak Rajendran | Chalk-Talk | ProfessionalDev_C15 - Communities, MVP & You | Professional Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 12:45 | 13:15 | DENALI | Prince Rastogi | Chalk-Talk | DBA_C45 - In-Memory OLTP: Internal Structure And Memory Estimation | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 13:30 | 14:00 | KILIMANJARO | Pooja Kamath | Chalk-Talk | DBA_C44 - Discussing Alternate Solutions For SQL Agent In The Cloud (Automation , Alerts, Web Hooks, Elastic Jobs) | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 13:30 | 14:00 | DENALI | Don Castelino | Chalk-Talk | DEV_C60 - IIS Administration Basics For SQL DBA | Database Development | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 14:15 | 14:45 | KILIMANJARO | Hamish Watson | Chalk-Talk | DBA_C31 - TempDB - The Forgotten Pillar Of Performance Tuning. | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 3 - 19th | 14:15 | 14:45 | DENALI | Satya Ramesh | Chalk-Talk | DBA_C50 - Sql Server 2016- A Quick Walk Through | Database Administration | N/A | Chalk-Talks are 30 minutes’ sessions focussing on conceptual & architectural understanding, that too with only whiteboard and marker. No Laptops, no PPTs, no demos – only whiteboard-ing! |
| Day 1 - 17th | 10:45 | 11:15 | HEKATON | Jimmy May | Open-Talk | BIGDATA/VLDB_O12 - SQL Server on Flash | Big Data & VLDBs | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 10:45 | 11:15 | HELSINKI | Deepti Pillai | Open-Talk | ProfessionalDev_O19 - Email Etiquettes | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 11:30 | 12:00 | HEKATON | Satya Jayanty | Open-Talk | BIGDATA/VLDB_O13 - Big Data Analytics - Where Am I And What's Coming Next? | Big Data & VLDBs | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 11:30 | 12:00 | HELSINKI | Anupama Natarajan | Open-Talk | BIA_O03 - Advanced Transformation With Power Query And M In Power BI | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 12:15 | 12:45 | HEKATON | Murilo Miranda | Open-Talk | CLOUD/IoT/NoSQL_O22 - Azure SQL Database - Where To Start? | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 12:15 | 12:45 | HELSINKI | DATASCIENCE Panel | Open-Talk | DATASCIENCE_O32 - Data Science - Panel 1 | Data Science | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 13:00 | 13:30 | HEKATON | Dilip George | Open-Talk | ProfessionalDev_O16 - Cloud Trends – Keep Yourself Abreast | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 13:00 | 13:30 | HELSINKI | DATASCIENCE Panel | Open-Talk | DATASCIENCE_O33 - Data Science - Panel 2 | Data Science | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 13:45 | 14:15 | HEKATON | Avanish Panchal | Open-Talk | ProfessionalDev_O17 - DBA Profession In Cloud World. | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 13:45 | 14:15 | HELSINKI | Rob Farley | Open-Talk | DATASCIENCE_O20 - Microsoft Machine Learning :How To Use It In Real Case | Data Science | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 14:30 | 15:00 | HEKATON | Sanjay Mishra / Denzil Rebeiro | Open-Talk | DBA_O44 - SQL Server On Linux: Everything You Wanted To Know, But Didn’t Know Whom To Ask | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 14:30 | 15:00 | HELSINKI | Steve Jones | Open-Talk | DEV_O57 - Getting Started With Devops | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 15:30 | 16:00 | HEKATON | Hariharan Rajendran | Open-Talk | BIA_O01 - The Most Wanted Features In Power BI | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 15:30 | 16:00 | HELSINKI | DEV Panel | Open-Talk | DEV_O58 - Database Development - Panel 1 | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 16:15 | 16:45 | HEKATON | Amit Bansal | Open-Talk | DBA_O36 - Importance Of Base-Lining In SQL Server | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 16:15 | 16:45 | HELSINKI | DEV Panel | Open-Talk | DEV_O59 - Database Development - Panel 2 | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 17:15 | 17:45 | HEKATON | Hamish Watson | Open-Talk | DEV_O51 - Visual Studio Team Services Can Help You Reliably Develop, Build And Deploy. | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 17:15 | 17:45 | HELSINKI | Ajay Jagannathan / Sudhakar Sannakkayala | Open-Talk | DBA_O35 - How Do You Successfully Execute A Data Migration Project? | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 18:00 | 18:30 | HEKATON | Nagaraj Venkatesan | Open-Talk | CLOUD/IoT/NoSQL_O23 - How To Pick PaaS Or IaaS On Azure? | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 1 - 17th | 18:00 | 18:30 | HELSINKI | Sudhir Rawat | Open-Talk | BIGDATA/VLDB_O02 - Securing Your Hadoop Cluster on Cloud | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 08:30 | 09:00 | HEKATON | Uwe Ricken | Open-Talk | DEV_O60 - Heaps Or Clustered Index | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 08:30 | 09:00 | HELSINKI | Amit Khandelwal | Open-Talk | DBA_O37 - Points To Ponder Before Considering Columnstore Indexes In OLTP Environment | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 09:15 | 09:45 | HEKATON | André Melancia | Open-Talk | DEV_O50 - SQL Indexing Tips | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 09:15 | 09:45 | HELSINKI | Pooja Kamath | Open-Talk | DBA_O43 - Discussing Azure SQL Database Solid Security Features That Will Make You Sleep Well At Night | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 10:15 | 10:45 | HEKATON | Shweta Gupta | Open-Talk | BIA_O07 - Building Data Pipelines, How Can I Move From A Traditional System Developed A Decade Ago Into The Modern Datawarehouse | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 10:15 | 10:45 | HELSINKI | BIGDATA Panel | Open-Talk | BIGDATA/VLDB_O14 - Big Data & VLDBs - Panel 1 | Big Data & VLDBs | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 11:00 | 11:30 | HEKATON | Steve Jones | Open-Talk | ProfessionalDev_O27 - Blogging For The Tech Professional | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 11:00 | 11:30 | HELSINKI | BIGDATA Panel | Open-Talk | BIGDATA/VLDB_O15 - Big Data & VLDBs - Panel 2 | Big Data & VLDBs | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 11:45 | 12:15 | HEKATON | Anupama Natarajan | Open-Talk | BIGDATA/VLDB_O11 - Multiple Big Data Platforms And What's Really Different Between Them? | Big Data & VLDBs | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 11:45 | 12:15 | HELSINKI | Sheela Siddappa | Open-Talk | BIA_O06 - Data Analytics And How Organizations Are Viewing It | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 12:30 | 13:00 | HEKATON | Sumit Sarabhai | Open-Talk | CLOUD/IoT/NoSQL_O29 - Why Should I Opt For SQL DB (PaaS) On Azure? | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 12:30 | 13:00 | HELSINKI | Santosh Goli | Open-Talk | BIA_O04 - Nextgen BI In Enterprise IT | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 13:15 | 13:45 | HEKATON | Tejas Shah | Open-Talk | DBA_O48 - Non-Yielding Scheduler And Deadlocked Schedulers | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 13:15 | 13:45 | HELSINKI | Sandy Winarko | Open-Talk | DEV_O56 - Data Quality Services (DQS) – Future Roadmap | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 14:00 | 14:30 | HEKATON | Chris Testa-O Neill | Open-Talk | ProfessionalDev_O18 - Data Science And AI For The SQL Server Professional: Where Do You Start? | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 14:00 | 14:30 | HELSINKI | Manish Sharma | Open-Talk | DBA_O40 - AWS RDS – Sql Server Vs Azure SQL Database | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 14:45 | 15:15 | HEKATON | Sheela Siddappa | Open-Talk | ProfessionalDev_O26 - Will Jobs Be Hit Due To The Robots ? | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 14:45 | 15:15 | HELSINKI | CLOUD Panel | Open-Talk | CLOUD/IoT/NoSQL_O30 - Cloud, IoT & NoSQL - Panel 1 | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 15:30 | 16:00 | HEKATON | Andreas Wolter | Open-Talk | DBA_O38 - In-Memory Technologies In SQL Server – Do I Need To Care? | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 15:30 | 16:00 | HELSINKI | CLOUD Panel | Open-Talk | CLOUD/IoT/NoSQL_O31 - Cloud, IoT & NoSQL - Panel 2 | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 16:30 | 17:00 | HEKATON | Karen Lopez | Open-Talk | DEV_O05 - The Performance/Data Quality/Data Secuirty Trade-off: Finding a Win-Win | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 16:30 | 17:00 | HELSINKI | Parikshit Savjani | Open-Talk | DEV_O54 - Data Loading Best Practices | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 17:15 | 17:45 | HEKATON | Patrick Flynn | Open-Talk | DBA_O42 - Backup And Restore – Test Your Knowledge! | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 2 - 18th | 17:15 | 17:45 | HELSINKI | Sravani Saluru | Open-Talk | DBA_O45 - AlwaysOn Multi Subnet – Addressing Connection Time Outs | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 08:45 | 09:15 | HEKATON | Subramani Paramasivam | Open-Talk | ProfessionalDev_O28 - IT Vs Business - Handling Political Situations | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 08:45 | 09:15 | HELSINKI | Hitesh Chouhan | Open-Talk | DEV_O52 - Implementing Your Own Workload Change Tracking | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 09:30 | 10:00 | HEKATON | Don Castelino | Open-Talk | DBA_O39 - SQL Connectivity Troubleshooting Tips And Tricks | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 09:30 | 10:00 | HELSINKI | Joey D Antoni | Open-Talk | DEV_O53 - SQL Graph | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 10:30 | 11:00 | HEKATON | Muthukumaran Arumugan | Open-Talk | DBA_O24 - Using Release Management Online for Database Deployment Automation | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 10:30 | 11:00 | HELSINKI | BIA Panel | Open-Talk | BIA_O09 - Business Intelligence & Analytics - Panel 1 | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 11:15 | 11:45 | HEKATON | Nagaraj Venkatesan | Open-Talk | DBA_O41 - CPU Performance Troubleshooting: 5 Important Things To Do! | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 11:15 | 11:45 | HELSINKI | BIA Panel | Open-Talk | BIA_O10 - Business Intelligence & Analytics - Panel 2 | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 12:00 | 12:30 | HEKATON | Yogeshwar Phull | Open-Talk | DBA_O49 - SQL Server Backups And Restores | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 12:00 | 12:30 | HELSINKI | Rob Farley | Open-Talk | ProfessionalDev_O25 - How To Give Presentations | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 12:45 | 13:15 | HEKATON | Sandip Pani | Open-Talk | DEV_O55 - Tips To Become A Successful SQL Developer | Database Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 12:45 | 13:15 | HELSINKI | Manohar Punna | Open-Talk | ProfessionalDev_O21 - A New Defenition Of Data Proessional - The Cloud Perspective | Professional Development | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 13:30 | 14:00 | HEKATON | Vijay Rodrigues | Open-Talk | CLOUD/IoT/NoSQL_O34 - Azure Storage Performance (Standard Storage, Premium Storage, Managed Disks) And SQL Server | Cloud, IoT & NoSQL | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 13:30 | 14:00 | HELSINKI | DBA Panel | Open-Talk | DBA_O46 - Database Administration - Panel 1 | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 14:15 | 14:45 | HEKATON | Siva Harinath | Open-Talk | BIA_O08 - Power BI – Open Q&A | Business Intelligence & Analytics | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |
| Day 3 - 19th | 14:15 | 14:45 | HELSINKI | DBA Panel | Open-Talk | DBA_O47 - Database Administration - Panel 2 | Database Administration | N/A | Open-Talks are 30 minutes free-flowing discussion on a specific topic. No laptops, no PPTs, no demos – only discussion and Q & A |