SQLSaturday #197 - Omaha 2013

Event Date: 04/06/2013 00:00:00

Event Location:

  • Mammel Hall, University of Nebraska-Omaha
  • 6708 Pine Street
  • Omaha, Nebraska

PDF of Schedule

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: Hardware 201: Selecting Database Hardware

Abstract: The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.

Speaker(s):

  • Glenn Berry

Track and Room: DBA - N/A


Title: Beyond Plateaux: Optimize SSAS via Best Practices

Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs.

Speaker(s):

  • William E Pearson III

Track and Room: Business Intelligence - N/A


Title: Tips and Tricks for Auditing in SQL Server

Abstract: SQL Server 2005 and later continued to introduce tools to help you audit what was occurring in your database, with 2012 introducing even more auditing tools. In this session, we’ll go over the questions you need to ask your business to determine what level of auditing is appropriate. We’ll go through how to set up many of the common audits to meet your business’ requirements. Each technique has its features and each has associated costs - your goal is to find a balance.

Speaker(s):

  • Ronald Yenko

Track and Room: General - N/A


Title: Extend your Knowledge with Extended Events

Abstract: With 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database. This presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance. We will create a new Event and I will show you how you can use the data collected to report commonly monitored statistics.

Speaker(s):

  • Kathy Gibbs

Track and Room: DBA - N/A


Title: Building Dashboards in PerformancePoint

Abstract: PerformancePoint can be a useful tool for delivering a dashboard to users through SharePoint. The data visualizations for your dashboard can come from PerformancePoint, Excel Services, Reporting Services, or a web page. Understanding the features and limitations of these sources of data visualizations can help you create a dashboard that best meets your users’ needs.

Speaker(s):

  • Meagan Longoria

Track and Room: Business Intelligence - N/A


Title: Troubleshooting Query Plan Quality Issues

Abstract: When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.

Speaker(s):

  • Joe Sack

Track and Room: Developer - N/A


Title: Designing a Data Recovery Solution

Abstract: Having scheduled database backups is one thing, but knowing what backup types are needed is a different horse of a different color. Building on the “Backups 101” session, this discussion focuses on why we should build Recovery solutions instead of Backup solutions, and the most important things to remember when designing the solution.

Speaker(s):

  • Brandie Tarvin

Track and Room: General - N/A


Title: Dimensional Modelling for the DBA

Abstract: Have you ever wondered what’s going on with that SQL Server Analysis server you support? Do you want to know what this BI fuss is all about? I’ll walk you through the basics of dimensional modelling to help you understand from a operational DBA perspective what’s going on and why a BI system needs to be treated differently. I’ll take the mysticism out of the differences between OLTP and OLAP and provide a method to the maddness.

Speaker(s):

  • Scott Shaw

Track and Room: Business Intelligence - N/A


Title: Amazon RDS and SQL Azure - DB in the cloud

Abstract: Amazon’s AWS and Microsoft’s Azure both offer SQL Server instances as services (not necessarily as servers). What do they offer, why would one use them, how do they differ, what special considerations are there? What exactly does “Platform as a Service” (PaaS) mean with SQL?

Speaker(s):

  • Tim Plas

Track and Room: DBA - 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: Developer - N/A


Title: Performance baseline your new SQL instance

Abstract: Using freely available tools to baseline your new SQL server instance. Using Crystal disk mark, SQLIO, Memtest86, and Dell DVDstore tools to measure, baseline and compare results of your new hardware. Crystal disk mark and SQLIO will test IO subsystems ; memtest86 will test your memory before you put it into production. Dell DVDstore will be used to create a database enabling you to put a synthetic load simulating numerous users to your SQL server instance, enabling the creation of solid baselines when putting the server under a heavy load. Using the benchmarks to determine capacity of the hardware and will it met the expected load.

Speaker(s):

  • Shawn Meyers

Track and Room: DBA - N/A


Title: Dimension Modeling Design Patterns: Beyond Basics

Abstract: This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.

Speaker(s):

  • Jason Horner

Track and Room: Business Intelligence - N/A


Title: Database Security Shrinking Your Attack Surface

Abstract: Database Security is a very broad and scary topic, one which many days could be dedicated to speaking on it. In this session Matt will give a high level overview of what Database Security is, what tools Microsoft gives you to accomplish it and some simple things that you can do to shrink your attack surface.

Speaker(s):

  • Matthew Brimer

Track and Room: DBA - N/A


Title: Searching Binary Data in SQL Server 2012

Abstract: More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important data, but the formatting must be stripped out in order for users to effectively search this data. Filestream, Filetable, Full-Text Search, and Semantic Search are covered.

Speaker(s):

  • Steve Jones

Track and Room: Developer - N/A


Title: SQL Server 2012 HA and DR

Abstract: This is a deep dive session in the new HA/DR options for SQL Server 2012. Through interactive discussions and lively demos, get an in depth understanding of the AlwaysOn Failover Clustering and AlwaysOn Availability Groups. Experience how to set up active secondary’s and off load backups to the secondary servers. You will walk away with a thorough understanding of the pros and cons of each HA/DR option in SQL Server 2012 and can immediately apply it to practical use.

Speaker(s):

  • Sudhir Gajre

Track and Room: DBA - N/A


Title: Tabular Models

Abstract: Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.

Speaker(s):

  • Jeff Renz

Track and Room: Business Intelligence - N/A


Title: Master Data Services – 101

Abstract: Master Data Services (MDS) is a Master Data Management solution on the Microsoft Platform. This solution enables the management of non-transactional data (nouns) within the enterprise. Get a good business and technical understanding of how MDS can help your organization obtain better data governance. The demo will walk through the basics of getting started with Master Data Services 2012, including the Excel Add-in for Master Data Services.

Speaker(s):

  • Reeves Smith

Track and Room: Business Intelligence - N/A


Title: The Encryption Primer

Abstract: Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.

Speaker(s):

  • Steve Jones

Track and Room: DBA - N/A


Title: Getting Started with PowerShell’s Job Infrastructure

Abstract: A key feature of Windows PowerShell is the ability to execute long running tasks in the background while you continue to use the shell for other tasks. In this session you will learn about the PowerShell’s job infrastructure including using scheduled background jobs, a new PowerShell 3.0 feature. We’ll also explore some alternatives such as using runspaces.

Speaker(s):

  • Jeff Hicks

Track and Room: General - N/A


Title: Windows Azure SQL Reporting Services

Abstract: What you need to know about Reporting Services in the Cloud. We will cover benefits, limitations and scenarios that you may or may not have thought about for implementing this into your enviornment or for simply taking advantage of the free trial period.

Speaker(s):

  • Leslie Weed

Track and Room: Business Intelligence - N/A


Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!

Speaker(s):

  • Kevin Boles

Track and Room: Developer - N/A


Title: DAX – Get Context

Abstract: Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Understand the basics of the DAX language and get introduced to evaluation context.

Speaker(s):

  • Reeves Smith

Track and Room: Business Intelligence - N/A


Title: SSIS 2012: A Deep Dive into the SSIS Catalog

Abstract: New in SQL Server 2012, the SSIS catalog provides a rich set of built-in tools for capturing/reporting package logging, statistics, and other interesting things all within a few keystrokes or mouse clicks. This session will focus on the internals of this new catalog and how to use it. You will learn how to extend and query the metadata captured by the package execution process and how to navigate your way around the built-in reports.

Speaker(s):

  • Phil Brammer

Track and Room: Business Intelligence - N/A


Title: Exposing the Core: SQL 2012 on Server Core

Abstract: Everything that’s old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.

Speaker(s):

  • Michael Fal

Track and Room: DBA - N/A


Title: Dr. DMV: How to Use Dynamic Management Views

Abstract: SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 R2 adds even more capability in this area. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session (which is applicable to SQL Server 2005 through 2012), presents and explains over fifty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Speaker(s):

  • Glenn Berry

Track and Room: DBA - N/A


Title: Minimum Database Indexing

Abstract: Discuss the basic indexing principles you should have learned in school if you had been paying attention. We will examine a couple of data and indexing patterns that will enable you to make an educated decision on your indexing strategy. We will also take a deep dive in how indexes begin and grow and how they are used

Speaker(s):

  • Dean Nicholson

Track and Room: Developer - N/A


Title: SQL Server vs. Oracle: The Throwdown!

Abstract: Come see David Klee (@kleegeek) and Joe Grant (@dba_jedi) in a “discussion” with a competitive comparison between SQL Server and Oracle in a highly interactive dynamic session. Each database engine has its place in the IT world, and we will discuss which is the right tool for the job. The goal is to be objective and compare features, strengths and weaknesses, and editions. Check your opinions at the door and come join us for an educational session!

Speaker(s):

  • David Klee

Track and Room: DBA - N/A


Title: Building BI Solutions with Excel 2013

Abstract: If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went “all-in” with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.

Speaker(s):

  • Steve Hughes

Track and Room: Business Intelligence - N/A


Title: Getting Started with PowerShell Workflow

Abstract: One of the killer features in PowerShell 3.0 is the ability to create workflows with Powershell script. You do not need a developer background or Visual Studio to create workflows. Now you can workflow scripts for long running and unattended tasks that can survive network interruptions or even reboots. In this session we’ll look at workflow syntax, how to run and some best practices.

Speaker(s):

  • Jeff Hicks

Track and Room: General - 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.

Ronald Yenko

LinkedIn: Ronald Yenko

Ronald Yenko is a Database Engineer at Senior Market Sales, Inc. in Omaha, NE. For the past 20 years he has been involved with various Microsoft technologies including providing enterprise database architecture solutions using Microsoft SQL Server (from 6.5 through 2017) in the ecommerce, retail, law enforcement, government and financial industries. He holds various Microsoft certifications including MCT and MCITP/MCTS.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.

Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.

Tim Plas

Twitter: - tjplas

LinkedIn: Tim Plas

Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.

Jeff Renz

Twitter: - jeff_renz

LinkedIn: Jeff Renz

Contact: http://www.revgen.com

Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

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.

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.

Jason Horner

Twitter: - jasonhorner

LinkedIn: Jason Horner

Contact: http://blog.jasonhorner.com

Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.

I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.

In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games

Joe Sack

Twitter: - @JoeSackMSFT

LinkedIn: Joe Sack

Joe Sack is a Principal Program Manager in the SQL Server product team at Microsoft, with a focus on the Query Optimizer. Joe is an author and speaker with over 18 years of experience in the industry, specializing in performance tuning, high availability and disaster recovery.

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Kathy Gibbs

Twitter: - KGdba

LinkedIn: Kathy Gibbs

Kathy has over 19 years of IT work experience and over 13 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy excels in being a liaison between technical and the end-users or management teams to provide solutions

Sudhir Gajre

Twitter: - @SudhirGajre

LinkedIn: Sudhir Gajre

Contact: http://www.dbbest.com/blog/author/sudhir/

Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.

Glenn Berry

Twitter: - GlennAlanBerry

LinkedIn: Glenn Berry

Contact: https://glennsqlperformance.com/

Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.

Reeves Smith

Twitter: - SQLReeves

LinkedIn: Reeves Smith

Contact: http://reevessmith.wordpress.com

Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.

Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.

Leslie Weed

Twitter: - @weederbug

Leslie Weed is currently a Data and BI Architect with RevGen Partners in Denver, CO. She has been a SQL Professional specializing in Business Intelligence, data analytics, systems implementation, integration, and solutions delivery for the last 20ish years, including a variety of Enterprise Data Warehouses in various industries.

Phil Brammer

Twitter: - @PhilBrammer

LinkedIn: Phil Brammer

Contact: http://www.ssistalk.com

Phil Brammer, a sixth year Microsoft MVP in SQL Server and a Microsoft Certified Solutions Expert, has over 12 years’ data management experience in various technologies from reporting through ETL to database administration. He has worked with SSIS since 2007 and he continues to play an active role in the SSIS community via online resources as well as his technical blog site, SSISTalk.com. He has contributed to books, SQLSaturdays, SQL PASS Summits, and other online communities.

Brandie Tarvin

Database Administrator by day and Author by night Brandie Tarvin sails pirate-populated waters, fights evil robots in disguise and turns kingdoms into chaotic rebellious city-states all while coding ETL processes and protecting real-world data from corruption. If it weren’t for her, someone else would have the job and where would be the fun in that?

Brandie’s first computer experience was with a State-of-the-Art Commodore 64 brought home by her father, who informed her that “computers are NOT toys” and would not let her use it until she learned how to program. In late 2003, she turned her hobbies of programming, MUSHing and assisting friends with generic tech support into a full time career as a database administrator. She’s been stuck in the fabulous and bizarre world of professional IT work ever since.

Currently, Brandie is a Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQLSaturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.

Glenn Berry

Twitter: - GlennAlanBerry

LinkedIn: Glenn Berry

Contact: https://glennsqlperformance.com/

Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.

Dean Nicholson

I have been in IT for 16 years, over 12 as a DBA. I have worked on Oracle, Sybase and Sql Server 6.5 thru SQL 2012 in both administration and development roles. I am active in the local PASS user group.

Steve Hughes

Twitter: - dataonwheels

LinkedIn: Steve Hughes

Contact: http://www.dataonwheels.com

Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Jeff Hicks

Contact: http://jdhitsolutions.com/blog

Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for MPCMag.com and is a regular contributor to the Petri IT Knowledgebase and 4SysOps.

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).

Scott Shaw

Contact: http://www.dbaexperience.com

Scott Shaw is the co-author of two T-SQL books through Apress publishing. He is a frequent speaker at community events and most recently spoke at the 2013 SQL PASS Summit. He is co-chair of the SQL PASS Virtual Chapter on Virtualization and teaches classes at both Washington University CAIT program and Saint Louis University. Scott lives in Saint Louis with his wife and 2 children. He is a Principal Consultant for Oakwood Systems Group.

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.

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

Jeff Hicks

Contact: http://jdhitsolutions.com/blog

Jeffery Hicks is a Microsoft MVP in Windows PowerShell, Microsoft Certified Trainer and an IT veteran with over 20 years of experience, much of it spent as an IT consultant specializing in Microsoft server technologies with an emphasis in automation and efficiency. He works today as an independent author, trainer and consultant. Jeff writes the popular Prof. PowerShell column for MPCMag.com and is a regular contributor to the Petri IT Knowledgebase and 4SysOps.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page