SQLSaturday #87 - Louisville 2011
Event Date: 10/29/2011 00:00:00
Event Location:
- Duthie Center for Engineering
- 222 Eastern Pkwy
- Louisville, Kentucky
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: The 4-hour DBA: Automate, Audit and Relax
Abstract: Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks. I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores. The flip side of automation is auditing. Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control. We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office.
Speaker(s):
- Sarah Barela
Track and Room: DBA - N/A
Title: The Periodic Table of Dynamic Management Objects
Abstract: Taking the periodic table of elements into consideration I’ve created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today’s SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yeild interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!
Speaker(s):
- Tim Ford
Track and Room: Misc. - N/A
Title: Table Vars and 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: Developer - N/A
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract: SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
Speaker(s):
- William E Pearson III
Track and Room: BI - N/A
Title: Automate Policy-Based Management using PowerShell
Abstract: The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.
Speaker(s):
- Allen White
Track and Room: Advanced DBA - N/A
Title: Everything You Need to Know About SQL Azure
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. 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: Developer - N/A
Title: Get Ready for SSIS in Denali!
Abstract: With the next release of SQL Server right around the corner, BI developers and database professionals need to know what’s coming and how to take advantage of new features and capabilities. During this session, we’ll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we’ll look at new SSIS features including project parameters, shared connection managers, a new Data Quality Services component, and team-based development improvements. Come see some of the exciting changes coming in your favorite data integration tool!
Speaker(s):
- Dave Fackler
Track and Room: Misc. - N/A
Title: Beyond Plateaux: Optimize SSAS with Best Practices
Abstract: Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker(s):
- William E Pearson III
Track and Room: BI - N/A
Title: Introduction to Common Table Expressions
Abstract: Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries. In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
Speaker(s):
- Vicky Harp
Track and Room: Developer - N/A
Title: Writing faster queries
Abstract: Poor database performance is the Achilles’ heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this all-demo session we’ll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.
Speaker(s):
- Tim Chapman
Track and Room: Advanced DBA - N/A
Title: Secure SSAS Data Without Tying Yourself in Knots
Abstract: Are you looking for the best way to secure the data in your cube? There are several approaches to applying data security, each with its own pros and cons. Learn about the basic built-in security, and then see approaches for extending this through dynamic security, using security dimensions, and SSAS stored procedures. You’ll see examples of each as well as a discussion of when to use which approach.
Speaker(s):
- Craig Utley
Track and Room: BI - N/A
Title: Understanding SSIS Performance
Abstract: Many casual users of SSIS (including database professionals using the SSMS Import/Export Wizard) don’t necessarily understand the inner workings of SSIS and what factors impact performance. During this session, we’ll look at different aspects of SSIS and discuss their impact on package performance. We’ll take a deep dive into the Data Flow component, looking at how SSIS manages data as it moves from sources, through transformations, and then to destinations. Finally, we’ll talk about several of the top performance killers casual SSIS users experience and discuss strategies for overcoming these common issues.
Speaker(s):
- Dave Fackler
Track and Room: BI - N/A
Title: Master Data Services in Denali
Abstract: Most DBAs at one time or another have been taught the importance of master data management(MDM), which is just comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of Denali, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the basics of MDS in Denali This session will definitely be an eye opener for some that ar
Speaker(s):
- Arie Jones
Track and Room: Misc. - N/A
Title: Add It Up: Analysis Services Aggregations
Abstract: Are you looking to maximize the performance of your Analysis Services queries? This session explains what aggregations are and how they work. You’ll learn how to create aggregations, tune the aggregations based on actual usage, and design custom aggregations when necessary. You’ll discover the benefits and pitfalls of flexible aggregations, when to use rigid aggregations, and the meaning of lazy aggregation processing. You’ll dive into queries to see if aggregations are being used and learn when aggregations aren’t useful. If you thought aggregation design began and ended with the aggregation wizard, you owe it to yourself (and your cubes) to attend this session.
Speaker(s):
- Craig Utley
Track and Room: BI - N/A
Title: SQL Server Performance Monitoring
Abstract: Everyone knows perfmon is a great tool, but knowing which counters to collect and their optimal values is less well known. I will discuss the counters most helpful in diagnosing performance issues with SQL Server.
Speaker(s):
- Joe Ferry
Track and Room: DBA - N/A
Title: Exploring Data Privacy
Abstract: Somewhere out there someone is storing data about you. What defines sensitive and personally identifiable data? What should you, as a consumer, expect in regard to the protection of this data? What should you as a database professional do to ensure that your customer’s data is protected? In this session we will explore these and other dimensions of the increasingly critical topic of data privacy.
Speaker(s):
- John Magnabosco
Track and Room: DBA - N/A
Title: Transactional Replication – Follow the Data
Abstract: Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.
Speaker(s):
- Chris Skorlinski
Track and Room: Advanced DBA - N/A
Title: Intro to SSRS
Abstract: Are you still ramping up on SSRS? In this session Chris will show you how to create your first SSRS report. In this session we will cover all of the basics including some best practices to get you up to speed when creating reports. This session was designed for someone with little to no experience with SSRS.
Speaker(s):
- Chris Albrektson
Track and Room: BI - 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 have given this talk nearly a dozen times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Developer - N/A
Title: High Availability features in the NEXT SQL Server
Abstract: This sessions provides insight into the high availability features planned for the next release of SQL Server, code named Denali. I’ll provide a brief look at current HA options, Clustering, Replication, Mirroring, and Log Shipping. Then we’ll explore how these were all combined into new AlwaysOn HA feature for Denali.
Speaker(s):
- Chris Skorlinski
Track and Room: Misc. - N/A
Title: Monitoring Databases in a Virtual Environment
Abstract: When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.
Speaker(s):
- Thomas LaRock
Track and Room: DBA - N/A
Title: Choose Your Own Adventure: Performance Tuning
Abstract: Life is all about choices, and when it comes to SQL Server it is no different. If you don’t have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft’s Tim Chapman and Thomas LaRock from Confio Software as they help guide you while YOU make the choices in this interactive performance tuning adventure.
Speaker(s):
- Tim Chapman
Track and Room: DBA - N/A
Title: T-SQL in Denali
Abstract: The next version of SQL Server has something for everyone! Attend this session to learn about the new features and functions to make T-SQL coding easier and more efficient. Those attending will have a chance to win my Denali T-SQL book.
Speaker(s):
- Kathi Kellenberger
Track and Room: Misc. - N/A
Title: SQL Server Memory Deep Dive
Abstract: Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server’s health and performance.
Speaker(s):
- Kevin Boles
Track and Room: Advanced DBA - N/A
Title: Let Service Broker Help You Scale Your Application
Abstract: How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Speaker(s):
- Allen White
Track and Room: DBA - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Advanced DBA - N/A
Title: What Counts For a DBA
Abstract: The world of a DBA can be daunting for a person, either as a new or old, because not only do they need to keep up with new and emerging technologies, but also with the code and designs of their coworkers. In this highly participation driven session, we will employ a random topic chooser to pick several of these traits for discussion as a group. Possible topics include past blog topics such as Logic, Curiosity, Failure, Humility, Skill and Passion, as well as any other topics that might be added for that day. So come prepared to participate and voice your opinion about what counts for a DBA.
Speaker(s):
- Louis Davidson
Track and Room: Misc. - N/A
Title: T-SQL Alphabet Soup
Abstract: Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.
Speaker(s):
- Rodney Landrum
Track and Room: Developer - N/A
Title: Database design for developers
Abstract: As a developer there are a few things you’ll want to know about database design. How can you build tables optimized for high transaction volume? How can referential integrity checks save you from building extra validation code into your applications? We’ll cover how and when to add indexing to your tables for performance gains. Finally we’ll briefly cover views, functions, and triggers, and when you should avoid them.
Speaker(s):
- Shannon Lowder
Track and Room: Developer - N/A
Title: Page Latches for Mere Mortals
Abstract: Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you’ve seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!
Speaker(s):
- Eddie Wuerch
Track and Room: Advanced 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.
Craig Utley
Contact: http://www.learnmicrosoftbi.com
Craig Utley is a Senior Architect with CTS and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he focused on business intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0 and has consulted on over 50 BI implementations worldwide, including the largest Microsoft data warehouse in the world. He is a former MVP in both SQL Server and C# and has written three books and more than 35 articles.
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.
Rodney Landrum
Twitter: - @SQLBeat
Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/
Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP
Vicky Harp
Twitter: - vickyharp
Contact: http://vickyharp.com
Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
Thomas LaRock
Twitter: - @SQLRockstar
LinkedIn: Thomas LaRock
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
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
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.
Chris Skorlinski
Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;
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
Chris Albrektson
Contact: http://www.bidn.com/blogs/ChrisAlbrektson
Chris Albrektson is a Business Intelligence consultant for Pragmatic Works and is experienced in Reporting Services, Crystal Reports and Integration Services. Chris is an active member of the Jacksonville SQL Server User Group (JSSUG), and also volunteers/speaks at SQLSaturday and Code Camp events. He’s also a regular blogger on BIDN.com and recently a technical editor on SQL Server books.
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.
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.
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.
Craig Utley
Contact: http://www.learnmicrosoftbi.com
Craig Utley is a Senior Architect with CTS and a former Program Manager with the SQL Server Customer Advisory Team (SQLCAT), where he focused on business intelligence. Craig has been involved in the Microsoft BI space since the betas of SQL Server 7.0 and has consulted on over 50 BI implementations worldwide, including the largest Microsoft data warehouse in the world. He is a former MVP in both SQL Server and C# and has written three books and more than 35 articles.
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.
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
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.
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.
Tim Chapman
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
Tim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Originally from Louisville, KY Tim now resides in Columbus, OH Tim has over 12 years of database architecture, programming, and administration experience.
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.
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.
Tim Chapman
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
Tim Chapman is a Microsoft Certified Master (MCM) and works as a dedicated field engineer (PFE) at Microsoft specializing in performance tuning and high availability. Originally from Louisville, KY Tim now resides in Columbus, OH Tim has over 12 years of database architecture, programming, and administration experience.
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.
Kathi Kellenberger
Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx
Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “SQL Server MVP Deep Dives.” In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.
Joe Ferry
I have been a Microsoft Premier Field Engineer for four years, assisting customers with SQL Server Analysis Services, SQL Server Integration Services and the SQL Server Relational Engine. I don’t have to find myself to be the smartest guy in the room to be helpful because I have seen more environments and issues than most dbas and can share my experiences that help others to focus in on what is important rather than what is more likely to be of academic interest.
Shannon Lowder
Twitter: - @shannonlowder
LinkedIn: Shannon Lowder
Contact: http://shannonlowder.com
For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using TSQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero candidate and is awaiting the final approval for the award.
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
John Magnabosco
Contact: http://www.simple-talk.com/community/blogs/johnm/default.aspx
John Magnabosco is the Data Services Manager at Defender Direct; although he prefers the title “Data Coach”. He also is a co-founder of IndyPASS and IndyTechFest. He is also the author of the book “Protecting SQL Server Data” and contributing author of the soon to be released “SQL Server MVP Deep Dives, Vol. 2”.
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.
Sponsors
The following is a list of sponsors that helped fund the event: