Abstract: If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this session I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.
About Rick: Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.
Abstract: Azure SQL Database provides fantastic scalability and flexibility for your data tier. You can scale it up with ease when you need more power and scale it down again when load returns to normal. With the pay as you go model, you pay for each database based on performance characteristics. But when you have a scaled out architecture of hundreds, thousands, or tens of thousands of databases, how can you keep costs from spiraling out of control? How can you query across all of those databases? How can you MANAGE so many databases? How can you write your application to make the right decisions about where to put which data? This session will introduce you to four key pieces of this overall story: Elastic Database Pools, Elastic Query, Elastic Database Jobs, and the Elastic Database Tools .Net library. With these tools, you take your Azure SQL Database data tier to the next level of scale and manageability.
About Mark: Mark is a Data Solution Architect for Microsoft and a former Data Platform MVP. He has been speaking on Microsoft data technologies at conferences and user groups for a decade. With a background in Theater and Improvised Comedy, Mark makes sure his presentations are informative AND fun.
Abstract: As companies start to embrace cloud based technologies, IT organizations will need to understand the available solution capabilities. Microsoft Azure is full of tools that improve data movement, storage, analysis and consumption. Some traditional on-premise concepts still apply and others do not. In this session, we will look at real world customer examples embracing Azure and provide insights into how organizations can start planning their move to the cloud.
About Dave: Dave DuVarney is President and Co-Founder of Talavant. Dave has delivered numerous business intelligence projects in both a technical and functional leadership role. Dave's latest technical focus has been on leveraging Microsoft Azure to support Business Intelligence need. Along with technical delivery, Dave has assisted clients in establishing Data Warehousing and Business Intelligence initiatives. This includes working with executive stakeholders to define objectives, assisting in the identification of team roles and implementing development best practices using Agile Scrum. Dave is currently training for his 4th marathon and hopes to not blow out a hip or calf muscle along the way.
Abstract: You are invited to be a participant on the SQL Server DBA Quiz Show; this interactive session will test your knowledge of SQL Server. We will be using an online tool to allow you to submit your answers to questions via a mobile device or laptop. If you have ever played trivia in a bar or restaurant you'll be familiar with the setup for this.
This session promises to be fast paced and fun and hopefully you will even learn something. This session will also be of value to people who need to interview or be interviewed for SQL Server positions as the questions may be the type of things you might hear in an interview.
About Eric: Eric is the SQL Server Architect for Boston Scientific, a self-proclaimed Level 70 Database Slayer, he enjoys development, performance tuning, and troubleshooting SQL Server.