SQLSaturday #8 - Orlando 2008

Event Date: 10/25/2008 00:00:00

Event Location:

  • Seminole Community College
  • 100 Weldon Boulevard
  • Orlando, 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: Report Viewer Controls in Reporting Services 2008

Abstract: Learn how to create a web-based reporting dashboard in Reporting Services 2008. This session will show you how to use the 2008 Report Viewer controls inside an ASP.NET page while also demonstrating the use of parameters supplied through the client interface. Examples ASP.NET and C#.

Speaker(s):

  • Darren Herbold

Track and Room: Reporting Services - N/A


Title: Server Monitoring made Simple with SQL 2008

Abstract: SQL 2008 introduces a number of new features to help monitor and diagnose problems with SQL Servers. This session will cover the use of Extended Events and the Performance Data Collectors to monitor and troubleshoot common problems with SQL Server, while having a minimal impact on the Server itself.

Speaker(s):

  • Jonathan Kehayias

Track and Room: General DBA - N/A


Title: Advanced SQL Server 2005 Reporting Services

Abstract: In this presentation I would present some of the more arcane aspects of SSRS including advanced charting, using custom code in reports, subreports and navigation internally and externally in Reporting services. I have been a trainer in the past and I’ve found it best that when I’ve made presentations my usual rule is to not allow any questions during the presentation, this avoids “presentation hi-jacking” by some attendees. I aim at having at least the last quarter hour for questions. I aim for above all an instructional and entertaining time.

Speaker(s):

  • Neil Marchadie

Track and Room: Reporting Services - N/A


Title: DBA Repository, 2008 SSRS Overlay and Gantt Chart

Abstract: This idea delivers a series of SSRS 2008 reports added to the DBA Repository. One is a working Gantt chart for reporting on SQL Server Agent schedules. I like to call this an “overlay” report, like the old days of the overhead projector where transparencies could be combined in chart form to show time-differentiated values or conicidence. This is vital to a DBA so that he or she can see when jobs overlap on all servers that may cause contention for resources. This is ideal for creating the best-fit schedule for existing jobs or answering scheduling decisions with future jobs. The presentation will cover the follow technologies specific to the popular DBA Repository: SSIS (2008), Reporting Services (2008), and new gauge and range style repor

Speaker(s):

  • Rodney Landrum

Track and Room: Reporting Services - N/A


Title: Transact SQL Frequently Asked Questions

Abstract: MVP Kent Waldrop takes a quick tour of a few of the SQL issues that come up frequently in the MSDN Transact SQL forum. Some of the topics covered include set oriented processing, pitfalls of user defined functions, working with string lists, filtering by date and time and more.

Speaker(s):

  • Kent Waldrop

Track and Room: Sharepoint - N/A


Title: Virtualizing SQL Server

Abstract: Virtualization is a hot topic these days, and SQL Server is often considered for virtualization. This session will cover the various technologies available for virtualizing SQL Server, how to determine whether or not a SQL Server is a canidate for virtualization, as well as alternatives to virtualizing SQL for Disaster Recovery scenarios.

Speaker(s):

  • Jonathan Kehayias

Track and Room: General DBA - N/A


Title: Creating and Publishing InfoPath Forms

Abstract: this session will take a quick overview of how to create a typical user form using InfoPath for deployment in SharePoint so that it displays in the user’s web browser. It will also take a look at creating reusable controls for your InfoPath forms and how you can use data from a SharePoint list to display in a browser-based report.

Speaker(s):

  • Michael Antonovich

Track and Room: Sharepoint - N/A


Title: Intro to SQL Server 2008 Full Text Searching

Abstract: Microsoft SQL Server 2008 contains the functionality you need to issue full-text queries against plain character-based data in SQL Server tables. Full-text queries could include words and phrases or multiple forms of a word or phrase.Come learn how to setup your own full text searches in your applications. Give your users search capabilities into their data. It’s as easy as 1-2-3!

In this session, the attendees will learn not only how to use the standard full text search functionality, but how to customize the built in list of “noise words”, to be able to add and remove words that should or should not be ignored. In addition attendees will also learn how to customize the thesaurus for their own needs. DBAs will also find helpful queries

Speaker(s):

  • Robert Cain

Track and Room: General DBA II - N/A


Title: Upgrading Analysis Services 2005 to 2008

Abstract:

  1. Present upgrading a real Analysis Services 2005 cube to Analysis Services 2008 (not Adenture Works)
  2. Show some of the new Analysis Services 2008 features
  3. Demonstrate a few performance improvement examples side by side (most likely MDX queries using Mosha’s MDX Studio to walk through the details of specific improvements.

Speaker(s):

  • Jen Underwood

Track and Room: Business Intelligence - N/A


Title: What Greeen and Sustainability Mean to SQL

Abstract: Professionals, and Why You Should Care.

SQL Professionals have the opportunity to be in the front lines in the Green and Sustainability effort.

“Green and Sustainability” encompasses more than just energy conservation, although on that front the new tools in SQL Server 2008 are huge contributors to the Green effort to reduce bits sent across the pipe.

When you add keystroke saving and time saving to the Green and Sustainability effort, SQL Server 2008 can contribute significant metrics to the war on bits (can you say SSIS and SSRS)!

Come to this interactive session to brainstorm with other interested people, hear how Green starts with how you do what you do (Be Green); hear about the opportunities associated with green (Build Gr

Speaker(s):

  • Kathy Malone

Track and Room: SQL 2008 - N/A


Title: Understanding Indexes for Single-Table Queries

Abstract: This session describes everything you ever wanted to know about physical index structures, as well as how the optimizer chooses indexes for performance. (Join performance in separate session!)

Speaker(s):

  • Jeffrey Garbus

Track and Room: Performance - 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: SQL 2008 - N/A


Title: ASP.NET Databinding 101

Abstract: This session will show the attendee how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data.

Speaker(s):

  • Chris Rock

Track and Room: SQL Developers - N/A


Title: SQL Server 2008: The Need for Speed!

Abstract: SQL Server 2008 is FAST! This session looks at how the increase in performance in this latest release is reason enough for an upgrade. On the database engine front there are features such as resource governors, filtered indexes, read ahead scan caching, improved parallelism, native data compression support, sparse column support and non-relational data types. Pulling it all together is the new Performance Studio, which is an integrated framework that you can use to collect, analyze, troubleshoot

Speaker(s):

  • Joe Homnick

Track and Room: SQL Developers - 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/2008 for query tuning. Finish with explanation of parameter sniffing and different solutions.

Speaker(s):

  • Plamen Ratchev

Track and Room: Performance - N/A


Title: Optimizing SSIS PackagesUsing Sql Server 2008

Abstract: In this session, Ryan will be giving some tips on how to better optimize your 2008 SSIS packages. Specifically looking at the data flow task, the demonstration will take a look at how an existing package performs which contains common and not so common mistakes. Then starting with the source, we will take a look on how to improve the performance of the package by editing some of the properties of each component (such as the new and improved lookup in 2008) contained in the data flow.

Speaker(s):

  • Ryan Fonnett

Track and Room: General DBA II - 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: Business Intelligence - N/A


Title: Why DBAs Should Learn PowerShell

Abstract: I will detail my reasoning why a DBA would benefit from learning PowerShell.
I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.

Speaker(s):

  • Ronald Dameron

Track and Room: General DBA II - N/A


Title: Using Excel Services with SharePoint

Abstract: This session will look at publishing Excel spreadsheets to the web using SharePoint and Excel Services. It will show how to view the Excel spreadsheet in a web browser and how to publish portions of the spreadsheet in a web part on a standard web page. It will look into creating parameterized views of the data as well as how to use data connections from other data sources such as SQL Server to provide a data source for the worksheet content.

Speaker(s):

  • Michael Antonovich

Track and Room: Sharepoint - N/A


Title: Tips and Tricks for Reporting Services

Abstract: This session will show methods to make your reports both easier to create and more flexible. We will cover data driven layouts and formatting. We will see how templates make it easier to have more consistent report formats and how to setup data sources that are more portable. We will review emailing reports and how this can be integrated into your current application.

Speaker(s):

  • Pam Shaw

Track and Room: Reporting Services - N/A


Title: Getting Started with SQL Server Profiler 2005

Abstract: Learn how to use SQL Server Profiler to troubleshoot, audit, and tune your SQL Server. Includes creating custom templates, integrating with Performance Monitor data, and creating scripts for creating server-side traces.

Speaker(s):

  • Jack Corbett

Track and Room: Performance - N/A


Title: Database development 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: SQL 2008 - N/A


Title: Introduction to Reporting Services 2008

Abstract: This session gives an introduction to Reporting Services while focusing on the features that are new in 2008. It will demo the new report designer layout and how to use the Report Builder 2.0. We will also cover the tablix and newly added Dundas visualizations.

Speaker(s):

  • Devin Knight

Track and Room: Reporting Services - N/A


Title: Building a Polished Cube

Abstract: In this session we will explore the steps needed to create a user friendly cube. This will cover the analysis process, a very brief overview of the data mart processes and finally the cube itself. Within the cube we will focus on steps that will ensure a better experience for the user.

Speaker(s):

  • Pam Shaw

Track and Room: Business Intelligence - N/A


Title: The Modern Resume - Building Your Brand

Abstract: Steve Jones will lead a discussion of how to develop a living resume using the Internet. Branding, polish, and presentation are becoming more and more important as each of us increases our online footprint. Drawing from his experience, Steve will talk about a variety of techniques that have helped and hurt IT professionals looking for employment.

Speaker(s):

  • Steve Jones

Track and Room: General DBA II - N/A


Title: indexes and join performance

Abstract: The sequel to “understanding single-table index optimization,” you will learn all about SQL Server joins, and how they are optimized.

Speaker(s):

  • Jeffrey Garbus

Track and Room: Performance - N/A


Title: Transactional Replication Deep Dive

Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication but most DBAs don’t look under the covers once they’re done walking through the setup wizards. In this session we’ll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.

Speaker(s):

  • Kendal Van Dyke

Track and Room: General DBA II - N/A


Title: T-SQL Enhancements in SQL Server 2008

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

Speaker(s):

  • Plamen Ratchev

Track and Room: SQL 2008 - N/A


Title: SSIS Configurations, Expressions and Constraints

Abstract: This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.

Speaker(s):

  • Eric Wisdahl

Track and Room: Business Intelligence - 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 across SQL Server 2000/2005/2008 as well as some of the newer features and how to use them for SQL Server 2005 and 2008.

Speaker(s):

  • Brian Kelley

Track and Room: SQL 2008 - N/A


Title: SQL Server 2008 SSRS Changes

Abstract: This presentation would be aimed at current users of SQL Server 2005 SSRS focusing on the improvements and differnces in the latest iteration of SSRS. Substantial changes in the BIDS layout would be covered along with the new enhancements in SSRS 2008. I have been a trainer in the past and I’ve found it best that when I’ve made presentations my usual rule is to not allow any questions during the presentation, this avoids “presentation hi-jacking” by some attendees. I aim at having at least the last quarter hour for questions. I aim for above all an instructional and entertaining time.

Speaker(s):

  • Neil Marchadie

Track and Room: Reporting Services - N/A


Title: The SQL DBA Green Thumb

Abstract: This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrate how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation and performance. All queries, which are SQL 2000 and 2005 trie

Speaker(s):

  • Rodney Landrum

Track and Room: General DBA - N/A


Title: Test Data Generation Practices

Abstract: Adding test data into your database can be a time-consuming, boring exercise - but you need valid data scenarios, a range of inputs, and the ability to easily generate large volumes of test data rapidly. With Visual Studio 2008 Database Edition (“Data Dude”) find out how you can leverage the powerful tools available to fine-tune your test data, and rapidly generate the data you need to fully test your apps!

Speaker(s):

  • Ryan Dorrell

Track and Room: SQL Developers - N/A


Title: Using LINQ to SQL in Your Applications

Abstract: LINQ (Language Integrated Query) is a powerful new technology built into the Microsoft.NET 3.5 platform that allows developers to query object graphs (including DataSets, XML and SQL Server databases) with a familiar and easy-to-use query syntax right from their application code. Learn how to setup a LINQ project, retrieve strongly-typed object graphs from SQL Server (including child relationships and object dependencies) and bind this data to an ASP.Net webpage, a Windows Form or a Silverlight/WPF application.

Speaker(s):

  • Brandon Kelly

Track and Room: SQL Developers - N/A


Abstract: You may be liable for the data you keep. You will be liable for the data you destroy. We will discuss the brave new world of e-discovery, liability, and effective database and data retention policies. In addition, you will receive practical guidance on protecting yourself and your company from legal liability and your data from theft and inadvertent disclosure.

Speaker(s):

  • Suzanne Meehle

Track and Room: SQL 2008 - N/A


Title: SQL Compact Data Sync

Abstract: Intro to SQL Compact and Data Sync services. In this presentation we go over benefits of SQL Compact not only on a mobile device, but as an amazing alternative to locally cached data for occasionally connected devices like laptops. We will also go over Sync Services for SQL Compact.

Speaker(s):

  • Nikita Polyakov

Track and Room: Performance - N/A


Title: Slowly Changing Dimensions

Abstract: Nearly every Data Warehouse, Data Mart, or OLAP Cube is challenged by changes over time. How do you report on a store that was in a different territory last year? What do you do when a product changes categories?

This session will show you how to design SQL Tables and Analysis Services dimensions that will accurately model changes over time.

Speaker(s):

  • Robert Hatton

Track and Room: Business Intelligence - N/A


Title: Getting With it With With (and Over On It, Too)

Abstract: While CTEs and Analytic functions were new features in SS2005, this talk will rather focus on the utility of these features focusing on uses gleaned from the speaker’s experience. We will cover performance enhancements, clarity of code, and problems to which the recursive capabilities of WITH can be applied as well as some ways to apply analytic functions to better performance.

Speaker(s):

  • Terry Bomberger

Track and Room: General DBA II - N/A


Title: Disaster Recovery: Preparing for the Storm

Abstract: A presentation on preparing ahead of time for the ultimate loss of data due to hurricanes, floods, fires, theft or even server crashes. This session will cover various options for protecting your databases and the pros cons of each.

Speaker(s):

  • Brandie Tarvin

Track and Room: General DBA - N/A


Title: The Nitty Gritty of Database Backups

Abstract: A beginner level session on the available types of SQL database backups and how their choices affect your database recovery. This focuses on how to implement backups and how to come to a decision on which backup / recovery policy is best for your workplace.

Note: This session is not the same as Disaster Recovery - Preparing for the Storm

Speaker(s):

  • Brandie Tarvin

Track and Room: General DBA - N/A


Title: Databinding in Silverlight 2

Abstract: We will talk about the different databinding modes and how to validate data. In this demo we will create a wcf service to send data to a silverlight app. We will bind this data to controls and a datagrid

Speaker(s):

  • Kenneth Tucker

Track and Room: SQL Developers - N/A


Title: Data Scrambling

Abstract: Data Scrambling is aimed to assist DBA-s to represent schema, data volume and characteristics of data without divulging PII and other real data. Data scrambling provides a realistic data environment for demonstration, training or testing purposes. This presentation will give an understanding of the levels, problems and possible solutions of Data Scrambling, together with a practical demonstration.

Speaker(s):

  • Andreas Etelkozi

Track and Room: SQL Developers - N/A


Title: Building a Data Warehouse using SQL Server 2008

Abstract: Intersested in learning about data warehousing? SQL Server 2008? Come to this session and learn about both. We will specifically look at the new features for data warehousing with SQL Server 2008.

Speaker(s):

  • Wes Dumey

Track and Room: Business Intelligence - N/A


Title: SQL Server Statistics

Abstract: This is a beginner to intermediate level session that will show you how and why statistics are created, how the impact query plans, how to maintain statistics, and what to do when statistics works against you due to uneven data distribution.

Speaker(s):

  • Andy Warren

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

Nikita Polyakov

Contact: http://www.campuskoder.net

Nikita has been speaking on SQL Compact and WindowsMobile at code camps. ASP.NET MVP.

Chris Rock

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.

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.

Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Mike Antonovich is the Asst Director Web Services for OCPS in Orlando, FL where he manages the SharePoint portal team. He is also responsible for multiple .Net custom applications used throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User’s Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007. He recently spoke at the PASS Summit in November 2012 on PowerPivot.

Andreas Etelkozi

I am an active SQL DBA at a public company in St.Pete, and MCT with considerable experience in the field.

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

Jonathan Kehayias

Jonathan Kehayias is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he was hired as the SQL Database Administrator for OSI Restaurant Partners, parent company of Outback, Carrabbas, and Bonefish Grill. He has experience in upgrading and consolidating SQL environments, in some cases reducing the number of servers by two-thir

Neil Marchadie

Neil has spent many long years in IT (over 25, but who’s counting) starting in the days of Hollerith cards, ask your parents about “Do Not Fold, Spindle or Mutilate”. He has worked as a developer at Helmsley-Spear and Maidenform in New York and in Jacksonville worked for CPI/Alltel, Blue Cross, Homeside Lending (now WAMU), Merrill Lynch and ADT. He has worked on all level and “flavors” of IT including Mainframes, Windows and Unix and is currently doing SSRS engineering at Red Rocket Solutions,

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.

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.

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

Brandon Kelly

Contact: http://blogs.estatic.org/users/avatar.aspx?userid=2102

Mr. Kelly is a technical professional with over 10 years experience in developing and leading teams that write “killer apps”. Mr. Kelly owned and operated a private micro-consultancy (estatic.org / BusinessRx) for over 4 years, where he built a technical platform that allowed software developers around the world to create high-impact web applications with ease. In January, 2008 Mr. Kelly re-joined his colleagues at Tribridge. Tribridge’s success in the Microsoft consulting industry is represente

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

Robert Cain

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

LinkedIn: Robert Cain

Contact: http://arcanecode.com

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

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

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.

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.impactanalytix.com/

Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

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

Kenneth Tucker

Contact: http://www.vb-tips.com

Ken is the President of the Space Coast .Net User Group and a frequent speaker at Florida Code Camps. Ken is also a Microsoft MVP in Visual Basic.

Pam Shaw

Pam has been a developer for over 25 years. For the last 20 years she has been developing for software vendors. For the last 5 years she has been actively involved with SQL Server. She has bee the President of the Tampa Bay SQL Server Group for the past year.

Suzanne Meehle

Contact: http://www.shuffieldlowman.com/meehle.htm

Suzanne D. Meehle is an attorney with the law Ffirm of ShuffieldLowman in Orlando, Florida. Prior to her legal career, Suzanne worked for over ten years as a SQL Server database administrator and systems engineer for software and heath care IT firms such as International Presence, Interactive Media Corporation, Avio Systems, Shared Medical Systems, Electronic Healthcare Systems, and VeArd Computer Research. Her practice includes both transactional and litigation aspects of intellectual property

Neil Marchadie

Neil has spent many long years in IT (over 25, but who’s counting) starting in the days of Hollerith cards, ask your parents about “Do Not Fold, Spindle or Mutilate”. He has worked as a developer at Helmsley-Spear and Maidenform in New York and in Jacksonville worked for CPI/Alltel, Blue Cross, Homeside Lending (now WAMU), Merrill Lynch and ADT. He has worked on all level and “flavors” of IT including Mainframes, Windows and Unix and is currently doing SSRS engineering at Red Rocket Solutions,

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

Wes Dumey

Contact: http://www.durableimpact.com

Wes Dumey is a Senior Consultant for Durable Impact Systems, a Florida-based provider of business intelligence solutions. Wes has experience working with many Fortune 500 clients. Wes grew up in Missouri and is a Cheif’s fan, even when it’s difficult to be one. He enjoys flying airplanes and traveling helping executives solve business issues through the use of business intelligence.

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.

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.

Patrick Thompson

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

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

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.

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.

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

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.

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.

Ryan Fonnett

My name is Ryan Fonnett, and I work for an international company as a senior consultant called Sogeti, which is a subsidiary of Capgemini. I have been with the company for a little over a year and a half. The technologies that I have a great deal of experience working with are developing web, windows, and services custom apps using the .NET 1.1 to 3.5 frameworks, SSIS, Oracle (9i to 11g), and SQL Server (2000 to 2008). Currently, I am working with a client on an ETL project that will be extracti

Ryan Dorrell

Contact: http://www.agilethought.com

Ryan Dorrell is the CTO of AgileThought, a software development services provider headquartered in Tampa, FL. Ryan has been involved in enterprise software development for over a dozen years with both .NET and J2EE. Passionate about building great software, he is deeply involved in helping clients leverage the power of Microsoft Visual Studio Team System and Team Foundation Server.

Kent Waldrop

I have worked with MS SQL Server going back to version 6.0. Before that I worked with Sybase for about 5 years. I’ve written thousands of stored procedures, functions and triggers and a few hundred DTS packages. I have about 3000 posts on Microsoft’s SQL Server MSDN forums – most of these posts related to transact SQL. I received MVP awards in 2008 and 2009. I like snorkeling, swimming, bicycling, ice skating and bringing out the best of people.

Jonathan Kehayias

Jonathan Kehayias is a MCITP Database Administrator and Developer, who got started in SQL Server in 2004 as a database developer and report writer in the natural gas industry. After spending two and a half years working in TSQL, in late 2006, he was hired as the SQL Database Administrator for OSI Restaurant Partners, parent company of Outback, Carrabbas, and Bonefish Grill. He has experience in upgrading and consolidating SQL environments, in some cases reducing the number of servers by two-thir

Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Mike Antonovich is the Asst Director Web Services for OCPS in Orlando, FL where he manages the SharePoint portal team. He is also responsible for multiple .Net custom applications used throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User’s Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007. He recently spoke at the PASS Summit in November 2012 on PowerPivot.

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.

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.

Robert Hatton

LinkedIn: Robert Hatton

Contact: http://www.RobertJHatton.com

Rob Hatton is the author of the Business Intelligence Team Handbook.

Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.

Terry Bomberger

A long time ago (1982) in a place far away (Summit, NJ), Mr. Bomberger was a Facility Engineer in dire need of a CMMS for a pharmaceutical site. A database consultant was hired, a career change was made, and the rest is history. As a consultant, Mr. Bomberger has worked extensively in a wide range of technologies, roles, business application areas, and industries with a focus on databases. He is currently employed as an Architect by Tallan, Inc.

Steve Jones

Twitter: - way0utwest

LinkedIn: Steve Jones

Contact: http://www.voiceofthedba.com/

Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page