SQLSaturday #286 - Louisville 2014

Event Date: 06/21/2014 00:00:00

Event Location:

  • Indiana Wesleyan University
  • 1500, Alliant Avenue
  • Louisville, Kentucky

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: Clustered Columnstore Indexes in SQL Server 2014

Abstract: SQL Server 2012 introduced columnstore indexing but with one major drawback – columnstore indexes were not updateable. Thus, adopting them to improve data warehousing (or other) query patterns took careful planning and quite a bit of management. SQL Server 2014 introduces clustered columnstore indexes that are now fully updateable! During this session, we’ll take a look at how clustered columnstore indexes work, what implications exist for using them, and how the update process is handled. We’ll also take a look at what management and maintenance operations are required to keep clustered columnstore indexes performing optimally. Anyone with a large data warehouse environment (or even an OLTP or ODS database with very large tables) will definitely want to attend!

Speaker(s):

  • Dave Fackler

Track and Room: Track 3 - BI - N/A


Title: Best Practices for Efficient SSRS Report Creation

Abstract: You always have more report requests than you can possibly fulfill. Wouldn’t it be great if you could speed up the generation of reports? Templates can streamline the life cycle of a report for the whole team. In this session, you’ll learn how templates in your tool belt can help you efficiently gather requirements, quickly design mock-ups, and standardize the look and feel of your SSRS reports. Reports don’t stop changing once they’re released into production, and some reports are phased out over time. Wouldn’t it be great to have a way to keep track of the changes a report takes on in production over time? We’ll talk about how to keep track of change requests, how to analyze the utilization of existing reports, and how to track changes in users for the reports in production.

Speaker(s):

  • Mickey Stuewe

Track and Room: Track 3 - BI - N/A


Title: Database Design Fundamentals

Abstract: In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming “difficulties” are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).

Speaker(s):

  • Louis Davidson

Track and Room: Track 4 - Dev - N/A


Title: Tame Your Unruly Data…With Constraints!

Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

Speaker(s):

  • Rob Volk

Track and Room: Track 4 - Dev - N/A


Title: SQL 2012 Table Compression

Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Speaker(s):

  • Jason Brimhall

Track and Room: Track 2 - Adv.DBA - N/A


Title: Self-Service BI with SSAS

Abstract: Now with SQL 2014 you can perform visual data exploration with Power View on traditional Multi-Dimensional models. See how to build out these types of analysis using Excel and SharePoint. Get insight into tips/tricks and lessons learned from the field to increase the value of your BI SQL investments and leverage new capabilities in PowerPivot, Tabular and Power BI.

Speaker(s):

  • Dan Evans

Track and Room: Track 3 - BI - N/A


Title: Table Vars Temp Tables - What you NEED to Know!

Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”

Speaker(s):

  • Wayne Sheffield

Track and Room: Track 2 - Adv.DBA - N/A


Title: Exposing SQL data with SharePoint

Abstract: You’ve got your data, but accessing it means using one application among dozens, which can be difficult for once-in-a-while users. Alternatively, you can make the data to SharePoint where it can be easily searched, related, and even (securely) exposed for integration via the SharePoint native OData, REST, and WCF interfaces.

Speaker(s):

  • Scott Brickey

Track and Room: Track 4 - Dev - N/A


Title: “So you have a performance issue. What now?”

Abstract: You’re a new DBA, want to be a DBA or you’ve been declared an “Accidental DBA” and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? Their query or stored procedure took a very long time to run. Can you help them? Do you even know where to begin to help them? Most sessions I’ve attended on performance tuning seem to start in the middle. They take the approach that the audience has some understanding on how or where to start. In this session we’ll cover how to handle performance tuning from the very beginning, when the user says “The database is slow”.

Speaker(s):

  • Ed Watson

Track and Room: Track 1 - DBA - N/A


Title: SQL Server 2014 Transitioning to the Cloud

Abstract: SQL Server 2014 provides a several new features such as backup to cloud, HA to cloud as well as other hybrid scenarios that can help you reduce costs and improve on-premises DR. With the release of SQL Server 2014 it is much easier for DBAs who may not be familiar with Windows Azure to easily deploy and manage SQL Server workloads to it, while still maintaining their existing SQL Servers in their data centers. In this session, you will be introduced to new features within SQL Server that will make your transition to the cloud smooth.

Speaker(s):

  • Sarah Barela

Track and Room: Track 5 - Misc. - N/A


Title: SQL 2012 Extended Events

Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.

Speaker(s):

  • Jason Brimhall

Track and Room: Track 2 - Adv.DBA - N/A


Title: Branding Yourself for a Dream Job

Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

Speaker(s):

  • Steve Jones

Track and Room: Track 5 - Misc. - N/A


Title: Introduction to FileTables in SQL 2012

Abstract: What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.

Speaker(s):

  • Warren Sifre

Track and Room: Track 5 - Misc. - N/A


Title: Say Goodbye to Boring Meetings

Abstract: Ever been in a meeting that drones on and on? It starts late, runs long, and doesn’t really accomplish anything. It’s a complete waste of everyone’s time. Worse yet, since nothing was resolved you’ll have to have a follow up meeting. Argh! In this session you’ll learn some of the keys to conducting an effective meeting. You’ll gain practical tips for making your meetings more productive and dramatically improving one of the most inefficient parts of your day. You’ll also learn how to make the meetings that you attend more effective by subtly influencing the meeting organizer

Speaker(s):

  • Joe Webb

Track and Room: Track 5 - Misc. - N/A


Title: Crazy Things That Developers Do

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.

Speaker(s):

  • Wayne Sheffield

Track and Room: Track 1 - DBA - N/A


Title: Transforming Data using T-SQL PIVOT / UNPIVOT

Abstract: Ever wish your horizontal data were vertical for data storage, or vice-versa for reporting? Your LED monitor is not meant to be rotated! Join Jeff Foushee as he explains SQL Server’s lesser-known PIVOT and UNPIVOT operators.

Speaker(s):

  • Jeff Foushee

Track and Room: Track 3 - BI - N/A


Title: How to Write a DML Trigger

Abstract: Triggers are extremely powerful and useful (if somewhat rarely needed) objects that are coded very similar to a common stored procedure. Yet for their similarity, there are some very important differences that need to be understood. In this session, I will walk through what goes into writing a robust DML trigger, starting with a simple version of a trigger, and working through some very useful applications of DML Triggers..

Speaker(s):

  • Louis Davidson

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


Title: Interrogating the Transaction Log

Abstract: Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data. It would be pandaemonium!!! Think of the Stay-Puft Marshmallow Man!

Thankfully the transaction log is there and we can all breathe easier. In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.

Speaker(s):

  • Frank Gill

Track and Room: Track 2 - Adv.DBA - N/A


Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract: Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

Speaker(s):

  • Mickey Stuewe

Track and Room: Track 4 - Dev - N/A


Title: SQL Server 2014 - An overview

Abstract: Microsoft SQL Server 2014 builds on the mission critical platform delivered in SQL Server 2012 by providing performance enhancements, increased availability and manageability for mission critical applications. SQL Server 2012 introduces new in-memory capabilities like in-memory OLTP, and enhanced in-memory data warehousing and BI features such as updateable column store. In this session, you will also learn about new about the new features in the database engine and see SQL Server 2014 in action.

Speaker(s):

  • Sarah Barela

Track and Room: Track 1 - DBA - N/A


Title: How SQL DBAs and Developers can speak to business leaders

Abstract: Are you frequently frustrated by managers and other non-technical business leaders that just don’t seem to get it? Do they frequently glaze over when you try to explain a great new business opportunity or efficiency improvement that you just know will enhance the bottom line? In this session we will explore some strategies and techniques for engaging decision makers in terms that they understand. Improving communications with decision makers and crystallizing their buy-in will enhance your value to the organization and give your career significant lift

Speaker(s):

  • Ron Reeves

Track and Room: Track 3 - BI - N/A


Title: Advanced Performance Tuning Tips with Database Performance Analyzer (formerly Confio Ignite)

Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.

Speaker(s):

  • Carlos Parra

Track and Room: Track 2 - Adv.DBA - N/A


Title: Achievement Unlocked: How to Get Promoted

Abstract: Have you ever felt like an extra in Office Space? You’ve got the skills. You’ve got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What’s the deal?

In this session, you’ll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

Speaker(s):

  • Dave Mattingly

Track and Room: Track 4 - Dev - N/A


Title: The Modern Data Warehouse with PDW/Hadoop

Abstract: In this session, you will learn about Microsoft Analytical Data Platform which will help in analyzing Structured and Unstructured data using PDW, Hadoop and SQL Server.

Speaker(s):

  • Madhu Desarapu

Track and Room: Track 5 - Misc. - N/A


Title: The Spy Who Loathed Me - An Intro to SQL Security

Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.

Speaker(s):

  • Chris Bell

Track and Room: Track 1 - DBA - N/A


Title: Visual Studio Database Tools

Abstract: Visual Studio is now host to several improvements for developing databases, database objects, and database code. These features are collectively known as SSDT – SQL Server Data Tools. During this presentation, we’ll discuss what SSDT has to offer, how database developers and administrators might take advantage of these features, and common patterns for working with database designs between SQL Server Management Studio (SSMS) and SSDT.

Speaker(s):

  • Dave Fackler

Track and Room: Track 4 - Dev - N/A


Title: Designing a Restore Strategy

Abstract: Do you back up your databases? If the answer is yes (and I really hope it is), do you test your restores? If a table gets dropped at 1:53PM, can you restore the database to 1:52PM using log backups? Can you use the WITH STANDBY parm to apply log backups to a read-only copy of a database?

For the answers to these questions and a whole lot more about database restores, plus some nifty scripts, join me for this presentation.

Speaker(s):

  • Frank Gill

Track and Room: Track 2 - Adv.DBA - N/A


Title: Best Practices for Database Deployment

Abstract: The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement to ensure that your deployments are as successful as they can be.

Speaker(s):

  • Grant Fritchey

Track and Room: Track 1 - DBA - N/A


Title: Isn’t That Spatial

Abstract: The geography data type allows for pinpoint accuracy of locations (0-D), routes (1-D), areas (2-D), and isometric power maps (3-D). SQL 2014 has broken through to the time. barrier (4-D). Watch your data change over time, and even export it into movie format with an appropriate soundtrack. Turn your data into a compelling story in geospace, the final frontier.

Speaker(s):

  • Dave Mattingly

Track and Room: Track 3 - BI - N/A


Title: Data Platform for Hybrid Cloud

Abstract: During this session, learn features which integrate SQL Server to the Cloud and also learn about Relational Data Services in the Cloud

Speaker(s):

  • Madhu Desarapu

Track and Room: Track 3 - BI - N/A


Title: Optimizing Protected Indexes

Abstract: As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.

Speaker(s):

  • Chris Bell

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

Sarah Barela

Twitter: - @sarahspace

Contact: http://www.sqlsarah.net

Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Dan Evans

Twitter: - @danthebiman

LinkedIn: Dan Evans

Dan Evans is a Data and Analytics evangelist with over 25 years’ experience deploying strategic and innovative analytic solutions. He’s focused on Microsoft technologies including Data Platform, Advanced Analytics and Business Applications. Current focuses include SQL Server, Power Suite, Cognitive Services, Artifical Inteligence and other Data Platform related topics in Azure. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite and supports best practices in Microsoft data and analytics across North America.

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.

Sarah Barela

Twitter: - @sarahspace

Contact: http://www.sqlsarah.net

Sarah Barela is a Senior Manager at CBeyond Cloud Services, formerly MaximumASP. She has a Master’s degree in Information Science from the University of Texas, where she specialized in Database Management Systems. Sarah has spent over 15 years focusing on the administration of enterprise environments with large numbers of SQL Servers. Sarah is currently responsible for a rapidly growing environment with more than 2000 SQL Server instances. Her latest interests are in applying cloud technologies to SQL Server environments. Sarah has been a guest speaker at a number of PASS Chapter meetings, SSWUG Virtual Conferences, SQL Connections, SQLSaturday events, and the 2007, 2009, and 2010 PASS Summits.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Warren Sifre

Twitter: - WAS_SQL

LinkedIn: Warren Sifre

Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com

Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.

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.

Joe Webb

Contact: http://www.foritpros.com

As a business and technical consultant for over 18 years, Joe Webb has consulted extensively with clients in the areas of business process analysis and improvements, database design and architecture, software development, and technical training. He has spoken at conferences in Europe and the North America and has authored or coauthored 4 books. Joe served as EVP of Finance for PASS and currently serves on several University Advisory Boards. Joe is an 8 time recipient of the Microsoft MVP awar

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Madhu Desarapu

Contact: http://microsoft.com

Madhu Desarapu is Data Platform and Cloud technology specialist. He has vast experience in designing and implementing Mission critical transactional and analytical applications. He had been with Microsoft for over 10 years and in IT industry for over 18 years. #160;#160; In his current role, Madhu provides architectural guidance to top fortune 500 customers in South Ohio, Kentucky and Tennessee with Hybrid Cloud Applications and extending data center to Cloud.#160;

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Dave Fackler

Twitter: - @sqlbiguru

LinkedIn: Dave Fackler

Contact: http://davefackler.blogspot.com/

Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.

Scott Brickey

Contact: http://www.sbrickey.com/Tech/Blog

Scott Brickey is the SharePoint Practice Director at Strategic Data Systems. His background includes solution architecture, database and SharePoint administration, .Net and SharePoint development, and training.

Jeff Foushee

Jeff Foushee has his MCITP certification in both SQL Server and Windows Server. He is also an Enterprise DBA at Louisville-based Humana, Inc., where he supports almost 20,000 databases on 1,800 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.

Carlos Parra

Contact: http://confio.com

Carlos Parra has more than twenty years of DBA experience, including design, development, and implementation of many critical database applications. Before coming to Confio Software, Carlos applied his skill set in roles which have included programmer, developer, analyst, and database administrator in the financial and healthcare industry.

Dave Mattingly

Twitter: - @dave_mattingly

LinkedIn: Dave Mattingly

Contact: http://www.davemattingly.net

Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Ron Reeves

Contact: http://www.vsoftconsulting.com/

Over the past 22 years, Ron has held a number of positions in the engineering and IT spaceIn his current position at V-Soft, he manages their Business Solutions division and works with their clients to translate their business challenges and opportunities into solid technology solutions.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Dave Mattingly

Twitter: - @dave_mattingly

LinkedIn: Dave Mattingly

Contact: http://www.davemattingly.net

Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.

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.

Madhu Desarapu

Contact: http://microsoft.com

Madhu Desarapu is Data Platform and Cloud technology specialist. He has vast experience in designing and implementing Mission critical transactional and analytical applications. He had been with Microsoft for over 10 years and in IT industry for over 18 years. #160;#160; In his current role, Madhu provides architectural guidance to top fortune 500 customers in South Ohio, Kentucky and Tennessee with Hybrid Cloud Applications and extending data center to Cloud.#160;

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Dave Fackler

Twitter: - @sqlbiguru

LinkedIn: Dave Fackler

Contact: http://davefackler.blogspot.com/

Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Frank Gill

Twitter: - skreebydba

LinkedIn: Frank Gill

Contact: http://skreebydba.com/

Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page