SQLSaturday #215 - Jacksonville 2013

Event Date: 04/27/2013 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).


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

Title: Principles of BISM Tabular Modeling

Abstract: Although BISM Tabular is a powerful analytical engine that can efficiently link data across multiple sources, it is common to get stuck when attempting to connect tables and generate calculations to leverage all sources in a single model. Many issues regularly encountered by BI developers (and data analysts when using PowerPivot) can be attributed to violations of one or more of the relationship rules of the Tabular engine. It is necessary to understand those rules in order to handle increasingly complex semantic modeling requirements.

On this session, attendees will gain an understanding of the fundamental principles which must be followed to develop effective models in BISM Tabular as well as PowerPivot.


  • Javier Guillen

Track and Room: BI (Auditorium 1) - N/A

Title: Putting Quality Back Into Your Data

Abstract: This session introduces Data Quality Services, a new feature of SQL Server 2012. One of the challenges in developing Business Intelligence solutions is ensuring that the data does not have inconsistencies, incomplete records, invalid or inaccurate values, and data duplication. Sometimes you even need to consolidate data from more than one source that may have different standards and format. Microsoft’s solution in SQL 2012 is Data Quality Services (DQS). In this session, you will learn the basics of what DQS is and how it can be used to clean your data. I will end the session with a set of demonstration of how DQS works with different data problems to help you put quality back into your data.


  • Michael Antonovich

Track and Room: BI - N/A

Title: SQL Server VS SQL Azure

Abstract: SQL Azure is Microsoft’s relational database offering in the cloud. While it’s similar to SQL Server 2008R2/2012 there are enough differences that it’s important to understand what you can and cannot do with SQL Azure. This presentation gets you comfortable with SQL Azure and understand how it can best be used. Topics: • Differences from other SQL Server 2012 editions
• Signing up for SQL Azure • Connecting to SQL Azure • Configuring the firewall • Getting the right connection string from the Azure UI • Creating a database, users and tables • Backups and Restores • Checking Usage and Billing information • Approaches to scaling with • SQL Azure Data Sync Features • Moving schema and data up and down from the cl


  • SQL Harry

Track and Room: Personal Dev Azure - N/A

Title: GeoSpatial Analytics Using Microsoft BI

Abstract: In this age of big data, location matters more than many people imagine. Almost every set of data has some geographic information tied to it, and it is all the more pertinent to understand and unravel the patterns and trends behind them. This session will start by explaining why GeoSpatial analytics is important in today’s world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will also feature practical demos for each of these tools, during which we will work on some of the publicly available datasets to uncover some interesting facts.


  • Jason Thomas

Track and Room: BI (Auditorium 1) - N/A

Title: SQL 2012 DMV’s Extended Events

Abstract: As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV’s and Extended Events.


  • Gareth Swanepoel

Track and Room: BI - N/A

Title: SQL Internals, Recovery Models, Backups! OH MY!

Abstract: The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!


  • Bradley Ball

Track and Room: DBA (Auditorium 2) - N/A

Title: Complex DAX Functions

Abstract: PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.


  • Mike Davis

Track and Room: BI - N/A

Title: Building an ETL Framework with SSIS 2012

Abstract: A lot has been said about ETL Frameworks and it’s an important topic considering these frameworks are the cornerstone of any data warehouse implementation. This session will discuss building a robust enterprise ETL Framework while leveraging the architectural enhancements available in SQL Server 2012. Topics include auditing, logging, designing for fault tolerance and recoverability, handling orchestration, parallelism and finally scheduling.


  • Christopher Price

Track and Room: BI - N/A

Title: Indexing for performance

Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session


  • Jeffrey Garbus

Track and Room: DBA (Auditorium 2) - N/A

Title: Iron Chef - Traditional vs Self Service BI

Abstract: Come watch two titans of tech showcase their “talents” while they compete in building BI solutions using two different methods. One will use Self-Service BI techniques while the other uses traditional methods of building BI solutions. This continuing saga proves to be epic as usual!


  • Adam Jorgensen

Track and Room: BI (Auditorium 1) - N/A

Title: A Walk Around the SQL Server 2012 Audit Feature

Abstract: In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.


  • Timothy McAliley

Track and Room: DBA - N/A

Title: NoSQL - Couchbase and Map/Reduce

Abstract: NoSQL databases are setting the big data world on fire! Get introduced Couchbase and learn how to utilize Map/Reduce to navigate your data from the perspective of someone coming from a Microsoft SQL Server background.


  • David Talbot

Track and Room: Personal Dev Azure - N/A

Title: Backup Strategies are for Losers!

Abstract: Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data, protected HIPAA information, and MY social security number. Because of that, Peggy will be bankrupting my credit report. In this session you will learn: what is a recovery strategy, creating your recovery point and recovery time objectives, selecting the proper backup type and recovery model, and then we will be putting it all together into a winning strategy!


  • Ed Watson

Track and Room: DBA (Auditorium 2) - N/A

Title: Extend Your Knowledge with Extended Events!

Abstract: SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.


  • Janis Griffin

Track and Room: DBA - N/A

Title: Tips Tricks for dynamic SSRS Reports

Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.


  • Pam Shaw

Track and Room: Personal Dev Azure - N/A

Title: Waiter, There’s a Fly In My Data

Abstract: Dealing with bad data is a painful and expensive experience.  In this session we will jump into SQL Server 2012 for a hands-on demonstration of cleansing and correcting data with  SQL Server Data Quality Services (DQS) and Integrations Services (SSIS). We will dive into DQS knowledge-driven approach, reusability, cleansing and matching, and explore the collaboration opportunities between data stewards and IT professionals.  You will demonstrate how to create a knowledge base, define domains and rules to clean data, enrich data by using third-party data providers, and use the new SSIS DQS cleansing component.


  • Rafael Salas

Track and Room: BI - N/A

Title: ETL Automation Using SSIS

Abstract: On this session you will learn how to find patterns and generic processes to create an ETL framework to automate the most common task within your organization using SSIS, from metadata driven package execution to ETL tracking of file loading processes.


  • Jorge Novo

Track and Room: BI - N/A

Title: Creating a Power View Reporting Solution

Abstract: Power View lets you create eye-popping visualizations and provides intuitive ad-hoc reporting that a variety of business users can use to make critical decisions. But before you can begin building these incredible reports, you must have your data properly prepared. This session will give you a beginning-to-end view of what is needed to create Power View reports, from organizing a PowerPivot model source to preparing the actual Power View report.


  • Devin Knight

Track and Room: BI (Auditorium 1) - N/A

Title: ABCs of CDC with SSIS 2012

Abstract: SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.


  • Steve Wake

Track and Room: BI - N/A

Title: MDXplosion! Intro To MDX

Abstract: The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It’s easier than you might think. In this session, attendees will learn the basic MDX query syntax, how to navigate a hierarchy, how to create dynamic time calculations, and how to add calculations to your cube.


  • Dustin Ryan

Track and Room: BI - N/A

Title: Roping the Elephant - Hadoop and BI Live!


Have you been wondering how you can sit down at work and use Hadoop to make your BI better? Have you thought about what Big Data could mean to your firm? Come watch Adam setup, populate, consume and integrate data from a Big Data Platform into a SQL BI solution Live!


  • Adam Jorgensen

Track and Room: Personal Dev Azure - N/A

Title: DMX - Data Mining Extensions

Abstract: Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. We will work through clustering and forecast examples and populate a relational table using SSIS.


  • Mike Milligan

Track and Room: BI - N/A

Title: Maintaining Indexes in SQL Server

Abstract: So… you’ve created a bunch of indexes to improve the performance of your application, but then you start to notice performance degradation overtime. Digging further, you find that your indexes are not being maintained. In this session we’ll look at some different systems that can be used for index maintenance. Additionally we’ll explore some of the basic DMV’s that provide us information about indexes.


  • Robert Biddle

Track and Room: DBA - N/A

Title: Predictive Analytics at your fingertips

Abstract: The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.


  • Jose L. Rivera

Track and Room: BI - N/A

Title: Database Projects - An Introduction

Abstract: Database projects have come a long way since the first fumbling attempts. The newest incarnation is SSDT (Sql Server Development Tools) and it has left behind the false errors and obtuse directory hierarchy of database projects past. Database projects have finally evolved to where they can be integrated into your daily build cycle! I know, I know, I was skeptical too; and I don’t mean to disillusion you into thinking it will all work fine right out of the box – no, we’re not close to there yet! Come to this session and let me introduce you to the strengths, weaknesses, caveats, and workarounds of database projects.


  • Jonathon Moorman

Track and Room: DBA - N/A

Title: Global Address Data: Storage and Verification

Abstract: This session will focus on the differences in address format and structure around the world and how that can place in the effective storage of “useful” address data within the Enterprise. In addition, we’ll discuss how address data is “mangled” to be stored and how it can impact the overall quality level of any tool used for address validation and correction internationally. With 240+ countries and territories around the world, this is not a small consideration.


  • Charles Gaddy

Track and Room: DBA - N/A

Title: What is a BI DBA?

Abstract: Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!


  • Jorge Segarra

Track and Room: DBA (Auditorium 2) - N/A

Title: Dashboards…How To Choose Which MSBI Tool

Abstract: Compare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting. We’ll explore the strengths and limitations of each tool for creating dashboards scorecards with PerformancePoint, Reporting Services, Excel, and Power View. This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another.


  • Melissa Coates

Track and Room: BI - N/A

Title: Intro to SSIS 2012 Deployment Models

Abstract: With the release of SQL Server 2012, Microsoft has killed the ever popular debate of ‘Where should we deploy our packages?’. The new deployment model, with the use of environments, adds many new benefits and possibilities for different deployment scenarios. Learn the basics of the new deployment model and how to setup environments in this demo intensive session.


  • Shawn Harrison

Track and Room: BI - N/A

Title: BI Consultant’s Toolkit

Abstract: This session will present 16 (free) tools that are available…when, where, why, and how to use them and include some demo’s.


  • Steve Schneider

Track and Room: Personal Dev Azure - N/A

Title: Adventures in Job Hunting

Abstract: This session will cover in how to properly research companies, interview, properly resign and how to brand yourself.


  • Tom Brenneman

Track and Room: Personal Dev Azure - N/A

Title: SQL Server Security

Abstract: In this Session I will be covering what a normal dba/developer needs to be aware of with SQL Server’s: Logins, Roles, and Schemas. (2008 and whats new in 2012!) We’ll cover major NO/NOs, common mistakes, and point the way to best practices to tighten the security in your SQL server. We’ll have about 20% slides and 80% hands on demos. :-)


  • Scott Gleason

Track and Room: DBA (Auditorium 2) - N/A

Title: Database Requirements

Abstract: A Requirements Analysis defines the system in terms of the operations and/or events that must be performed in order to meet the goals of the software. The goal of the requirements analysis is to assist in defining and allocating actions for the people that are to use the system that are best suited to their capabilities and limitations


  • Arvin Meyer

Track and Room: DBA - N/A

Title: Moving Big Data - SSIS, Pig, and Sqoop

Abstract: Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.


  • John Welch

Track and Room: BI (Auditorium 1) - N/A


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Robert Biddle

Twitter: - @robert_biddle

LinkedIn: Robert Biddle

Contact: http://robert-biddle.com

Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.

Javier Guillen

Twitter: - @javiguillen

LinkedIn: Javier Guillen

Contact: http://javierguillen.wordpress.com/

Javier Guillen is a Solutions Architect for BlueGranite.

An active blogger, speaker, and Microsoft community contributor, Javier has more than 10 years developing SQL Server solutions and is very interested in SQL Server Analysis Services and the practical application of MDX and DAX patterns.

Javier is also a Power BI Workshop instructor, delivering classes in private and public settings, an adjunct BI instructor for Central Piedmont Community College in Charlotte, NC and an adjunct lecturer for the City University of New York (CUNY) School of Professional Studies undergraduate and bridge graduate courses in Business Analytics. He is also the co-founder and co-organizer of the Charlotte Business Intelligence User Group (CBIG).

Tom Brenneman

As a former web designer/developer now working in the recruiting industry for the past 5 years. Tom has helped fortune 500 clients to highly recognized Microsoft consulting firms helping them hire and retain talent.

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

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

Contact: http://www.sqlballs.com

Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com

Melissa Coates

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

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.

Charles Gaddy

Contact: http://blog.melissadata.com/data-quality-authority/

Charles is a Business Development Manager with Melissa Data focusing primarily on Melissa Data’s Global Solutions. Charles has 15+ years of experience in Information Technology, Software Development, Product Management and Sales Support. His past positions include VP of Product Management, Alliance Manager, Senior Sales Engineer and Director of Information Technology. He has specific experience in banking, insurance, direct marketing technology and the global data quality market sectors.

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.

Mike Milligan

Contact: http://www.bidn.com/blogs/MMilligan

I have been in love with computers since I was very young. My first computer was a Timex Sinclair 1000 which I programmed to run my paper route. I have always enjoyed discovering new ways that these wonderful machines can improve our lives. I derive an immense amount of satisfaction from developing solutions that allow businesses to make intelligent informed decisions efficiently.

SQL Harry

Contact: http://sqlharry.com/

Hari Reddy is a Lead SQL DBA working at a Bank in Jacksonville FL. I have been working with SQL Sevrer for more than 6 yrs serving clients across US and also provides support for Junior DBA who are SQL Server enthusiast.I have been part of JSSUG PASS for more than 3yrs through which I try to share and learn about the new Teshcnologies in SQL Server and with SQL Communities.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

Christopher Price

Contact: http://bluewatersql.wordpress.com/

Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.

Jason Thomas

Twitter: - @SqlJason

LinkedIn: Jason Thomas

Contact: http://www.SqlJason.com

Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).

Jorge Segarra

Twitter: - @sqlchicken

LinkedIn: Jorge Segarra

Contact: http://sqlchicken.com

Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including “SQL 2008 Pro Policy-Based Management” and “SQL Server 2012 Bible” .

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.

David Talbot

Contact: http://www.legendarycode.com

David Talbot is the author of Applied ADO.NET and numerous articles on technology. He has over 14 years of experience specializing in developing rich user interface web applications.

Jorge Novo

Contact: http://etldevelopernotes.blogspot.com/

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

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.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

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

Jose L. Rivera

Contact: http://www.sqlbn.com

Jose L is a SQL Server MCITP and MCT with over 10 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. He currently works as Consultant at Nagnoi, Inc. as well as College professor at University of Phoenix. In addition, he shares his knowledge and perspectives as PRPASS Vice President and Community Leader, Co-Leader for the Azure and Global Spanish virtual chapters and frequent speaker at user groups and SQLSaturday events, among others.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

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

Steve Wake

Twitter: - stevewake

LinkedIn: Steve Wake

Contact: http://blog.wakebi.com

Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.

Shawn Harrison

Twitter: - @ShawnBHarrison

Contact: http://www.thesqlgoth.com

Shawn Harrison is a BI Developer at Community Hospice and Palliative Care. He oversees the data warehouse and works within other levels of the MS BI stack. He also speaks at community events such as SQLSaturday, user group meetings.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

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.

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.

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.

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

Contact: http://sqldusty.com

Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.

Arvin Meyer

Contact: http://www.datastrat.com

A Microsoft Certified Professional and a 15 time awarded Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security, Special Interest Groups, and is the President Emeritus of the Central Florida Computer Society. Arvin works as a consultant, and is Chief Database Architect of a software technology firm in Orlando, FL.

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.


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

Back to the SQLSaturday Event List

Back to the home page