SQLSaturday #77 - Pensacola 2011
Event Date: 06/04/2011 00:00:00
Event Location:
- Pensacola Junior College, Main Campus
- 1000 College Blvd, Pensacola
- Pensacola, Florida
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: How to Make (more) Money with WP7
Abstract: When you get your app running… and even more so when published… you are most likely feeling pretty good and on cloud 9. It feels great, doesn’t it? Here are a few suggestions in this chapter to make you feel even better. Of course, more work is needed. Getting your app noticed in marketplace will not happen automatically or optimally by publishing alone. There specific suggestions I will offer up to help the cause. So, grab a deep breath and get ready to settle in and focus on making more money. Make all the time you have invested so far, well worth it. Many of the suggestions are common sense when you think them through, but are a few I found out the hard way and hopefully will save you some pain. Topics include: Marketing Basics, Gettin
Speaker(s):
- Russ Fustino
Track and Room: Windows Phone Garage - 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: DBA and TSQL - N/A
Title: T-SQL Awesomeness: 3 Ways to Write Cool SQL
Abstract: There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability.
Come learn three new-school ways to expand your T-SQL repertoire with: • Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY
We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.
Speaker(s):
- Audrey Hammonds
Track and Room: DBA and TSQL - N/A
Title: Transition from DBA to BI Architect
Abstract: Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.
Speaker(s):
- Thomas LeBlanc
Track and Room: SSIS and BI - N/A
Title: Design and Implement BI Like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s):
- William E Pearson III
Track and Room: SSIS and BI - N/A
Title: Pulp SQL
Abstract: Pulp SQL: Stories, all have them. In this session Brad and Jorge will tell the tales of how SQL in shops can go horribly wrong, and how to properly go about doing it. This story will be told Tarrantino-style so prepare for some twists, characters and ninja-like tactics* to help you avoid your own SQL mistakes!*fight scenes may or may not break out
Speaker(s):
- Jorge Segarra
Track and Room: DBA - N/A
Title: Branding Yourself for a Dream Job - The Modern Res
Abstract: Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker(s):
- Steve Jones
Track and Room: MISC - N/A
Title: Dynamic SSIS: Configurations, Expression and Vari
Abstract: One of the biggest hurdles in any organization is migrating from DEV to PROD with minimal issues. In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier. Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables. After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration. At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package!
Speaker(s):
- Bradley Schacht
Track and Room: SSIS and BI - N/A
Title: Attribute Discretization in Analysis Services (BI)
Abstract: Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability.
Speaker(s):
- William E Pearson III
Track and Room: SSIS and BI - N/A
Title: Windows Phone Garage
Abstract: You’re invited to spend a few hours working with “SAMS WP7 Development in 24 Hours” book authors Kevin Wolf and Joe Healy on your Windows Phone applications. We can play “fix the architecture”, brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications. Every 30 minutes Joe or Kevin will supply some “quick tips” in a lightning talk format from their book. Bring your laptop pre-loaded with the devtools and be ready to go.
Speaker(s):
- Joe Healy
Track and Room: Windows Phone Garage - N/A
Title: Building SMO Apps for the Non-Programmer DBA
Abstract: SMO gives us an exremely powerful library that can be used to perform a slew of SQL Server tasks. Using this library we can build tools to automate daily tasks and even build apps that might not be easy to do or even possible with SSMS/TSQL. In this session I will teach you, the non-programmer DBA, how to build an SMO application that performs some SQL Server health checks and reports back to you in a nice GUI tool. We will go over some basic OOP information but the bulk of this session will be hands on building/demoing. No .NET experience is required. The less experience you have with .NET development the better!!
Speaker(s):
- Shawn McGehee
Track and Room: DBA - N/A
Title: You inherited a database, now what?
Abstract: You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.
Speaker(s):
- Tim Radney
Track and Room: DBA and TSQL - N/A
Title: SQL Server DMV Overview
Abstract: What are DMV’s in SQL 2005/2008, and how can you use them to improve query performance, discover indexing needs and more? Dynamic Management Views are essential tools for the SQL 2005/2008 administrator but have a wide range of applications by developers, network engineers and DBAs. Now updated with more jokes and more practical scripts!
Speaker(s):
- William Assaf
Track and Room: Performance - N/A
Title: Entity Framework Quick Introduction
Abstract: For those attendees who want to attend the Entity Framework version 4.1 session, but aren’t quite sure what Entity Framework is, and how to get started with the basics, this talk with some background info and basic demos will get you up to speed. This will use the traditional EF approach of creating a model using a designer based on an existing or new database.
Speaker(s):
- Sven Aelterman
Track and Room: DEV - N/A
Title: Windows Phone Garage (Continued)
Abstract: You’re invited to spend a few hours working with “SAMS WP7 Development in 24 Hours” book authors Kevin Wolf and Joe Healy on your Windows Phone applications. We can play “fix the architecture”, brainstorm, troubleshoot, or just give you a quiet zone to co-work on your applications. Every 30 minutes Joe or Kevin will supply some “quick tips” in a lightning talk format from their book. Bring your laptop pre-loaded with the devtools and be ready to go.
Speaker(s):
- Karla Landrum
Track and Room: Windows Phone Garage - N/A
Title: Preparation for Disaster
Abstract: This session will showcase how a DBA can be ready for any problems that might occur in their environment. Steve Jones will talk about how you can develop a well thought out backup and recovery solution for all kinds of disasters, learn about practicing restores, and the value of regularly running checks for corruption in your databases..
Speaker(s):
- Steve Jones
Track and Room: DBA - N/A
Title: Introduction to Data Warehousing
Abstract: In this session you will learn why you need a Data Warehouse, how to plan for one, and what the key steps to developing one. You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse. This session will focus more on the concepts of development rather than demonstrating the development itself.
Speaker(s):
- Devin Knight
Track and Room: DBA - N/A
Title: Performance Tuning Analysis Services
Abstract: In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
Speaker(s):
- Devin Knight
Track and Room: Performance - N/A
Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !
Abstract: This presentation is for those familiar with SQL Server, but absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour, stepping through a classic “old pro” DBA forced into Beginner ETL Developer scenario. We’ll quickly cover not just developing the package, but also ways to deploy and execute.
Speaker(s):
- Julie Smith
Track and Room: SSIS and BI - N/A
Title: Building Occasionally Connected Apps Using SQL Azu
Abstract: In this presentation we will walk though utilizing Microsoft SQL Azure, a scalable cloud database service built on SQL Server technologies, and the Microsoft Sync Framework, a comprehensive synchronization platform, to build a highly available and scalable collaboration business application. Along the way we will discuss the capabilities and challenges of building such an application using the current frameworks.
Speaker(s):
- Kevin Grohoske
Track and Room: DEV - N/A
Title: Deploying Kentico CMS Applcaition to Windows Azure
Abstract: In this session, Bryan Soltis will demonstrate deploying a Kentico CMS application to Windows Azure. Topics covered will include converting a Kentico CMS site to a web application, adding and configuring a Windows Azure web role, implementation and configuration of Windows Azure storage accounts, deployment of a Kentico CMS database to SQL Azure, and deploying the application to Windows Azure. Bryan will demonstrate several code examples, real world applications, and best practices in developing Kentico CMS in the cloud.
Speaker(s):
- Bryan Soltis
Track and Room: DEV - N/A
Title: Revenge: The SQL!
Abstract: Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG!
This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you’ll ache for the chance!
Speaker(s):
- Rob Volk
Track and Room: DBA - 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: Performance - N/A
Title: The Power of ASP.NET 4.0 Dynamic Data
Abstract: ASP.NET Dynamic Data is now a matured offering of the .NET framework. In this session we will take a feature tour demonstrating its power and flexibility. We’ll discuss practical usages and customizations.
Speaker(s):
- Mike Huguet
Track and Room: DEV - N/A
Title: RedGate Tools Demonstration
Abstract: TBA
Speaker(s):
- Karla Landrum
Track and Room: DBA - N/A
Title: Leveraging Open XML to Create More Dynamic Docs
Abstract: Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions. We’ll also discuss the role of some of the SharePoint Office Services.
Speaker(s):
- Mike Huguet
Track and Room: DEV - N/A
Title: Windows Azure Overview
Abstract: Should you be be looking to the Cloud? Your path to blue skies might be through Windows Azure Platform.Windows Azure is just one element of Microsoft’s Cloud Computing Strategy. There are a wide variety of Cloud Services and Cloud Technology offerings from Microsoft. This session will focus on Windows Azure and the Microsoft offerings under this umbrella. It will provide developers and business people an overview of Windows Azure.
Speaker(s):
- Vincent Mayfield
Track and Room: DEV - N/A
Title: Introduction to SQL Azure
Abstract: SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer.
Speaker(s):
- Ryan Duclos
Track and Room: DBA and TSQL - N/A
Title: SQL Server Partitioning from A to Z
Abstract: We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.
Speaker(s):
- Kevin Boles
Track and Room: DBA - N/A
Title: SSIS: The DBA multiplier
Abstract: Ever wanted to create clones of yourself to get all your work done faster? I will demonstrate how SSIS can help you perform your DBA tasks as if there were more than one of you. You will leave the session knowing how to use SSIS to automate tasks such as performance monitoring above (and below) the normal health checks and transporting databases from one environment to another. You will also learn how SSIS can be used in assisted HA and DR failover strategies as well as backup solutions that go beyond the simple BACKUP statement. We’re going to take SSIS and make it a standard tool for your administrative tasks!
Speaker(s):
- Ted Krueger
Track and Room: SSIS and BI - N/A
Title: Quickly Gather Performance Data with PowerShell
Abstract: Continuously gathering performance data to log history and developing a performance baseline is a really important task in any environment. Having quick access to what’s happening right now is equally important. In this session we’ll take a look at how to continuously gather Perfmon counters and DMV info. We’ll also take a look at how to Visualize the data using charts.
Speaker(s):
- Aaron Nelson
Track and Room: Performance - N/A
Title: Loading Data with PowerShell
Abstract: In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table. We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell. Finally we’ll re-use our newly found XML scills to modify an SSIS package before we run it.
Speaker(s):
- Aaron Nelson
Track and Room: MISC - N/A
Title: Performance Tuning With Execution Plans
Abstract: In this session we will look at examining execution plans as a method for performance tuning. With the execution plan we can see the exact type of operation performed, and, more than that, we can look at the differences in what the optimizer thought the query would cost vs what it actually cost to perform the query. By examining the plans we have a road map for determining what type of improvements we should be striving for in order to make the particular statement more optimal.
Speaker(s):
- Eric Wisdahl
Track and Room: Performance - N/A
Title: Entity Framework v4.1: What’s New in 2011
Abstract: Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a “code only” approach, which has many benefits, including for testability and long-term evolution of your code.
Speaker(s):
- Sven Aelterman
Track and Room: MISC - N/A
Title: Predictive Analytics - You Can, Too!
Abstract: Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…
Speaker(s):
- Troy Ketsdever
Track and Room: DBA and TSQL - N/A
Title: PowerPivot, Idea to Solution in 60 Minutes
Abstract: This fast-paced session will construct a PowerPivot for SharePoint dashboard, analyzing a humorous, everyday problem-set. Beginning with installing PowerPivot for Excel and concluding with a working, interactive dashboard, this session will prepare attendees to leverage PowerPivot to load data from disparate, related sources. Limitations for creating good relationships, and the construction of good dimensions will be covered. Finally, surfacing the assembled data using slicers, charts and tables.
Speaker(s):
- Barry Ralston
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: DBA and TSQL - N/A
Title: Execution Plan Basics - Beginners
Abstract: This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?
Speaker(s):
- Thomas LeBlanc
Track and Room: Performance - N/A
Title: Using PowerShell to Rapidly Deploy SQL Server
Abstract: This session will cover a PowerShell project that is designed to allow organizations to rapidly deploy new SQL Server instances to their environment. The process includes automating all aspects of the SQL Server install from Operating System pre-configurations, the SQL Server install, to deploying standard SQL objects such as databases, tables, jobs, and stored procedures.
Speaker(s):
- Michael Wells
Track and Room: MISC - 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.
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.
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.
Thomas LeBlanc
Twitter: - TheSmilingDBA
LinkedIn: Thomas LeBlanc
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
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.
Audrey Hammonds
Contact: http://www.datachix.com
Audrey Hammonds is a BI Consultant for Key2 Consulting in Atlanta, GA, and one half of the Datachix (www.datachix.com). She holds MCTS certifications in SQL Server 2008 Database Development and SQL Server 2008 Business Intelligence. Fourteen 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.
Mike Huguet
Contact: http://blogs.msdn.com/b/pfedev
Mike Huguet is a Developer Premier Field Engineer for Microsoft. He is an active member of the IT community as the President of the Baton Rouge .NET User Group, a founding member of the Baton Rouge SQLSaturday event, and an avid speaker at all day conferences and user groups. He has a software development background and has been delivering solutions with .NET since Beta 1 and SharePoint since 2006.
Eric Wisdahl
Twitter: - @EricWisdahl
LinkedIn: Eric Wisdahl
Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.
Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.
Ryan Duclos
Contact: http://about.me/rduclos
Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.
Vincent Mayfield
Contact: http://www.bitwizards.com/Blogs/Vincent-Mayfield
Vincent W. Mayfield (Vinny/Vince) is the Chief Executive Officer and co-founder of Bit-Wizards of Fort Walton Beach, Florida. Bit-Wizards is an innovative technology company providing professional software engineering, systems integration, web design, and IT consulting services. Bit-Wizards is a Microsoft Managed Gold Partner. Vince has over 21 years of experience developing software, and over 18 years developing applications for the Windows Family of Operating Systems. Vince is a Microsoft VTSP
Barry Ralston
Barry Ralston is Chief Architect for Business Intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for Business Intelligence, responsible for assisting in Alabama, Mississippi and Northwest Florida sales efforts including customer meetings, software demonstrations and Proof of Concept efforts. Barry’s client successes include: ACIPCO, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.
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
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.
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.
Thomas LeBlanc
Twitter: - TheSmilingDBA
LinkedIn: Thomas LeBlanc
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
Troy Ketsdever
Twitter: - @42and5
Contact: http://www.42and5.com
Troy Ketsdever is a data architect with over 15 years of commercial software development experience, and has maintained a love/hate relationship with SQL Server since version 4.2. In addition to his “day job”, Troy enjoys writing articles and presenting at user groups on a variety of database design and implementation topics. His main objective and vision is “making the right information available to the right people at the right time”.
William Assaf
Twitter: - william_a_dba
LinkedIn: William Assaf
Contact: http://www.sqltact.com
William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.
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
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
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.
Karla Landrum
TBA
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
Bryan Soltis
Contact: http://www.bitwizards.com/Blogs/Bryan-Soltis
Bryan Soltis is the Directory of Technology Research for Bit-Wizards Custom Solutions, Inc. in Fort Walton Beach, FL. Bryan has over 13 years of experience designing and implementing solutions using Microsoft technologies. Bryan is an MCPD 4.0, MCSD, and Microsoft VTSP. In his free time he enjoys traveling with his family, lounging on beach with live music, and wiping out repeatedly trying to wakeboarding.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Russ Fustino
Contact: http://www.russtoolshed.net
Russ Fustino wisely shelved dreams of rock and roll stardom in order to share his vast knowledge with developers nationwide. Given that he can’t sing or play an instrument, other than in Guitar Hero, we’re all very grateful. Russ has more than 30 years of software development. He’s the creator of the Russ’ Tool Shed developer seminar series and has donned his trademark suspenders, hardhat and tool belt in presentations for over 120,000 developers at over 2000 live events.
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Shawn McGehee
Contact: http://www.gulfcoastsql.com
Shawn McGehee is the Senior Database administrator for a nationwide health care company currently residing in the Orlando area. He has been working in the IT industry for over 12 years and came from a development background before he moved into database administration in 2004. Shawn has contributed to several online publications and speaks at SQLSaturdays, Code Camps and local user group meetings as much as possible. Shawn was also a co-author on the 2008 Reporting Services book from Apress.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Ted Krueger
Contact: http://blogs.lessthandot.com/index.php/All/?disp=authdirauthor=68
Ted Krueger has been working in development and database administration for over a decade. Ted currently works for a respected consulting company, Magenic Technologies as a valued Database Professional resource. He is a PASS Region Mentor, Friends of Red Gate member, SQL Server MVP and community mentor. Ted blogs and is also one of the founders of LessThanDot Technical Community
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.
Kevin Grohoske
Contact: http://www.bitwizards.com/Company/Meet-the-Team/Corporate-Leadership/Kevin-R–Grohoske
Kevin first started programming on a Timex Sinclair 1000 when he was 11 years old. As a professional, Kevin has been designing and developing custom applications using Microsoft development tools since 1995. He has designed and developed large enterprise class applications and intranet applications for companies such as International Paper, LexisNexis, and Duke Energy. He moved from Cincinnati in 2006 to join Bit-Wizards, Custom Software Solutions headquartered in Fort Walton Beach, FL.
Michael Wells
Twitter: - @SqlTechMike
LinkedIn: Michael Wells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
Bradley Schacht
Contact: http://www.bradleyschacht.com
Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQLSaturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).
Joe Healy
Contact: http://blogs.msdn.com/devfish
— Joe Healy is a Technology Evangelist for Microsoft covering North and Central Florida. He can be reached at jhealy@microsoft.com or http://blogs.msdn.com/devfish ….
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
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.
Mike Huguet
Contact: http://blogs.msdn.com/b/pfedev
Mike Huguet is a Developer Premier Field Engineer for Microsoft. He is an active member of the IT community as the President of the Baton Rouge .NET User Group, a founding member of the Baton Rouge SQLSaturday event, and an avid speaker at all day conferences and user groups. He has a software development background and has been delivering solutions with .NET since Beta 1 and SharePoint since 2006.
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.
Karla Landrum
TBA
Jorge Segarra
Twitter: - @sqlchicken
LinkedIn: Jorge Segarra
Contact: http://sqlchicken.com
Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including “SQL 2008 Pro Policy-Based Management” and “SQL Server 2012 Bible” .
Sponsors
The following is a list of sponsors that helped fund the event: