SQLSaturday #8 - Orlando 2008
Event Date: 10/25/2008 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.
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:
- Present upgrading a real Analysis Services 2005 cube to Analysis Services 2008 (not Adenture Works)
- Show some of the new Analysis Services 2008 features
- 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
Title: Damned If You Do, Damned If You Don’t: Legal Liabi
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: