SQLSaturday #15 - Jacksonville 2009

Event Date: 05/02/2009 00:00:00

Event Location:

  • The University of North Florida Campus
  • 1 UNF Drive
  • Jacksonville, Florida

PDF of Schedule

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

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


Sessions

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


Title: 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: Room 1009 (Auditorium) - 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: Room 1009 (Auditorium) - N/A


Title: SSIS - Beginner’s Walkthrough

Abstract: This session will step the attendees through the basics of SSIS by setting up a sample solution to import data from a variety of sources. We will look at some of the more common control flow tasks as well as the various components of the data flow task. The sample solution created will be based, at least in part, on questions from the audience.

Speaker(s):

  • Eric Wisdahl

Track and Room: Room 1016 (Auditorium) - N/A


Title: IIS, ASP\ASP.NET, SQL Security HowTo

Abstract: By now we all know that we should use Windows Authentication to connect to SQL Server from our IIS applications…but most of us don’t know how. This session aims to clear up the confusion by demonstrating the ways that ASP ASP.NET applications can be configured to make secure connections from different versions of IIS so that we can keep our connections secure and our DBAs happy.

Speaker(s):

  • Kendal Van Dyke

Track and Room: Room 1026 - N/A


Title: SQL Server 2008 Fast Track Data Warehouse

Abstract: This session will provide an overview and guide to SQL Server Fast Track Data Warehouse, a new set of reference architectures created for scale-up (SMP) SQL Server based data warehouse solutions. It includes a summary of the resources available in the reference configuration, the distinguishing features of the approach, and the steps necessary to take full advantage of the new architectures.

Speaker(s):

  • Jean-Claude Armand

Track and Room: Room 1009 (Auditorium) - N/A


Title: Making your SSIS Packages Dynamic

Abstract: Learn how to use SSIS features such as Configuration Files, Configuration Tables, Parent to Child Configurations, Expressions, and Variables to make your SSIS packages Dynamic. Stop the deployment headache by creating packages that can be updated remotely and do not need to be redeployed when a change is needed. Learn how to update multiple packages with a single change.

Speaker(s):

  • Mike Davis

Track and Room: Room 1003 - N/A


Title: Identifying and Removing Duplicate Records

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

Speaker(s):

  • Michael Antonovich

Track and Room: Room 1001 - N/A


Title: Troubleshooting SQL Server

Abstract: I will present the custom stored procedure I use first whenever an event happens on my 2005 servers. Then, I will discuss the interpretation of the output and the underlying code that extracts that information.

Speaker(s):

  • Steve Schneider

Track and Room: Room 1009 (Auditorium) - N/A


Title: Using Sql To Generate Sql

Abstract: An overview of the system objects that can be utilized to create new database objects. We will investigate the catalog views and object functions with an eye towards creating utility scripts and templates to make the day-to-day work of a database developer easier.

Speaker(s):

  • Jonathon Moorman

Track and Room: Room 1001 - N/A


Title: SSIS - SQL server information

Abstract: As a DBA in a new environment you need to learn as much as you can about the SQL Servers in your enterprise. I came across an SSIS package, created by Rodney Landrum, which gave me the core of what I was looking for. This session will focus on the benefits of the SSIS package as well as provide a walkthrough of the SSIS package, which I have made several changes to support our infrastructure. The server information included is OS edition, OS service pack level, CPU, RAM, Free drive space, SQL server version, SQL service pack, etc. Session will also demonstrate how to deploy this package to an SSIS server and schedule it via SQL agent.

Speaker(s):

  • Michael Flora

Track and Room: Room 1003 - N/A


Title: LINQ for SQL

Abstract: This presentation gives developers and SQL Server professionals an overview of the Language Inline Query (LINQ) syntax in .NET 3.5 that can be used to query SQL Server databases.

Speaker(s):

  • David Fekke

Track and Room: Room 1002 - 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: Room 1026 - N/A


Title: Advanced SQL Querying Techniques

Abstract: This session will focus on analytical ranking functions in SQL Server 2005/2008 and their use, implementing paging, string concatenation with XML PATH, pivoting, unpivoting, and separating elements in a string/column.

Speaker(s):

  • Plamen Ratchev

Track and Room: Room 1016 (Auditorium) - N/A


Title: SSIS - A Beginning Framework

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

This session will present an example framework which can be used as the basis for future SSIS Package development.

Speaker(s):

  • Eric Wisdahl

Track and Room: Room 1002 - N/A


Title: Introduction to SQL Server Reporting Services

Abstract: Never created a report in Reporting Services 2005? Don’t fret! In this session you will learn the basics on creating reports using SQL Server Reporting Services 2005. Topics will include the architecture of reporting services, creating a report using the wizard, creating reports from scratch, as well as deploying them to the server for general usage.

Speaker(s):

  • Brian McDonald

Track and Room: Room 1026 - N/A


Title: Things Go Wrong

Abstract: During this session Kent Waldrop will discuss some of his personal experiences with the ups and downs of an IT career. Some of the subjects covered will be watching out for never, never land; flying high; crashing; “coming back”; dealing with personal problem and trying to guard your self.

Speaker(s):

  • Kent Waldrop

Track and Room: Room 1026 - N/A


Title: The Truth About Disk Performance and Configuration

Abstract: Would you buy a million dollar race car then show up to the track on a clear day with rain tires that aren’t properly inflated and wonder why you’re only doing 180 when the manufacturer says it can do 220? Your answer was probably close to something like “Of course not!”. Now let’s suppose that your million dollar race car is really your DB server and your tires are your hard drives. Do you know the right configuration to use to get the best performance out of them? Sure, there’s RAID 1, RAID 10, and RAID 5 but do you know which combination of partition offset, RAID stripe size, and allocation unit size to use? This session will answer those questions by looking at the results of extensive testing performed against local disks and DASD encl

Speaker(s):

  • Kendal Van Dyke

Track and Room: Room 1001 - N/A


Title: Save Time and Merge It

Abstract: The SQL Server 2008 MERGE command combines the features of the Insert and Update commands into a single powerful statement. You can now insert new data into one table while also update or delete data from an existing table with a single statement. In this session, we will take a look at this new addition to your TSQL toolbox in SQL Server 2008 to show how to merge two tables without creating duplicate records, how to synchronize two tables, how to use the OUTPUT clause with MERGE to save deleted records from the merge into an archival table, how indexing effects performance of MERGE statements and more.

Speaker(s):

  • Michael Antonovich

Track and Room: Room 1009 (Auditorium) - N/A


Title: Introduction to query optimization

Abstract: This session will cover the basics of writing optimized query’s with focus on the ‘where clause’ and ‘having clause’ of a select statement. If you have never attended a query performance session before, you’ll learn a lot!

Speaker(s):

  • Scott Gleason

Track and Room: Room 1001 - N/A


Title: SQL ServerBeyond S Roadmap 2008

Abstract: This session will cover SQL Server 2008 adoption momentum in addition to the scheduled 2 SQL Server release that are currently schedule to be release during the next 36 months. As part of this session we will discuss in details of the upcoming release of SQL Server Kilimanjaro release and schedule around SQL11.

Speaker(s):

  • Jean-Claude Armand

Track and Room: Room 1009 (Auditorium) - N/A


Title: Upgrading DTS to SSIS

Abstract: See the methods available to convert DTS to SSIS. Get an understanding how to convert Active X scripts in your DTS packages to SSIS packages. Watch a demonstration of the software available to discover your packages, convert them, and apply best practices. Learn how to scope out your DTS conversion project.

Speaker(s):

  • Mike Davis

Track and Room: Room 1003 - N/A


Title: On Demand Report Subscriptions

Abstract: This session will explore subscriptions which are the scheduled delivery process defined within Reporting Services. We will explore what is required to create subscriptions, what options are available and how we can manipulate these for use on demand. We will review some practical applications that would require use of on demand subscriptions.

Speaker(s):

  • Pam Shaw

Track and Room: Room 1026 - N/A


Title: What is new for Data Mining in SQL 2008

Abstract: The presenter will describe basic building blocks of Data Mining process. These building blocks will be mapped on to the features available in SQL 2005 and then shortcoming on SQL 2005 will be discussion. After that the new features in SQL 2008 Data Mining will be demoed to present how the Shortcoming in 2005 were improved in 2008 and what new power in added in 2008 data mining.

Speaker(s):

  • Vikas Hawaldar

Track and Room: Room 1002 - N/A


Title: SQL Server Statistics

Abstract: Why does SQL Server need statistics? How and when are they created and maintained? How do you know when they are incorrect or out of date? How much difference do they make in query plans? We’ll answer all of those questions and more! You’ll leave the session with a firm understanding of the working of statistics and what you need to know to keep them in great condition.

Speaker(s):

  • Andy Warren

Track and Room: Room 1001 - 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: Room 1016 (Auditorium) - N/A


Title: Building a Data Warehouse using SQL Server 2008

Abstract: We will use SQL Server 2008 and the SSIS tool suite to demonstrate building a data warehouse. This session will cover the basics of a data warehouse before leading into the code demonstration.

Speaker(s):

  • Wes Dumey

Track and Room: Room 1002 - N/A


Title: Lunch (served outside)

Abstract: Lunch served outside

Speaker(s):

  • Brian Knight

Track and Room: Room 1016 (Auditorium) - N/A


Title: RESTful Data

Abstract: REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE.

This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.

Speaker(s):

  • Chris Eargle

Track and Room: Room 1002 - N/A


Title: Tips Tricks for dynamic Reporting Services Repor

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

Speaker(s):

  • Pam Shaw

Track and Room: Room 1016 (Auditorium) - 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: Room 1016 (Auditorium) - N/A


Title: Advanced SSAS development using MDX

Abstract: Speaker will present basic concepts behind MDX. Then a demonstration will be given on basic to intermediate MDX queries. At the end some examples will be presented about developing calculated measures in SSAS using MDX.

Speaker(s):

  • Vikas Hawaldar

Track and Room: Room 1002 - N/A


Title: SQLServer 2008 and Geography

Abstract: Demonstration of using the new Geography datatype in SQLServer 2008. The implementation will showcase in Virtual Earth and .net 3.5 Listview.

Speaker(s):

  • Michael Stark

Track and Room: Room 1026 - N/A


Title: Disaster Recovery: Preparing for the Storm

Abstract: A non-technical discussion on the methods a business should use to prepare for the inevitable disaster. This discussion includes things you can do to prevent disasters as well as what things to have into place for when the disaster occurs. It goes beyond the usual “back up SQL Server” thoughts.

Speaker(s):

  • Brandie Tarvin

Track and Room: Room 1003 - N/A


Title: T-SQL 101 - English to T-SQL Queries

Abstract: A beginner’s level session on how to write the basic SELECT statement and the functions that can make your life either easier or harder.

Speaker(s):

  • Brandie Tarvin

Track and Room: Room 1001 - N/A


Title: What Is PASS?

Abstract: PASS is the Professional Assocation of SQL Server, and it’s the official not for profit group for SQL Server professionals. We’ll talk about the annual PASS Summit (conference), chapters/user groups, regional events like SQLSaturday, and where PASS is going in the future. This will be an informal presentation with lots of time for questions and discussion.

Speaker(s):

  • Andy Warren

Track and Room: Room 1001 - N/A


Title: Introduction to SQL Server Analysis Services(SSAS)

Abstract: Ever want to implement drag-and-drop reporting in your application and stop the rampant report queue. In this session you’ll have a gentle introduction to SQL Server Analysis Services. You’ll see how to use it to give your users their own ad-hoc reporting and have better than expected performance results.

Speaker(s):

  • Brian Knight

Track and Room: Room 1016 (Auditorium) - N/A


Title: The DBA Script 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 demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and yes even 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries.

Speaker(s):

  • Rodney Landrum

Track and Room: Room 1003 - N/A


Title: Patterns And Practices For Successful Architecture

Abstract: What are the steps for successfully architecting a solution? What makes software projects successful? Have you heard these questions before? Bayer White can show and tell you what makes software projects successful from gathering requirements to providing a stable architecture! This presentation will give you a better idea as to the processes that should be followed and artifacts that should be produced to be make a project 360 degrees successful.

Speaker(s):

  • Bayer White

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

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 McDonald

I am a recent college graduate, MCSD and MCDBA with nine years of various IT experiences. Professional - As an IT Consultant, I have come into contact with many technologies over the past nine years. I was a Desktop and Web Programmer for about 4 of those years, but now serve as a Database Administrator. Personal - When I’m not working (or tinkering), I spend most of my time with my wife and two young children with things like going to the beach, hiking and watching movies. I also like to get

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.

David Fekke

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

David Fekke is a Software Engineer for Lender Processing Services and is the manager for the JaxFusion user group.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

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

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

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

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

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

Jonathon Moorman

LinkedIn: Jonathon Moorman

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

Michael Flora

Helpdesk - 4 years Network Desktops - 2 Years DBA - 1 Year

MCP, CompTia A+ CompTia Network+

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

Jean-Claude Armand

Microsoft

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

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

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

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

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

Brandie Tarvin

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

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

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

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.

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.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

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

Wes Dumey

Contact: http://www.durableimpact.com

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

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.

Vikas Hawaldar

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

Brian Knight

Twitter: - @BrianKnight

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

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

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.

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.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

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

Steve Schneider

LinkedIn: Steve Schneider

Contact: http://sqlinsight.net/blog/

Speaker Bio: Steve Schneider is a Business Intelligence developer for the City of Jacksonville (Florida), and has been embedded in SQL for over 20 years. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. Along with his passion for SQL, he spends his time running half marathons and sailing. His current focus of interest is performance tuning, security, and cube building. He tries to maintain a constant sense of gratitude to God for the wonderful things he has been enabled to do.

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.

Jean-Claude Armand

Microsoft

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

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

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.

Bayer White

Contact: http://www.humanworkflow.net

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

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.

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.

Scott Gleason

Scott Gleason has worked in Jacksonville Florida as DBA in the medical and Fincial field for too many years to count now. He a long standing Vice President in the Jacksonville SQL Server Users Group (JSSUG).

Michael Stark

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

Vikas Hawaldar

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

Brian Knight

Twitter: - @BrianKnight

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

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

Chris Eargle

Contact: http://www.kodefuguru.com

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

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page