SQLSaturday #291 - Chicago 2014
Event Date: 04/26/2014 00:00:00
Event Location:
- DeVry University - Addison Campus
- 1221 North Swift Road
- Addison, Illinois
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Business Continuity: The Real Reason for HA and DR
Abstract: These days, I’ve stopped counting how many times I’ve been approached to help implement feature X because a customer thinks/was told it provides 24x7 for a DB/instance. These decisions often lead to more downtime and less uptme if the technology choice was not right or cannot be administered by the current staff. The secret sauce is not what gets implemented but understanding everything behind the scenes that influences the final architecture based on your actual requirements. It’s less about technology and more about understanding what it will take to keep your business going even when things seems like they are crumbling down around you. This session will cover how to approach achieving business continuity with the right amount of uptime.
Speaker(s):
- Allan Hirt
Track and Room: Room 216 - N/A
Title: Query Tuning Mastery: Clash of the Row Goals
Abstract: The fight for better performance is a battle of wits: your mind, your intelligence, and your honor pitted against the less-than-dependable whims of the Query Optimizer. But alas, the arbitrary rewrites and clunky hints leveraged by most developers to get around optimization deficiencies make things feel less like a proper duel and more like a skirmish at the sandbox. To truly engage your enemy you must comprehend his inner workings, and in the case of the Query Optimizer, that means you must delve into the mysteries of “row goals.” These internal metrics are tracked and enforced within Top iterators–and they exhibit a considerable amount of influence over plan shape and flow, both at compile time and as your query runs. Attend this session to learn how to take charge of optimization, expertly mold your query plans, and gain a new set of tools for eliminating bottlenecks in even your most complex problem queries. En garde!
Speaker(s):
- Adam Machanic
Track and Room: Room 116 - N/A
Title: DANGER: The Art and Science of Presenting
Abstract: Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room–including you.
Speaker(s):
- Mark Vaillancourt
Track and Room: Room 116 - N/A
Title: How to Think Like the Engine
Abstract: You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In this session with Microsoft Certified Master Brent Ozar, you’ll role play as the database engine while Brent gives you queries. You’ll learn first-hand about clustered indexes, nonclustered indexes, execution plans, sargability, statistics, TempDB spills, and T-SQL anti-patterns.
Speaker(s):
- Brent Ozar
Track and Room: Room 116 - N/A
Title: Database Development using SQL Server Data Tools
Abstract: In 2007, Microsoft introduced Data Dude for Visual Studio 2005 to help bring the processes, controls and tools for code management to Database Development that Application developers had been enjoying for ages. It had its problems, but it mostly worked and was a welcome step in the right direction. Many versions later we have SQL Server Data Tools for Visual Studio 2013 (and 2012 and 2010…). A more mature product that finally brings database development up to par with traditional application development and has many features data geeks, like ourselves, will truly love. This talk will provide an overview of SSDT’s features and show you how to get started using it to save time, implement better code controls and be a better DBA or database developer.
Speaker(s):
- Ken Stuber
Track and Room: Room 218 - N/A
Title: Choose Your Geospatial Mapping Adventure
Abstract: You have geospatial data and you know that plotting it on a map will deliver insights. Or maybe you keep hearing “geospatial” as a current BI buzzword and you want to be informed about your options when you get to it. The Microsoft BI stack provides several options for visualizing location data. But how do you know which tool will best serve your purpose, or what factors are important in making this decision? We’ll identify factors to consider when choosing a tool to visualize your data in maps such as system requirements, availability and type of location data, required level of technical understanding, and more. You’ll leave the session confident in your ability to choose the best tool within Excel and SQL Server.
Speaker(s):
- Meagan Longoria
Track and Room: Room 218 - N/A
Title: Real-Life SQL 2012 and 2014 Availability Group Deployments
Abstract: You want to deploy AlwaysOn, but you’re concerned about hidden drawbacks, performance impacts, and how it affects development. Brent Ozar has deployed SQL 2012 and SQL 2014 Availability Groups at big web sites including StackOverflow.com and the Discovery Channel, plus used it to scale out reads at data warehouses. Come learn what he’s found in real-life deployments of AlwaysOn.
Speaker(s):
- Brent Ozar
Track and Room: Room 216 - N/A
Title: How to properly gather performance counter data using Windows PowerShell
Abstract: We DBA´s know how important it is to collect performance data. In this session, I will show to you how to properly use the native Get-Counter PowerShell cmdlet to get all information you need from your servers. It has never been as easy to collect performance counter data and save it to a CSV file or a SQL Server table for baselining and later analysis. You may be thinking “But I don’t know nothing about PowerShell and explicitly using .NET classes in my code”. Don’t worry; you don’t need to know this to collect counters. Although this is a 100-level session, you’ll be producing 400-level results and your scripts will scale as the number of servers increase, because we’ll use asynchronous collection and processing. And better yet, we’ll schedule all of it. All this using native PowerShell cmdlets and a minimal amount of script code.
Speaker(s):
- Laerte Junior
Track and Room: Room 215 - N/A
Title: SQL Server Features That Will Blow Your Mind!
Abstract: How many lines of code does it take to generate a running total? How would you find a value in the next row of data - without using a cursor or loop? How can you efficiently store rows of data with a lot of optional fields, and how can you quickly find which of those rows have values? And how can you eliminate locking without resorting to dirty reads? SQL Server has answers for all of these questions, and none requires more than a few lines of code. Give me an hour, and I will blow your mind!
Speaker(s):
- Ed Leighton-Dick
Track and Room: Room 117 - N/A
Title: Introducing Power BI
Abstract: Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you’ll have a better understanding of what’s possible and whether it’s time to launch your BI-in-the-cloud solution.
Speaker(s):
- Stacia Varga
Track and Room: Room 217 - N/A
Title: Extending SQL Server with Advanced Analytics and R
Abstract: The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the open-source statistical software R and how we can use it to connect to SQL Server, analyze data, and put the results of our analysis back into SQL Server for later use. We’ll look at examples of analyses performed by a fictional company as they segment their customers, forecast their sales, and examine interesting relationships among their product offerings. Along the way, we’ll see what some of these analyses would take if done in SQL Server itself and why R is so effective when paired with SQL Server.
Speaker(s):
- Michael Schulte
Track and Room: Room 215 - N/A
Title: Working with Data in Windows Azure
Abstract: The Windows Azure Platform provides a plethora of options for data storage and trying to make sense of it all can be overwhelming. In this session we will explore the many Azure data services including Windows Azure SQL Database , Azure Storage, Local Storage and Caching. We will walk through the scenarios that each storage service addresses. Next we will dig into how to use each storage service and how they can complement each other when used together. Finally, we will explore the pricing and economic drivers that encourage one storage service over another when multiple fit into your solution.
Speaker(s):
- Eric D. Boyd
Track and Room: Room 215 - N/A
Title: Database Unit Testing
Abstract: Learn about Database Unit Testing, how it can add value to your projects, and how to do It with Microsoft Visual Studio. Brian will be speaking about the fundamentals of what database unit testing is and the Microsoft Visual Studio Tools for implementing database unit test projects. This talk is intended for audiences who are new to database unit testing and want to learn the basics behind using Visual Studio to perform automated database unit tests.
Speaker(s):
- Brian Beswick
Track and Room: Room 116 - N/A
Title: Designing a Restore Strategy
Abstract: Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database?
For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.
Speaker(s):
- Frank Gill
Track and Room: Room 214 - N/A
Title: In-Memory Columnstore Indexes–Make Your Data Warehouse Fly
Abstract: Columnstore indexes were introduced in SQL Server 2012, along with a new type of query processing “batch mode”. In SQL 2014 they get even better–we can use a Columnstore index as a clustered index and update it. In this session we will explore the basics and beyond of Columnstore indexes and how they can help your warehouse performance. We will also examine their impact to insert and update performance, and the best use cases for implementation.
Speaker(s):
- Joseph D’Antoni
Track and Room: Room 217 - N/A
Title: Self Service Pitfalls
Abstract: Every Business Department, BI Developer, BI Sales Consultant can put together a snazzy Power Pivot Demo and even prettier Power View Dashboard. They will wow you with capabilities and even convince you that Self Service BI can cure all that ails your organization. And while these tools are very powerful and provide huge benefit to organizations when used properly, in the wrong hands they can cause chaos and confusion. In this session we will discuss common pitfalls when implementing Self Service BI. We will discuss important issues such as Data Quality, Data Security, Properly defining Roles and Responsibilities for end users. Yes, at the end of the day Self-Service BI is very powerful and a GREAT asset to organization, however implementing it properly is more important than the pretty Power View Visualization the sales person shows you!
Speaker(s):
- David Ortiz
Track and Room: Room 218 - N/A
Title: The Modern Analytics Architecture
Abstract: The traditional data warehouse has been around a long time, and it isn’t going away anytime soon. However, with other options such as Hadoop and new analytic and data mining techniques, the warehouse is no longer the center of our business analytics universe. In this session, we will cover these new platforms and our approach for integrating them into your warehouse environment.
Speaker(s):
- Joseph D’Antoni
Track and Room: Room 117 - N/A
Title: Every Byte Counts: Why Your Data Type Choices Matter
Abstract: Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker(s):
- Andy Yun
Track and Room: Room 219 - N/A
Title: SQL Audit - auditing doesn’t have to be boring
Abstract: Let’s face it, auditing isn’t fun. But if you’re a DBA, you need to know what’s going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we’ll cover what you can and can’t audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn’t have to be hard. And with the help of a little custom coding, it can even be fun.
Speaker(s):
- Colleen Morrow
Track and Room: Room 214 - N/A
Title: Replicate and sync SQL Server data on mobile devices
Abstract: Zumero for SQL Server (ZSS) provides synchronization of SQL Server data with mobile devices (including iOS, Android, WinRT, WP8, Phonegap, and Xamarin). This session will provide an overview of ZSS and how it can be used to integrate with your existing SQL Server data and create great mobile apps that work offline.
Speaker(s):
- Wendy Pastrick
Track and Room: Room 217 - N/A
Title: Master Data Services
Abstract: Does your company have similar data in multiple locations? Not really sure which set of data is accurate? With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data to use with your applications or send to other databases and ETL processes. Leverage data stewards to help manage the data repository to ensure it is up-to-date and accurate. In this session we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this session, you should have a good understanding of what MDS does, how to use it, and how to get started with your own MDS project.
Speaker(s):
- Jeff Prom
Track and Room: Room 218 - N/A
Title: Best Practices for Database Deployment
Abstract: The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code?
The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.
Speaker(s):
- Grant Fritchey
Track and Room: Room 215 - N/A
Title: When Cluster and Virtualization Aren’t Enough: How to Create an Application Availability Framework
Abstract: Join us for a talk on how to create an application availability framework for any SQL Server implementation. Clustering and virtualization solved some of the issues around high availability, but then these “infrastructure-up” approaches raised new challenges, including rigid configuration rules and restrictions, expensive software stacks, and complex operational models. In this webinar, we’ll show you how you can focus on what matters most- your applications. Whether or not your environment already uses virtualization or clustering, this webinar will show you how to create an application availability framework that provides heterogeneous instance mobility from anything to anything, anywhere - truly physical, virtual, OS, SQL Server version agnostic. Ready for a new approach to assured availability? Attend this talk to learn how.
Speaker(s):
- Wendy Pastrick
Track and Room: Room 117 - N/A
Title: Fast and Flexible Applications with Better Database Design
Abstract: Are you a jack of all trades? Have you been writing application code AND designing databases? Are you spending lots of time altering your tables knowing there has just got to be a better way? This beginner session will take a tour through common pitfalls in database designs, discuss the repercussions of lacking standards, prove out consistency issues and help you keep your applications fast and flexible. A properly designed database should perform at the highest levels and not require a gargantuan effort to adapt to routine application growth.
Speaker(s):
- Bill Lescher
Track and Room: Room 218 - N/A
Title: PowerPivot and Excel Reporting
Abstract: In this session, learn how anyone with Excel experience can take advantage of PowerPivot, the free add-in for Excel, to quickly and easily turn data from different sources such as traditional databases, Analysis Services, Excel, or the web into a workable dataset. Use this data for ad hoc analysis or to create visually impressive reports directly in Excel. Then leverage SharePoint to automatically refresh the data and publish it to share with others in the organization.
Speaker(s):
- Melissa Meyer
Track and Room: Room 218 - N/A
Title: Pig\Hive - All That’s New is Old Again
Abstract: Pig and Hive sound strange and exotic, but what are they? As a SQL Server DBA you’ll find these two technologies to be quite familiar and easy to learn. Why? Because both were created for you. If you are a SQL Server DBA and you have to manage data in Hadoop, Pig and Hive may be your first tools of choice. This session will demystify both with clear examples and demos.
Speaker(s):
- Scott Shaw
Track and Room: Room 117 - N/A
Title: DBA 911 - Database Corruption
Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s):
- David Maxwell
Track and Room: Room 214 - N/A
Title: Managing SQL Server Performance with Extended Events
Abstract: One of a DBA’s primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it’s one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.
Speaker(s):
- Jason Strate
Track and Room: Room 219 - N/A
Title: Hybrid Solutions: The Future of SQL Server Disaster Recovery
Abstract: The cloud is a polarizing buzzword in IT, especially for DBAs. The reality is that all of us will be affected by it over the next few years in one way or another much like we have been by virtualization. One of the best uses for the cloud is creating disaster recovery easier than we have been able to do in the past. This session will discuss the cloud from a SQL Server DBA perspective and how things like hybrid on premise/cloud solutions can be architected today to bring resiliency to current solutions with features like availability groups in SQL Server 2012 and 2014.
Speaker(s):
- Allan Hirt
Track and Room: Room 216 - N/A
Title: 2012 TSQL Sweets
Abstract: The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you’ll have a taste for all the sweets they’ve packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
Speaker(s):
- Bill Fellows
Track and Room: Room 214 - N/A
Title: PowerShell and SQLPSX the Dynamic Duo for the DBA
Abstract: With PowerShell and SQLPSX your DBA life can be a lot simpler. SMO is powerful, but can be difficult to use. Enter SQLPSX. Chad Miller put together a set of PowerShell functions that streamline the use of SMO, easing management of a multi-server environment. Come learn when and how the addition of PowerShell and SQLPSX can benefit you.
Speaker(s):
- Jim Dorame
Track and Room: Room 215 - N/A
Title: Best Practices for your Very Large Databases
Abstract: As businesses’ data needs keep growing so do the sizes of the databases we are entrusted to manage. Faced with constant growth and the scale of multiple Terabytes, more DBA’s are facing the challenges to properly tune and maintain the VLDB’s in their environment.
In this session we will go into the best practices, tips and tricks learned from helping customers in the field with this common growing pain. We will cover the best way to do integrity checks, stats updates, index maintenance, partitioned tables and more so you can to tame your Very Large Databases and keep them running in top shape.
Speaker(s):
- Warner Chaves
Track and Room: Room 214 - N/A
Title: SQL Server Virtualization 101
Abstract: What is virtualization? What impact does it have on DBAs and their systems? What aspects of their job stays the same, and what changes? What is really going on inside that black box? The fundamentals of private cloud computing and how it impacts data professionals will be discussed in this interactive session. Tips on how to use the best of virtualization to improve their daily tasks and efficiencies will be demonstrated, and common questions and concerns will be addressed.
Speaker(s):
- David Klee
Track and Room: Room 116 - N/A
Title: Advanced Performance Tuning Tips with Database Performance Analyzer
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis with Database Performance Analyzer (formerly Confio Ignite). Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
Speaker(s):
- Wendy Pastrick
Track and Room: Room 219 - N/A
Title: Squeezing Top Performance from Your Virtualized SQL Server
Abstract: Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.
Speaker(s):
- David Klee
Track and Room: Room 216 - N/A
Title: MDX Trek: First Contact
Abstract: Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.
Speaker(s):
- Mark Vaillancourt
Track and Room: Room 217 - N/A
Title: Forward the Federations
Abstract: If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I’ll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data.
Speaker(s):
- MIKE DONNELLY
Track and Room: Room 219 - N/A
Title: Eureka! Visual deep dive into storage internals
Abstract: Sometimes half the battle in computing is just to see what’s happening. We will take a visual tour of physical database storage structures, using live demos with the freeware application SQL Server File Layout Viewer and our old friends the DBCC commands as guides. See what happens in a data file when you convert a table from a heap to a clustered index! See fragmentation and the havoc wrought by Shrink! Marvel at the behavior of multiple files and filegroups! Index Rebuilds! Eureka!
Speaker(s):
- Merrill Aldrich
Track and Room: Room 217 - N/A
Title: 5 Ways to Improve Performance through Indexing
Abstract: Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.
Speaker(s):
- Jason Strate
Track and Room: Room 217 - N/A
Title: Spatial Data: Cooler Than You’d Think!
Abstract: Spatial data has been around since 2008 but it should fire it’s PR person. It’s too bad that spatial data gets no love, it’s actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map.
Speaker(s):
- Hope Foley
Track and Room: Room 214 - N/A
Title: Keynote
Abstract: SQL 2014 - What’s New
Speaker(s):
- Wendy Pastrick
Track and Room: All Attendees - N/A
Title: Query Tuning Superstardom for Beginners
Abstract: In this session aimed at the novice query tuner we’ll explore what big results may be yielded through the smallest of query tweaks. We will explore impacts of removing unnecessary joins, predicate blunders and problems with returning too much information. The end result is to improve those bad queries and make you look like a tuning superstar.
Speaker(s):
- Tim Ford
Track and Room: Room 215 - N/A
Title: Women In Technology Panel
Abstract: Join us to hear from women in the SQL Server Community as they discuss their success as Women In Technology!
Speaker(s):
- Wendy Pastrick
Track and Room: Room 219 - N/A
Title: Achievement Unlocked: How to Get Promoted
Abstract: Have you ever felt like an extra in Office Space? You’ve got the skills. You’ve got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What’s the deal?
In this session, you’ll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker(s):
- Dave Mattingly
Track and Room: Room 219 - N/A
Title: Using Dell tools to improve visibility, efficiency and overall performance
Abstract: An overview of Dell Software’s Spotlight on SQL Server Enterprise and Performance Analysis for SQL Server. The session will focus on how the Dell tools improve visibility, efficiency and overall performance.
Speaker(s):
- Wendy Pastrick
Track and Room: Room 216 - N/A
Title: SSIS: The DBA Multiplier
Abstract: ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!
Speaker(s):
- Ted Krueger
Track and Room: Room 216 - N/A
Title: How to baseline performance for SQL Server
Abstract: Optimal configuration of he I/O subsystem is critical and can ultimately be responsible for the response times of your applications. In this session we analyze the different options that you have for your IO subsystem, what are their pros and cons, what tools are available to baseline the performance of the hardware that you will use for SQL Server and what numbers are important to you.
Speaker(s):
- Luke Jian
Track and Room: Room 117 - N/A
Title: Introduction to Big Data
Abstract: Political campaign predication, Google Flu trend, DNA sequencing, public sentiment on Twitter, and should I add ginger to the dish I am experimenting with? All the aforementioned topics have something in common: they use Big Data to help us understand this world and make intelligent decisions.
In this session, I will talk about some use cases of Big Data and the technologies behind the scene that enables it: Cloud computing, Hadoop/MapReduce, NoSQL, machine learning, statistics modeling, and such. I will also talk about what we this mean to data professionals like us and what we need to learn to face these challenges
Speaker(s):
- Haidong Ji
Track and Room: Room 117 - N/A
Title: Take SQL Server performance to the next level with SQL 2014 in-memory OLTP
Abstract: SQL Server 2014 ships with a powerful, new feature, to take your performance to the next level with In-Memory OLTP (Codename Hekaton). In-Memory OLTP unleashes today’s powerful processors and removes the roadblocks to new heights in performance. During the session, you will learn about the In-Memory OLTP capability, see a demo of its capabilities and gain an understanding on the behavior, scalability and use cases where it apply based on our extensive benchmark testing that we have completed.
Speaker(s):
- Ross LoForte
Track and Room: Room 116 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Frank Gill
Twitter: - skreebydba
LinkedIn: Frank Gill
Contact: http://skreebydba.com/
Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
Ross LoForte
Ross LoForte is a Technology Architect at the Microsoft Technology Center in Chicago focused on SQL Server solutions. With more than 16 years of business development, project management, and SQL architecture solutions experience, he has been working with the Microsoft Technology Centers the past 10 years and has led architecture design and proof-of-concept engagements for Microsoft’s largest and most strategic customers to design enterprise, mission-critical SQL Server solutions.
Adam Machanic
Twitter: - @AdamMachanic
LinkedIn: Adam Machanic
Contact: http://sqlblog.com/blogs/adam_machanic
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is the author of the award-winning SQL Server monitoring stored procedure, quot;sp_WhoIsActive.quot; He has contributed to several books on SQL Server, including quot;T-SQL Queryingquot; (Microsoft Press, 2015). He is a Microsoft Most Valuable Professional (MVP) for SQL Server.
Merrill Aldrich
Twitter: - @onupdatecascade
LinkedIn: Merrill Aldrich
Contact: http://sqlblog.com/blogs/merrill_aldrich/
Merrill is a consultant with the national Digital and Technology Consultancy RBA. In past lives he was a SQL Server DBA for Financial Services and Real Estate Management organizations, a designer of buildings, an expert in three dimensional computer graphics and building information modeling, a speaker, teacher, and visiting lecturer.
Colleen Morrow
Twitter: - @ClevelandDBA
LinkedIn: Colleen Morrow
Contact: http://colleenmorrow.com
Colleen Morrow is a database professional living in Cleveland, OH who has been working with database systems since 1996. For more than 12 years, she was a Database Administrator at a large law firm where she developed an appreciation for auditing, automation, and performance tuning. Since that time she has worked with clients in the healthcare, manufacturing, software, and distribution/freight delivery industries. Colleen is currently a Senior Consultant at Fortified Data. She is an active member of the Ohio North SQL Server User Group and has presented at many SQLSaturday events as well as PASS Summit 2014 and 2015.
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Mark Vaillancourt
Twitter: - @markvsql
LinkedIn: Mark Vaillancourt
Contact: http://markvsql.com
Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
Haidong Ji
Twitter: - @haidong
LinkedIn: Haidong Ji
Contact: http://www.haidongji.com
Haidong Ji is an experienced SQL Server and MySQL consultant, author of several SQL Server books, and an active speaker and participant in user groups and SQLSaturday events.
David Ortiz
Contact: http://www.sqlbigpapi.com
David Ortiz is a Solutions Director for The Glenture Group, an NTT Data Company. In this role I am responsible for participating and supporting all packaged solutions for our existing and potential clients. Furthermore, I am responsible for working on building out POC’s and developing potential accelerators leveraging latest technology within the Microsoft BI Stack.
Brian Beswick
LinkedIn: Brian Beswick
Contact: http://brianbeswick.com/
Brian is a Managing Consultant at Allegient. He has many years of experience in database architecture and development across multiple versions of SQL Server. He’s an accomplished Database Architect with a specialty in Business Intelligence. He’s particularly strong at understanding and designing solutions for complex requirements.
Ted Krueger
Twitter: - @onpnt
LinkedIn: Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdiramp;author=68
Ted Krueger is a SQL Server MVP and has been working in development and database administration for the better part of his career. Specialties range from High Availability and Disaster / Recovery design, implementation, testing methods and administration, down to custom assembly development for SQL Server Reporting Services.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
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.
Joseph D’Antoni
Twitter: - jdanton
LinkedIn: Joseph D’Antoni
Contact: http://joeydantoni.com
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Warner Chaves
Twitter: - @warchav
LinkedIn: Warner Chaves
Contact: http://sqlturbo.com
Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Ken Stuber
Twitter: - @KenStuber
LinkedIn: Ken Stuber
Contact: http://dropcleanbuffers.com/
Ken Stuber is the Data Architect at Jewelers Mutual Insurance in Neenah, WI as well as being an independent consultant with Drop Clean Buffers Consulting, LLC. Ken has been working with SQL Server since v6.5 in 1997 and has broad experience in the Microsoft Data Platform. His primary interests are in the performance tuning, enterprise architecture, DevOps, database design and database development. When not fighting the query optimizer, he can be found RVing around North America, backpacking, cooking, gardening, reading, and studying for whatever will replace the MCM program.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Jeff Prom
LinkedIn: Jeff Prom
Contact: http://jeffprom.com/
Jeff Prom is a Data and BI Developer with over 15 years experience. From a wide variety of industries, he has worked at corportations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect in Minnesota.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Eric D. Boyd
Twitter: - @EricDBoyd
Contact: http://www.ericdboyd.com
Eric D. Boyd is a Director for Centare Group, Ltd. and is responsible for their Chicago business and Cloud Computing Practice. Eric began his technology career by starting a web development firm in the 90’s and has served in multiple roles since including developer, consultant, business owner and technology executive. Today, he primarily helps Fortune 500 companies with software development practices and cloud computing in the Chicago-Milwaukee area.
Ed Leighton-Dick
Twitter: - eleightondick
LinkedIn: Ed Leighton-Dick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
Jim Dorame
Twitter: - @DBAJD
LinkedIn: Jim Dorame
Contact: http://www.jamesdorame.com/
Jim Dorame has been working with SQL Server for over 20 years. Over those years he has learned a great deal from the SQL community. He has also given back to the community in the hopes that he may help someone in their career. He is always looking for something to learn and luckily Microsoft keeps adding to SQL Server.
Laerte Junior
Twitter: - @laertesqldba
LinkedIn: Laerte Junior
Contact: https://www.red-gate.com/simple-talk/author/laerte-junior/
Laerte Junior is a Windows PowerShell MVP Reconnect, PASS PowerShell VC Co-lead and, through his simple-talk articles, an active member of the Microsoft Community around the world. He also is a huge Star Wars fan (yes, he has the Darth Vader#180;s Helmet with the voice changer). He has a passion for DC comics and living the simple life.
Bill Lescher
Twitter: - https://twitter.com/blescher
LinkedIn: Bill Lescher
Bill has over 20 years of database administration and development experience. He is a co-founder of the Chicago chapter of the Professional Association for SQL Server (PASS), where he served as President for its first decade. He is a recipient of the “Outstanding PASS Volunteer” award, and he was a top 5 finalist of the Exceptional DBA Award. Bill has been a key organizer of the annual “SQLSaturdays” in Chicago. An Alum of Illinois State University, he was born and raised in Chicagoland.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Hope Foley
Twitter: - hope_foley
LinkedIn: Hope Foley
Contact: http://www.hopefoley.com
Hope Foley, a former Data Platform MVP, has worked across many industries as a DBA and Business Intelligence consultant. She joined team at Microsoft and is a Data AI Technology Solutions Professional. She has worked with enterprise customers but now focuses on education. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing the SQLSaturday event in Indianapolis.
Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw is the co-author of two books on T-SQL through Apress publishing. He is a frequent speaker at SQL community events and is the co-leader for the PASS Virtual Chapter on Virtualization. He frequently teaches Big Data and Microsoft BI related courses for Saint Louis University Workforce and Organizational Development Center. He currently lives in Saint Louis working for Oakwood Systems Group as a Principal Consultant and Data Management Lead.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Melissa Meyer
Contact: http://www.covenanttechnologypartners.com
Melissa is an architect with Covenant Technology Partners who has a passion for all things data. Melissa has been worked in BI for 10 years and specializes in implementing the SharePoint BI stack and BI solutions of all types and sizes. In her free time, she enjoys travel, hunting, cooking and spending time with family.
Jason Strate
Twitter: - @stratesql
LinkedIn: Jason Strate
Contact: http://www.jasonstrate.com/
Jason Strate is a SQL Server Solutions Architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. Jason writes, blogs, and presents on SQL Server.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Luke Jian
Twitter: - @sensware
LinkedIn: Luke Jian
Contact: http://blog.sqlpositive.com
Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.
MIKE DONNELLY
Twitter: - SQLMD
LinkedIn: MIKE DONNELLY
Contact: http://sqlmd.wordpress.com
Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
Mark Vaillancourt
Twitter: - @markvsql
LinkedIn: Mark Vaillancourt
Contact: http://markvsql.com
Mark is a Data Solutions Architect for Microsoft, helping organizations design data solutions in Azure. He has been working with Microsoft data technologies since 2007. Before joining Microsoft, he was a Business Intelligence consultant and two-time Microsoft Data Platform MVP. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.
Dave Mattingly
Twitter: - @dave_mattingly
LinkedIn: Dave Mattingly
Contact: http://www.davemattingly.net
Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Grant Fritchey
Twitter: - @gfritchey
LinkedIn: Grant Fritchey
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
Michael Schulte
Mike Schulte is a decision support analyst at Gateway Health Plan. He works with tools such as SQL, Tableau, R, SAS, Azure Machine Learning, and Spark to use data to support decisions. These days he is trying to change the world by supporting value-based healthcare initiatives, whereby healthcare costs are lowered while quality of care is improved! In his spare time, he teaches economics and philosophy courses, plays chess and directs chess tournaments, and rings bells in church bell towers.
Sponsors
The following is a list of sponsors that helped fund the event: