Event Location:
Spencer Fox Eccles Business Building
1655 Campus Center Dr
Salt Lake City, Utah
Abstract:
Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This opens up new opportunities for SQL developers to extend and work with the data in Access apps. In this session you will learn to easily create an Access Web Apps with automatic views, view the online development environment and see a real-world, production web app in action. We’ll discuss different the use of hybrid applications and integrating office web apps as well as learn about app distribution, deployment and upgrades. And lastly, see the pros/cons of Access Web Apps in a corporate environment.
Speaker(s): Andy Tabisz,
Abstract:
Ever wonder how Management Studio gets information for the Properties dialogs it shows? SQL Server SMO consists of objects that can be used to manipulate SQL Server and the objects it contains. Ever wanted to get information about a database without opening Management Studio, or writing a query against DMVs? Ever wanted to change a property of a database without writing an ALTER DATABASE statement? This session will cover a few main objects in SMO and how to manipulate them using SMO as well as learning a Turbo button for your automation using SMO. Join us for a great time while we take a look behind the curtain and seeing how SMO really works. The session will have a majority of demos to give us time to really see how things work and how you can control things to get just what you want as fast as you can.
Speaker(s): Ben Miller,
Abstract:
Think of all the tools you use in managing your SQL Servers. All those SQL Servers being managed by tools and man that is a lot of clicks. We will show practical scripts and techniques to help you get a handle on all those clicks. Whether you are gathering data or statistics from your SQL Servers or deploying an object to all of them. Configuration items are not excluded from the need for good tools. PowerShell is that tool that will let you get away from all those clicks. Reusable scripts that let you manage all those instances with ease. This session will give you a great start on how to think about admin tasks using PowerShell scripts or modules. Many items are already out there to help you and we will take a good look.
Speaker(s): Ben Miller,
Abstract:
The “Gold” record. The “master maintainable list”. There is so much data in so many systems that businesses may have no way of telling which record is accurate and up to date. Even if a given record is accurate, how do we correct the inaccurate records in other systems? The dissonance between these systems costs businesses time and money and can lead to poor customer relations. Master Data Services (MDS) provides tools to get all of your databases singing from the same sheet of music. This hour will include an overview of key master data management concepts, an introduction to MDS and how that fits in a data quality strategy and demonstrations integrating MDS systems using SSIS.
Speaker(s): Michael Sexton,
Abstract:
Developers have been using Visual Studio for years to create apps that connect to your database. Why not use Visual Studio to create your database and help you keep it running fast and lean? Come learn how to use SQL Server Data Tools (SSDT) in Visual Studio to create tables, views, stored procedures, users and more. These database objects can be tied together during development which means no more procedure calls to misspelled tables, no more inconsistent column names and no more orphaned objects. We will also cover how easy it is to publish changes to different environments. Come join us and find out how you can add Visual Studio to your tool belt and help bring joy to your database development lifecycle process.
Speaker(s): Steve Seeley,
Abstract:
Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head. Contemporary IT environments should standardize their architecture including a tier of flash. Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, availability. Learn how flash flips the /faster bit the significant impact flash makes not just in terms of performance, but also best practices, the massive savings in licensing driven by consolidation on flash.
Speaker(s): J May,
Abstract:
SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.
Speaker(s): Rick Lowe,
Abstract:
After spending the last decade or so completely devoted to the Microsoft stack, I spent the last year supporting the SQL Server instance for a team of Java developers. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. I did find, however, that there were cultural differences which made my biggest challenges different from what I was used to dealing with in the .Net world. Come hear about my misadventures with JBoss, server side cursors, and NOCOUNT settings.
Speaker(s): Rick Lowe,
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker(s): Steve Jones,
Abstract:
Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different. Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified. Pointing out what is sub-par is only part of the process though. As a group we will discuss what the better options are based upon what we uncover. In a combination of instructor-led training and group discussion formats we will use Dynamic Management Objects, System Catalog Views and even Ola Hallengren's SQL Server Maintenance Solution to identify improvement points and next steps. Tim then goes one step further and introduces you to how Power BI takes this collected metadata to the next level of performance analysis.
Speaker(s): Tim Ford,
Abstract:
In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS. This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration. You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.
Speaker(s): Michael Fal,
Abstract:
The EXEC statement provides plenty of flexibility, and sp_executesql offers even more benefits on top of that. But both have their drawbacks, their nuances, and their impact on performance. After this session, you will know what to expect from the query processor when using these features in your code and how to get the most performance out of them.
Speaker(s): Jay Robinson,
Abstract:
We have all heard of Table level partitioning in SQL Server. It has been around for a few years but isn't something that is highly used. In this session, we will walk through the definition, setup and maintenance of table partitioning on SQL Server. We will also highlight some advanced concepts like Sliding Windows and Partition Switching.
Speaker(s): Brandon Preece,
Abstract:
In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits. We will also visualize this data using PowerBI.
Speaker(s): Montrial Harrell,
Abstract:
How well do you know your SQL components, methods and fundamentals? Come test your SQL foo against your peers and co-workers Jeopardy™ style! Questions will cover a broad scope of SQL development, administration and BI basics up to a 300 level. There will be time to discuss the correct answers and (as time allows) dig deeper into explanations. No one will be required to participate, but everyone who wishes to will have an opportunity to lead their team to glory as SQL Champions!
Speaker(s): Chad Crawford,
Abstract:
How to keep the database parts of three tier server environments (Development, Staging [QA], Production) in alignment so you can minimize risk to your production release process. I'll show you how we have been able to keep application database releases from spiraling out of control and give us the ability to rollback and respond to rapidly changing environments and how to release what was truly testing in the staging tier. Rapid development requires rapid changes to the database schema and with the change of database schema come some difficulties that can be managed to reduce downtime and scale-ability.
Speaker(s): Steve Peterson,
Abstract:
This is a deep dive into data compression in SQL Server and how it affects the performance of your database. After attending this session, you will be able to recognize situations in which enabling compression will help, how to configure it, and how to deploy it in busy production systems.
Speaker(s): Jay Robinson,
Abstract:
What do you do when the performance of a single query suddenly goes bad, bringing down your production system? We will walk through several possible solutions for a specific example, showing how to identify when each one is the root cause. We will delve through query plans, statistics and the optimizer on our way to discovering the true origin of the example's deterioration.
Speaker(s): Chad Crawford,
Abstract:
Powershell can be hard. As a language, it is fairly complex and provides a large array of functionality. Fortunately, you can teach yourself how to use Powershell with tools that are built right into the language. This session will cover some Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, taking the mystery out of the code and helping you start writing your own Powershell scripts. The key to learning Powershell is using it and this session will give you a launchpad to start building your own tools.
Speaker(s): Michael Fal,
Abstract:
For many engineers, interpreting disk I/O is a black art. Yet analyzing perfmon virtual file stats is typically straightforward. This session provides authoritative, clear guidance on collecting interpreting disk I/O metrics.
Speaker(s): J May,
Abstract:
Tips and Tricks and Painful lessons learned as I have ventured into the world of Hadoop, JSon and Hive. Our data has made the move from a relational database to a JSon structure, and reporting across the entire enterprise of data has changed. We have introduced Hadoop batch processing to our ETL processes to collect and process data from various locations, depositing them in various other locations. Along the way, various brick walls were surmounted. We will discuss some of these brick walls. Some of the oddities encountered in this journey. and hopefully prepare you for a similar trip, without all the pain we suffered.
Speaker(s): TJay Belt,
Abstract:
Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.
Speaker(s): Andre DuBois,
Abstract:
Have you ever watched a Microsoft SQL Presentation and wondered how in the world they did that cool trick? What was that keyboard shortcut? Come find out Microsoft SQL tips and tricks that will help you be more productive in your day to day work and give you a few cool ideas to make other SQL people jealous.
Speaker(s): Andrea Allred,
Abstract:
In order to implement a successful big data project, Hadoop Cluster needs to be installed successfully. To successfully install a Hadoop Cluster on physical servers, the operating system must be prepared with many configuration changes. I will discuss a few tips tricks about the overall process, right from the operation system installation, potential processes to follow, some features to consider along with steps for public key authentication (PKE). These steps will provide you with great confidence, save lots of time and a good starting point to successfully install a Hadoop Cluster.
Speaker(s): Sruthi Kumar Annamnidu,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/patwright
Contact: http://www.sqlasylum.com
Pat Wright has been working in the DBA space for 10+ years. Focusing on Performance tuning and ETL/DW projects. He helped found the local SQL Users group(www.slcsql.com) and founded the Not For profit Organization Utah Geek Events(www.utahgeekevents.com) which was founded to help the local community put on events.
LinkedIn: https://www.linkedin.com/in/montrialharrell
Contact: http://www.broadstrokeconsulting.com
Montrial has been involved with Technology since his first programming class in Junior High over 23 years ago. Since then he has been discovering how to use technology to solve problems in support of infrastructure teams, software development, Health Care and Government agencies. He has worked as a Systems Admin, LAN Admin, QA Engineer, instructor and finally decided to focus on Data Management and Governance because it offered so many ways to help businesses.
LinkedIn: http://www.linkedin.com/in/dbaduck/
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let's catch up.
LinkedIn: https://www.linkedin.com/in/davefackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
LinkedIn: http://www.linkedin.com/in/aspiringgeek
Contact: http://blogs.msdn.com/jimmymay
Jimmy May is a Microsoft Certified Master (MCM). He's formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io's Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.
LinkedIn: http://www.linkedin.com/in/aspiringgeek
Contact: http://blogs.msdn.com/jimmymay
Jimmy May is a Microsoft Certified Master (MCM). He's formerly a Principal Architect at Microsoft as well as Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, most interesting SQL Server apps from all over the world. More recently he was a SQL Server Technologist for what was Fusion-io's Data Propulsion Lab (DPL). He is a founder of the IndyPASS IWUG user groups.
LinkedIn: https://www.linkedin.com/in/dbachad
Chad Crawford is an MCM and Principal Database Engineer with 19 years' experience in database architecture, development, and administration. He has worked in the manufacturing, health care, and consulting industries, primarily focusing on design, performance, and high-availability of customer facing SAAS systems. He loves teaching and sharing new ideas, and created a custom training course that helped dozens of coworkers prepare for certification exams. He speaks regularly for users groups and SQLSaturday, and leads the Utah County SQL Users Group. When he isn’t optimizing a query or analyzing performance tests, you will find him running, tweaking a ham radio, or looking for a new strategy board game.
LinkedIn: http://www.linkedin.com/pub/andrea-allred/3/748/aa2/
Contact: http://www.RoyalSQL.com
Once upon a time in a kingdom not far away, Andrea was sick of answering phones and filing forms. Her kingdom was running low on gold and the wise wizard told her to find work that she loved and she would never truly work a day in her life. When she found the magical SQL Server, she knew it was the calling for her. She is passionate about SQL Server, “works” as a Database Administrator, loves her #SQLFamily and finds joy in helping others find their passion too. She is celebrating her 15th year with SQL Server this year.
LinkedIn: http://www.linkedin.com/in/andytabisz
Contact: http://www.worksmartdb.com/blog/
Andy Tabisz is a Microsoft MVP and owner of WorkSmart Database Masters based in Grand Rapids, MI. WorkSmart provides custom database and mobile solutions for small to mid-sized corporations using Access, SQL/Azure, ASP.NET, SharePoint, Power BI, Excel and integration with many technologies. Through rapid application development, WorkSmart empowers organizations to work smarter and make better decisions by automating workflow, alerts and reporting capabilities.
I have worked in ASP.NET and C# for a number of years before turning to SQL Server and T-SQL where Steve has been a SQL Server DBA for over 12 years with a focus on up time and performance. MCP MCTS Steve also likes photography.
My database experience began almost 25 years ago while working in a small accounting department. I started working with MSSQL 6.0 and have used every version since. I am a former Microsoft Certified Trainer and am now leading a slower life as a programmer specializing in data warehouse design, ETL and BI development.
LinkedIn: https://www.linkedin.com/in/timothyford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
LinkedIn: https://www.linkedin.com/in/dbachad
Chad Crawford is an MCM and Principal Database Engineer with 19 years' experience in database architecture, development, and administration. He has worked in the manufacturing, health care, and consulting industries, primarily focusing on design, performance, and high-availability of customer facing SAAS systems. He loves teaching and sharing new ideas, and created a custom training course that helped dozens of coworkers prepare for certification exams. He speaks regularly for users groups and SQLSaturday, and leads the Utah County SQL Users Group. When he isn’t optimizing a query or analyzing performance tests, you will find him running, tweaking a ham radio, or looking for a new strategy board game.
LinkedIn: http://www.linkedin.com/in/dbaduck/
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let's catch up.
Contact: http://datamountain.sqlmountain.com/
Stunningly handsome, yet surprisingly humble, Mike Sexton spent the first ten years of his career as a public defender in New York. Upon learning the discrepancies between his salary and the salary of newly minted college graduates working in IT, he had an epiphany and immediately learned how to program database applications. He has designed and built database applications for 12 years in both SQL Server and Oracle based systems, he has been published in SQL Server Magazine and is one of the aut
LinkedIn: http://www.linkedin.com/in/tjaybelt/
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
LinkedIn: https://www.linkedin.com/in/michaelfal/
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
LinkedIn: https://www.linkedin.com/profile/view?id=13788580
Contact: https://downshiftdata.wordpress.com/
I write C# and T-SQL code that scales well. I teach others to do it. DBAs like me.
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
Sruthi Kumar Annamnidu Hadoop Administrator
LinkedIn: https://www.linkedin.com/in/michaelfal/
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently. Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
LinkedIn: https://www.linkedin.com/profile/view?id=13788580
Contact: https://downshiftdata.wordpress.com/
I write C# and T-SQL code that scales well. I teach others to do it. DBAs like me.
LinkedIn: https://www.linkedin.com/in/brandonpreece
Contact: http://brandon.preece.xyz/
Brandon Preece started from the early days of SQL Server. His first migration was from SQL Server 6.5 to SQL Server 7.0. Since that day, he has loved being a Database Administrator working with every major version since then. He now manages the best SQL Server Team you will ever find (maybe he is a little biased). He love teaching technology and helping others find the best way to use this incredible tool that we all love called SQL Server. I work with SQL Server during the day and have been for many years. I enjoy teaching and making a difference. In my free time, I like action sports. I enjoy snowboarding and Mountain Biking. I started doing triathlons in 2015 and am liking the challenge. I am also a huge fan of the University of
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Contact: http://MtnDBA.wordpress.com
Andre has been in the IT industry for over 25 years in various positions with the majority working as database administrator, designer and programmer. His experience has been in the financial, travel and education industries.
The following is a list of sponsors that helped fund the event.