SQLSaturday #14 - Pensacola 2009

Event Date: 06/06/2009 00:00:00

Event Location:

  • Pensacola Junior College, Main Campus
  • 1000 College Blvd, Pensacola
  • Pensacola, 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: Database Design Fundamentals

Abstract: Before you get immersed in all the technical details of SQL Server, let’s talk about the fundamentals. What does it mean to normalize a database? How do I pick a natural primary key vs. a sequence? What about naming tables, views, columns, etc? We will use the “chalk talk” format. I will introduce a topic then ask the class to share their ideas and experiences with the topic. We will have plenty of fundamentals to cover, so I will serve as moderator to keep us on track. Quoting cycling great Greg LeMond - “Perhaps the single most important element in mastering the techniques and tactics of racing is experience. But once you have the fundamentals, acquiring the experience is a matter of time.”

Speaker(s):

  • Keith Rowe

Track and Room: Room 2172 - N/A


Title: SQL Server Preproduction Tasks

Abstract: This session will cover the tasks you need to perform before you hand over a new SQL Server to production in order to keep the server running smoothly. After this session, you should be able to create a script that best suits your organization in order to make moving a server into production a quick and easy process. While the session is geared towards new systems, many of these preproduction considerations apply to existing SQL Servers as well.

Speaker(s):

  • Ken Simmons

Track and Room: Room 2172 - N/A


Title: Streaming Applications using SQL Server 2008 Files

Abstract: SQL Server 2008 introduced the concept of the FILESTREAM support. Most DBAs whom have been around for a while have in one instance or another supported streaming applications by use of the VARBINARY(MAX) datatype in order to store file information within the database architecture. However, this has drastic limitations as the RDBMS are not typically set up to deal with data that is not accessible in terms of pages and extents. FILESTREAM support adds a new paradigm to the database platform by marrying the database system with the NTFS filesystem in order to overcome these old obstacles. In this session, we will delve into FILESTREAM support, what it takes to implement, and some of the extremely cool things that you can do with this new power

Speaker(s):

  • Arie Jones

Track and Room: Room 2175 - N/A


Title: BI (Business Intelligence) For the .Net Guy

Abstract: You have heard the buzz around Business Intelligence and SQL Server Analysis Services 2008, but you’re a .Net developer and are wondering how to add BI to your .Net applications without having to use Reporting Services, well this is the session for you. We will give you a short introduction to SSAS, show you how to build a data access framework on top of the ADOMD.Net provider to gain access to your SQL Server OLAP Cubes, develop parameterized MDX Queries, and expose the query results via WCF and ASP.Net.

Speaker(s):

  • Don Demsak

Track and Room: Room 2169 - 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 2172 - N/A


Title: Best Practices and Performance Tuning SSIS

Abstract: In this session you will learn some of the most common mistakes in SSIS that can cause performance issues. Then Devin will discuss some best practices that you can take back and use in packages you develop.

Speaker(s):

  • Devin Knight

Track and Room: Room 2175 - N/A


Title: * It’s All About The Tools - TV Show Episode 3

Abstract: Did you ever feel inundated with developer tools? Did you ever feel you’re missing something that could make your life easier as a developer and a power user? There are so many tools available to choose from and it keeps getting tougher to keep up with them. Tool familiarity continues to be one of the top developer challenges. This series of seminars is all about tools for developers, by developers. Join Microsoft Florida Developer Evangelist Russ Fustino MVP Stan Schultes and others as they bring you demos and discussion about their favorite developer tools. This episode includes but is not limited to these tools; Live Services Live ID, Expression Blend, Visual Studio Debugger, Live Mesh and more. (Session begins at 1:00)

Speaker(s):

  • Russell Fustino

Track and Room: 2142 Auditorium - N/A


Title: Using Wait-Time Analysis for Database Performance

Abstract: “Using Wait-Time Analysis for Database Performance Monitoring and Tuning”

There are many ways to use wait events for performance tuning, but often there is confusion on exactly what the data means. The wait event data may be analyzed at the wrong level or not detailed enough. Confio will focus on these problems and review several real-life case studies using wait event data coupled with Wait-Time based performance analysis to solve the most difficult performance related issues.

Speaker(s):

  • David Waugh

Track and Room: Room 2175 - N/A


Title: Introduction to Microsoft® Silverlight™

Abstract: Learn more about Microsoft® Silverlight™ technology that delivers the next generation of media and rich interactive applications for the web. Topics include: evolution of the user interface, cross platform user experience, flexible programming model, low cost delivery of media, and evaluating the technology for your business. This seminar is targeted for non-developers, managers, network administrator, and database administrators, who what to learn more about this new and exciting technology.

Speaker(s):

  • Vincent Mayfield

Track and Room: Room 2169 - N/A


Title: Apply Here

Abstract: MVP Kent Waldrop takes a look at the CROSS APPLY and OUTER APPLY operators and steps through a number of scenarios where these two operators might be useful. Topics included include use of the APPLY operators with table functions, substituting inline table functions for scalar functions to improve performance, use of the APPLY operator in conjunction with XML and more.

Speaker(s):

  • Kent Waldrop

Track and Room: Room 2176 - N/A


Title: Building Scalable ASP.NET Applications

Abstract: Building Scalable ASP.NET Applications for the Enterprise with NLB and Clustering Network Configurations.

Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics.

Speaker(s):

  • Vincent Mayfield

Track and Room: Room 2169 - N/A


Title: Introduction to Execution Plans

Abstract: Execution plans are a great tool for finding performance issues in your code. Learn the basics of how to read them and use that knowledge to tune you queries and maximize your performance.

Speaker(s):

  • Nathan Heaivilin

Track and Room: Room 2175 - N/A


Title: Near Real-Time Data Warehouse-No Third Party Tools

Abstract: The near real-time data warehouse was created to satisfy the needs of our billing department. The data is replicated into the extraction area of the warehouse using Microsoft SQL Server Transactional Replication. When inserts and/or updates occur a message is sent to the message queue via a trigger. There are two C# .net console apps that run, which can also run as a service, that constantly checks the message queue. When the app finds a message it processes it. The transformation and loading of the warehouse occurs here. Inside of the actual warehouse databases there is a schema named Meta. The schema houses information that is used by the warehouse processor. These tables contain information such as stored procedures and SSIS packages to

Speaker(s):

  • Patrick LeBlanc

Track and Room: Room 2175 - N/A


Title: Creating Dashboards with PerformancePoint Server 2

Abstract: The monitoring and analytics (MA) portion of PerformancePoint Server allows companies to manage their key performance indicators. This session will discuss methods of designing dashboards, deployment scenarios, and ways to integrate SharePoint with the PerformancePoint dashboard. While the next version of the PerformancePoint Server MA will be included in SharePoint, the design concepts from PPS 2007 will still be applicable in future versions.

Speaker(s):

  • Jessica Moss

Track and Room: Room 2169 - N/A


Title: Tips Tricks for dynamic Reporting Services Repor

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

Speaker(s):

  • Pam Shaw

Track and Room: Room 2172 - N/A


Title: Getting the Most Out of the SQL Server Profiler

Abstract: While many DBAs may understand SQL Server 2005/2008 Profiler basics, not too many know how to tap the full potential of this important utility. In this session, DBAs will learn many advanced techniques you can use to troubleshoot both SQL Server problems and performance issues, including: How to Identify and Analyze Slowly Performing Queries, How to Identify Deadlocking Issues, How to Identify Blocked Processes, How to Identify Excessive SP Compilations, How to Identify Excessive Table/Index Scans, How to Identify Memory Problems, and How to Correlate Profiler and System Monitor Data. Given the limited time available, not every possible use of Profiler can be discussed. But by learning these specific examples, the DBA will begin to have a f

Speaker(s):

  • Brad McGehee

Track and Room: Room 2176 - 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: Room 2175 - 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 2176 - N/A


Title: Getting Start with SQL Server Profiler

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: Room 2176 - N/A


Title: A first look at Visual Studio 2010

Abstract: Microsoft has released Beta 1 of Visual Studio 2010. In this presentation we will briefly review the new language and IDE features. We will also review the new built-in capabilities for technologies such as WCF, WF, WPF, AJAX, MVC, and Parallel Computing.

Speaker(s):

  • Kevin Grohoske

Track and Room: Room 2169 - N/A


Title: Reporting Services 2008 - Report Authoring

Abstract: I will giving an Introduction to Reporting Services 2008 and an overview of some the Report Authoring changes from Reporting Services 2005 and Reporting Services 2008.

Speaker(s):

  • Ryan Duclos

Track and Room: Room 2172 - N/A


Title: MDX for SQL Programmers

Abstract: This session will introduce the language for accessing data in SQL Server Analysis Services (SSAS) cube structures. SSAS is not just about ad hoc tools and end-user ‘slicing and dicing’ of data. The speaker will present the basic concepts of MDX including hierarchical navigation functions, sorting and ranking and creation of calculated members. The session will incorporate demonstration queries using OLAP structures readily available for self-led follow-up training.

Speaker(s):

  • Brian Knight

Track and Room: Room 2176 - N/A


Title: Creating dasboard applications with SSRS and .NET

Abstract: Learn how to create useful dashboard reports for applications and integrate these reports into a .NET application for continual monitoring. We will create a report for a trouble ticketing system and an application to monitor the results with data refreshes and configurable monitoring settings.

Speaker(s):

  • Shawn McGehee

Track and Room: Room 2172 - N/A


Title: Unconventional ETL using SSIS Scripting

Abstract: In this session, we will explore the Script Task and Script Component tools within SSIS. Learn how to break out of the traditional flat-file ETL mold and, using VB.NET or C#, create custom scripts to address unconventional transformations and related tasks.

Speaker(s):

  • Tim Mitchell

Track and Room: Room 2175 - N/A


Title: DBA 101: Best Practices Every DBA Should Know

Abstract: This session, which is designed for part-time or full-time DBAs with one year or less of DBA experience, explores some of the key best practices that all DBAs should be familiar with. The session is divided into two parts. The first covers “Check and Verify,” which covers one-time tasks that should be performed on all SQL Servers, and “On-Going Tasks,” which cover periodic tasks all DBAs should be performing. Because of time limitations, the focus is on what you need to do, not how to do it. This of this session as a basic checklist of what all DBA need to do to optimize performance and maximize server availablity.

Speaker(s):

  • Brad McGehee

Track and Room: 2142 Auditorium - N/A


Title: Introduction to SQL Server Analysis Services(SSAS)

Abstract: In this session you’ll learn the necessary information to launch a proof of concept at your company for Analysis Services. You’ll learn how SSAS can speed up queries by pre-aggregating data and help you build scorecards and drag-and-drop ad hoc reports.

Speaker(s):

  • Brian Knight

Track and Room: 2142 Auditorium - N/A


Title: FILESTREAM In Depth

Abstract: SQL Server 2008 introduces a new way to store Binary Large Objects (BLOBs) in the database. This session will provide an introduction to FILESTREAM and then go into several of the uses of FILESTREAM, including n-tier applications and Reporting Services.

Speaker(s):

  • Sven Aelterman

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


Title: The Modern Resume: Building Your Brand

Abstract: Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today’s modern world, and take advantage of the tools offered by blogging, social networking, and more.

Speaker(s):

  • Steve Jones

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


Title: Introduction to SQL Server Statistics

Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.

Speaker(s):

  • Andy Warren

Track and Room: 2142 Auditorium - N/A


Title: Integrating Silverlight 2.0 Into Web Applications

Abstract: A demonstration and walkthrough of techniques used to integrate Deep Zoom, Page Turner, and animations to deliver robust web applications using Silverlight 2.0 and Microsoft .NET technologies.

Speaker(s):

  • Bryan Soltis

Track and Room: Room 2169 - N/A


Title: Consulting Outside the Box: Using Creativity and P

Abstract: Often in the consulting world you encounter individuals whom grasp onto logical ideas and parables like Occam’s razor “The simplest explanation for a phenomenon is most likely the correct explanation.” However, in the database world, reaching these explanations often require more of an artistic flair of creativity in order to reach a successful answer.

This presentation will focus on some of the unique ways in which Perpetual Technologies consulting staff have formulated successful solutions in what seemed to be improbable circumstances and how the same principles can help you in your everyday endeavors.

Speaker(s):

  • Arie Jones

Track and Room: Room 2172 - N/A


Title: WPF - XAML an Introduction

Abstract: This session will be an intoduction to the Windows Presentation Foundation. We will concentrate on XAML and declarative based programming.

Speaker(s):

  • Steven Lane

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

Arie Jones

Contact: http://www.programmersedge.com

Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com

Keith Rowe

Contact: http://www.ConsultWithUs.com

Keith Rowe has been developing database-driven solutions since 1979. He owns and manages Cornerstone Software Services in Tallahassee, a small consulting and software development firm that focuses on staff augmentation for the State of Florida and developing line of business applications with predominantly Microsoft technologies. Keith served as the founding president of the Capital City .NET Users Group and supports the .NET and SQL Server community in the region along with key employees of h

Sven Aelterman

Twitter: - @svenaelterman

LinkedIn: Sven Aelterman

Contact: https://svenaelterman.wordpress.com

Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.

Arie Jones

Contact: http://www.programmersedge.com

Arie Jones ‘AJ’ is the Principal Technology Manager for Perpetual Technologies, Inc. in Indianapolis, IN. Arie leads PTI’s team of expert consultants in planning, design, development, deployment, and management of database environments and applications to achieve the best combination of tools and services for each client. Additionally, AJ is a community speaker, has written several books such as “Learn SQL in 24 Hours”, and blogs extensively at http://www.programmersedge.com

Shawn McGehee

Contact: http://www.gulfcoastsql.com

Shawn McGehee is the Senior Database administrator for a nationwide health care company currently residing in the Orlando area. He has been working in the IT industry for over 12 years and came from a development background before he moved into database administration in 2004. Shawn has contributed to several online publications and speaks at SQLSaturdays, Code Camps and local user group meetings as much as possible. Shawn was also a co-author on the 2008 Reporting Services book from Apress.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

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

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

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.

Steven Lane

Senior Solution Architect with I.S. Consulting (http://www.goisc.com/). President Tallahassee .NET User Group (www.tlhdotnet.net). Founder Tallahassee Architectural SIG (http://tallyarch.com). More than 12 years continuous and progressive experience as a Development Team Leader, Object Oriented Software Architect, Business System and Data Analyst, Principal Consultant, Technical Instructor, Lead Programmer, and Environmental Quality Control Specialist.

Don Demsak

Contact: http://donxml.com

bio

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.

Brad McGehee

Twitter: - @bradmcgehee

Contact: http://www.bradmcgehee.com

Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master’s in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years’ SQL Server experience. He has been involved in the industry since 1982.

Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.

Ken Simmons

Contact: http://cybersql.blogspot.com

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

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

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

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.

Bryan Soltis

Contact: http://www.bitwizards.com/Blogs/Bryan-Soltis

Bryan Soltis is the Directory of Technology Research for Bit-Wizards Custom Solutions, Inc. in Fort Walton Beach, FL. Bryan has over 13 years of experience designing and implementing solutions using Microsoft technologies. Bryan is an MCPD 4.0, MCSD, and Microsoft VTSP. In his free time he enjoys traveling with his family, lounging on beach with live music, and wiping out repeatedly trying to wakeboarding.

David Waugh

Contact: http://www.confio.com

David Waugh is the main man at Confio.

Vincent Mayfield

Contact: http://www.bitwizards.com/Blogs/Vincent-Mayfield

Vincent W. Mayfield (Vinny/Vince) is the Chief Executive Officer and co-founder of Bit-Wizards of Fort Walton Beach, Florida. Bit-Wizards is an innovative technology company providing professional software engineering, systems integration, web design, and IT consulting services. Bit-Wizards is a Microsoft Managed Gold Partner. Vince has over 21 years of experience developing software, and over 18 years developing applications for the Windows Family of Operating Systems. Vince is a Microsoft VTSP

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.

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

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.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

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.

Russell Fustino

Contact: http://www.russtoolshed.net

Russ wisely shelved dreams of rock and roll stardom in order to share his vast knowledge with developers nationwide. Given that he can’t sing or play an instrument, other than in Guitar Hero, we’re all very grateful. Russ has more than 25 years of software development. He’s the creator of the Russ’ Tool Shed developer seminar series and has donned his trademark suspenders, hardhat and tool belt in presentations for over 100,000 developers at 1,900 events. Russ also has expertise in developing Vi

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.

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.

Kevin Grohoske

Contact: http://www.bitwizards.com/Company/Meet-the-Team/Corporate-Leadership/Kevin-R–Grohoske

Kevin first started programming on a Timex Sinclair 1000 when he was 11 years old. As a professional, Kevin has been designing and developing custom applications using Microsoft development tools since 1995. He has designed and developed large enterprise class applications and intranet applications for companies such as International Paper, LexisNexis, and Duke Energy. He moved from Cincinnati in 2006 to join Bit-Wizards, Custom Software Solutions headquartered in Fort Walton Beach, FL.

Ryan Duclos

Contact: http://about.me/rduclos

Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.

Nathan Heaivilin

Just a DBA who wants to give back to the community in the way they have given to me and helped my development over the years.

Patrick LeBlanc

Contact: http://sqldownsouth.blogspot.com/

Patrick LeBlanc is currently a BI Consultant for Pragmatic Works. I have 9 years experience with developing and deploying database solutions. Patrick is a regular speaker at SQLSaturday, User Groups and SQL Lunches. He is also the founder of TSQLScripts.com and SQLLunch.com. Patrick is also the President of the Baton Rouge Area SQL Server User Group.

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.

Brad McGehee

Twitter: - @bradmcgehee

Contact: http://www.bradmcgehee.com

Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master’s in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years’ SQL Server experience. He has been involved in the industry since 1982.

Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.

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.

Vincent Mayfield

Contact: http://www.bitwizards.com/Blogs/Vincent-Mayfield

Vincent W. Mayfield (Vinny/Vince) is the Chief Executive Officer and co-founder of Bit-Wizards of Fort Walton Beach, Florida. Bit-Wizards is an innovative technology company providing professional software engineering, systems integration, web design, and IT consulting services. Bit-Wizards is a Microsoft Managed Gold Partner. Vince has over 21 years of experience developing software, and over 18 years developing applications for the Windows Family of Operating Systems. Vince is a Microsoft VTSP

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

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page