SQLSaturday #242 - Indianapolis 2013
Event Date: 08/10/2013 00:00:00
Event Location:
- Indiana Wesleyan University North
- 3777 Priority Way South Drive
- Indianapolis, Indiana
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: Cloud Ready: Preparing Yourself for Azure SQL Databases
Abstract: Cloud computing is one of the hot topic issues of the day and Microsoft is pushing hard to show that they are in the game to win. As such, SQL Azure is your data storage in the cloud solution. However, the platform is much different from simply a SQL Server that sits in the cloud and needs to be approached in an intelligent manner. In this fast paced session, we will be going well beyond the simple “hello world” scenario to show you how to leverage the cloud architecture for data storage as well as educate you in how the cloud works differently than your local database instance. Learn all of the functionality as well as the limitations so that you can make and educated decision when looking to move resource to a cloud based environment. This session is going to be an eye opener for sure and will have many of you dreaming of your data sitting in the cloud.
Speaker(s):
- Arie Jones
Track and Room: Track 5 - N/A
Title: Demystifying BISM and Tabular Mode SSAS
Abstract: With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes. An entire new method of modelling analytic data has emerged and it’s called Tabular Mode Analysis Services. In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes – Multidimensional and Tabular – into one level playing arena.
In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation.
Speaker(s):
- Josh Fennessy
Track and Room: Track 3 - N/A
Title: MDS and DQS - Beyond the TLAs to Data Quality
Abstract: Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality.
High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.
Speaker(s):
- Neil Hambly
Track and Room: Track 6 - N/A
Title: Why are we Waiting..
Abstract: An in-depth session examining “Waits” happening in your SQL Servers, using the well-known “Waits Queues” methodology.
With particular focus in the session on understanding and interpreting the information found the (DMV) sys.dm_os_wait_stats, Taking note of which “Waits “with the highest counts or excessive wait times, as well as those which “Waits” can be safely ignored, We can discover those “performance hurdles” and ways to overcome or remove them, restoring your SQL Servers performance levels. By using established methodologies like “Waits Queues”, we can systematically identify and remove performance
Previous Presented @ SQLBits 8 9 in UK @ SQLPASS Summit 2011 (310 Attendees) SQLDay And @ several UK User Groups
Speaker(s):
- Neil Hambly
Track and Room: Track 1 - N/A
Title: Agile Data Warehouse Design – Just Enough Design for Success
Abstract: How comfortable are you with your current process for designing data warehouses? Have you encountered difficulties determining how to better gather, organize, and use requirements to ensure a successful data warehouse design? This session will help by providing an agile data warehouse design process that gets targeted and meaningful requirements. The session will start by reviewing common\current data warehouse design elements and architectures. Next, the session will detail primary agile techniques and terminology. Lastly, the session will detail the use of Modelstorming using BEAM* (Business Event Analysis Modeling) and the 7 Ws Framework.
Speaker(s):
- Joe Salvatore
Track and Room: Track 3 - N/A
Title: Anatomy of a Join
Abstract: A lot of database professionals today do not have a Computer-Science Degree so they never attended a “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker(s):
- Luke Jian
Track and Room: Track 6 - N/A
Title: Getting Started with MDX
Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s):
- William E Pearson III
Track and Room: Track 6 - N/A
Title: What SQL DBAs need to know about SharePoint
Abstract: With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint, what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, supported methods for providing high availability and disaster recovery, and the part SharePoint and SQL each play in the Microsoft Business Intelligence story.
Speaker(s):
- JD Wade
Track and Room: Track 4 - N/A
Title: T-SQL Tips Tricks
Abstract: Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you’ll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.
Speaker(s):
- Aaron Cutshall
Track and Room: Track 1 - N/A
Title: Designing Formatting Reports
Abstract: You spent 45 minutes making your first report, but now you want more. Of course you do; everyone wants to make things pretty. Using SSRS 2012 we will look into rendering types considerations, conditional formatting, properties you can’t live without, and why standards are good. Full of samples and demos, you can’t miss this one.
Speaker(s):
- Tamera Clark
Track and Room: Track 4 - 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 fucntionality can help you manage your data in whatever forms it exists.
Speaker(s):
- Warren Sifre
Track and Room: Track 5 - N/A
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract: Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s):
- Eddie Wuerch
Track and Room: Track 2 - N/A
Title: Pervasive business information through Mobile BI
Abstract: There’s no arguing the proliferation of mobile devices in our society. Mobile devices offer BI teams a very exciting new product offering, Mobile BI. Early studies indicate Mobile BI can dramatically increase user adoption. It also allows BI teams to market to new customer segments. While the possibilities are great, Mobile BI also introduces a number of challenges that can push a BI team out of their comfort zone.
In this session we’ll discuss the pros and cons of Mobile BI. We’ll discuss common use cases and look at best practices for developing mobile visualizations in the Microsoft BI stack on both Windows 8 and iOS platforms.
Speaker(s):
- Josh Burgin
Track and Room: Track 3 - N/A
Title: Agile Database Development
Abstract: In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC. Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build. He’ll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
Speaker(s):
- Aaron King
Track and Room: Track 5 - N/A
Title: SSIS Templates Can Make Your Life Easier
Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
Speaker(s):
- Brian Davis
Track and Room: Track 4 - N/A
Title: Visualizing Your Indexes - Science vs Art
Abstract: Indexes make queries run faster, right? Not always, no. And finding the right indexes for your needs is often more of an Art than a Science. Attend this session as we take a visual tour of how indexes are laid out and the way data is accessed when indexes are utilized. We will discuss clustered indexes as well as non-clustered indexes and also when to use indexed views along with some other variations.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 1 - N/A
Title: Into a Swan - Discovering the Beauty of RESTORE
Abstract: Many DBAs believe that a backup is the most important process to implement. For most, they soon realize that the most important process to the business is actually the restore. In this session, we’ll start by exploring some of the options in the SSMS restore wizard, but will quickly move to T-SQL to discover the power and beauty that writing the RESTORE statement can provide. In addition to the classic RESTORE DATABASE and LOG statements, we’ll work through some real world examples of how to leverage some of the lesser known syntax of the restore statement to help in both foreign and well known environments.
Speaker(s):
- Kyle Neier
Track and Room: Track 4 - N/A
Title: High Performance SANLess Clustering
Abstract: Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card.
Speaker(s):
- Sios Technology and Allan Hirt
Track and Room: Track 3 - N/A
Title: Database Design Contentious Issues
Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: Track 4 - N/A
Title: WIT Panel: You.. as a brand.
Abstract: You.. as a brand. How important is it to create a professional presence for your career success?
Speaker(s):
- WIT Panel
Track and Room: Track 6 - N/A
Title: Introduction to SQL Server 2012 AlwaysOn Availability Groups
Abstract: One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications databases, are currently using Database Mirroring, or if you’re just curious about Availability Groups, then you won’t want to miss this session.
Speaker(s):
- Adam Belebczuk
Track and Room: Track 2 - N/A
Title: SQL Server ‘BI Stack’ Metadata Management
Abstract: Have you ever fallen behind on your Microsoft BI solution documentation? Can you easily determine which tables and queries are used in which SSRS Report / SSIS Package / or SSAS Cube? The answers to these questions are probably buried in your BI solution metadata. In this session, we will examine techniques that can be used to extract, organize, and query this very helpful metadata.
Speaker(s):
- Jim Miller
Track and Room: Track 1 - N/A
Title: Troubleshooting SQL IO issues with Xperf
Abstract: Xperf is a light weight performance tracing tool based on Event Tracing for Windows (ETW). The tool can help troubleshoot notoriously difficult SQL Server issues such as determining the root cause of slow IO’s and high privileged time on the sql server process. Xperf can help bridge the gap between SQL tracing and kernel tracing to give insight into these types of issues that previously was unavailable. We will look at how Xperf works and how to configure it for different issues. We’ll then step through using Xperf to determine the root cause of a 15 second IO error.
Speaker(s):
- Joe McTaggart
Track and Room: Track 6 - N/A
Title: Denali Ho! Exploring SQL Server
Abstract: Lewis and Clark. Stanley and Livingstone. Armstrong and Aldrin. Never bound by 9-to-5 TPS reports, they forged dauntlessly into uncharted territory, driven to discover, learn, and conquer the unknown. This session will be nowhere near that exciting or dangerous, but will explore features of SQL Server that you may not know, and give you the tools to do your own discovery. Learn about all those weird functions, undocumented procedures, and how to find and use them yourself. We’ll also cover how to “hack” SQL Server and possibly find even more interesting features…from the future!
Speaker(s):
- Rob Volk
Track and Room: Track 2 - N/A
Title: Performance Troubleshooting Tools Techniques
Abstract: Ever wonder how Microsoft Support collects and analyzes data to troubleshoot SQL Server problems? Some of the tools we use, SQLDiag, SQLNexus, and PAL, are publicly available and free! In this session we will show you these tools and how to use them. We will also walk through some techniques to analyze the data that has been collected to quickly troubleshoot problems.
Speaker(s):
- Lisa Gardner
Track and Room: Track 6 - N/A
Title: Pretty Output: T-SQL for Presentation
Abstract: So you’ve got your data in the database? That’s great! Now… how about getting it back out? Sometimes complex reports call for complex queries, and this session is all about that. Want to pivot your rows into columns? Sure. Want to format that self-referencing hierarchy? Got it. Ranking? Windowing? No problem. In this session we’ll cover some common data formatting issues and the T-SQL solutions that make them a little less scary.
Speaker(s):
- Audrey Hammonds
Track and Room: Track 3 - N/A
Title: BIML–Step by Step
Abstract: BIML–Business Intelligence Markup Language is your key to faster development of SSIS Projects. This session will guide you through initial familiarization and setup of BIML, ending with more complex demos which show the true power of BIML.
Speaker(s):
- Julie Smith
Track and Room: Track 3 - N/A
Title: DBA 911 - Database Corruption
Abstract: Database corruption is simply a fact of a DBA’s life - if you haven’t seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it.
Speaker(s):
- David Maxwell
Track and Room: Track 1 - N/A
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract: You have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker(s):
- Allen White
Track and Room: Track 5 - N/A
Title: “Indexing” Encrypted Data
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 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 - 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: Track 1 - N/A
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over FORTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Track 5 - N/A
Title: Going Live! Upgrading to SQL 2012 with Log Shipping
Abstract: Want to see an in-the-trenches example of transitioning a SQL2005 server to a SQL2012 server? This session will review how we upgraded a SQL2005 server to a SQL2012 by utilizing Log Shipping, speedy restore operations, and quick thinking. This isn’t a technical demonstration of how you COULD do something:this is a review of how we planned, organized, and executed a server upgrade. I’ll include some of the problems we encountered and troubleshot before, during, and after the upgrade.
Speaker(s):
- Brent Dragoo
Track and Room: Track 2 - 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.
Joe McTaggart
I have worked with Microsoft for 8 years. I started with SQL Server in 2001 with CTS at Microsoft. Currently I am a Premier Field Engineer based out of Indianapolis.
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.
David Maxwell
Twitter: - https://twitter.com/dmmaxwell
LinkedIn: David Maxwell
Contact: https://dmmaxwell.wordpress.com/
David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Aaron King
Twitter: - https://twitter.com/trendoid
LinkedIn: Aaron King
Contact: http://www.aaronstanleyking.com
Aaron King is an application architect specializing in enterprise web applications and very large databases. He has helped several successful startups move to the software plus services model. He is currently working as an independent consultant on several long term engagements. Aaron is also a community leader and active in Indy PASS.
Brian Davis
Twitter: - @Brian78
LinkedIn: Brian Davis
Contact: http://blogs.sqlsentry.com
Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.
Aaron Cutshall
Twitter: - sqlrv
LinkedIn: Aaron Cutshall
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.
Tamera Clark
Twitter: - https://twitter.com/tameraclark
LinkedIn: Tamera Clark
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
JD Wade
Twitter: - https://twitter.com/jdwade
LinkedIn: JD Wade
Contact: http://wadingthrough.com
JD Wade has been providing solutions using various Microsoft products in the St. Louis area for over 18 years. J.D.’s expertise is the architecture, design, deployment, and troubleshooting of SharePoint and Microsoft Cloud solutions as well as interfacing with the surrounding technologies (directory services, e-mail, load balancers, DNS, SQL, WAN accelerators, etc.). J.D. has worked on the deployment of various corporate intranet, extranet, and public-facing web sites.
Audrey Hammonds
Twitter: - @DataAudrey
LinkedIn: Audrey Hammonds
Contact: http://datachix.com
Audrey Hammonds is a Data Platform Specialist for Microsoft in South Florida. Twenty-one years ago, she volunteered for database training to escape the clutches of COBOL and has never looked back. A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things. These days, she gets her kicks from helping customers adopt data services in Azure.
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.
Josh Fennessy
Twitter: - @joshuafennessy
LinkedIn: Josh Fennessy
Contact: http://www.joshuafennessy.com
Josh Fennessy, Solution Architect at BlueGranite, has been building solutions with the SQL Server BI stack for 8 years. He is a Microsoft Certified Solutions Expert in Business Intelligence. Josh#39;s passions include manipulating data in novel ways to open analytic possibilities not before possible.
Josh is active in the SQL Server and Open Source communities. Beyond relational and OLAP data projects, Josh is also involved in projects using cluster computing platforms such as Hadoop.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Joe Salvatore
Contact: http://datadesignpro.com/
Joe is an accomplished Business Intelligence Architect with Pragmatic Works. For over 15 years, Joe, has designed complex business intelligence solutions for customers throughout all of North America. His focus on architecting the right hardware and software solution along with implementing best practice dimensional models has earned him high praise from customers.
Brent Dragoo
Twitter: - brentdragoo
Brent Dragoo lives in Noblesville, Indiana
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
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.
Jim Miller
Twitter: - https://twitter.com/BITracks
LinkedIn: Jim Miller
Contact: https://bitracks.wordpress.com/
For more than 30 years, Jim has worked in the IT/BI business, primarily focused on data warehousing, enterprise reporting, business intelligence, dashboards, analytics, data modeling (relational, multi-dimensional), ETL frameworks, strategic design, master data management, database performance tuning, and replication. In previous engagements, Jim has fulfilled roles as Data Architect, DBA, IT Director, and Senior Consultant.
Kyle Neier
Twitter: - @Kyle_Neier
LinkedIn: Kyle Neier
Contact: http://sqldbamusings.blogspot.com/
Kyle has been working professionally with computers since 1995, the past 10 years being dedicated to SQL Server. He currently works as an Engineer for Apparatus (apparatus.net) where he continues to chase his passion to automate DBA processes. He is a proud father of 5, a leader of the local PASS chapter (www.indypass.org), a Microsoft Certified Master (MCM), and enjoys sharing his passion for SQL Server with others by speaking and mentoring at local and regional events.
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 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
WIT Panel
Contact: http://wit.sqlpass.org/
We have a great panel of Tamera Clark, Wendy Pastrick, Julie Smith and Audrey Hammonds. Kandy Vicini will be moderating.
Adam Belebczuk
Twitter: - @SQLDiablo
LinkedIn: Adam Belebczuk
Contact: http://www.sqldiablo.com/
Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.
Josh Burgin
Twitter: - @joshbdata
LinkedIn: Josh Burgin
Helping people turn data into knowledge using Microsoft products.
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.
Lisa Gardner
Twitter: - sqlgardner
Contact: http://blogs.msdn.com/sqlgardner
Lisa Gardner is a Microsoft Premier Field Engineer based in Columbus, Ohio. She has been with Microsoft since early 2011 and has been a DBA and database developer since 1998. Throughout her DBA years, she also worked with Sybase and DB2, although SQL Server has always been her favorite RDBMS. Lisa’s passion for working with customers comes from many years of supporting high-profile production systems and wanting to help others gain from her experience.
Luke Jian
Twitter: - @sensware
LinkedIn: Luke Jian
Contact: http://blog.sqlpositive.com
Luke Jian is an experienced database architect with a leading healthcare information company. A frequent speaker at conferences and local user groups he has 15+ years of experience in database design, development and optimization on SQL Server and Big Data projects.
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Sios Technology and Allan Hirt
Contact: http://www.sqlha.com
Cluster MVP Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992. He is currently based in the Boston, MA, area and travels all over the world to work with and train clients. His most recent book is “Pro SQL Server 2008 Failover Clustering” (Apress) and is currently working on its sequel, Mission Critical SQL Server due in 2014.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Sponsors
The following is a list of sponsors that helped fund the event: