SQLSaturday #62 - Tampa 2011
Event Date: 01/15/2011 00:00:00
Event Location:
- K-Force
- 1001 East Palm Ave
- Tampa, 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: Creating a Metadata Mart w/ SSIS - Data Governance
Abstract: Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000’s of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts.
Speaker(s):
- Ira Warren
Track and Room: Track 7 - N/A
Title: Do You Know the Data Flow?
Abstract: The Data Flow task is one of the most powerful and most complex tools available in SSIS. Whether you are brand new to SSIS, or you’ve been using it for a while, it’s likely you’ve had some questions about the Data Flow. Why are some components so much slower than others? Why can’t I store a value (like a row count) in one component, and use it in another component later in the Data Flow? And why does it always seem to be the part of my package that fails when I run it against real data? Well, you’re not alone. During this session, we’ll answer these questions (and many others) by learning how the Data Flow operates internally. After attending this session, you’ll know a lot more about getting the most out of Data Flows in SSIS.
Speaker(s):
- John Welch
Track and Room: Track 1 - N/A
Title: DR Availability,You’re Wanted in the Recovery Room
Abstract: There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA’s) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, reasons for using each of them.
Speaker(s):
- Kendal Van Dyke
Track and Room: Track 5 - N/A
Title: DBA 101
Abstract: When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
Speaker(s):
- Don Stevic
Track and Room: Track 2 - N/A
Title: How SQL saved my Business Intelligence Platform
Abstract: The capabilities of SQL are appreciated by the PASS community, but when the end users express their love for SQL, that is pretty amazing. SQL 2005 actually saved a BI deployment from becoming an utter disaster and flipped it to an enormous success. We will explore the previous data model and how the adaptability of SQL made changes to the front end (changing from standard html output to allowing RIA and Ajax design tools) and extension of user capabilities possible without degrading performance or burdening the developers.
Speaker(s):
- Scott Schledwitz
Track and Room: Track 3 - N/A
Title: Revive the code: refactoring for performance
Abstract: Stored procedures are slow? SQL Server is overloaded? Maybe it’s time to upgrade the server. But maybe all you need to do is the code refactoring.
This session shows how to replace several common procedural style patterns in T-SQL code with set-based approaches. It demonstrates how to gain huge performance improvements using CTE, table-valued functions, TVP, MERGE operator, OUTPUT clause and other modern T-SQL constructs. No PowerPoint slides. Presentation is based on the real examples and real code.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Track 4 - N/A
Title: Developing Date and Role-Playing Dimensions
Abstract: Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions.
Speaker(s):
- Sandra Mueller
Track and Room: Track 3 - N/A
Title: Introduction to PowerPivot for Excel
Abstract: This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
Speaker(s):
- Michael Antonovich
Track and Room: Track 3 - N/A
Title: Building Hierarchy Solutions with SQL Server 2008
Abstract: Hierarchical solutions used to be “reserved” for experts in the theory of trees and graphs. Not anymore! Learn how the new data type HIERARCHYID in SQL Server 2008 helps to simplify storage and manipulation of hierarchies. Practical examples and comparison with traditional methods like nested sets, adjacency list, and materialized path.
Speaker(s):
- Plamen Ratchev
Track and Room: Track 2 - N/A
Title: Accelerating BI Development with BI xPress
Abstract: In this session, Brian Knight will show you how to accelerate your BI development lifecycle with BI xPress. You’ll see how to implement advanced SSIS frameworks, implement code reusability in SSIS and write MDX calculation code in seconds with this must have time saving application.
Speaker(s):
- Brian Knight
Track and Room: Track 2 - N/A
Title: Why Learn PowerShell?
Abstract: I will detail my reasoning why any IT Pro working in the Microsoft space would benefit from learning PowerShell. I will demonstrate how you can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage your workload. I will also share my thoughts on the best ways to learn PowerShell.
Speaker(s):
- Ronald Dameron
Track and Room: Track 5 - N/A
Title: Policy-Based Management in a Nutshell
Abstract: We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!
Speaker(s):
- Jorge Segarra
Track and Room: Track 6 - N/A
Title: SQL Smackdown: SSIS vs. PowerShell
Abstract: In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You’ll see a battle between two database experts (Mike Davis and Aaron Nelson), attempting to load the database in the fastest, simplest, and most reliable way. You’ll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the SQL Smackdown.
Speaker(s):
- Aaron Nelson
Track and Room: Track 1 - N/A
Title: MDX 201
Abstract: Intermediate MDX. Calculations, subselect, subcubes, MDX extensions. The subsequent session to “MDX 101”.
Speaker(s):
- Mark Landry
Track and Room: Track 6 - N/A
Title: Introduction to SSIS
Abstract: In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demostrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS. Co-Presenter: Sherri McDonald
Speaker(s):
- Bradley Schacht
Track and Room: Track 1 - N/A
Title: Spatial Data in SQL 2008 and Bing
Abstract: A demonstration of SQL Geography Data Type in SQL Server 2008. We will constuct queries to easily match data by geographic location. Then we will wire this query up to an ASP.Net using Javascript and Handlers. Finally, we will wire this query up to a windows phone 7 device.
Speaker(s):
- Michael Stark
Track and Room: Track 7 - N/A
Title: Introduction to Transactional Replication
Abstract: SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.
Speaker(s):
- Troy Gallant
Track and Room: Track 6 - N/A
Title: Troubleshooting with the SQL Server 2008 DC MDW
Abstract: In this session you will learn about the SQL Server 2008 R2 data collector and management data warehouse for troubleshooting your problem situations with your SQL Server. I’ll demonstrate several problem scenarios and how the MDW reports can help you identify the root cause.
Speaker(s):
- Bill Ramos
Track and Room: Track 2 - N/A
Title: Reporting Services 2008
Abstract: SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this introductory session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access.
Speaker(s):
- Brian McDonald
Track and Room: Track 4 - N/A
Title: Page And Row Compression How, When, and Why
Abstract: Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.
Speaker(s):
- Bradley Ball
Track and Room: Track 2 - N/A
Title: SSIS and SSRS Better Together
Abstract: SQL Server Integration Services (SSIS) and Reporting Services (SSRS) are two pillars of Microsoft’s Business Intelligence stack: SSIS gathering the data and SSRS displaying the data. Do you know that SSRS provides a set of Web Services that SSIS can use to manage and even render SSRS reports? In this session we will develop an SSIS package that exports an SSRS report to pdf format using these Web Services. Then we will use the SSRS Web Services in a Data Flow Script Component to get data from a report.
Speaker(s):
- Russel Loski
Track and Room: Track 4 - N/A
Title: SQL Server Auditing 101
Abstract: Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008.
Speaker(s):
- Jonathan Kehayias
Track and Room: Track 4 - N/A
Title: Become a Bilingual DBA! Oracle for the SQL Server
Abstract: In today’s enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA’s for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two.
Speaker(s):
- Randy Knight
Track and Room: Track 6 - N/A
Title: Iron Chef SQL Server
Abstract: In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You’ll see a battle between two SSIS experts (Adam Jorgensen and a surprise guest GURU), attempting to load the data warehouse the best way. You’ll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition.
Speaker(s):
- Adam Jorgensen
Track and Room: Track 1 - N/A
Title: Where should I be encrypting my data
Abstract: In this session we’ll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.
Speaker(s):
- Denny Cherry
Track and Room: Track 5 - N/A
Title: SSIS Cafeteria
Abstract: SSIS can be tricky sometimes. You’ve probably encountered some behaviours that make you scratch your head, throw up your hands, or even something unprintable. Well, me too!. Over the years of working with SSIS, I have acquired a collection of tips and tricks around areas like: Working with Excel, both as a source and destination, why does this package run so fast on this server and not even run on this other one? How can I compare packages? We will start the session by selecting , cafeteria style, from the topics of interest to the attendees, pick four or five, and drill down from there. Bring your questions!
Speaker(s):
- James McAuliffe
Track and Room: Track 1 - N/A
Title: Cool Tricks to Pull from your SSIS Hat:
Abstract: Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer new to SSIS who has mastered the dataflow, and is now looking for elegant ways to automate his/her solutions. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions. It will demonstrate short case studies of commonly encountered, real world business scenarios and solutions.
Speaker(s):
- Julie Smith
Track and Room: Track 1 - N/A
Title: Bad SQL
Abstract: How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
Speaker(s):
- Geoff Hiten
Track and Room: Track 3 - N/A
Title: Implementing auditing in SQL Server
Abstract: SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
Speaker(s):
- David Dye
Track and Room: Track 4 - N/A
Title: SQL Server 2008 R2 Parallel Data Warehouse
Abstract: We will cover an overview of the functionality of SQL PDW. PDW is a highly scalable appliance for Enterprise data warehousing. We will discuss how PDW partitions large tables across multiple physical nodes, each having its own dedicated CPU, memory, storage, and each running its own instance of SQL Server in a parallel shared nothing design.
Speaker(s):
- Brian Mitchell
Track and Room: Track 3 - N/A
Title: SQL Server Memory Deep Dive
Abstract: Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server’s health and performance.
Speaker(s):
- Kevin Boles
Track and Room: Track 6 - N/A
Title: Sql Server Service Broker - An Overview
Abstract: Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures.
Speaker(s):
- Janis Griffin
Track and Room: Track 7 - N/A
Title: Efficient Datawarehouse Design
Abstract: Design tips and tricks on implementing enterprise datawarehose and common pitfalls to avoid. This session also provides the realworld examples
Speaker(s):
- Dr. Suresh Rajappa
Track and Room: Track 2 - 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
Speaker(s):
- Jeffrey Garbus
Track and Room: Track 3 - N/A
Title: To click or to type, that is the question
Abstract: When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee’s Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.
Speaker(s):
- David Taylor
Track and Room: Track 7 - N/A
Title: You inherited a database Now What?
Abstract: You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited.
Speaker(s):
- Tim Radney
Track and Room: Track 5 - N/A
Title: SSIS Data Flow Buffer Breakdown
Abstract: An advanced session which will attempt to break down areas of the data flow buffer. In examining how the buffers are built and used, the user will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The session will further take a look at the effects of parallel package and parallel task execution.
Speaker(s):
- Eric Wisdahl
Track and Room: Track 6 - N/A
Title: SQL Server PowerShell Extensions (SQLPSX)
Abstract: In this sesssion we will look at how the CodeProject SQLPSX can be used for real world PowerShell automation. Specific topics covered include using ADO.NET, retrieving SQL Server information, SSIS administration, Policy-Based Management and SQLIse a WPF-based query tool.
Speaker(s):
- Chad Miller
Track and Room: Track 5 - N/A
Title: ITIL V3 for the Database Administrator
Abstract: Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework.
Speaker(s):
- Timothy McAliley
Track and Room: Track 7 - N/A
Title: Windows PowerShell 2.0 Best Practices for DBA’s
Abstract: Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences
Speaker(s):
- Ed Wilson
Track and Room: Track 5 - N/A
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract: At its heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
Speaker(s):
- Rodney Landrum
Track and Room: Track 4 - N/A
Title: Find Performance Problems by Reading the Waits
Abstract: Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing!
Speaker(s):
- Eddie Wuerch
Track and Room: Track 7 - N/A
Title: Why I Use Stored Procedures
Abstract: In today’s environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework. Jack will share the reasons why he still believes that stored procedures are the best way to access data in SQL Server. When the session is over you will be able to discuss the issues with developers and have resources to show why you think stored procedures can improve application performance, data security, and code maintenance.
Speaker(s):
- Jack Corbett
Track and Room: Track 2 - 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.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Bradley Ball
Contact: http://www.SQLBalls.com
Bradley Ball is a MCITP SQL 2005 MCTS 2008 DBA with over 10 years of IT experience. Bradley 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. He is currently a Sr. SQL DBA Staff Specialist for Publix Supermarkets. He has presented at SQLSaturdays 62, 74, 79, 85 for the MAGICPASS OPASS SSUG’s, SQL Rally, and at the PASS Summit in 2011. Bradley can be found blogging on http://www.sqlballs.com
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.”
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.
Bradley Schacht
Contact: http://www.bradleyschacht.com
Bradley is a consultant at Pragmatic Works in Jacksonville, FL. He was an author on the book SharePoint 2010 Business Intelligence 24-Hour Trainer. Bradley has experience on many part of the Microsoft BI platform. He has spoken at events like SQLSaturday, Code Camp, SQL Lunch and SQL Server User Groups. He is a contributor on sites such as BIDN.com and SQL Server Central as well as an active member of the Jacksonville SQL Server User Group (JSSUG).
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.
Brian McDonald
Twitter: - @briankmcdonald
Contact: http://www.sqlbigeek.com
Brian K. McDonald, MCDBA, MCSD is a Business Intelligence Consultant. Brian has experience in Database Administration, SQL Server Reporting Services, SQL Server Integration Services and Analysis Services. He has worked as an Application Developer, Network Administrator and a Database Administrator throughout his 11 years in the IT industry. He even spent a year on a large Help Desk operation a long, long time ago. Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written articles for industry websites and continually strives to learn more and become a better version of himself. Brian is an active member of the Jacksonville SQL Server User’s Group and has presented at User group meetings, Code Camps, many SQLSaturdays and SQL Rally events across Florida and South Carolina.
Jonathan Kehayias
Twitter: - @SQLPoolBoy
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Russel Loski
Twitter: - sqlmovers
LinkedIn: Russel Loski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
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.
Brian Mitchell
Twitter: - @brianwmitchell
LinkedIn: Brian Mitchell
Contact: http://brianwmitchell.com
Brian Mitchell, an MCM - SQL 2008 with a MBA from the University of Florida, is a Senior Consultant in the Microsoft Big Data Center of Expertise, where he focuses on SQL Server Parallel Data Warehouse, HDInsight, and Microsoft Business Intelligence. Brian has spent countless hours onsite at customer sites delivering Microsoft database and BI solutions. He has extensive experience creating and delivering advanced training for the full range of the Microsoft BI stack, with a particular passion for Analysis Services and Reporting Services.
Brian has presented at TechEd, PASS Summit, SQLRally, and several SQLSaturdays and SQL Server user groups. You can read more about his deep involvement in Microsoft data technologies at http://brianwmitchell.com.
Michael Antonovich
Twitter: - @SharePointMikeA
LinkedIn: Michael Antonovich
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
Chad Miller
Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQLSaturdays and Code Camps.
Ronald Dameron
Twitter: - @RonDBA
LinkedIn: Ronald Dameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.
He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.
He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.
He is most active on Twitter as @RonDBA.
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.
Scott Schledwitz
Contact: http://ecuity.wordpress.com
Senior Consultant in BI and Data Architecture for Information Builders. * Deploy solutions to clients in the grovernment, financial services and healthcare sectors. * Developed the ARRA Fund Manager, a compliance reporting tool used by states and municipalities for federal funds reporting. * Author of ‘No Nerds’ and ‘The Brave, New Front’ - articles printed in Computerworld. * 2010 Recipient of the Business Intelligence Competency Center Visionary Award.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Bill Ramos
Contact: http://blogs.msdn.com/billramo
I'm currently a Work Stream Manager for Advaiya. During my 15 years at Microsoft as a program manager, I shipped or been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Ashton-Tate/Microsoft SQL Server for OS2 (at Ashton-Tate), Excel 2003, Access 2003, Access XP, Access 2000,
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.
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
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” .
David Dye
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
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.
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.
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
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Sandra Mueller
Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions.
Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQLSaturday events and supports her local community by speaking, volunteering and attending regional chapters.
Ed Wilson
Twitter: - ScriptingGuys
LinkedIn: Ed Wilson
Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog
Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd, Tech Ready, Geek Ready, SQL Rally and various SQLSaturday conferences. A Microsoft-certified trainer he has taught scripting to Microsoft Premier Customers worldwide. He has written 11 books including 9 on Windows scripting that were published by Microsoft Press. His Windows PowerShell 3.0 Step by Step for MSPress is a current best seller.
James McAuliffe
LinkedIn: James McAuliffe
James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!
Michael Stark
Michael Stark has been developing software since 1992. He has worked for both large and small companies. He has worked in a variety of platforms and environments. He prefers the newer technologies and enjoys learning new skills and applying them as solutions to existing processes. He prefers client facing software development projects. He gets personal satisfaction with build products that make business life easier for the end user. Mr. Stark is originally from Miami, Florida and currently resides in Tampa, Florida. In between the two he has live in Atlanta, Detroit, Deland, and Madrid Spain.
Geoff Hiten
Twitter: - SQLCraftsman
LinkedIn: Geoff Hiten
Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.
David Taylor
Contact: http://dyfhid.wordpress.com
David is an DBA/Developer for a private educational institution in New Hampshire. David has five years of experience learning and administering SQL Server and more recently developing BI solutions using SSIS. Having earned both his MCTS and MCITP DBA certifications for SQL Server 2008, he still considers himself a beginner sharing with other beginners.
Denny Cherry
Twitter: - mrdenny
LinkedIn: Denny Cherry
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Troy Gallant
Contact: http://www.troygallant.com
Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.
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 Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Don Stevic
Twitter: - https://twitter.com/DonStevic
LinkedIn: Don Stevic
I have spent the last 16 years of my life living, learning and teaching SQL Server. I am currently a Principal DBA at SAIC, and I teach online DBA courses at BYU-Idaho. My life before all this was as a high school Drama teacher here in Florida. It might seem an odd transition, but it really isn’t. To me, part of being a great DBA is embracing the artistry of the process. How the design of a database ebbs and flows into its final form. So, I guess you could say I am a SQL artist.
Mark Landry
Mark Landry has over thirty years of experience in software development.
He has been an independent software consultant for fifteen years specializing in object-oriented design and programming, relational and multidimensional database design, and data warehousing. He is considered a regional expert in Analysis Services.
Mr. Landry holds Bachelors and Masters Degrees in Computer Science.
Dr. Suresh Rajappa
LinkedIn: Dr. Suresh Rajappa
Suresh Rajappa is a Principal @ Intellisee Group focusing on Enterprise Performance Management, Big Data, Business Analytics and In-memory computing. He has 20 years of experience in databases and Business intelligence. He holds a PhD in Data Mining and MBA degree in Strategy and Finance.
He had spoken in various SQLSaturday sessions across the country.
Sponsors
The following is a list of sponsors that helped fund the event: