SQLSaturday #410 - Chattanooga 2015

Event Date: 06/27/2015 00:00:00

Event Location:

UT Chattanooga EMC Building
784 Vine Street
Chattanooga, Tennessee

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: How In-Memory Database Objects Affect Database Design

Abstract: With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn’t that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.

Speaker(s):

Louis Davidson

Track and Room: DBA/Developer - RM 230

Title: Why should I care about the plan cache?

Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick’s “Why should I care” series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV’s for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why DBAs drink in the morning (allegedly).

Speaker(s):

Rick Lowe

Track and Room: DBA/Administration - RM 218

Title: Manageable SSAS Deployment Strategies

Abstract: When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

If you’ve answered “yes” to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.

Speaker(s):

Kerry Tyler

Track and Room: BI - RM 218

Title: Performance Tuning for Mere Mortals Part II

Abstract: This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events.

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning.

There will be homework!

Speaker(s):

Mike Lawell

Track and Room: DBA/Administration - RM 201

Title: PowerShell for Data Professionals

Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

Speaker(s):

Aaron Nelson

Track and Room: Other - RM 302

Title: Execution Plans for Mere Mortals

Abstract: This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.

Speaker(s):

Mike Lawell

Track and Room: DBA/Administration - RM 218

Title: Are Availability Groups a good fit for your database?

Abstract: How do you know if Availability Groups are the correct high availability solution for your business application? We’ll cover some common business problems that Availability Groups can solve and go through a quick demo where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.

Speaker(s):

Doug Purnell

Track and Room: DBA/Administration - RM 302

Title: Getting involved and Getting ahead

Abstract: Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability. PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out. The rewards of the SQL Community are endless.

Speaker(s):

Tim Radney

Track and Room: Management/Personal - RM 302

Title: Zero to Hero with PowerShell and SQL Server

Abstract: PowerShell is everywhere, and that includes SQL Server. In this session we’ll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library. Learn how to handle common DBA tasks, such as checking the status of various services, validating backups, and checking for disk usage. You’ll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to become a hero with SQL Server and PowerShell.

Speaker(s):

Robert Cain

Track and Room: Other - RM 219

Title: Getting Started With SQL Server Replication

Abstract: In this session we will examine how SQL Server replication works. A technology that has been around, this tool is not going anywhere anytime soon. It’s an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!). We will examine terms, internals, and walk through the setup of transactional and snapshot replication pieces so you can implement this technology in your environment and use it as a valuable tool in your personal knowledge book.

Speaker(s):

Robert Verell

Track and Room: DBA/Administration - RM 301

Title: SQL Server 2014 New Features

Abstract: There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. When I thought of doing this session I initially wanted to have some demos, but there are SOOO many things to cover I couldn’t fit in any demos in a 1 hour session!

Speaker(s):

Kevin Boles

Track and Room: DBA/Administration - RM 301

Title: Much Ado About Hadoop

Abstract: Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

Speaker(s):

Kevin Feasel

Track and Room: BigData - RM 230

Title: SQL Server 2014 Column Store Index vNEXT

Abstract: The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it’s underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.

Speaker(s):

Kevin Boles

Track and Room: Other - RM 230

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract: As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

Speaker(s):

Wes Springob

Track and Room: BI - RM 201

Title: Backup Strategies are for Losers…of Data!

Abstract: Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!

Speaker(s):

Ed Watson

Track and Room: DBA/Administration - RM 302

Title: Tuning SQL Server for SharePoint

Abstract: We will discuss SQL and SharePoint integration concepts, walk through the different types of SharePoint databases, and get you more comfortable with the SharePoint platform. Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).

Speaker(s):

Daniel Glenn

Track and Room: Other - RM 219

Title: Performance Tuning for Mere Mortals Part I

Abstract: In this first part of a two part series, we look at performance tuning from the very beginning. You’re a new DBA, you 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? The application is running slowly. Can you help them? Do you even know where to begin to help them? 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: DBA/Administration - RM 201

Title: What’s your Imperative doing in my Declarative?

Abstract: T-SQL is one of a minority of computer languages where you describe the results rather than code an algorithm. Unfortunately, many people use habits and constructions learned in imperative languages such as C# or Java when writing T-SQL Code. In this all-demo session we will explore several such commonly used constructions that are detrimental to SQL Server performance and scalability.

Speaker(s):

Geoff Hiten

Track and Room: DBA/Administration - RM 302

Title: The Next Dimension of Data

Abstract: Send your data on a journey through space and time, while engaging your audience’s senses to tell its story. MS SQL Server’s geospatial datatype offers pinpoint accuracy and many advanced location-aware capabilities, such as shapes, overlaps, distances, and direction. The Power Map feature in Office 2013 can turn your addresses and supporting figures into a movie. Turn your facts and figures into a compelling story by entering geospace: the final frontier.

Speaker(s):

Dave Mattingly

Track and Room: BigData - RM 219

Title: Introduction to Azure Machine Learning

Abstract: We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

Speaker(s):

Warren Sifre

Track and Room: BigData - RM 301

Title: Tame the sibling rivalry

Abstract: Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.

We will review locking, blocking and deadlocking. We will also review how to identify deadlocks and how to lessen the family fighting.

Speaker(s):

William Wolf

Track and Room: DBA/Administration - RM 201

Title: Primer on Power BI

Abstract: Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies. We will answer the following questions:

◾What makes Power BI different from the Microsoft Office I have known for years?

◾What are the major Power BI features in Excel 2013 and 2010?

◾What are the major features for Power BI for Office 365?

◾How can our team license Power BI?

Speaker(s):

Mark Tabladillo

Track and Room: BigData - RM 219

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: Management/Personal - RM 219

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Abstract: What is master data management and why should I care about it? What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality

Speaker(s):

Gene Webb

Track and Room: BigData - RM 202

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract: Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA’s can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA’s are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.

Speaker(s):

Lindsay Clark

Track and Room: DBA/Administration - RM 301

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. Also leverage the new capabilities with the Power BI Preview and create real-time dashboards and interactive reports on any device.

Speaker(s):

Dan Evans

Track and Room: BI - N/A

Title: Crash course on becoming better SQL Developer.

Abstract: Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.

Speaker(s):

Vladimir Oselsky

Track and Room: DBA/Developer - RM 301

Title: Self-Service BI with Big Data

Abstract: Now with SQL 2014 Data Platform you can perform visual data exploration with unstructured data sets using Hadoop and other MapReduce data sets. See how to build out these types of analysis using existing tools like Excel, SharePoint and O365. Get insight into tips/tricks and lessons learned from the field to increase the value of your existing big data investments and leverage new capabilities in Power Query, PowerPivot Power View, Power Map and Power BI!.

Speaker(s):

Dan Evans

Track and Room: BI - RM 230

Title: Know Your Role(s)!

Abstract: Developers and DBAs naturally conflict with each other over permissions since developers want to be able to fix their code and research issues, but DBAs are the gatekeepers. In this session we will discuss Microsoft recommended best practices for setting up users and service account permissions. We will go over common server and database roles and what they actually allow, including roles that should be avoided as potential security loopholes. He will also look into alternatives for elevated database roles, and easier ways of setting up users across an enterprise environment, all as part of how to consolidate your development servers into fewer instances.

Speaker(s):

Robert Verell

Track and Room: Other - RM 230

Title: Data Mining with SQL Server Data Tools

Abstract: Geared towards folks who are starting to dip their toes into data mining and analytics, but don’t know where to start - this session will go over the data mining tools baked into the Sql Server/Analysis Services tool suite. During the session we will review the basic algorithms available out of the box, demo how to set them up and interpret their results.

Speaker(s):

Annelies Beaty

Track and Room: BI - RM 218

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract: Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven’t had a chance to dive in and figure out how to develop one yourself? Now is the time! SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.

Speaker(s):

Kerry Tyler

Track and Room: BI - RM 218

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Gene Webb

Twitter: - None

LinkedIn: Gene Webb

Contact: http://None

Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Gene Webb

Twitter: - None

LinkedIn: Gene Webb

Contact: http://None

Sven Aelterman

Twitter: - @svenaelterman

LinkedIn: Sven Aelterman

Contact: https://svenaelterman.wordpress.com

Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

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.

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

Sumanth (Sam) Muralidhar

LinkedIn: Sumanth (Sam) Muralidhar

Business Intelligence Architect

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Lindsay Clark

Twitter: - @LindsayOClark

LinkedIn: Lindsay Clark

Lindsay started out in network administration with a BA in Computer Science from South University prior to finding her true love in database administration. Whether it#39;s mentoring in the office or presenting sessions at SQLSaturday, Lindsay loves to find new ways to collaborate and share information. In addition to her role as DBA at American Credit Acceptance, she actively recruits speakers for her user group and chairs her local SQLSaturday event.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Robert Verell

Twitter: - @sqlcowbell

LinkedIn: Robert Verell

Contact: http://sqlcowbell.com/wordpress/

Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User’s Group, a volunteer for SQLSaturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.

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.

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.

Daniel Glenn

Twitter: - DanielGlenn

LinkedIn: Daniel Glenn

Contact: https://DanielGlenn.com

Daniel is a Microsoft MVP with 15 years’ experience building technology solutions, intranets and extranets. As Practice Leader for the Nashville-based InfoWorks Inc., Daniel helps organizations of all sizes solve complex data challenges by implementing Office 365 and SharePoint without the need of customization and costly investments.

Daniel is passionate about giving back and building the Microsoft technical community. Daniel holds leadership roles in various local user groups, serves as an organizer for Microsoft 365 Nashville, and is a co-host for the popular podcast 365 Message Center Show on https://MessageCenter.Show. You can follow Daniel online at https://DanielGlenn.com and @DanielGlenn on Twitter.

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.

Mike Lawell

Twitter: - @sqldiver

LinkedIn: Mike Lawell

Contact: http://sqlserverassociates.com/Blog

Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.

He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.

He is also a certified Scuba instructor with a long bucket list of dive sites.

He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.

Sven Aelterman

Twitter: - @svenaelterman

LinkedIn: Sven Aelterman

Contact: https://svenaelterman.wordpress.com

Wes Springob

Twitter: - /SQLWes

LinkedIn: Wes Springob

Contact: http://SQLWes.com

Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.

Annelies Beaty

A IT professional with 15 years experience, Annelies has spent much of her career in data intensive application development and data management. Starting back in 2000 with Sql Server 2000 and .Net Programming, she has progressed from database design and development for application needs to data integration team management and currently is responsible for long term strategic planning and direction at US Xpress.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Doug Purnell

Twitter: - https://twitter.com/sqlnikon

LinkedIn: Doug Purnell

Contact: http://sqlnikon.wordpress.com

Doug Purnell is a DBA at Elon University and is a co-leader for the Triad SQL BI PASS User Group. In his spare time you can find Doug taking photos and cooking up some BBQ on his cooker.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Dave Mattingly

Twitter: - @dave_mattingly

LinkedIn: Dave Mattingly

Contact: http://www.davemattingly.net

Robert Cain

Twitter: - https://twitter.com/arcanecode

LinkedIn: Robert Cain

Contact: http://arcanecode.com

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.

Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.

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.

Mike Lawell

Twitter: - @sqldiver

LinkedIn: Mike Lawell

Contact: http://sqlserverassociates.com/Blog

Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.

He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.

He is also a certified Scuba instructor with a long bucket list of dive sites.

He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.

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.

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

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

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Dan Evans

Twitter: - @danthebiman

LinkedIn: Dan Evans

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Robert Verell

Twitter: - @sqlcowbell

LinkedIn: Robert Verell

Contact: http://sqlcowbell.com/wordpress/

Vladimir Oselsky

Twitter: - @VladyOselsky

LinkedIn: Vladimir Oselsky

Vladimir Oselsky (Vlady) is an IT Professional with over 15 years of experience in various IT Jobs. Born and raised in Siberia, moved to United States in late 90s. Passion for computer and programming started with DOS games and learning Borland Paschal in 8th grade as a hobby. IT career consisted of everything from hardware and software support to server administration. Current focus on SQL Server Database Development and .NET programming

Ed Watson

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

LinkedIn: Ed Watson

Contact: http://sqlgator.com

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

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

Robert Cain

Twitter: - https://twitter.com/arcanecode

LinkedIn: Robert Cain

Contact: http://arcanecode.com

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.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.

SQLSaturday #410 - Chattanooga 2015

Sessions

Title: How In-Memory Database Objects Affect Database Design

Title: Why should I care about the plan cache?

Title: Manageable SSAS Deployment Strategies

Title: Performance Tuning for Mere Mortals Part II

Title: PowerShell for Data Professionals

Title: Execution Plans for Mere Mortals

Title: Are Availability Groups a good fit for your database?

Title: Getting involved and Getting ahead

Title: Zero to Hero with PowerShell and SQL Server

Title: Getting Started With SQL Server Replication

Title: SQL Server 2014 New Features

Title: Much Ado About Hadoop

Title: SQL Server 2014 Column Store Index vNEXT

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Title: Backup Strategies are for Losers…of Data!

Title: Tuning SQL Server for SharePoint

Title: Performance Tuning for Mere Mortals Part I

Title: What’s your Imperative doing in my Declarative?

Title: The Next Dimension of Data

Title: Introduction to Azure Machine Learning

Title: Tame the sibling rivalry

Title: Primer on Power BI

Title: Achievement Unlocked: How to Get Promoted

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Title: Beginners SQL Server Security the Low Hanging Fruit

Title: Self-Service BI with SSAS

Title: Crash course on becoming better SQL Developer.

Title: Self-Service BI with Big Data

Title: Know Your Role(s)!

Title: Data Mining with SQL Server Data Tools

Title: 45 Minutes to Your First SSAS Tabular Model

Speakers

Sponsors