SQLSaturday #3 - Jacksonville 2008

Event Date: 05/03/2008 00:00:00

Event Location:

  • The University of North Florida Campus
  • 1 UNF Drive
  • Jacksonville, 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: Comprehansive data protection for SQL Server

Abstract: We will explore how SQL Server SAN integration is designed to deliver comprehensive SQL Server database protection, rapid recovery and high availability. We will also discuss how SAN Smart Copies easily enable parallel processing for data mining, and testing and development environments.

Speaker(s):

  • Fadi Albatal

Track and Room: Classroom 1402 - N/A


Title: XML Features in SQL 2005

Abstract: XML in SQL 2000 wasn’t very exciting and it was easy to dismiss it altogether by just relying on developers to handle any XML needed within the application. SQL 2005 changes the game and this session will show you how to use the new XML data type, do basic XML operations on XML data, and showcase the changes to FOR XML that make it so much more useful. This isn’t a session to convince you to use XML, but to show you what you can do with XML if you do need to use it!

Speaker(s):

  • Kendal Van Dyke

Track and Room: Classroom 1400 - N/A


Title: SQL Server 2008 Business Intelligence

Abstract: SQL Server 2008 has taken a leap forward in BI. In this session you’ll learn about the key new features in SQL Server 2008 for the business intelligence person.

Speaker(s):

  • Darren Herbold

Track and Room: Auditorium 1202 - N/A


Title: Trigger Happy Database Security

Abstract: In this session we’ll look at the use of triggers for security and auditing. DML, DLL, and logon triggers will all be covered. We’ll look at both good and bad ways of implementing triggers as part of an overall security solution.

Speaker(s):

  • Brian Kelley

Track and Room: Classroom 1404 - N/A


Title: Performance Tuning and Query Optimization

Abstract: This session will focus on common performance problems, considerations, and solutions. Review of methods for isolating long running queries and techniques for writing better SQL. Learn how to use dynamic management views and functions in SQL Server 2005 for query tuning. Finish with explanation of parameter sniffing and different solutions.

Speaker(s):

  • Plamen Ratchev

Track and Room: Auditorium 110 - N/A


Title: Choosing indexes for performance

Abstract: Understand how the optimizer selects indexes, and how you can design accordingly.

Speaker(s):

  • Jeffrey Garbus

Track and Room: Auditorium 110 - N/A


Title: Introduction to SSIS

Abstract: In this session, Devin Knight shows you the basics of SQL Server Integration Services (SSIS) and how to use it in a real word example. He shows you how to create your first end to end SSIS package that loops through a series of files and loads them dynamically.

Speaker(s):

  • Devin Knight

Track and Room: Classroom 1406 - N/A


Title: Building a DBA Repository with SSIS and SSRS

Abstract: Based on several popular articles in SQL Server Magazine, this session will cover the specifics of deploying a centralized DBA reporting solution using the combined powers of SSIS and SSRS. This session will focus on the current solution that uses SSIS variables and data flow objects to roll through potentially hundreds of SQL Server instances. Emphasis will be on the data it gathers and how that data can be formulated into queries, views, stored procedures and ultimately a series of useful SSRS

Speaker(s):

  • Rodney Landrum

Track and Room: Classroom 1404 - N/A


Title: Introduction to the Business Data Catalog

Abstract: This session is an introduction to the Office Sharepoint Server Business Data Catalog (BDC). The session will show to expose enterprise data from SQL Server into your MOSS environment. Learn about how to create the application definition xml that Sharepoint uses to view data from SQL Server and web services.

Speaker(s):

  • David Fekke

Track and Room: Classroom 1404 - N/A


Title: ADO.NET Synchronization Services in .NET 3.5

Abstract: Explore how you can build offline smart client applications in a RAD way that synchronizes backend database with a local Microsoft SQL Server Compact Edition store using the Microsoft Synchronization Services for ADO.NET. Use the Microsoft Visual Studio Designer to help build a two-tier application and N-tier application that incrementally downloads data that can be cached on a SQL Server Compact Edition store. We can also explore how to perform bidirectional synchronization with conflict detect

Speaker(s):

  • Joe Healy

Track and Room: Classroom 1406 - N/A


Title: LINQ For SQL Server

Abstract: This session will be an introduction into how to use the .NET 3.5 Linq framework to query and modify data in SQL Server.

Speaker(s):

  • David Fekke

Track and Room: Auditorium 110 - N/A


Title: Database Impact on Application Performance

Abstract: How to approach getting to the root cause of difficult application performance problems, based on numerous case studies from actual professional services engagements by Jeff Garbus. What to do when you think it is the database…What to do when it is not the database (including convincing the disbelievers). How to move from a reactive APM methodology to a proactive APM methodology and best practices.

Speaker(s):

  • Jeffrey Garbus

Track and Room: Classroom 1400 - N/A


Title: Smokin’ Mirrors - SQL 2005 Mirroring Technology

Abstract: In this session I will demonstrate how to configure Mirroring for both high availability and offloading reporting stress via database snapshots. I will also cover the different modes of mirroring and how they may affect performance.

Speaker(s):

  • Michael Mollenhour

Track and Room: Classroom 1400 - N/A


Title: SQL 2008 Policy Based Management

Abstract: Learn how to scale your DBA efforts across your entire SQL Infrastructure and guarantee your systems work the way you want.

Speaker(s):

  • Geoff Hiten

Track and Room: Auditorium 1202 - N/A


Title: First Day/Month a DBA

Abstract: So you’re starting your first DBA job because someone was willing to take a chance on you. You have thousands of questions and don’t know who to ask. This session is for anyone looking for tips on how to get your first job, improve your skills and gain confidence as a DBA.

Speaker(s):

  • Devin Knight

Track and Room: Classroom 1404 - N/A


Title: Gain RANK in your queries with the ranking functio

Abstract: In this session, we will explore the ranking functions that were part of the new feature set added with SQL 2005. These allow the addition of a ranking column to your result sets that can be used to manipulate data sets without the need of the dreaded cursors. We will explore Row_Number, Rank, Dense_Rank and NTile along with ways that they can greatly optimize queries. We will also see the use of CTE’s while demonstrating some of their uses.

Speaker(s):

  • Pam Shaw

Track and Room: Classroom 1400 - N/A


Title: SQL 2008 Overview

Abstract: Find out what is really in the new SQL 2008 product. Learn what features are going to impact your job and your systems. Session is 50% Administrator content and 50% T-sQL Developer content.

Speaker(s):

  • Geoff Hiten

Track and Room: Auditorium 1202 - N/A


Title: FAQs from the MSDN Transact SQL Forum

Abstract: 01 Count Occurrences 01 Repalce Function with no accounting for strings that end with spaces 02 Replace Function with sensitivity for strings that end with spaces

02 Looping 01 Filter based on State List 02 Filter based on State List with Numbers Table 03 Numbers Table 04 _Numbers Function

03 Last Day of the Month 01 Last Day of the Month 02 Nth Day m of the Month 03 Calendar Table Reference Information

04 String or Numeric Part 01 Split Left Hand

Speaker(s):

  • Kent Waldrop

Track and Room: Auditorium 110 - N/A


Title: Report Viewer Control for Web and Windows

Abstract: This session will show you how to use the report viewer controls in both WinForm and Web applications, and offer some good tips for using them effectively.

Speaker(s):

  • Darren Herbold

Track and Room: Classroom 1404 - N/A


Title: Protecting Your SQL Server from Treasure Seekers

Abstract: In this presentation, we’ll look at ways of securing SQL Server and coding secure means of data access for an organization’s sensitive data. This presentation will cover all audiences, from system administrators, to database administrators, to developers. We’ll look at features common in both SQL Server 2000 and 2005 as well as some of the newer features and how to use them for SQL Server 2005.

Speaker(s):

  • Brian Kelley

Track and Room: Classroom 1406 - N/A


Title: Modeling People and Organizations

Abstract: This session will go through some common approaches and issues associated with representing people and organizations. It will include reviews of some common models (for example, X.500 based models and PIM inspired models such as VCard) and discuss the implications of current dominant scenarios, particularly social applications together with various strategies for representing and integrating this data with a relational database.

Speaker(s):

  • Patrick Thompson

Track and Room: Classroom 1402 - N/A


Title: Understanding Disk I/O Performance in SQL 2005

Abstract: Understanding Disk I/O performance can lead to improved overall SQL Server Performance. In this presentation we will look at the effects of RAID, SAN how to configure them for optimal disk performance. We will also cover how to measure the performance of I/O through perfmon and look at some simple ways to graph and manage this data so that over time we can understand the effects of I/O performance on the SQL Servers we manage.

Speaker(s):

  • Bryan Oliver

Track and Room: Auditorium 110 - N/A


Title: Finding a Job - Do’s Dont’s

Abstract: Presented by Comsys

Speaker(s):

  • Brian Knight

Track and Room: Classroom 1406 - N/A


Title: Backup and Recovery Basics

Abstract: An overview of how to plan for, implement, and monitor a sound backup and recovery strategy for your databases using SQL Server 2005. Using a simple, one server environment as an example, this session will look at the kinds of questions you should ask when creating backup and recovery plans, and how to know whether your backup and recovery plans are actually meeting the needs of your business.

Speaker(s):

  • Brian Knight

Track and Room: Classroom 1402 - N/A


Title: Tips and tricks for dynamic Reports

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: Classroom 1406 - N/A


Title: Reporting in Microsoft Dynamics GP

Abstract: How do you find the right *^%$^ table for reporting on data in Microsoft Dynamics GP? It’s a common question and yes, the table structure is a bit unusual. I’ll cover the basic structure and lots of tools you can use to figure out how get the right tables when building a Crystal, SSRS or other report using Dynamics GP data as the source.

Speaker(s):

  • Mark Polino

Track and Room: Classroom 1404 - N/A


Title: SQL Server CLR

Abstract: In this talk we will talk about all the things that the CLR can do in SQL Server (Stored Procedures, Triggers, Functions, etc.).

Speaker(s):

  • Shawn Weisfeld

Track and Room: Auditorium 1202 - N/A


Title: Introduction to SQL Reporting Services

Abstract: An overview of how to create basic reports using SQL Server Reporting Services 2005. This session will touch on how to create data sources, data sets, set report properties and use the most common features required for the basic report. The Adventure Works sample database will be used in the demonstration.

Speaker(s):

  • Brandie Tarvin

Track and Room: Auditorium 110 - N/A


Title: ASP.NET Dynamic Data Web Application

Abstract: This session will go over the new Dynamic Data Web Application available with the ASP.NET 3.5 Extensions.

Using Visual Studio 2008 we will build our model using LINQ TO SQL. Then we will see how easy it is to create a website based on our model that easily allows you to edit the data in your tables.

We’re also going to look under the hood at what type of TSQL is generated from our LINQ TO SQL class.

Speaker(s):

  • Chris Rock

Track and Room: Classroom 1406 - N/A


Title: Programming SMO for Fun and Profit!

Abstract: Managing numerous SQL Servers can be very difficult. Fortunately, Microsoft has provided a rich programmatic interface to allow DBAs to easily manage SQL Servers, databases, and objects. Using SMO objects, a code-savvy DBA can automate otherwise tedious manual tasks: you can create and monitor backups and agent jobs, stop and start services, administer users and logins, and much more, on all of your SQL installations with ease.

Speaker(s):

  • Tim Mitchell

Track and Room: Classroom 1402 - N/A


Title: Data Mining Concepts and Techniques

Abstract: Have you always thought of revealing insights from your database/data warehouse but was deterred by the lack of tools and the lack of knowledge of what techniques and algorithms to use? SSAS solves the first problem with its comprehensive suite of tools and algorithms. In this session I will cover the basic data mining concepts and techniques that may help you get your first data mining project off the ground. My focus will be on the various techniques of effective predictive modeling.

Speaker(s):

  • Sherif Elfayoumy

Track and Room: Classroom 1406 - N/A


Title: Benchmarking: The Forgotten Role of Performance

Abstract: As DBA’s in the SQL Server world become increasingly concerned with performance management of the SQL Servers, the interesting item that appears to be forgotten by most is the underlying performance characteristics of the hardware, the database and lastly the SQL Code that is been run against the server. If the hard disk system can only write at 200mb per second than the I/O issue that the DBA is confronting maybe hardware related and not the queries that are been run against the database.

Speaker(s):

  • Bryan Oliver

Track and Room: Classroom 1400 - N/A


Title: SQL Server 2008 T-SQL Enhancements

Abstract: This session will present new T-SQL enhancements in SQL Server 2008. Learn how to use MERGE, table valued parameters, new data types (Date and Time related, FILESTREAM, HIERARCHYID), table value constructors, grouping sets, new table and query hints, sparse columns, filtered indexes, delighters, and more.

Speaker(s):

  • Plamen Ratchev

Track and Room: Auditorium 1202 - N/A


Title: Building a Data Warehouse Using SQL Server 2005

Abstract: Learn the basics of data warehousing on the Microsoft platform. This will be a fun session and you’ll learn a lot.

Speaker(s):

  • Wes Dumey

Track and Room: Auditorium 1202 - N/A


Title: Mentoring Professional Development Plans

Abstract: This will be a very interactive session as we discuss professional development plans including why you should write it down, what to do when your manager doesn’t care, finding time and funding to implement your plan, and what to do when your plan doesn’t quite work out. We’ll also discuss finding a mentor and the value that a mentor can add to your career.

Speaker(s):

  • Andy Warren

Track and Room: Classroom 1400 - N/A


Title: An Introduction to Performance Point

Abstract: Microsoft Office 2007 Performance Point is the latest addition to the Microsoft BI technologies. This session gives you a practical introduction to getting started using the BI platform you have built using SQL Server Database Engine, Analysis Service and Reporting Services.

Speaker(s):

  • Trey Johnson

Track and Room: Classroom 1402 - N/A


Title: Beginning Transactional Replication

Abstract: Replication is a very useful technology that often gets ignored because it seems to be a big scary black box. Join us for a beginner level session that looks at how to set up and use transactional replication for common scenarios and how to do with the few common problems you may run into using it.

Speaker(s):

  • Andy Warren

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

Darren Herbold

Contact: http://www.pragmaticworks.com/about.htm

Darren Herbold, MCDBA, MCSE is a dedicated consultant who is passionate about delivering business value to his clients. With a Bachelors degree in Management Information Systems from Florida State and 10+ years experience in the information technology industry, he has expertise in Business Intelligence, Database Administration, and .Net Software Development. Darren’s main focus is on the SQL Server stack where he delivers training, mentoring, and develops Data Warehouse, ETL, and Reporting

Brian Kelley

Twitter: - kbriankelley

LinkedIn: Brian Kelley

Contact: https://truthsolutions.wordpress.com/

Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

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

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.

David Fekke

Contact: http://www.fekke.com/blog/

David Fekke is a software engineer and speaker based in the Jacksonville, Fl. He also owns a company that produces mobile software for smartphones and iOS devices.

Joe Healy

Contact: http://blogs.msdn.com/devfish

— Joe Healy is a Technology Evangelist for Microsoft covering North and Central Florida. He can be reached at jhealy@microsoft.com or http://blogs.msdn.com/devfish ….

Mark Polino

Contact: http://www.dynamicaccounting.net

Mark Polino is a Microsoft MVP for Dynamics GP. He is a senior consultant with 2008 Global Dynamics GP Partner of the year I.B.I.S., Inc. In his spare time he runs the very successful DynamicAccounting.net website and blog focused on Microsoft Dynamics GP and related technologies like SQL Server and Reporting Services. Mark lives in the Orlando area and drags his behind to oPASS meetings whenever he’s actually in town.

Shawn Weisfeld

Twitter: - https://twitter.com/shawnweisfeld

LinkedIn: Shawn Weisfeld

Contact: http://www.usergroup.tv

Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld

David Fekke

Contact: http://www.fekke.com/blog/

David Fekke is a software engineer and speaker based in the Jacksonville, Fl. He also owns a company that produces mobile software for smartphones and iOS devices.

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

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.

Sherif Elfayoumy

Contact: http://www.unf.edu/~selfayou

Sherif Elfayoumy, Ph.D., is an associate professor of Computer Science at the University of North Florida and a senior member of the IEEE. He has over 15 years of software development experience and has two patents, pending USPTO approval, in the area of text mining. He is a member of the program committees of several international conferences, an author of over 25 manuscripts, and an appointed reviewer for major journals by Elsevier and Kluwer.

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

Kent Waldrop

Member of the Jacksonville SQL Server Users Group. Worked with MS SQL Server, DB2 and Sybase. Active member and moderator of the MSDN SQL Server forums.

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.

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.

Chris Rock

Contact: http://www.rocksthoughts.com

Chris Rock is a developer, DBA, and trainer for End to End Training. Chris is a frequent presenter at area Code Camps and has written several articles on SQLServerCentral.com and SQLTeam.com. He also blogs about all things SQL and .Net related at http://www.rocksthoughts.com

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.

Trey Johnson

Contact: http://www.sqlserverbi.com

Trey is a long-standing member of the Microsoft Business Intelligence community and is a Jacksonville-native! He is a member of the executive leadership team for Cizer - A CALIBRE Company (http://www.cizer.com) and is their Chief Business Intelligence Architect. He is a former 6-year member of the PASS Board, has spoken at more Code-Camps and SQLSaturdays than he remembers and really has enjoyed speaking around the globe at events like Tech-Ed, PASS, SQL Connections, VS Live and SQL Live! H

Brian Knight

Brian Knight is a database and business intelligence consultant with Ironworks, an enterprise technology services firm in Richmond, Virginia. Brian is passionate about learning and teaching techniques for managing database systems that generate business value.

Fadi Albatal

In his role as Product Marketing Manager, Fadi Albatal oversees Dell Storage strategy for Microsoft environments. Albatal joined Dell-EqualLogic from KOM Networks where he held the position of Director of Business Development, managing their technology alliance program and their channel strategy. Before KOM, Fadi served as CIO at Langu-EDGE Solutions where he implemented the IT infrastructure required to differentiate it in a competitive market. Albatal holds a Masters degree in Computer Science

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.

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.

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.

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

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

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

Bryan Oliver

Bryan Oliver has over 20 years of industry experience, 11 of which were spent working primarily with SQL Server. Bryan is a lead developer at Quest Software for a number of solutions, including LiteSpeed for SQL Server. Bryan’s position allows him to work with some of the largest and most recognizable SQL database environments in the world. He is also a valued speaker at conferences such as SQL PASS and SQL Server Summit. Born and raised in Australia, Bryan graduated from RMIT University in Melb

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.

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.

Bryan Oliver

Bryan Oliver has over 20 years of industry experience, 11 of which were spent working primarily with SQL Server. Bryan is a lead developer at Quest Software for a number of solutions, including LiteSpeed for SQL Server. Bryan’s position allows him to work with some of the largest and most recognizable SQL database environments in the world. He is also a valued speaker at conferences such as SQL PASS and SQL Server Summit. Born and raised in Australia, Bryan graduated from RMIT University in Melb

Darren Herbold

Contact: http://www.pragmaticworks.com/about.htm

Darren Herbold, MCDBA, MCSE is a dedicated consultant who is passionate about delivering business value to his clients. With a Bachelors degree in Management Information Systems from Florida State and 10+ years experience in the information technology industry, he has expertise in Business Intelligence, Database Administration, and .Net Software Development. Darren’s main focus is on the SQL Server stack where he delivers training, mentoring, and develops Data Warehouse, ETL, and Reporting

Brian Kelley

Twitter: - kbriankelley

LinkedIn: Brian Kelley

Contact: https://truthsolutions.wordpress.com/

Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation

Patrick Thompson

Contact: http://www.standingwaiting.com/Resume/WebResume.htm

http://www.standingwaiting.com/Resume/WebResume.htm

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Brian Knight

Contact: http://www.pragmaticworks.com

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was recently on the Board of Directors of the Professional Association for

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page