SQLSaturday #422 - Oklahoma City 2015
Event Date: 08/29/2015 00:00:00
Event Location:
- Moore/Norman Technology Center South Penn Campus
- 13301 South Pennsylvania Avenue
- Oklahoma City, Oklahoma
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: SQL Server for the Configuration Manager 2012 administrator
Abstract: SQL Server is a core dependency for all components of the System Center suite of products. Configuration Manager 2012, a component of the suite, will be the focus of our discussion as it is more demanding that a typical SQL application. To best support Configuration Manager 2012 administrators need to understand database structure, configurations that will allow for optimal SQL performance, the way Configuration Manager 2012 replication leverages the SQL Broker engine and more. This session will focus on the nuggets that the Configuration Manager administrator needs to understand to make sense of the SQL backend. Beyond the Configuration Manager 2012 administrator discussions will be interesting to anyone trying to tune SQL.
Speaker(s):
- Steven Rachui
Track and Room: Pyramid Analytics - Dell
Title: Managing Security in SSIS
Abstract: In the world of extraction, transformation, and loading (ETL), everything we do involves moving data from one point to another. However, very often the focus in SSIS package development is on functionality, not security. When building internal data transformation and movement processes, it is easy to forget that these operations broaden our security footprint, and must be actively managed to ensure that ETL doesn’t become the weak link in the security chain. In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover: Properly securing connection passwords in SSIS Using package protection levels Restricting access to deployed packages Using role-based security for SSIS deployment and execution Using execution proxies
Speaker(s):
- Tim Mitchell
Track and Room: Pyramid Analytics - N/A
Title: Incremental Load Design Patterns
Abstract: The volume of data addressed by the typical ETL operation is constantly on the rise. Not so many years ago, a table with a few million records was considered to be huge. These days, it’s not uncommon to deal with multibillion row tables. As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.
In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: –Deciding whether an incremental load is appropriate –Pick your tool: T-SQL or SSIS? –Methods for detecting new and changed records –Common incremental load design patterns
Speaker(s):
- Tim Mitchell
Track and Room: Pyramid Analytics - Track E
Title: SS2014 In-Memory Tables: Formula 1 Performance Unleashed!
Abstract:
Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment.
After this session you will
- Understand what in-memory tables are and how to create and maintain them including their limitations
- Be able to identify performance gains over equivalent disk back tables
- Comprehend the new data monitoring needed for in-memory tables
Speaker(s):
- Mike Byrd
Track and Room: Microsoft - Track D
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you. Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.
Speaker(s):
- Sean McCown
Track and Room: Track D - Microsoft
Title: INDEXING 101 - WHAT IS AN INDEX?
Abstract: If your eyes glaze over when you read the terms ‘clustered index’ or ‘non-clustered index’, and you think you really ought to know what these are, this may just be the session for you.
This session is designed for those new to database design/development. If you have some idea of how databases and tables are used, but need a (re)grounding in the basic concepts of indexing and how to use them to your advantage, you will benefit from this session. You will leave knowing what a clustered index is, what a non-clustered index is, when to use them, how to use them, their advantages and disadvantages. We will start at a very high level with simple examples and basic definitions, and then go into details of how indexes work and practical examples of index usage in T-SQL.
Speaker(s):
- Hakim Ali
Track and Room: Microsoft - Dell
Title: Scripting out SQL Server for Documentation and Disaster Recovery
Abstract: Most DBAs need to use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
Speaker(s):
- George Walkey
Track and Room: Microsoft - Dell
Title: Minion Maintenance and Backup Solutions
Abstract: The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable. In this session I’ll show you the benefits to Minion Reindex and Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.
Speaker(s):
- Sean McCown
Track and Room: Track D - Microsoft
Title: Automating Your Database Deployments
Abstract: Deploying your database changes to production can be nerve-wracking. We’ll discuss methods that take the stress out of the process by ensuring that you practice your deployments using continuous integration before you ever get near production. Automating the deployment and testing processes through various pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.
In this session, we’ll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We’ll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.
Speaker(s):
- Grant Fritchey
Track and Room: Microsoft - Pyramid Analytics
Title: Backup and Restore Tips and Tricks
Abstract: Do you need to devise a backup and restore plan to meet the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) of your business? I’ll show you how to pick the right backup type, method, and recovery model to meet your business needs. You’ll learn how the network and drive format can have an effect on your backups and avoid the pitfalls that slow down your backup and restore plan. You’ll also learn how to keep your transaction log from growing uncontrollably while speeding up your backups and restores using the native tools without any added cost!
Speaker(s):
- Ryan Adams
Track and Room: Pyramid Analytics - Track D
Title: Automate your daily checklist with PBM and CMS
Abstract: This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.
Speaker(s):
- John Sterrett
Track and Room: Dell - Microsoft
Title: Designing Stored Procedure Solutions
Abstract: With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:
Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance
This session is for data professionals who can write T-SQL, but haven’t spent a lot of time in SQL development.
Speaker(s):
- Jennifer McCown
Track and Room: Microsoft - Dell
Title: Troubleshooting SQL Server Performance
Abstract: Microsoft SQL Support Engineers troubleshoot performance issues all day, every day. They use a set of tools that not only gather all the data necessary to troubleshoot any performance issue, but the tools also analyze the data and generate visually attractive reports. These tools have been available to the public for free for years. This presentation explains the tools, how to run them and how to interpret the results, including how to determine disk latency root cause, top reasons for high cpu, and what to do when you have excessive waits.
Speaker(s):
- Stacy Gray
Track and Room: Pyramid Analytics - Pyramid Analytics
Title: Things i wish I knew sooner about data loading.
Abstract: In this session I’ll share some of the lessons I’ve learned the hard way about loading data. I’ll show you some ways SQL Server Integration Services can make your life easier (or harder!) and ways you can move data without ever leaving SQL Server management studio. Want to move data like a boss Monday morning? This session will show you how!
Speaker(s):
- Tim Costello
Track and Room: Pyramid Analytics - Microsoft
Title: SQL Security Best Practices Shrinking Your Attack Surface
Abstract: Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA’s tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data. In addition, attending this talk is worth 1.5 Continuing Education credits.
Speaker(s):
- Matthew Brimer
Track and Room: Microsoft - Dell
Title: SSIS Project Deployment Model: Deployment and maintenance
Abstract: In this session, you’ll learn everything you need to know to successfully deliver a modern SSIS solution. We’ll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.
Speaker(s):
- Bill Fellows
Track and Room: Microsoft - Pyramid Analytics
Title: Common Coding Mistakes and how to Mitigate them
Abstract: There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker(s):
- William Wolf
Track and Room: Pyramid Analytics - Track E
Title: Biml – The Next Step in Agile Data Warehousing
Abstract: Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker(s):
- David Stein
Track and Room: Microsoft - Track E
Title: Azure SQL Database Elastic Scale
Abstract: Azure SQL Database Elastic Scale enables the data-tier of an application to scale out and in via industry-standard sharding practices, while significantly streamlining the development and management of your sharded cloud applications. Elastic Scale delivers both developer and management functionality which are provided through a set of .Net libraries and through Azure service templates that you can host in your own Azure subscription to manage your highly scalable applications. Azure DB Elastic Scale implements the infrastructure aspects of sharding and thus allows you to focus on the business logic of your application instead.
Speaker(s):
- Shawn Weisfeld
Track and Room: Pyramid Analytics - Track D
Title: Database Development with Visual Studio 101
Abstract: Learn how to design, develop and deploy databases with Microsoft Visual Studio’s SSDT (SQL Server Data Tools).
Speaker(s):
- Hakim Ali
Track and Room: Pyramid Analytics - Track E
Title: Windowing Functions
Abstract: Window functions are some of the coolest things SQL Server, but they can be tricky to figure out. In this session we’ll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning!
Speaker(s):
- Tim Costello
Track and Room: Pyramid Analytics - Track D
Title: Churn Analytics with Azure ML
Abstract: In this session, we will explore the topic of customer churn analytics and then build a predictive model for customer churn using Azure ML Studio.
Speaker(s):
- Bryan Smith
Track and Room: Pyramid Analytics - Track E
Title: Back to Basics - The SELECT Statement
Abstract: Are you new to SQL Server? Have you just started and still need to understand the basics of how you query data from SQL Server. If you answered yes, then this session is for you. We are going back to basics and spending the entire hour on just the Select statement.
Speaker(s):
- Andrew Karcher
Track and Room: Pyramid Analytics - Track D
Title: SMO Internals for High Performance Automation
Abstract: Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: Pyramid Analytics - Dell
Title: Overview of SSAS Tabular
Abstract: #183; Setting the Table—Creating a Tabular BI Semantic Model #183; Preparation for Creating Tabular Models #183; SQL Server Analysis Services Tabular Instance #183; Managing the Workspace Database #183; Creating a Tabular Model #183; Data Sources for Our Tabular Models #183; Creating Measures in a Tabular Model using DAX #183; Manually Creating a Time Table #183; Relationships and Hierarchies #183; Validating the Model Using the Analyze in Excel Feature
Speaker(s):
- jim hudson
Track and Room: Pyramid Analytics - Pyramid Analytics
Title: Making the Leap from Developer to DBA
Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s):
- Amy Herold
Track and Room: Pyramid Analytics - Pyramid Analytics
Title: A NoSQL Primer for the SQL Server Developer
Abstract: You have all probably heard about this “NoSQL” thing and wondered what is about, how does it differ from SQL Server and how will this affect me. You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions. We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:
- The different types of NoSQL databases
- Some use cases where they might be applicable
- Some of the major solutions out there for each one
Speaker(s):
- Andrew Karcher
Track and Room: Pyramid Analytics - Microsoft
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Andrew Karcher
Twitter: - @akarcher
Contact: http://www.andrewkarcher.com
Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
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.
Hakim Ali
Twitter: - @forhakim
LinkedIn: Hakim Ali
Contact: http://www.sqlzen.com/blog
Database developer and designer with valuable experience on and a great liking for SQL Server. Trying to get the word out on developing SQL Server databases with Visual Studio.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
Bryan Smith
LinkedIn: Bryan Smith
Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
George Walkey
Twitter: - sqlbytehd
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
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.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Sean McCown
Twitter: - @KenpoDBA
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
jim hudson
Twitter: - @Hudson_OakTree
LinkedIn: jim hudson
Contact: http://www.oaktreeit.com
I teach and consult on SQL Server,SharePoint and Business Intelligence Development and Administration, including SSAS, SSRS, and SSIS. I#39;ve written Web Parts, Workflows and Application Pages in C# as well as several large scale Enterprise SharePoint applications managing terabytes of data. Lately, I#39;m doing a lot of Power BI using Power Query, Power Pivot, Power Map and Power View and integrating them with Office 365.
Tim Costello
Twitter: - timcost
LinkedIn: Tim Costello
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
Andrew Karcher
Twitter: - @akarcher
Contact: http://www.andrewkarcher.com
Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.
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.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Matthew Brimer
Twitter: - @sqlcenturion
LinkedIn: Matthew Brimer
Contact: http://www.sqlcenturion.com
Matthew Brimer has 10 years experience with SQL Server, 3 of which was spent as a Database Security expert for a Department of Defense Agency and 5 as the Database/Security Manager for a leading Pharmacy Services Company. These days Matt can be found helping customers get the most out of the Databases/Servers/Networks as a Consultant for InterWorks. Matt also holds several Security and Microsoft Certifications, is the President of OKC SQL PASS Chapter and is the former Event Chair for SQLSaturday Oklahoma City.
Hakim Ali
Twitter: - @forhakim
LinkedIn: Hakim Ali
Contact: http://www.sqlzen.com/blog
Database developer and designer with valuable experience on and a great liking for SQL Server. Trying to get the word out on developing SQL Server databases with Visual Studio.
Tim Costello
Twitter: - timcost
LinkedIn: Tim Costello
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
Jennifer McCown
Twitter: - http://www.Twitter.com/MidnightDBA
LinkedIn: Jennifer McCown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Stacy Gray
Contact: https://stacylaray.wordpress.com
Stacy is a Technical Advisor in Microsoft’s Global Business Support team based in Las Colinas, Texas. Prior to joining Microsoft in 2011, her job titles ranged from Systems Engineer to DBA. In 1999 Stacy earned her MCSE (NT, SQL65, TCP/IP), and is currently working on her MCSE: Data Platform certification for SQL 2012.
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
Shawn Weisfeld
Twitter: - https://twitter.com/shawnweisfeld
LinkedIn: Shawn Weisfeld
Contact: http://www.usergroup.tv
Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld
Steven Rachui
Contact: http://blogs.msdn.com/steverac
Steven has supported System Center products at Microsoft for 16 years and currently works in the premier field engineering group. He hosts a popular System Center blog, has served as an author and technical editor for several System Center books and has been an active participant and speaker at MMS for the past several years. He has also traveled extensively within the US and Internationally helping customers learn and better make use of System Center technology.
Sponsors
The following is a list of sponsors that helped fund the event: