SQLSaturday #151 - Orlando 2012
Event Date: 09/29/2012 00:00:00
Event Location:
- Seminole State College of Florida
- 100 Weldon Blvd Building UP
- Sanford, Florida
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server Internals Architecture
Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - …and much more.
Speaker(s):
- Kevin Kline
Track and Room: Perf Tuning - N/A
Title: Wish you could live the glamorous consulting life?
Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).
I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out
Speaker(s):
- Juan Soto
Track and Room: Career Skills - N/A
Title: Taking the Scary out of Monster Reports
Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
Speaker(s):
- Pam Shaw
Track and Room: Reporting - N/A
Title: Free tools from the SQL Server Community
Abstract: No budget? That’s OK! Need Tools? We’ve get them! Don’t know where to go? We’ll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will walk through a list of twenty great tools, scripts, blogs and other resources to help you out. Best of all, it’s all free! But wait, there’s more. Order now and we’ll include an extra two tips at no additional cost!
Speaker(s):
- Eric Wisdahl
Track and Room: Admin - N/A
Title: Tame Your Unruly Data…With Constraints!
Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s):
- Rob Volk
Track and Room: Admin - N/A
Title: SQL Azure vs. Azure Tables –Clearing The Confusion
Abstract: The Azure platform is quickly gaining momentum and acceptance, in part due to the relational database capabilities of SQL Azure as well as the inexpensive and high-capacity storage capabilities of Azure Tables. Yet, there seems to be some confusion as to why and when you would use SQL Azure vs. Azure Tables. One is relational, and one is not, yet there has been a tendency to use Azure Storage Tables as a replacement for SQL Azure, with poor results. This session will provide a deep look at the difference between SQL Azure and Azure Storage Tables, and show the performance differences when querying each. We will look at how each stores data and the pros and cons of using each as a storage mechanism, and discuss how and why you would choose.
Speaker(s):
- Scott Klein
Track and Room: Cloud - N/A
Title: Transitioning from SQL Trace to Extended Events
Abstract: Extended Events were introduced with SQL Server 2008, but without a UI, which meant using T-SQL to create and manage them and using XPath and XQuery to parse the output. Microsoft has added an Extended Events UI in SQL Server 2012 and also added additional events. With the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learning Extended Events. This session will show you how to take existing Traces and convert them to Extended Event Sessions.
Speaker(s):
- Jack Corbett
Track and Room: Perf Tuning - N/A
Title: Designing An Efficient Replication Topology
Abstract: This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve business needs will also be covered.
Speaker(s):
- Chad Churchwell
Track and Room: Admin - N/A
Title: SSAS Tabular and Self Service BI - TheDynamDAX Duo
Abstract: In this session I will cover how SSAS tabular and Self Service BI compliment each other and make the slicing and dicing of large amounts of data a breeze for Power Users. I will give a brief explanation and history of each then will walk through how to create a SSAS tabular model, get into how to create data relationships from a regular database model with large tables, then hook it up to Excel and expose the elements for users to slice and dice data with ease and create charts. Then will demonstrate a few DAX commands that are very powerful yet very easy.
Speaker(s):
- Anthony Sammartino
Track and Room: BI - N/A
Title: PowerPivot+Powerview=Self-service BI Revolution
Abstract: SQL Server 2012 introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot and the new ad-hoc dashboarding tool called PowerView are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves. In this session you will also understand what is the role of IT in this new self-service paradox.
Speaker(s):
- Jose Chinchilla
Track and Room: SSIS - N/A
Title: LinkedIn for SQL Server Professionals
Abstract: LinkedIn is more than an online resume! The platform is chock full of useful features for networking, relationship building, and job searching. Think of it as your professional online image. LinkedIn is rapidly becoming the de facto platform for business networking. There are many powerful, advanced features that most people don’t know how to use or even exist. It is also an online communication platform, professional networking portal, and contacts database. Takeaways include: how to optimize and polish your profile, how to get your profile to 100%, quality vs. quantity networking strategies, selecting of and the correct use of LinkedIn groups
Speaker(s):
- Craig Purnell
Track and Room: Career Skills - N/A
Title: PowerShell for Beginners
Abstract: PowerShell is Microsoft’s automation engine, which includes a command-line shell and scripting language. Since its initial release in 2006, it has become an essential tool for managing Microsoft technologies and products from vendors such as VMware. This session will explain what PowerShell is, demonstrate the fundamentals, and provide some reasons why everyone working with Microsoft products should know the basics.
Speaker(s):
- Jason Hofferle
Track and Room: Career Skills - N/A
Title: SQL Internals , Recovery Modes, and 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!
Speaker(s):
- Bradley Ball
Track and Room: Admin - N/A
Title: Rewriting Bad Code
Abstract: This session consists of real-life examples of poorly performing t-sql code and what was done to improve performance by several orders of magnitude. Jeff will cover a variety of performance topics from misuse of tempdb, to excessive io, to taking advantage of new t-sql features. These examples are also featured in his most recent (and well-reviewed) book, “Microsoft Transact - SQL, The Definitive Guide”.
Speaker(s):
- Jeffrey Garbus
Track and Room: Cloud - 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.
Speaker(s):
- Pam Shaw
Track and Room: Reporting - N/A
Title: Partitioning for Perf Management of Large Tables
Abstract: Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s):
- Eddie Wuerch
Track and Room: Perf Tuning - N/A
Title: Manage SQL Server 2012 on Server Core w/PowerShell
Abstract: Windows Server 2008 introduced Server Core, the operating system without the Graphical User Interface. SQL Server 2012 is the first version of SQL Server to support Server Core. To gain the maximum efficiency from your servers you want to make use of Server Core and with PowerShell you can effectively manage SQL Server in that environment. This session will demonstrate how to manage SQL Server 2012 on Windows Server Core and provide scripts to help you perform the common tasks you need to perform on that platform.
Speaker(s):
- Allen White
Track and Room: Admin - N/A
Title: Real-world Fuzzy matching with SSIS
Abstract: Fuzzy Lookup and Fuzzy Grouping in SSIS are two powerful transformations that allow you to match inputs by providing a similarity threshold. In this presentation you will learn how to implement Fuzzy Lookup and Fuzzy Grouping in real-world scenarios such as matching individuals by a series of attributes, creating master or header records for Master Data Management as well as implementing data cleansing for Data Quality frameworks.
Speaker(s):
- Jose Chinchilla
Track and Room: SSIS - N/A
Title: Running SQL Server 2012 as a Windows Azure VM
Abstract: This session will cover an introduction to Windows Azure Virtual Machines and then we will explore the options for planning and configuring SQL Server 2012 as a Windows Azure Virtual Machine. You will see a demonstration of configuring SQL Server 2012 as a Windows Azure Virtual Machine, and then a demonstration of post-configuration tasks such as storage provisions and resource monitoring. You will also learn the basics of what you need to obtain a Windows Azure account and the different subscription options.
Speaker(s):
- Timothy McAliley
Track and Room: Cloud - N/A
Title: The server side of Reporting Services
Abstract: This session will cover important information about how to set up Reporting Services. We’ll go beyond the simple installation and configuration issues. Covered topics will include shared data sources, managing the folder structure, using linked reports, and the management user interfaces. We’ll also cover the database that Reporting Services uses to house report definitions.
Speaker(s):
- Robert Hatton
Track and Room: Reporting - N/A
Title: SQL Server Data Tools, What can you do for me?
Abstract: With the release of SQL Server 2012 Microsoft introduced a bunch of new functionalities into their product, including a whole set of tools that can make your life a whole lot easier. In this session we will go through the different scenarios where the SSDTs can be used and help you develop and/or administer your databases in a whole new way and without the need of third party tools.
Speaker(s):
- Guillermo Caicedo Santiago
Track and Room: Cloud - N/A
Title: Change Tracking and Change Data Capture Deep Dive
Abstract: In this session Luis will cover beginning to end these two technologies key to delivering a real time reporting. Come join him to discuss different scenarios and some gotcha’s he has learned and dealt with in real world implementations.
Speaker(s):
- Luis Figueroa
Track and Room: BI - N/A
Title: Database Creation Process
Abstract: A beginning to intermediate look at Requirements Analysis, Needs Assessment, and Software Satisfaction followup
Speaker(s):
- Arvin Meyer
Track and Room: Admin - N/A
Title: Job Common Sense - Don’t be that Guy!!
Abstract: In this session, Tom will share stories from those in the community to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities.
Speaker(s):
- Tom Brenneman
Track and Room: Career Skills - N/A
Title: Best Practices Are Not Just Hypothetical
Abstract: Ever had a discussion where someone said well X is best practices but that is impossible to implement? This session is a step by step installation guide to best practices for SQL Server. When you install with best practices in mind, maintaining them is much simpler.
Speaker(s):
- Ed Watson
Track and Room: Admin - 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.
Speaker(s):
- Mike Davis
Track and Room: BI - N/A
Title: SSIS Moving Beyond the Script Task Script Compon
Abstract: Move beyond the script task and script component and you’ll find one of the often overlooked aspects of Integration Services is the extensibility options that are available. We will dive into a world of .Net code and discover your options for extending your SSIS Packages with custom objects. We will explore both custom task and data flow components as we develop from the ground up a set of reusable SSIS components using managed code.
Speaker(s):
- Christopher Price
Track and Room: SSIS - N/A
Title: Look who’s Blocking
Abstract: Have you ever faced the situation of trying to retrieve some data and the query keeps waiting on. Why this simple query is taking so long? There is a good chance that you are encountering locking/blocking problems. In this session, we will demonstrate how to recognize, diagnose and troubleshoot common locking and blocking scenarios. We will discuss transactions basics, lock types, escalation, and the infamous deadlock, among others.
Speaker(s):
- Jose L. Rivera
Track and Room: Perf Tuning - N/A
Title: Data Visualization in Reporting Services
Abstract: Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what’s new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
Speaker(s):
- Stacia Varga
Track and Room: Reporting - N/A
Title: DBA Repository Update Using SSIS and SSRS
Abstract: At its heart, the DBA Repository solution employs SSIS and SSRS to centralize important SQL Server information for the DBA to analyze with ad hoc queries or reports. It was recently updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine and his book SQL Server Tacklebox, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS. Rodney will also show you how to use the fundamental package contructs so that you can easily expand the freely available project in your own environment. Two additional packages will be demonstrated, Error Log gathering and SSRS audit logs.
Speaker(s):
- Rodney Landrum
Track and Room: Reporting - N/A
Title: Introduction to Power View
Abstract: Power View has the capability of creating eye-popping visualizations within SharePoint 2010. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. This session walks you through creating your first Power View report and shows you how to create an impressive reporting solution.
Speaker(s):
- Devin Knight
Track and Room: BI - N/A
Title: Intro to SQL Server Performance Tuning
Abstract: In this session we’ll cover an introduction to SQL Server Performance tuning. We will go through a step-by-step process to identify causes of poor-performing systems.
Speaker(s):
- Robert Biddle
Track and Room: Perf Tuning - N/A
Title: Introduction to Master Data Services 2012
Abstract: Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization’s master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.
Speaker(s):
- Christopher Price
Track and Room: BI - N/A
Title: Looney Tuner? No, there IS a method to my madness
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: Perf Tuning - N/A
Title: Introduction to Project Management
Abstract: The IT industry is now being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process as defined by the Project Management Institute. It will also focus on the tools that data professionals can use to deliver projects ontime and on budget.
Speaker(s):
- Richie Rump
Track and Room: Career Skills - N/A
Title: BI for the Masses Deux, PowerPivot 2012
Abstract: The latest version of PowerPivot brings even more BI power to the masses the addition of defined hierarchies, KPI’s, perspectives, formatted measures, and more. This session focuses on showing how to use some of the latest features of PowerPivot to give your power users the tools they need to perform their own analysis of their business data. In fact, when your users begin to use Office Excel 2013, PowerPivot is already built-in and does not require a separate download. Stay ahead of the curve and attend this session so you can help your users effectively use this tool.
Speaker(s):
- Michael Antonovich
Track and Room: BI - N/A
Title: Building Your Professional Development Plan
Abstract: Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you’ll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker(s):
- Andy Warren
Track and Room: Career Skills - N/A
Title: Data Conversions - Steps, Best Practices More
Abstract: This session will cover the stages and steps of a data conversion project, some best practices and other considerations. The session includes information that could be useful to someone involved in planning, managing or developing a data conversion project.
Speaker(s):
- Norm Bowen
Track and Room: SSIS - N/A
Title: Basic Intro to PowerShell for the DBA (1/2)
Abstract: Description:This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and testing PowerShell working with both SMO and SQLPS module to build SQL PowerShell scripts. This is not a language intro but it will get you started to learn PowerShell. Covering PowerShell V2/V3 and SQL Server tools.
Speaker(s):
- Maximo Trinidad
Track and Room: Cloud - N/A
Title: Object Level Recovery Made Easy
Abstract: Learn how to recover database objects quickly and efficiently without having to do a full database restore.
Speaker(s):
- Andy Warren
Track and Room: BI - N/A
Title: Surviving Your Sql Developer Interview
Abstract: This session will describe what to expect when interviewing for a sql server developer position with tips from the “other” side of the table. The session will include tips to strengthen your interviewing techniques, and pitfalls to avoid. The session will explain why “I don’t know.” is a perfectly acceptable answer and when it’s okay to brag. This session will describe what’s “really” going on in the minds of the interviewer!
Speaker(s):
- Jonathon Moorman
Track and Room: Career Skills - N/A
Title: Database Backend - Between Ground and Clouds
Abstract: The choice of the database backend is one of the most important tasks during system design stage. This session compares various options available to users, such as on-premises SQL Server installation; Windows Azure SQL Database; Amazon Elastic Compute Cloud (EC2) and Amazon Relation Database Service (RDS). It analyzes pros, cons and platform limitations for different types of the systems, architecture and design requirements for each platform and discusses conversion of the systems from one platform to another.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Cloud - N/A
Title: How Active Directory Affects SQL Server
Abstract: There are many things that can go wrong with SQL server, and a lot of times they come from outside influencers. Active Directory is one of the largest influencers that can have many interesting and unexpected issues that are not apparent. We’ll discuss how the location of your server in AD is important, how security can be compromised, AD DNS configuration, and of course Kerberos. By the end of the session you’ll have a check list of things to discuss with your domain administrator when you return to work. This includes the biggest perpetrator, Group Policy Objects.
Speaker(s):
- Andy Warren
Track and Room: SSIS - N/A
Title: SSRS in ASP.Net Application
Abstract: In this session I will show you how to incorporate your SSRS reports into a ASP.Net Web Application. We will create a web page that will pass parameters to an SSRS report using the Report Server Service.
Speaker(s):
- David Liebman
Track and Room: Reporting - 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.
Robert Hatton
LinkedIn: Robert Hatton
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook.
Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
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.
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.
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.
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.
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
Tom Brenneman
Contact: http://www.pragmaticworks.com
Tom Brenneman is the Vice President of Recruiting Services at Pragmatic Works. Tom has over 5 years of experience and has advise on and deliver improved business processes, operational models, and technology-driven solutions. Mr. Brenneman is highly active in the Microsoft community as President of the .NET Jacksonville users group (JaxDug) and helps run the Jacksonville SQL Server Users group.
Norm Bowen
Contact: http://www.obieepedia.wordpress.com
Norm currently works as a Sr. Business Intelligence Developer for an organization in downtown Orlando. His major professional focus is making corporate data as valuable as possible through Data Warehousing Business Intelligence. This is his 2nd time presenting at SQLSaturday.
Timothy McAliley
Timothy is currently a Technical Trainer in the Enterprise Security Group at Symantec (www.symantec.com, SYMC). Timothy’s 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. Timothy delivers training for SharePoint 2010, Windows Server 2008 R2, SQL Server 2008 R2, and Exchange 2010, and speaks frequently as user groups.
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
Luis Figueroa
Contact: http://blog.extremebi.net
Luis Figueroa is an IT professional focused on delivering business solutions that leverage the Microsoft SQL Server platform. His area of expertise is Data Warehousing and Business Intelligence but he is passionate about all things SQL Server. With 10+ years of experience in the IT field, Luis has delivered data management solutions for companies in the Security, Online Marketing and Healthcare Industries. He is also the chapter leader of the MS BI user group of South Florida.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
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.
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.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Jason Hofferle
Contact: http://www.hofferle.com
Jason is an IT Specialist for the US Department of Defense and has been an IT professional since 1997. His experience includes enterprise desktop engineering for a Fortune 500 financial institution and Active Directory design and support for local governments. He is currently a federal employee with the Defense Contract Management Agency, where he is a technical lead on Windows 7 and Virtual Desktop Infrastructure.
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).
Kevin Kline
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Anthony Sammartino
Twitter: - @SQLAnt
LinkedIn: Anthony Sammartino
Contact: http://www.sqlant.me
Anthony Sammartino is the Vice President of the BI Solutions division for TekPartners. Anthony has been building Business Intelligence solutions as a consultant for many fortune 500 companies for over 13 years. For the last 11 years he has almost exclusively used the Microsoft SQL Server BI stack and focused on the following technologies: DB Engine, SSIS, SSAS, SSRS, PowerPivot, Power View, and SharePoint. Anthony currently holds certifications as an: MCP, MCTS(BI), MCITP (BI), and PMP#174;
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.”
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.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Craig Purnell
Twitter: - @CraigPurnell
LinkedIn: Craig Purnell
Contact: http://www.craigpurnell.com/
Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013
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.
Richie Rump
Twitter: - @jorriss
LinkedIn: Richie Rump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
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
Dmitri Korotkevitch
Twitter: - aboutsqlserver
LinkedIn: Dmitri Korotkevitch
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.
Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Juan Soto
Twitter: - jsoto22
LinkedIn: Juan Soto
Contact: https://accessexperts.com/blog/
I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.
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.
Stacia Varga
Twitter: - @StaciaV
LinkedIn: Stacia Varga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.
Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
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.
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.
Jonathon Moorman
Jon is currently a database architect at Lender Processing Services in Jacksonville. A developer for many years, Jon has been working with Sql Server since 6.0 in 1996. When not head’s down coding, Jon heads for outdoors to hike, camp, or canoe around the marsh.
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.
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Guillermo Caicedo Santiago
Twitter: - @sqltitan
LinkedIn: Guillermo Caicedo Santiago
Contact: http://www.sqltitan.com
Guillermo Caicedo es un profesional de bases de datos y tecnolog#237;a trabajando como Consultor en Nagnoi, LLC. Ha ayudado a numerosas empresas a obtener conocimiento sobre sus datos por desarrollar e implementar soluciones de inteligencia empresarial en sus organizaciones. El Sr. Caicedo tambi#233;n tiene una amplia experiencia desarrollando aplicaciones web y m#243;viles. Guillermo es un Data Platform MVP y l#237;der del Cap#237;tulo PASS para Puerto Rico (PRPASS).
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.
Maximo Trinidad
Twitter: - maxtrinidad
LinkedIn: Maximo Trinidad
Contact: http://www.maxtblog.com
Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.
Jose L. Rivera
Contact: http://www.jlrivmir.com
Jose L, Business Analytics Manager at Abarca Health and College professor at University of Phoenix, has over 9 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. In addition, he shares his knowledge and perspectives as PRPASS Community Leader, college professor and Co-Leader for the Azure and Global Spanish virtual chapters. He holds the MCTIP in Database Administration, Database Development and Business Intelligence for SQL Server 2008.
Chad Churchwell
Twitter: - @chadchurchwell
LinkedIn: Chad Churchwell
Contact: http://www.sqlchad.com
Seasoned SQL Server DBA Professional with over 18 years IT experience with 15 years experience in databases. I have managed an enterprise DBA team and am currently in a strategic consulting role specializing in HA, DR, Replication, and Performance Tuning and Optimization. I am currently speaking at several SQLSaturday’s as well as local user group meetings.
David Liebman
Twitter: - @BISQLDave
LinkedIn: David Liebman
Contact: http://www.bisqldave.com
I’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL.
Sponsors
The following is a list of sponsors that helped fund the event: