SQLSaturday #21 - Orlando 2009

Event Date: 10/17/2009 00:00:00

Event Location:

Seminole Community College
100 Weldon Boulevard
Orlando, Florida

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

Sessions
Speakers
Sponsors

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

Sessions

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

Title: No Better Time to Start Your Own Tech Business!

Abstract: There may never have been a better time since the start of the Internet to launch that technology business you’ve always wanted! With Microsoft having the largest product launch in its history between now and next April, plus awesome Microsoft support tools for startups, students, and partners, you have no excuse not to! Whether you are thinking part or full time, software, SaaS, S+S, consulting, hosting, or any other variation, there is something new on the horizon to help your new business take off! Come hear about the free tools Microsoft is making available, hear about “gotchas” you need to think about as you go forward, and hear about different business models. Focus is on building a business sustainably.

Speaker(s):

Kathy Malone

Track and Room: Security (J107) - N/A

Title: Introduction to SQL Server Analysis Services

Abstract: In this session, you’ll learn how to build a highly efficient analytical platform by using Analysis Services (SSAS). You’ll learn the how to create and configure a cube to pre-aggregate your data and then how to create hierarchies to make your users more effective. Lastly, Brian will cover the basic tabs that are available to you in SSAS.

Speaker(s):

Brian Knight

Track and Room: SSAS (V111A) - N/A

Title: Taking Control of SQL Server Error Logs

Abstract: The SQL Server Error Logs contain vital information for the day to day DBA. For 1 to 10 servers, reviewing the error logs can be an enlightening experience done manually. For 200+ servers it is more than a chore and automating the consolidation and analysis of the error log contents is essential to be a successful DBA. From failed login attemtps to data corruption, this session will show you how to maintain error log history, raise errors in code that will write to the error log and most importantly, centralize and report on specific errors across multiple servers. The solution will use several different technologies including SSIS and the MERGE statement, new to SQL Server 2008.

Speaker(s):

Rodney Landrum

Track and Room: Administration (V006) - N/A

Title: Introduction to MDX

Abstract: The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.

Speaker(s):

Brian Knight

Track and Room: SSAS (V111A) - N/A

Title: Database Hardening - Standardization, Optimization

Abstract: Database Hardening - Standardization, Optimization, and Automation. I will cover how I handle these issues in a very large environment that has over 500 database servers and 3600 databases. My talk will touch on my use of PowerShell, Policy Based Management, the Enterprise Policy Management Framework, and an internally development DBA utility database to manage this inventory.

Speaker(s):

Ronald Dameron

Track and Room: Performance (V003) - N/A

Title: Using the CLR to Monitor Disk Space

Abstract: In this session I will demonstrate how to use a couple of CLR Stored Procedures and the SQL Server Agent to monitor disk space in an Enterprise with several SQL Servers.

Speaker(s):

Patrick LeBlanc

Track and Room: Development 1 (J108) - N/A

Title: Cloud Computing: SQL Azure and Beyond

Abstract: Microsoft SQL Azure Database is a cloud-based relational database platform built on SQL Server technologies. With SQL Azure Database, you can easily provision and deploy relational database solutions to the cloud, and take advantage of a globally distributed data center that provides enterprise-class availability, scalability, and security with the benefits of built-in data protection, self-healing and disaster recovery. There is a huge investment going on in moving the infrastructure to the cloud. Come check out the future.at this session.

Speaker(s):

Joe Homnick

Track and Room: Design (V101) - N/A

Title: Automating Routine Maintenance

Abstract: In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.

Speaker(s):

Ken Simmons

Track and Room: Administration (V006) - N/A

Title: Introduction to SSIS Part 1

Abstract: This is part 1 of a session that will get you past the learning curve of SSIS. Devin will cover the basics of the development environment that is used to build SSIS packages. He will show how to create an end to end package that covers many of the concepts in SSIS. This session will be great for anyone who is a beginner to SSIS.

Speaker(s):

Devin Knight

Track and Room: SSIS (J105) - N/A

Title: Introduction to Execution Plan

Abstract: An introductory session on the different types of execution plans, how to generate each of them, the pro’s and cons of each of them, and how to read an execution plan.

Speaker(s):

Nathan Heaivilin

Track and Room: Security (J107) - N/A

Title: RESTful Data

Abstract: REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.

Speaker(s):

Chris Eargle

Track and Room: Development 1 (J108) - N/A

Title: Sql and the Cloud

Abstract: This talk will look at the implications of cloud computing for Sql databases. Topics covered will include: What’s in the cloud, data processing or both? Running Sql in the cloud. Sql alternatives in the cloud, SimpleDB, DIY indexing. Stuff that definitely won’t work in the cloud (not at the moment anyway). The talk will be focused mostly on the use of Amazon’s S3, SimpleDB and EC2 with a bit of Rackspace Mosso thrown in. It will demo setting up S3 buckets and EC2 instances. What’s involved in getting Sql Server running on them (including licensing implications) and discuss some of the speaker’s experience in working with the Amazon environment.

Speaker(s):

patrick thompson

Track and Room: Design (V101) - N/A

Title: Indexing for Join Optimization

Abstract: Everything you wanted to know about join optimization but were afraid to ask… Join types, indexing, and how the optimizer makes its selections

Speaker(s):

Jeffrey Garbus

Track and Room: Performance (V003) - N/A

Title: SQL 2008 DataMining

Abstract: In this session I will demonstrate datamining with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine, and show how these can be integrated with Reporting Services and Excel.This session will mainly focus on new features available for SQL 2008

Speaker(s):

Michael Mollenhour

Track and Room: SSAS (V111A) - 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: Performance (V003) - N/A

Title: SQL Server 2008 Spatial Data

Abstract: A walkthru of the Geometry and Geography Data Types in SQL Server 2008. Demonstration will include Geographic points and shapes. After discussing the features in SQL Server there will be a demonstration of using Virtual Earth to display the data from SQL Server interactively.

Speaker(s):

Michael Stark

Track and Room: Development 1 (J108) - N/A

Title: Database Design

Abstract: Based on the popular Example of Test-Driven Development series at SQL Server Central, this session focuses on Database Development as part of the Application Lifecycle Management (ALM) process. Examples demonstrate how to test, but the session focuses on the benefits of testing database scripts. T-SQL error trapping, database projects, test artifacts, and source control are also discussed.

Speaker(s):

Andy Leonard

Track and Room: Design (V101) - N/A

Title: Deep Dive in SQL Server Encryption

Abstract: This presentation will focus on SQL Server security, specifically focusing on encryption. We will first take a tour of different encryption methods including hashing and encryption then move into specific examples on how to implement encryption at different levels. Parts of this presentation will include C# code.

Speaker(s):

Herve Roggero

Track and Room: Security (J107) - N/A

Title: Dive into the Default Trace

Abstract: Beginning with SQL Server 2005 Microsoft included a Default Trace auditing many events. This trace is used by many of the reports included with SSMS and can be mined for information about who has logged into your server, who created/changed/dropped objects, and much more! Learn how to use this resource to audit and manage your SQL Servers!

Speaker(s):

Jack Corbett

Track and Room: SSRS (V107) - 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: Administration (V006) - N/A

Title: Tips Tricks for dynamic Reporting Services Repor

Abstract: This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application.

Speaker(s):

Pam Shaw

Track and Room: SSRS (V107) - N/A

Title: Database Partitioning, The Basics

Abstract: In this session I will go over what database partitioning is and what the structures are to implement it. There will be some general information on partitioning strategies.

Speaker(s):

Elijah Baker

Track and Room: Design (V101) - N/A

Title: SQL Server Resource Governor

Abstract: SQL Server 2008 introduces a new feature called the “Resource Governor”. It allows you to set limits (both minimum and maximum) on your SQL Server Instance’s use of CPU and Memory - helping to prevent runaway queries, shoring up your Service Level Agreements, and aiding in consolidating your SQL Server databases onto fewer Instances or even in Virtualization. Come hear Buck Woody, Microsoft’s “Real World DBA”, present an introduction to this feature, and show you an overview of its functionality and flow.

Speaker(s):

Buck Woody

Track and Room: Administration (V006) - N/A

Title: SQL Server 2008 - Beyond Relational

Abstract: Learn about the new features in SQL Server 2008 that support non-structured and semi-structured data. You will learn about filestreams, sparse columns, hierarchy ids, and geo spatial data and be exposed to these technologies with comprehensive demos of each as well as technical insight on when and how to use them. This session is based on a real project and how it took advantages of the new technology in SQL 2008 compared to its first version in SQL 2005.

Speaker(s):

Telmo Sampaio

Track and Room: Development 1 (J108) - N/A

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: SSRS (V107) - N/A

Title: SSIS - A Beginning Framework Part 2

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

Speaker(s):

Eric Wisdahl

Track and Room: SSIS (J105) - N/A

Title: Identifying and Removing Duplicate Records

Abstract: Perhaps you inherited a database with one or more tables having duplicate potential keys or maybe even entire duplicate records or maybe you generated a recordset from a SELECT statement that has duplicate records. In any case, you have a problem. You need to identify which tables have duplicate records or duplicate index values, isolate those records, and then delete only the duplicate records from the table. This session will focus on the functions and methods that you can use to identify and remove duplicate data from your tables

Speaker(s):

Michael Antonovich

Track and Room: Development 1 (J108) - N/A

Title: It’s All About the Requirements - MINI

Abstract: Requirements elicitation is often where success in a Business Intelligence (BI) deployment lives or dies. In this Mini session we will take a quick look at how business process driven requirements can mean the difference between standard reporting and true BI.

Speaker(s):

Bob Blaydes

Track and Room: Administration (V006) - N/A

Title: SQL 101 - MINI

Abstract: An introduction to the SQL for a beginner. The session will cover the basic DML (Data Manipulation Language) statements = INSERT, SELECT, UPDATE, and DELETE. This will be a demo driven session.

Speaker(s):

Delbert James

Track and Room: Development 1 (J108) - N/A

Title: Tuna Helper - Proven Process for Tuning SQL

Abstract: Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.

Speaker(s):

Dean Richards

Track and Room: Development 1 (J108) - N/A

Title: Backup Basics MINI

Abstract: This session will review recovery models, backup types and restore procedures.

Speaker(s):

Todd Holmes

Track and Room: Performance (V003) - N/A

Title: T-SQL - Subqueries and Joins

Abstract: Beginning T-SQL part 2. This session builds on the lessons of “English Requests to SQL Query”, teaching beginners how to filter their result sets with some of the most common T-SQL constructs.

Speaker(s):

Brandie Tarvin

Track and Room: Development 2 (V105) - N/A

Title: SSIS - A Beginning Framework Part 1

Speaker(s):

Eric Wisdahl

Track and Room: SSIS (J105) - N/A

Title: Demo of Red Gate SQL Backup (MINI)

Abstract: Thought about trying a third party backup tool but haven’t found the time? Looking for some insight from someone that has used it to see if it works as well as the advertising says it does? In this mini presentation Kendal Van Dyke will discuss installing and using SQL Backup by Red Gate. Great session to get a better look at what this product has to offer.

Speaker(s):

Kendal Van Dyke

Track and Room: Security (J107) - N/A

Title: Locking Blocking Made Simple

Abstract: A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Speaker(s):

Joe Webb

Track and Room: Performance (V003) - N/A

Title: Dynamic SSIS Packages

Abstract: Learn how to make your SSIS packages dynamic, by using Configuration Files, Configuration Tables, Parent to Child Package Relationships. You will see how to use variables and expression together in all areas of a package and understand how to update multiple packages with a single change without having to redeploy packages multiple times.

Speaker(s):

Mike Davis

Track and Room: SSIS (J105) - N/A

Title: Building a Data Warehouse using SQL Server 2008

Abstract: In this session you will learn the fundamentals of data warehousing and how to effecively design and build a data warehouse system using a real-world example. The tools of choice will be SQL Server 2008 and SQL Server Integration Services.

Speaker(s):

Wes Dumey

Track and Room: SSAS (V111A) - N/A

Title: Database change management using Team System 2008

Abstract: Ever make a bunch of changes to your database then lose track of what you’ve changed? Frustrated with trying to come up with consistent, “meaningful” test data to test your applications? Wish you could unit test your database? Ever forget to make a backup copy of your stored procedure before you made that one line change (that happens to crash the system)? Tired of feeling like you’re not part of the team? We’ll take a look at how Team System can help ease the pain of database development and change management.

Speaker(s):

Jim Blizzard

Track and Room: Development 2 (V105) - N/A

Title: T-SQL - English Requests to SQL Queries

Abstract: Beginning T-SQL, part 1. The things every DBA needs to know to translate a user request into a workable Select statement.

Speaker(s):

Brandie Tarvin

Track and Room: Development 2 (V105) - N/A

Title: Catalog Views and the Art of Template Creation

Abstract: A look at the Sql Server catalog views to understand the contents of your database. From there we’ll utilize the catalog views to generate templates that help uncover potential issues within our database. We will also use the catalog views to create useable templates and enforce local T-SQL coding standards.

Speaker(s):

Jonathon Moorman

Track and Room: Design (V101) - N/A

Title: Performance Tuning Analysis Services

Abstract: Want to find out how to decrease processing time, improve query performance and leverage the real scale of your analysis services environment? Check out this session for can’t miss tips for these topics and more !!

Speaker(s):

Adam Jorgensen

Track and Room: SSAS (V111A) - N/A

Title: Introduction To Reporting Services 2008

Abstract: Reporting Services Rocks! If you haven’t seen it yet, this is one you will not want to miss. In this session, I will introduce the audience to Reporting Services 2008. An overview of the new and improved architecture will be given. Demo’s will show how to create a report using the built in wizard and from scratch with a blank report canvas. I will also show the user how to deploy the report for general usage.

Speaker(s):

Brian McDonald

Track and Room: SSRS (V107) - N/A

Title: Celko on SQL

Abstract: This is a placeholder, final topic description coming soon!

Speaker(s):

Joe Celko

Track and Room: Performance (V003) - N/A

Title: Introduction to SQL XML

Abstract: TBA

Speaker(s):

Scott Klein

Track and Room: SSAS (V111A) - N/A

Title: PowerShell and SQL Server (More SMO)

Abstract: Learn how DBA’s and Developers can take advantage of this new .NET scripting technology - PowerShell 2.0. This is a “most” to learn IT/.NET skill. In this session will discuss the difference between using SMO and the new integrated SQLPS in assisting managing your SQL Server 2000/2005/2008. Covering SMO samples and other third-party PowerShell tool.

Speaker(s):

Maximo Trinidad

Track and Room: Development 2 (V105) - N/A

Title: Configuring SQL Access for the Web Developer

Abstract: This session will demonstrate the ways that ASP ASP.NET applications can be configured to make connections to SQL Server from different versions of IIS so that we can keep our servers secure and our DBAs happy. Session Goals:

Learn when to use SQL logins and when to use Windows Authentication
Understand the concept of impersonation
Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server
Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation

Speaker(s):

Kendal Van Dyke

Track and Room: Security (J107) - N/A

Title: Auditing User Activity 101

Abstract: Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008.

Speaker(s):

Jonathan Kehayias

Track and Room: Security (J107) - N/A

Title: Twitter and SQL: A Perfect UNION MINI

Abstract: This is a quick 15-minute presentation on how you can leverage the power of Twitter, one of the hottest social networking tools, to help you become a better SQL professional.

Speaker(s):

Jorge Segarra

Track and Room: Development 2 (V105) - N/A

Title: End to End Troubleshooting

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance.

Speaker(s):

Kevin Kline

Track and Room: Administration (V006) - N/A

Title: Encrypting SSIS Connection String - MINI

Abstract: When storing SSIS connection strings using SQL accounts in a database, how do you keep the passwords secure? One method is to encrypt the column in the table SSIS Configurations are stored in present that table to your users as a view with built-in logic to either show or obscure the password data based on their role. This session will take you through a complete solution, including code to encrypt or not based on whether a password is present.

Speaker(s):

John O’Shea

Track and Room: Design (V101) - N/A

Title: SSIS and Slowly Changing Dimensions

Abstract: An explanation of Slowly Chaning DImensions in a data model and how SSIS can help you maintain them.

Speaker(s):

Christian Loris

Track and Room: SSIS (J105) - N/A

Title: Database design of Highly Loaded OLTP systems

Abstract: The session shows some tips and tricks useful for the database design of the highly loaded OLTP systems.

Speaker(s):

Dmitri Korotkevitch

Track and Room: Design (V101) - N/A

Title: Introduction to SSIS Part 2

Abstract: This is part 2 of a session that will get you past the learning curve of SSIS. Devin will cover additional beginner level SSIS topics. You will learn the basics of using variables/expressions and different deployment techniques. This session will be great for anyone who is a beginner to SSIS.

Speaker(s):

Devin Knight

Track and Room: SSIS (J105) - N/A

Title: Performance Tuning With DMVs

Abstract: DMVs offer a wealth of information about how your SQL Server is performing, yet are often an underutilized resource. This session will offer a brief tour of the DMVs available in SQL Server 2005 2008 and show how they can be used to take performance baselines, tune indexes, analyze hardware performance, troubleshoot problems, and more.

Speaker(s):

Kendal Van Dyke

Track and Room: Performance (V003) - N/A

Title: Creating Data-Driven Subscriptions in SSRS

Abstract: Providing information to those that need it when they need it is key for many businesses. But, being able to automatically disseminate critical information in a timely fashion can be a challenge. In this session, we will discover how data-driven subscriptions in SQL Server Reporting Services can be used to effectively deliver reports to a varying list of subscribers.

Speaker(s):

Joe Webb

Track and Room: SSRS (V107) - N/A

Title: SANs and SQL Server

Abstract: Lets get down and dirty on some fundamentals and a few details of how SANs work and how we can best utilize and tune them to improve SQL Server’s IO performance and reliability.

Speaker(s):

Kevin Boles

Track and Room: Administration (V006) - N/A

Title: SQL Server PowerShell Extensions

Abstract: In this sesssion we will look at automating common DBA tasks through Powershell. An overview of the CodePlex project SQL Serer Powershell Extensions will be provided. Specific topics covered include PowerGUI, SQL Server security/permissions reporting, SSIS administration, replication and agent tasks, performing ETL with Powershell.

Speaker(s):

Chad Miller

Track and Room: Development 2 (V105) - N/A

Title: Getting started in blogging and technical speaking

Abstract: Are you thinking of starting a blog? Or are you interested in presenting at events like SQLSaturday but not sure what to do to get started? This panel style session, featuring SQL bloggers Andy Warren, Jack Corbett, and Kendal Van Dyke, will give you tips on bloging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.

Speaker(s):

Kendal Van Dyke

Track and Room: Security (J107) - N/A

Title: Wait Statistics: A Troubleshooting Methodology

Abstract: Understanding when and how SQL Server waits to continue executing can be a powerful tool for troubleshooting problems with SQL Server. In this session SQL Server MVP Jonathan Kehayias dives into how to look at and use wait statistics to determine the cause of performance problems inside of SQL Server. Learn what wait types mean, which types are signs of trouble, and how to determine the root cause of your performance problems in the shortest time possible.

Speaker(s):

Jonathan Kehayias

Track and Room: Development 2 (V105) - 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.

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.

Joe Celko

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008).

Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “SQL Explorer” in DBMS (Miller-Freeman); “Celko on SQL” in DATABASE PROGRAMMING DESIGN (Miller-Freeman); “WATCOM SQL Corner” in POWERBUILDER DEVELOPERS’ JOURNAL (SysCon); “SQL Puzzle” in BOXES ARROWS (Frank Sweet Publishing); “DBMS/Report” in SYSTEMS INTEGRATION (Cahner-Ziff); “Data Desk” in TECH SPECIALIST (RD); “Data Points” in PC TECHNIQUES (Coriolis Group); “Celko on Software” in COMPUTING (VNC Publications, UK), “SELECT * FROM Austin” (Array Publications, The Netherlands), and he was editor for the “Puzzles Problems” section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, “Celko on SQL”, on CompuServe.

Jonathon Moorman

LinkedIn: Jonathon Moorman

Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.

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.

Wes Dumey

Contact: http://www.durableimpact.com

Wes is a Senior Consultant with Durable Impact Consulting, a Florida-based data warehouse and business intelligence firm. Wes has over 10 years experience working with clients around the world, both large and small, on their business intelligence and operational needs.

Adam Jorgensen

Contact: http://www.wadamj.com

Adam Jorgensen, MBA, MCDBA has been delivering innovative SQL Server and Business Intelligence Solutions for over a decade. Adam is an active member of the Gold Coast User Group in South Florida and is a featured author on sites such as SQLServerCentral.com and JumpstartTV.com and has extensive technical and management experience in industries including automotive, manufacturing, software, education, security, and retail, among others.

Joe Webb

Twitter: - @joewebb

LinkedIn: Joe Webb

Contact: http://theserogroup.com/blog

Joe Webb is a partner for The SERO Group, a Nashville-based SQL Server consulting company. He has over 22 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, and technical and leadership training. Joe is an 8-time recipient of the Microsoft MVP Award and served on the PASS Board of Directors for 8 years, culminating his tenure as EVP of Finance.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

Todd Holmes

Contact: http://www.linkedin.com/in/toddering

Todd is a database administrator at Channel Intelligence in Celebration, Florida.

Jonathan Kehayias

Twitter: - @SQLPoolBoy

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

Brandie Tarvin

Database Administrator by day and Author by night Brandie Tarvin sails pirate-populated waters, fights evil robots in disguise and turns kingdoms into chaotic rebellious city-states all while coding ETL processes and protecting real-world data from corruption. If it weren’t for her, someone else would have the job and where would be the fun in that?

Brandie’s first computer experience was with a State-of-the-Art Commodore 64 brought home by her father, who informed her that “computers are NOT toys” and would not let her use it until she learned how to program. In late 2003, she turned her hobbies of programming, MUSHing and assisting friends with generic tech support into a full time career as a database administrator. She’s been stuck in the fabulous and bizarre world of professional IT work ever since.

Currently, Brandie is a Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQLSaturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.

Jim Blizzard

Contact: http://snowstormlife.com/blogs/bliz

Jim Blizzard is the Developer Technical Specialist for Microsoft in Florida, Alabama, and Mississippi, and is based out of Tampa, Florida. Jim worked previously for Microsoft Consulting Services in the application development space, focusing on web development, and was a Developer Evangelist for Microsoft, spreading the good news of .NET to the masses in the Pacific Northwest.

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.

Brian McDonald

Twitter: - @briankmcdonald

Contact: http://www.sqlbigeek.com

Brian K. McDonald, MCDBA, MCSD is a Business Intelligence Consultant. Brian has experience in Database Administration, SQL Server Reporting Services, SQL Server Integration Services and Analysis Services. He has worked as an Application Developer, Network Administrator and a Database Administrator throughout his 11 years in the IT industry. He even spent a year on a large Help Desk operation a long, long time ago. Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written articles for industry websites and continually strives to learn more and become a better version of himself. Brian is an active member of the Jacksonville SQL Server User’s Group and has presented at User group meetings, Code Camps, many SQLSaturdays and SQL Rally events across Florida and South Carolina.

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.

Delbert James

Sr Programmer Analyst with several years experience with SQL Server.

Kevin Kline

Contact: http://KevinEKline.com

Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.

Bob Blaydes

Bob is the Director of Research and Development for CFE Federal Credit Union in Lake Mary, Florida. Bob has over 20 years experience on both the business and technical side of the financial services industry.

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.

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.

John O’Shea

Contact: http://sqlpowershell.blogspot.com/

John O’Shea is a SQL Database Administrator with over 9 years of direct SQL experience ranging from SQL 7 to SQL 2008. He currently works for Raymond James, a diversified financial services holding company with subsidiaries engaged primarily in investment and financial planning, in addition to investment banking and asset management located in St Petersburg Florida.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

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.

Chris Eargle

Contact: http://www.kodefuguru.com

Chris Eargle is a Telerik Developer Evangelist, INETA Director, and Microsoft Most Valuable Professional – C# from Columbia, SC, USA. He has over a decade of experience designing and developing enterprise applications, and he runs the local .NET User Group: the Columbia Enterprise Developers Guild. He is a frequent guest of conferences and community events promoting best practices and new technologies. His blog, kodefuguru.com, features content to guide you in becoming a .NET Ninja!

Telmo Sampaio

Great guy!

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

Dean Richards

LinkedIn: Dean Richards

Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

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.

Joe Homnick

Twitter: - @SmokingJoe

LinkedIn: Joe Homnick

Contact: http://joeblog.homnick.com/

Joe Homnick is a Microsoft Regional Director since the start of the program over 20 years ago and is a principal owner of Homnick Systems (HSI), a Microsoft Gold Certified Partner located in Boca Raton, Florida. HSI is one of the most established Microsoft Certified Partners in the world, dating back to the beginning of the program in 1993. HSI delivers Microsoft services in the areas of system development and implementation through software consulting, development, training and mentoring.

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.

Brandie Tarvin

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

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.

Joe Webb

Twitter: - @joewebb

LinkedIn: Joe Webb

Contact: http://theserogroup.com/blog

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

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.

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

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

Jorge Segarra

Contact: http://sqlchicken.com

Jorge is an MCTS:SQL 2005 and has been a SQL DBA for over 5 years with experience with SQL 2000, 2005 and 2008. Some of his other specialties include virtualization, specifically on the VMware platform. He is currently the Database Administrator for University Community Hospital (www.universitycommunityhospital.org) in Tampa, Florida. Check out his blog at: http://sqlchicken.com

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.

Jorge Segarra

Contact: http://sqlchicken.com

Brian Knight

Twitter: - @BrianKnight

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

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.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps 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.

Buck Woody

Twitter: - BuckWoodyMSFT

LinkedIn: Buck Woody

Contact: http://buckwoody.wordpress.com/

Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.

patrick thompson

Contact: http://www.standingwaiting.com

see http://www.standingwaiting.com/Resume/Resume.html

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

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.

Michael Mollenhour

Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

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

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.

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.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

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.

Ken Simmons

Contact: http://cybersql.blogspot.com

Ken Simmons is a database administrator/developer specializing in SQL Server and .NET. He is the Author of Pro SQL Server 2008 Administration (Apress, 2009) and Pro SQL Server 2008 Mirroring (Apress, 2009). He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Eric Wisdahl

Twitter: - @EricWisdahl

LinkedIn: Eric Wisdahl

Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.

SQLSaturday #21 - Orlando 2009

Sessions

Title: No Better Time to Start Your Own Tech Business!

Title: Introduction to SQL Server Analysis Services

Title: Taking Control of SQL Server Error Logs

Title: Introduction to MDX

Title: Database Hardening - Standardization, Optimization

Title: Using the CLR to Monitor Disk Space

Title: Cloud Computing: SQL Azure and Beyond

Title: Automating Routine Maintenance

Title: Introduction to SSIS Part 1

Title: Introduction to Execution Plan

Title: RESTful Data

Title: Sql and the Cloud

Title: Indexing for Join Optimization

Title: SQL 2008 DataMining

Title: Choosing Indexes for Performance

Title: SQL Server 2008 Spatial Data

Title: Database Design

Title: Deep Dive in SQL Server Encryption

Title: Dive into the Default Trace

Title: Policy Based Management 101

Title: Tips Tricks for dynamic Reporting Services Repor

Title: Database Partitioning, The Basics

Title: SQL Server Resource Governor

Title: SQL Server 2008 - Beyond Relational

Title: Social and Not so Social Networking for the DBA

Title: SSIS - A Beginning Framework Part 2

Title: Identifying and Removing Duplicate Records

Title: It’s All About the Requirements - MINI

Title: SQL 101 - MINI

Title: Tuna Helper - Proven Process for Tuning SQL

Title: Backup Basics MINI

Title: T-SQL - Subqueries and Joins

Title: SSIS - A Beginning Framework Part 1

Title: Demo of Red Gate SQL Backup (MINI)

Title: Locking Blocking Made Simple

Title: Dynamic SSIS Packages

Title: Building a Data Warehouse using SQL Server 2008

Title: Database change management using Team System 2008

Title: T-SQL - English Requests to SQL Queries

Title: Catalog Views and the Art of Template Creation

Title: Performance Tuning Analysis Services

Title: Introduction To Reporting Services 2008

Title: Celko on SQL

Title: Introduction to SQL XML

Title: PowerShell and SQL Server (More SMO)

Title: Configuring SQL Access for the Web Developer

Title: Auditing User Activity 101

Title: Twitter and SQL: A Perfect UNION MINI

Title: End to End Troubleshooting

Title: Encrypting SSIS Connection String - MINI

Title: SSIS and Slowly Changing Dimensions

Title: Database design of Highly Loaded OLTP systems

Title: Introduction to SSIS Part 2

Title: Performance Tuning With DMVs

Title: Creating Data-Driven Subscriptions in SSRS

Title: SANs and SQL Server

Title: SQL Server PowerShell Extensions

Title: Getting started in blogging and technical speaking

Title: Wait Statistics: A Troubleshooting Methodology

Speakers

Sponsors