SQLSaturday #32 - Tampa 2010

Event Date: 01/23/2010 00:00:00

Event Location:

  • K-Force
  • 1001 East Palm Ave
  • Tampa, Florida

PDF of Schedule

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

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


Sessions

This is a list of sessions from the event, based on the schedule in the XML files.


Title: Getting Started with AppFabric Caching (Velocity)

Abstract: Let’s face it, reading and writing data with SQL Server can be expensive and has scaling this type of architecture has its implications that need to be considered upfront. This is one of the reasons Microsoft has included caching within its future AppFabric Framework. Caching is not a new methodology because we can use it currently in applications built on top of ASP.Net out of the box, however there are still scaling issues that AppFabric Caching (ACF), formerly Velocity addresses. As database developers, it is important to identify with new trends that may affect database integration and this presentation does just that. First we will learn the basics of AFC, how to install, how to scale, and how data driven solutions can benefit from it.

Speaker(s):

  • Bayer White

Track and Room: Track 4 - N/A


Title: Using XML to Query Execution Plans

Abstract: SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases.

Prerequisites Understanding of basic T-SQL coding Understanding of basic XQuery statements

Goals:

  1. Discuss information available in an execution plan
  2. Demonstrate use of XQuery to query execution cache
  3. Demonstrate methods to performance tune

Speaker(s):

  • Jason Strate

Track and Room: Track 4 - N/A


Title: Social and Not So Social Networking for the DBA

Abstract: Should you be networking? In this session we’ll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we’ll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills.

Speaker(s):

  • Andy Warren

Track and Room: Track 4 - N/A


Title: SQL Server Data Compression 101

Abstract: In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level.

Speaker(s):

  • Patrick LeBlanc

Track and Room: Track 5 - N/A


Title: Building a Near-Realtime Operational Dashboard

Abstract: Using Analysis Services, ASP.NET, AJAX callbacks for refresh, Dundas grids and charts, and Notification Services for alerts, this session will show how to integrate a variety of MS technologies to create a state-of-the-art dashboard system. This particular dashboard implementation is currently in use by Norfolk Southern railroad to monitor intermodal shipments. The concepts could be applied to monitoring any operational system. It also shows how cubes can be used for more than just decision support.

Speaker(s):

  • Mark Landry

Track and Room: Track 6 - N/A


Title: Database Table Partitioning, The Next Step

Abstract: In this session I will go over some of the techniques that I have used to implement database partitioning in a 2 TB OLTP database. This session will be about now that you have decided to use partitioning how do you determine what partition key to use? If my table is using multiple search criteria at different times how do I choose a partitioning key? What tables should I Partition? How should my partitions be stored?

Speaker(s):

  • Elijah Baker

Track and Room: Track 3 - N/A


Title: SQL Server Service Broker

Abstract: We will take a look at SQL Service Broker, the built-in asynchronous messaging subsystem provided with SQL Server. We will examine new terminology as well as get a grounding in how we can setup and use Service Broker for messaging applications. We live in an increasingly interconnected world and having a system that can handle intermittent connections and asynchronous processing can solve many business problems. And if MySpace can use it to pass hundreds of millions of messages around their system per day, it can probably do whatever you need it to do as well! Plenty of code in this presentation too.

Speaker(s):

  • Kevin Boles

Track and Room: Track 7 - N/A


Title: Why Should I Use Stored Procedures?

Abstract: With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view points welcome.

Speaker(s):

  • Jack Corbett

Track and Room: Track 3 - N/A


Title: 5 Resolutions to Build Your Professional “Brand”

Abstract: The start of a new year offers us the opportunity to “take stock” of what may or may not be helping us to achieve our personal and professional goals. One thing we may forget to assess is our “professional brand”. Your professional brand can help you to distinguish and position your personal portfolio of experience, skills and knowledge as unique and of value to customers and in the marketplace. This session looks at five actions to take that align your professional brand with your career goals, and can help your clients, peers, and managers see the tangible and intangible benefits of working with you.

Speaker(s):

  • Patricia (Pat) Baxter

Track and Room: Track 6 - N/A


Title: Tuna Helper for SQL Server DBA’s

Abstract: Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning.

Speaker(s):

  • Janis Griffin

Track and Room: Track 6 - N/A


Title: Accurate MDX RoadTrip

Abstract: In this session I will demonstrate MDX with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine using MDX. I will start with basic concepts of MDX and move to more Advanced calculations.

Speaker(s):

  • Michael Mollenhour

Track and Room: Track 5 - N/A


Title: ABCs of CTEs

Abstract: Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.

Prerequisites Understand of basic T-SQL coding

Goals: Provide an understanding of the purpose and use of CTEs for recursion and derived tables Define the pro’s and con’s to using CTEs in recursion and for derived tables Demonstrate real-world examples detailing methods for using CTEs to solve coding challenges

Speaker(s):

  • Jason Strate

Track and Room: Track 2 - N/A


Title: Choosing Indexes for Performance

Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

  • Jeffrey Garbus

Track and Room: Track 2 - N/A


Title: XML 101 for the SQL Developer

Abstract: This session is designed as a lead-in to the session by Scott Klein. It defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML.

Speaker(s):

  • Michael Antonovich

Track and Room: Track 7 - N/A


Title: SQL Server Beyond Relational

Abstract: Participate in an architecture review showcasing the use of SQL Server 2008 Spatial features and the filestream data. The session will focus on a pre-defined solution architecture using SQL Server 2005 with pure relational data and after a brief introduction of new features in SQL Server 2008, changes will be presented and discussed with the group, culminating in a new architecture.

Speaker(s):

  • Telmo Sampaio

Track and Room: Track 7 - N/A


Title: SSIS users: Turbocharge your ETL with expressor

Abstract: Microsoft SQL Server Integration Services (SSIS) users who are writing too much complex code to transform data, struggling with application performance or having trouble integrating diverse data sources will benefit from learning about the expressor semantic data integration system – an affordable, enterprise-class alternative to SSIS. They will learn how American Tower improved the data loading times for its data warehouse and enabled its developers to perform complex data transformations in a single process by migrating from Microsoft SSIS to expressor.

Speaker(s):

  • Michael Ruland

Track and Room: Track 2 - N/A


Title: Access SQL Back-End Gets Better Option

Abstract: Hear how Access 2010 and SharePoint 2010 can be used to better manage your Access applications, reducing the load on your SQL Server. SharePoint 2010 manages security, backup, and deployment of the Access aps, and makes it possible to use the Access ap in the browser without having Access on the client machine and in untrusted mode. And because of the way Access now caches, it becomes a tool of choice for large number of records queries and reports (40,000-160,000 records), reducing the load on your SQL Servers. Finally, see a tool for finding the Access applications in your environment so you can prioritize making them more managed.

Speaker(s):

  • Kathy Malone

Track and Room: Track 7 - N/A


Title: Introduction to Transactional Replication

Abstract: SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some of the primary reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.

Speaker(s):

  • Troy Gallant

Track and Room: Track 6 - N/A


Title: SQL Azure

Abstract: In this session we will discuss SQL Azure at a high level including development lifecycle, production, security, auditing and general limitations.

Speaker(s):

  • Herve Roggero

Track and Room: Track 4 - N/A


Title: PowerShell for Data Professionals

Abstract: In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet using PowerShell.

Speaker(s):

  • Aaron Nelson

Track and Room: Track 5 - N/A


Title: Zero to Cube in 60 Minutes

Abstract: Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.

Speaker(s):

  • Adam Jorgensen

Track and Room: Track 5 - N/A


Title: Getting familiar with SQL Server Storage Engine

Abstract: You need to know how SQL Server works internally if you want to design the effective solutions. This session will give the overview of how SQL Server stores data internally; what criteria query optimizer uses when choose the index and provide some guidelines how to design tables and indexes to improve the performance of the database solutions.

Speaker(s):

  • Dmitri Korotkevitch

Track and Room: Track 2 - N/A


Title: Data Mining and Predictive Analysis using SQL 2008

Abstract: The session will introduce the attendees to the basics of Data Mining and Predictive analysis. It will go over the basic building blocks of SQL 2008 Data Mining Engine and will provide an example of Data Mining project lifecycle.

Speaker(s):

  • Vikas Hawaldar

Track and Room: Track 6 - N/A


Title: Introduction to SSIS

Abstract: This session will get you past the learning curve of SSIS. Brian covers creating an end to end package that covers many of the concepts in SSIS. He covers, looping over a set of files, processing each file and then archiving. You won’t want to miss this if you’re new to SSIS.

Speaker(s):

  • Brian Knight

Track and Room: Track 1 - N/A


Title: Care and Feeding of TempDB

Abstract: EVERY SQL Server uses tempdb, many of them extensively. Suboptimal configuration is a leading cause of poor performance. We will cover how to have an optimal configuration for your environment and also how to effectively monitor various tempdb metrics.

Speaker(s):

  • Kevin Boles

Track and Room: Track 4 - N/A


Title: Rapid BI Development with Pragmatic Works

Abstract: In this session, you’ll learn how to use a series of free and pay components in your tool belt to improve the speed of your SSIS development. You’ll learn how to code packages faster with templates in BI xPress and how tasks and transforms built into Task Factory can take hours off your SSIS runtime.

Speaker(s):

  • Brian Knight

Track and Room: Track 1 - N/A


Title: PGP encryption using SSIS

Abstract: In this session I’ll show you how SSIS can use a scripted task or execute task to encrypt or decrypt a file. All examples will be in C#..

Speaker(s):

  • Scott Gleason

Track and Room: Track 1 - N/A


Title: Introduction to Execution Plans

Abstract: This session will cover the basics the different types of execution plans, how to generate them, and how to read them.

Speaker(s):

  • Nathan Heaivilin

Track and Room: Track 7 - N/A


Title: Iron Chef Competition: Loading a Data Warehouse

Abstract: In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You’ll see a battle between two SSIS experts (Brian Knight and Adam Jorgensen), attempting to load the data warehouse the best way. You’ll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition.

Speaker(s):

  • Brian Knight

Track and Room: Track 1 - N/A


Title: Clustering for Mere Mortals

Abstract: Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

Speaker(s):

  • Geoff Hiten

Track and Room: Track 2 - N/A


Title: PowerShell ETL

Abstract: In this sesssion we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

Speaker(s):

  • Chad Miller

Track and Room: Track 5 - N/A


Title: SQL University 101:Starting the SQL Journey

Abstract: On my blog I’ve started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know. This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources!

Speaker(s):

  • Jorge Segarra

Track and Room: Track 2 - N/A


Title: Developing with SQL Azure

Abstract: Cloud computing is gaining momentum. Knowing how to develop applications for the cloud is important. This session will discuss how to develop applications with SQL Azure, and It will focus on two areas when developing application for SQL Azure, the .NET side and the SQL side.

Speaker(s):

  • Scott Klein

Track and Room: Track 4 - N/A


Title: Common SQL Programming Mistakes

Abstract: Become a better SQL coder by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.

Speaker(s):

  • Plamen Ratchev

Track and Room: Track 3 - N/A


Title: Real-World Performance Tuning

Abstract: Confio Software (Janis Griffin, Sr. DBA Product Architect) and Soaring Eagle Consulting (Jeff Garbus, Principal) will conduct a demonstration of “Real-World Performance Tuning” using the Ignite Suite from Confio. In this demonstration and discussion, Janis Griffin and Jeff Garbus will show the audience how using Response-Time Analysis and Wait-Types in SQL Server to quickly diagnose and identify performance bottlenecks in SQL Server 2000,2005, and 2008. Ignite may also be used for cross-platform monitoring and performance tuning on Oracle, Sybase and DB2-LUW.

Speaker(s):

  • Janis Griffin

Track and Room: Track 3 - N/A


Title: Advanced Parameters in SSRS 2008

Abstract: In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures.

Speaker(s):

  • Mike Davis

Track and Room: Track 1 - N/A


Title: Database Hardening via PowerShell

Abstract: Database Hardening via PowerShell. I will demonstrate how I use PowerShell to handle the issues encountered in a Fortune 50 corporate environment that has over 500 database servers and 3600 databases.

Speaker(s):

  • Ronald Dameron

Track and Room: Track 5 - N/A


Abstract: Utilizing only T-SQL and algebra, I will engage the attendees in a discussion of teasing trends out of data buried within SQL Server, without having to learn the intricacies of Data Warehousing and MDX Querying. It is my hope that my methods can be used and expanded upon in your field, and I invite those who use SQL Server in any environment to come join the discussion.

Speaker(s):

  • David Taylor

Track and Room: Track 6 - N/A


Title: Real Time Problem Identification with Event Notifi

Abstract: Event Notifications are a hidden gem in SQL Server 2005, just waiting to provide you with real time information about problems inside of SQL Server. This session will provide a brief overview of the Service Broker components used by Event Notifications and then dive into how to build a monitoring solution for common problems in SQL Server like blocking and deadlocks that capture the needed information for troubleshooting in real time and provide email notification that a problem exists.

Speaker(s):

  • Jonathan Kehayias

Track and Room: Track 2 - N/A


Title: Refactoring SQL for Performance

Abstract: Many people live by the motto “If it’s not broken, don’t fix it”. But if you believe that you are missing all enhancements introduced in newer versions of SQL Server (2005/2008). These new features can help you develop better solutions with improved performance, scalability, and maintainability. Learn how to craft a better query using the new MERGE statement, ranking functions, and more. Practical examples with tips and tricks.

Speaker(s):

  • Plamen Ratchev

Track and Room: Track 3 - N/A


Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract: This session reviews rewriting a bad chunk of data migration code. Your speaker wrote the original code at 1:30 am, rewrote it with disgust at 2am, and wrote it nicely the next evening. We will review why the dozens of reqasons the first 2 passes are bad, followed by some firm coding recommendations.

Speaker(s):

  • Jeffrey Garbus

Track and Room: Track 3 - N/A


Title: SQLServer 2008 Spatial Data

Abstract: An overview of the new spatial geography data types in SQL Server 2008. Following the overview will be a demonstration of creating queries with spatial data as input and results. Finally, we will wire up a real world example into Bing Maps using ASP.Net.

Speaker(s):

  • Michael Stark

Track and Room: Track 7 - N/A


Title: SSIS - A Beginning Framework

Abstract: Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package.

In response to previous comments, the majority of the material will be presented via demos.

Speaker(s):

  • Eric Wisdahl

Track and Room: Track 1 - N/A


Title: SSIS and Slowly Changing Dimensions

Abstract: What are SCDs? How do I manage them? SSIS Provides an SCD Wizard which can make your life easier. It also has problems which we’ll show you how to work around.

Speaker(s):

  • Christian Loris

Track and Room: Track 1 - N/A


Title: Policy-Based Management 101

Abstract: We will be learning an overview of this powerful new feature in SQL 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

Speaker(s):

  • Jorge Segarra

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

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Jason Strate

Contact: http://feeds2.feedburner.com/StrateSql

Jason Strate, Digineer Inc, is a database architect and administrator with over 12 years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with MN PASS chapter and is currently serving as the Program Director. Jason enjoys speaking and has presented for SSWUG, PASSMN, and at the PASS Summit.

Scott Klein

Scott Klein is a Microsoft SQL Server MVP with a passion for all things SQL. He has authored a number of books and articles, including Professional SQL Server 2005 XML and Professional LINQ, both by Wrox. He is a frequent speaker at user groups, code camps, and SQLSaturday’s and is currently digging into SQL Azure and Visual Studio 2010 as he writes a book on the ADO.NET 4.0 Entity Framework.

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

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” .

Jonathan Kehayias

Twitter: - @SQLPoolBoy

Contact: https://www.sqlskills.com/blogs/jonathan

Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.

Kathy Malone

Kathy Malone has used Acces since version 1.0, SharePoint since the 2007 version, and was excited to hear at the SharePoint Conference in 2009 that there were 5 sessions on how the then-pending Access 2010 would integrate with SharePoint 2010. She had the opportunity to visit the Access team in Dec 2009, was active in the Office 2010 CTP/Beta, and continues to be explore how the 2 tools work together.

Scott Gleason

LinkedIn: Scott Gleason

Scott is a vice president of the Jacksonville FL SQL Users group with over 10 years experience as a database administrator, working in both Healthcare and Financial industries. He is both Energetic and animated teacher. His passion is learning new technology and sharing his Sql experiences (the good and the lessons learned) with others.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.

Vikas Hawaldar

Vikas is BI Architect at Idea Integration. He has 12 years of experience in Business Intelligence. He has spoken into several SQLSaturday sessions.

Dmitri Korotkevitch

Contact: http://www.actsoft.com

Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Management solutions. Back-end database handles around 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates.

Michael Stark

 Michael Stark has been developing software since 1992.  He has worked for both large and small companies.  He has worked in a variety of platforms and environments.  He prefers the newer technologies and enjoys learning new skills and applying them as solutions to existing processes.  He prefers client facing software development projects.  He gets personal satisfaction with build products that make business life easier for the end user.  Mr. Stark is originally from Miami, Florida and currently resides in Tampa, Florida.  In between the two he has live in Atlanta, Detroit, Deland, and Madrid Spain.

Elijah Baker

Elijah Baker is an 18 year veteran using SQL Server with the past 10 years being focused mostly on development. He has worked in all levels of SQL Server development from the JR developer up to the lead and architect positions. Currently he is working a PaySpan Inc. which processes medical payments and data. Elijah has become an expert on Partitioning to allow PaySpan’s largest database, 8TB+ 10 billion+ rows, to continue growing as needed without any significant performance degradation.

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” .

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.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Jason Strate

Contact: http://feeds2.feedburner.com/StrateSql

Jason Strate, Digineer Inc, is a database architect and administrator with over 12 years of experience. In July 2009, he was awarded Microsoft MVP (Most Valuable Professional) for SQL Server. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. He is actively involved with MN PASS chapter and is currently serving as the Program Director. Jason enjoys speaking and has presented for SSWUG, PASSMN, and at the PASS Summit.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

Brian Knight

Twitter: - @BrianKnight

Contact: http://www.bidn.com/people/brianknight

Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.

Nathan Heaivilin

Just a DBA who wants to give back to the community in the way they have given to me and helped my development over the years.

David Taylor

Contact: http://dyfhid.wordpress.com

David is an DBA/Developer for a private educational institution in New Hampshire. David has five years of experience learning and administering SQL Server and more recently developing BI solutions using SSIS. Having earned both his MCTS and MCITP DBA certifications for SQL Server 2008, he still considers himself a beginner sharing with other beginners.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

Herve Roggero

Twitter: - @hroggero

Contact: http://geekswithblogs.net/hroggero

Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.

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.

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Patrick LeBlanc

Contact: http://sqldownsouth.blogspot.com/

Patrick LeBlanc is currently a BI Consultant for Pragmatic Works. I have 9 years experience with developing and deploying database solutions. Patrick is a regular speaker at SQLSaturday, User Groups and SQL Lunches. He is also the founder of TSQLScripts.com and SQLLunch.com. Patrick is also the President of the Baton Rouge Area SQL Server User Group.

Ronald Dameron

Twitter: - @RonDBA

LinkedIn: Ronald Dameron

Contact: http://RonaldDameron.com

Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.

He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.

He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.

He is most active on Twitter as @RonDBA.

Telmo Sampaio

Great guy!

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQLSaturdays and Code Camps.

Bayer White

Contact: http://www.flowfocus.com

Bayer White has been developing enterprise solutions for the past 12 years using .Net Technologies. Since the first beta of the .Net Framework 3.0, his focus has been mastering Business Process Management (BPM) using Windows Workflow Foundation (WF). He is known within the Florida developer community by speaking at Florida Code Camps, blogging and writing articles focused on WF. He has also spoken at various conferences such as PASS, DevConnections, VSLive and MDC.

Jack Corbett

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

LinkedIn: Jack Corbett

Contact: http://www.wisemanorwiseguy.com

JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.

Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.

Jack has presented at many user groups and SQLSaturday even

Michael Ruland

Michael Ruland is director of field engineering at expressor software. Michael has more than 30 years’ IT experience, including more than a dozen focused on constructing and maintaining large, complex data warehouse and decision support structures. He has worked as a Global Technical Architect in IBM’s Advanced Technology Group, in addition to application programming, systems programming, and various sales and engineering positions with Amdahl, Informix, Prism Solutions, Ardent and Ascential.

Mark Landry

Mark Landry has over thirty years of experience in software development.

He has been an independent software consultant for fifteen years specializing in object-oriented design and programming, relational and multidimensional database design, and data warehousing. He is considered a regional expert in Analysis Services.

Mr. Landry holds Bachelors and Masters Degrees in Computer Science.

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.

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

Brian Knight

Twitter: - @BrianKnight

Contact: http://www.bidn.com/people/brianknight

Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.

Patricia (Pat) Baxter

Contact: http://www.patriciabaxter.com

Pat has served as a leader in global firms as SYKES, UNISYS, Siebel, Deloitte Touche Consulting, Citigroup, Prudential and AchieveGlobal. Her career is focused on helping to attract, develop and retain talent, believing “Without the people, it’s an empty building.” She serves on several university based boards including at the University of Tampa and USF. Pat holds a B.S., M.S., and post graduate degree, all in educational leadership and is a doctoral student in Leadership at Argosy.

Brian Knight

Twitter: - @BrianKnight

Contact: http://www.bidn.com/people/brianknight

Brian Knight, a SQL Server MVP, MCSE, and MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com, and SQLShare.com. Brian runs the local SQL Server users group in Jacksonville (JSSUG), is a contributing columnist at several technical magazines, and does regular webcasts at PragmaticWorks.com. He is the author of 15 SQL Server books and a frequent speaker at conferences such as PASS Summit, SQL Connections, TechEd, and many Code Camps.

Christian Loris

Contact: http://www.implementsivillage.net

Christian Loris is one of the group leaders from the Space Coast SQL User Group. He is a Software Engineer currently working in Data Warehousing, BI and BizTalk middleware at Harris Corporation. In the past Chris has worked as an ASP.Net developer, Engineering Manager, Professional Services Engineer, Test Engineer and a Technical Writer.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Microsoft MVP Geoff Hiten is a Principal SQL Server consultant for Intellinet.#160; Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since.#160; He specializes in high-availability and high-performance SQL systems.#160; Recent projects include: system upgrades, SQL Server platform migrations, performance tuning, custom reporting solutions, and database strategy implementations.#160;#160; Geoff is currently on the leadership team of the Atlanta area Microsoft Database Forum Use

Michael Mollenhour

Contact: http://www.bidevelopernetwork.com/blogs/MikeMollenhour

Mike is currently a Business Intelligence Architect for Pragmatic Works in Jacksonville Florida. During the past 3 years he has worked with many clients in multiple sectors to help them with High Availability, data warehousing, Integration Services, Analysis Services, Reporting Services ,SQL Server data mining, and performance tuning. Mike has spoken at several events including SQLSaturday and several Microsoft launch 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.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page