SQLSaturday #309 - Oklahoma City 2014
Event Date: 08/23/2014 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: 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: Dev - N/A
Title: Parent/Child Structures in SSIS
Abstract: SQL Server Integration Services provides the ability to nest packages within one another in a parent/child structure. By creating a multilayer package infrastructure using native elements of SSIS, you can easily encapsulate reusable components of your ETL layer, simplify logging, and make the development process more efficient.
In this session, we’ll take a tour through parent/child design architecture within SSIS. We’ll discuss the advantages of using the parent/child architecture while reviewing various design patterns. We’ll review the capabilities within the various versions of SSIS (2005 through 2014) and discuss the buttons and switches that make it work. Finally, we’ll have a number of realistic demonstrations to fully illustrate these concepts.
Speaker(s):
- Tim Mitchell
Track and Room: Dev - N/A
Title: Design and Implement BI like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s):
- William E Pearson III
Track and Room: Bonus 1 - N/A
Title: Getting Started with MDX
Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s):
- William E Pearson III
Track and Room: Bonus 1 - N/A
Title: SQL Server Storage internals: Looking under the hood.
Abstract: Ever wonder what goes on under the hood of your SQL Servers? SQL Server is a complicated system. Understanding how your data is actually stored on disk can have a profound effect on the choices you make while designing and architecting a solution. In this session I’ll show you how data is physically stored and how choices you make effect performance. We’ll look at the structure of rows and data pages, index allocation maps, and the physical differences between heaps and clustered indexes.
Speaker(s):
- Brandon Leach
Track and Room: DBA - N/A
Title: Power This, Power That…Making Sense of Power BI
Abstract: With the introduction of Power BI, Microsoft has moved one step closer to its vision of self-service BI for all. But with this new offering comes a bevy of “Power” apps that are bound to confuse just about anyone. In this session, we will power through Power BI for Office 365 bringing meaning to the mess of names like Power Query, Power Map, Power Pivot and Power View and how these experiences are delivered through Microsoft Excel and Office 365. Expect to leave with the power of insight into an exciting new offering that captures the essence of self-service BI.
Speaker(s):
- Brett Tomson
Track and Room: Bonus 1 - N/A
Title: Windowing Functions
Abstract: Window functions are one of the coolest new things in SQL Server 2012, 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: Bonus 2 - N/A
Title: BI Basics - Finding Return on Data
Abstract: This session will you chart the waters through the sea of Business Intelligence (BI) options. IT departments need tools to turn data into useful information for users. Instead of ROI, this session talks about Return on Data’ for IT Managers.
In this session we look at the roles of data warehousing, big data and business intelligence systems. The Microsoft BI stack has evolved from traditional OLAP cubes to include tabular models, PowerBI, integration with HADOOP, reporting tools and full integration with SharePoint. This session is non-technical.
Speaker(s):
- Allen Smith
Track and Room: BI - N/A
Title: T-SQL Throwdown
Abstract: Join us for a game of SQL that combines fun, learning SQL, networking, and friendly competition with your peers. Create your team for a SQL-off against other teams. If you can write a SQL query, you have the skills required to play. Each team must bring a laptop with SQL Server 2012 Express and AdventureWorks 2012 pre-installed. Please read full rules here: http://www.sqlzen.com/t-sql-throwdown.html
Track: Developer
Speaker(s):
- Hakim Ali
Track and Room: Dev - N/A
Title: Converting Unreliable Deployments Into Consistent Releases
Abstract: The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments. When you create an object like a table or stored procedure, you need to get this object deployed into each environment. Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.
Speaker(s):
- Thomas Norman
Track and Room: Bonus 2 - N/A
Title: Source Code Control: Revision management for the data dude.
Abstract: Ever wanted to see what has changed since the last time you looked, or work with someone else and realize you’ve both changed the same stored procedure? Do you really enjoy searching through folder after folder of obscure .sql files to find the query you might or might not have saved last week? There is a better way, and it doesn’t have to be a hassle. In this session we’ll look at why you would want a revision management system and options (build or buy, free or fee) to implement one for yourself or your team.
Speaker(s):
- Tim Costello
Track and Room: Bonus 2 - N/A
Title: Overcoming Complex Data Cleansing Challenges with Excel Power Query
Abstract: Building off the earlier session, “Finding Cleansing Data with Excel Power Query”, we will explore more advanced techniques for cleansing data using Excel Power Query including the use of Power Query expressions. Armed with these techniques, analysts should feel confident tackling some of the gnarliest data cleansing challenges.
Speaker(s):
- Bryan Smith
Track and Room: BI - N/A
Title: Finding and Cleansing Data with Excel Power Query
Abstract: The hardest part of the analyst’s job is finding data to support his or her work. And once that data is found, it is often in less than ideal shape for our needs. With Excel Power Query, the analyst now has capabilities to find and cleanse data, resulting in huge time savings. In this session, you will learn the basics of working with Power Query.
Speaker(s):
- Bryan Smith
Track and Room: BI - N/A
Title: Building an MDM Center of Excellence with MDS and Maestro
Abstract: Learn how to build a Master Data Management (MDM) Center of Excellence with Best Practices using extensive demonstration of SQL Server Master Data Services (MDS) and Profisee’s Maestro product. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.
Speaker(s):
- Pam Matthews
Track and Room: BI - N/A
Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control
Abstract: Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.
Speaker(s):
- Mike Byrd
Track and Room: Bonus 2 - N/A
Title: I’m New, Select Me!
Abstract: I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker(s):
- Thomas Norman
Track and Room: Bonus 2 - N/A
Title: Develop SQL Server Databases from Visual Studio: SQL Server Data Tools
Abstract: Did you know you can design and develop databases from within Visual Studio using SQL Server Data Tools? Attend this session to find out how to take database development to the next level using Visual Studio. Discover simple ways to manage databases using a tool designed by Microsoft.
Speaker(s):
- Patrick Bewley
Track and Room: Dev - N/A
Title: Introduction to Powershell cmdlets for DBAs
Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. You’ll want to take notes, or better yet, bring your laptop and start using Powershell immediately. We will get Posh running and then I’ll introduce you to the basic concepts, with examples to make things happen right away. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
Speaker(s):
- Jennifer McCown
Track and Room: Bonus 1 - N/A
Title: BIML: Taking the Pain Out of Integration Services Development
Abstract: You have data to move, but you’re tired of the pain and suffering that SQL Server Integration Services (SSIS) development brings. Business Intelligence Markup Language (BIML) is a popular meta-language that describes SSIS packages and solutions. In this high-speed, demo-laden session, we will look at some of the worst problems in SSIS development and how easily BIML sidesteps them while making you more productive. Most importantly, this session will demonstrate that you can develop SSIS packages without pulling out your hair!
Speaker(s):
- Jeremy Marx
Track and Room: Bonus 2 - N/A
Title: DIY Performance Reporting
Abstract: Stop relying on vendors to provide you with performance data. Between Windows and SQL Server you’ve already got all you need to collect and report on server performance. And it’s far more flexible than you’ll ever get from a vendor. This is often called a poor man’s method, but it’s so much more than that. I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.
Speaker(s):
- Sean McCown
Track and Room: Bonus 1 - N/A
Title: Data Discovery and Insights using Excel 2013 Power BI
Abstract: In this session you will learn how to provide valuable data insights through data discovery and visualisation with Microsoft’s Power BI capabilities. You’ll learn how to connect and discover the world’s data to enhance data discovery over your own and externally available datasets and how to combine multiple datasets together. You’ll also learn how to use existing and new data visualisation capabilities together using Power View and Power Map in Excel 2013, and get a deep drilldown into the Power BI capabilities.
Speaker(s):
- Derek Dai
Track and Room: BI - N/A
Title: Beginning Automation with Powershell
Abstract: This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven’t gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you wil learn how you can leverage Powershell to not only efficiently meet the needs of your busines, but also free up your time for other things.
Speaker(s):
- Amy Herold
Track and Room: DBA - N/A
Title: SQL Watchdog - find out instantly when SQL changes in production
Abstract: Almost everyone’s seen it happen - problems due to changes, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically and track down what changes were made when, by who, and from where? What if you could see in realtime when changes occur? It exists, it’s built into SQL Server standard edition from 2005-2014, and it’s easy to implement. Come learn what Event Notification is and why you’ll want it in your environment. This is not theory, all code provided and in production on hundreds of servers in multiple environments.
Speaker(s):
- Michael Bourgon
Track and Room: DBA - N/A
Title: Temporary Query Items and You
Abstract: Temporary Tables. Table Variables. Views. CTEs. Derived Tables. All of these are useful for some form of temporarily persisted query or data, but how do you choose between them? Join JK as he works his way through the strengths and weaknesses of each of these items, their scope and their impact on your queries in this demo-heavy session.
Speaker(s):
- JK Wood
Track and Room: Dev - 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: DBA - N/A
Title: Understanding Storage Systems and SQL Server
Abstract: The most important part of your SQL Server is also the slowest, Storage. This talk will take you through the fundamentals of your server’s Disk I/O System. From how hard drives work, through RAID configurations, and how to configure the file system. This session should give you a solid foundation over storage systems and help you understand why they are slow and how to overcome some of their limitations.
Speaker(s):
- Wesley Brown
Track and Room: DBA - N/A
Title: T-SQL Code Sins
Abstract: It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.
Speaker(s):
- Jennifer McCown
Track and Room: Bonus 1 - N/A
Title: Expand your TSQL: Intersect, Except, and Apply
Abstract: We all know and love inner join, outer join, in and exists. But, there are a several other TSQL operators that do not get as much press as the rest. Expand your TSQL tool belt with Intersect, Except, Cross Apply, and Outer Apply. You’ll get practical examples that you can use on Monday morning!
Speaker(s):
- Rudy Rodarte
Track and Room: Dev - N/A
Title: ColumnStore Indexes in SQL 2014
Abstract: ColumnStore indexes were first introduced as xVelocity with SQL 2012 as a way to improve query performance against large data sets by grouping and storing columns of data instead of rows. With SQL 2014, those ColumnStore indexes become update-able. In this session, we review the difference in ColumnStore indexes, implementing ColumnStore indexes Clustered and Non-Clustered and monitor performance.
Speaker(s):
- Allen Smith
Track and Room: BI - N/A
Title: AlwaysOn Live Deployment
Abstract: This session is 90% live demonstrations. I’ll walk you through a complete AlwaysOn deployment. You will see firsthand how to install and configure an AlwaysOn Failover Cluster. I’ll also show you how to setup an AlwaysOn Availability Group across 5 nodes using both the GUI and T-SQL so you know why and when to use each method. I’ll finish up by showing how you can connect to a readable secondary.
Speaker(s):
- Ryan Adams
Track and Room: DBA - 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.
Allen Smith
Contact: http://www.cognitiveinfo.com
Allen Smith is a business intelligence and data warehouse builder, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a Sr. Business Intelligence Lead at Devon Energy. He enjoys sushi, traveling to obscure places, fixing Rubik’s cubes and prefers Marvel over DC.
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
Allen Smith
Contact: http://www.cognitiveinfo.com
Allen Smith is a business intelligence and data warehouse builder, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a Sr. Business Intelligence Lead at Devon Energy. He enjoys sushi, traveling to obscure places, fixing Rubik’s cubes and prefers Marvel over DC.
Michael Bourgon
Twitter: - @mbourgon
LinkedIn: Michael Bourgon
Contact: http://thebakingdba.blogspot.com
Michael Bourgon started his IT career by performing tech support and managing Sybase databases on Unix starting in 1995, before moving to SQL Server 7… continuing all the way to SQL Server 2017. His focus on automation has led him to such diverse topics as Service Broker, WMI, Table Partitioning, Shell scripting, In-Memory Tables, and Powershell. He’s currently a senior DBA with a large healthcare company, dealing with millions of transactions of day and managing hundreds of servers. In his spare time he rides a bicycle, reads science fiction, blogs about SQL Server and Baking, and tries to raise his daughter to be a geek, too.
Brandon Leach
Twitter: - SQLServerNerd
LinkedIn: Brandon Leach
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
Derek Dai
Contact: http://derekdb.wordpress.com/
Over 10 years’ experience in database design, development, and administration using a wide variety of tools and technologies. Having focused on Business Intelligence using the SQL Server BI stack (SSAS, SSRS, SSIS, Power-pivot, Semantic Model and Data Mining) with solid knowledge on SQL Server DB Core engine. And extensive experience with Microsoft development tools. PASS VC Leader; MCT; MSCE BI and Data Platform
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
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.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
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.
Rudy Rodarte
Twitter: - http://www.twitter.com/shadyrudy
Contact: http://www.rodolforodarte.com
Rudy Rodarte works at Dimensional Fund Advisors as a DBA optimizing existing TSQL code, deploying SQL Server 2012, and implementing DB change tickets. Previously, Rudy spent 3 years at HotSchedules.com maintaining databases used by all major restaurants in the US. Rudy also spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in the Americas. Away from the keyboard, Rudy is a big fan of Liverpool Football amp; the Baylor Bears
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
JK Wood
Contact: http://www.sqlslacker.net
JK Wood is a Data Warehouse developer with three years of experience working with SQL Server and has worked and played with computers since the mid nineties. He is passionate about helping people to move beyond just writing code to writing beautiful, functional, and above all maintainable software. JK is an active member of the SQL community. He is involved with the Southwest Missouri SQL Server User Group and blogs at http://www.sqlslacker.net
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 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.
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.
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.
Wesley Brown
Twitter: - @sqlserverio
LinkedIn: Wesley Brown
Contact: http://www.sqlserverio.com
Wesley Brown is a former SQL Server MVP and PASS Chapter Leader who loves to teach others about SQL Server.He maintains his technical blog at http://www.sqlserverio.com. Wes specializes in high availability, disaster recovery, and large-scale database performance tuning.
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.
Jennifer McCown
Twitter: - https://twitter.com/MidnightDBA
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.
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.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Jeremy Marx
Twitter: - http://twitter.com/jmarx
LinkedIn: Jeremy Marx
Contact: https://www.interworks.com/company/our-team/staff/jeremy-marx
Jeremy Marx is#160;a Data Engineer with InterWorks, specializing in staging data for business intelligence initiatives for clients from nonprofits to Fortune 500 corporations. He also has a decade of experience in SQL Server as a DBA and is President of the Tulsa SQL Server User Group.
Brett Tomson
Brett Tomson is the owner of Beam Consulting as well as a Mentor with SolidQ specializing in delivering solutions using the Microsoft Business Intelligence stack and related .NET technologies. He is an accomplished architect and developer of large-scale enterprise systems as well as an author and mentor to others. Brett has been using SQL Server actively for the past 15 years and is the founder and Chapter Leader of the Triangle SQL Server User Group located in Raleigh, NC.
Patrick Bewley
LinkedIn: Patrick Bewley
Patrick Bewley is a developer turned DBA. He has worked with SQL Server and Microsoft development for 14 years. He specializes in technical and business process improvement, especially as it applies to SQL Server databases.
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.
Jennifer McCown
Twitter: - https://twitter.com/MidnightDBA
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.
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.
Pam Matthews
Contact: http://www.profisee.com
Pam Matthews is Director of Customer Solutions with Profisee. Profisee is the successor to the company Stratature that built the SQL Server Master Data Services (MDS) product which Microsoft acquired in 2007. Profisee focuses on Master Data Management (MDM) solutions. Pam has spent the last 10 years providing training, support and implementation assistance to customers implementing master data management projects utilizing MDS.
Sponsors
The following is a list of sponsors that helped fund the event: