SQLSaturday #85 - Orlando 2011
Event Date: 09/24/2011 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: Reporting Services Deep Dive
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 deep dive 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. ** This session is SQLSaturday favorite and is always packed full. Don’t miss it **
Speaker(s):
- Brian K McDonald
Track and Room: BI 2 - N/A
Title: You’re My Density: Making Sense of Statistics
Abstract: The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
Speaker(s):
- Erin Stellato
Track and Room: Performance - N/A
Title: Rapidly Deploying SQL Server with PowerShell
Abstract: As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours.
Speaker(s):
- Michael Wells
Track and Room: Misc - N/A
Title: 0 to SSRS Presentation
Abstract: In this presentation I will show you how to create a simple report and deploy the report to the Report Server using SQL Server Business Intelligence Development Studio(BIDS).
Speaker(s):
- David Liebman
Track and Room: BI 1 - N/A
Title: Revenge: The SQL!
Abstract: Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you’ll ache for the chance!
Speaker(s):
- Rob Volk
Track and Room: DBA 2 - N/A
Title: PowerPivot: BI Massive Data Analysis for Humans
Abstract: The paradox of Business Intelligence: it’s one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience ( range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q’s as you can muster :)
Speaker(s):
- Rob Collie
Track and Room: BI 1 - N/A
Title: Dynamic SSIS: Configs, Expressions and Variables
Abstract: One of the biggest hurdles in any organization is migrating from DEV to PROD with minimal issues. In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier. Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables. After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration. At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package!
Speaker(s):
- Bradley Schacht
Track and Room: SSIS - N/A
Title: Reporting in Silverlight
Abstract:
Join Russ Fustino as he takes a tour of the new ActiveReports 6 Silverlight Report Viewer. Now all the power of reporting the award winning ActiveReports for Windows and ASP.NET, is now available in Silverlight!
He will show how this component is designed for reporting in Microsoft Silverlight 4 and higher. See how the Silverlight Report Viewer is simple, lightweight, flexible, localizable, and easy to customize for quick end user deployment. It includes these features:
?Preview reports loaded from a file, document stream, ASPX page, RPX Handler, or WCF service.
?End-user toolbar with Table of Contents (TOC), Thumbnails, Print, Search, Zoom, and Navigation buttons, plus you can add your own custom buttons.
*And More!
Speaker(s):
- Russell Fustino
Track and Room: DBA 1 - N/A
Title: Page Row Compression Deep Dive
Abstract: Page and Row Compression are powerful new tools. Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. We can turn it on, we can turn it off, but we want more! What are Access Methods and how in the SQL Engine do they affect Compression? What are the “Gotchas” of Page Compression? How does Compression differ in the way it treats Non-Leaf Leaf Level pages? What additional functionality did we get in DBCC Page, DMV’s, Perfmon Counters, and Extended Events to support our usage of Compression? How do complex query plans affect Compression? Come find out!
Speaker(s):
- Bradley Ball
Track and Room: DBA 2 - N/A
Title: Powershell by Example
Abstract: I’ll review several intermediate PowerShell script examples that a DBA can use to automate repetitive tasks on multiple servers. Examples will include but not limited to, how to chart database growth, check how cluttered msdb is, check security configurations, create a login and set permissions.
Speaker(s):
- Ronald Dameron
Track and Room: Misc - 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 demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS.
Speaker(s):
- Bradley Schacht
Track and Room: SSIS - N/A
Title: Biz Intel Dashboards W/Excel OLAP formulas
Abstract: I will demonstrate how to develop MS Excel BI Dashboards in the following ways:
- Workbook style with Office data connections stored on local PC or networked document drive
- excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render
- Convert excel pivot table into excel OLAP formulas
- Discuss SP 2010 BI Center
- Discuss references to cap off session.
Speaker(s):
- Phillip E Rosen
Track and Room: BI 2 - N/A
Title: Data Sharding in OLTP Systems
Abstract: One of the biggest challenges for modern OLTP Systems is the amount of data needed to be collected and processed. Business requirements, industry standards and regulations require systems to retain enormous amount of information. Offline data archiving is not often an option especially with the hosted solutions - customers expect old data to be available on the fly. Keeping all data in the single instance of SQL Server is the most expensive option from hardware cost and management standpoints.
This session demonstrates several data sharding techniques that can be used to partition the data across multiple database servers focusing on the task of separating production and historical data in OLTP systems
Speaker(s):
- Dmitri Korotkevitch
Track and Room: DBA 1 - N/A
Title: Sql Server On VMware???
Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker(s):
- Janis Griffin
Track and Room: DBA 2 - 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: BI 2 - N/A
Title: Where to with NoSql
Abstract: The session will look at ways that the Sql and NoSql worlds can fit together. It will cover some of the major NoSql offerings such as Cassandra, MongoDb and Hadoop, and present some idea on how Sql fits with these non-Sql stores. It will particularly emphasize hadoop and some of the problems and opportunities offered by mixing hadoop and sql.
Speaker(s):
- patrick thompson
Track and Room: DBA 1 - N/A
Title: T-SQL Enhancements in Denali
Abstract: Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions.
Speaker(s):
- Plamen Ratchev
Track and Room: DBA 2 - N/A
Title: T-SQL Alphabet Soup
Abstract: Come see the quick brown fox jump over the lazy dog in creative T-SQL coding ways and possibly learn a few obscure commands you were not familiar with. This session will show 26 unique quries using T-SQL keywords that start with every letter of the alphabet.
Speaker(s):
- Rodney Landrum
Track and Room: DBA 1 - N/A
Title: SSRS Subscriptions
Abstract: Join Kyle’s session on SSRS subscriptions! In this session, you will get a chance to see some real world subscription requests and how to implement them. Some requests, which are common across a lot of businesses, fall outside of the functionality of Reporting Services so this session will also require some knowledge of SSIS.
Speaker(s):
- Kyle Walker
Track and Room: BI 1 - N/A
Title: Storing PowerShell Output
Abstract: You’ve run PowerShell scripts and need to store the output . In this session we’ll look at sending Powershell output to text, CSV, HTML, Excel, and SQL Server data sources.
Speaker(s):
- Chad Miller
Track and Room: Misc - N/A
Title: Using Script Task and Components in SSIS
Abstract: Mike shows you how to build script tasks in the control flow and Script components in the data flow of an SSIS package. If there is not a task in the toolbox that can do what you need, then a script task or component is used to complete these steps. Learn when to use them and when not to use them.
Speaker(s):
- Mike Davis
Track and Room: SSIS - N/A
Title: Advancing Data Storage for Databases
Abstract: Nimble Storage, launched by the co-founders of NetApp and Data Domain, has built a purpose-built storage architecture that integrates flash memory and high-capacity disk for the first time, combining primary storage, backup, replication, and disaster recovery in a single “converged” solution. Join this informative session where you will review the evolution of data storage and protection, learn about Nimble Storage’s breakthrough solution for SQL Server environments, and review real-world case studies that demonstrate its performance and reliability.
Speaker(s):
- Chris Wolfley
Track and Room: BI 1 - N/A
Title: Loading a Data Warehouse with SSIS
Abstract: You’ve just been assigned a data warehouse project. Maybe you’ve figured out what tables you want to work with, but outside of that you don’t really know how to get started. In this session you’ll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform.
Speaker(s):
- Robert Biddle
Track and Room: BI 2 - N/A
Title: Introduction to Execution Plan
Abstract: Every wonder what the database engine does when you run a proc? Want to know what is causing the procedure or sql statement to run really slow? This session with provide you with a start to understanding both of these.
Speaker(s):
- Nathan Heaivilin
Track and Room: Performance - N/A
Title: Upgrade Roadmap: Taking YOU to R2
Abstract: A Review of the upgrade process to SQL Server 2008 R2. A checklist of considerations for things a company would likely encounter coming from SQL Server 2000 or 2005. The Pros and Cons of in-place upgrades vs. the Build-out-new approach. There will also be some lessons learned sprinkled in as the presenter has personally led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor. Enterprise interfaces and stuff you will see in the real world, deprecated features and how to test for them
Speaker(s):
- Craig Purnell
Track and Room: DBA 2 - N/A
Title: SQL Azure Performance Considerations
Abstract: In this session we will dive in the world of Azure, the Cloud Computing offering from Microsoft. We will take a look at SQL Azure from an application design perspective including design options, scalability and performance. If you are wondering what SQL Azure can do for you, how to best leverage it from a performance and scalability standpoint, and it compares to SQL Server, then this session is for you!
Speaker(s):
- Herve Roggero
Track and Room: Performance - N/A
Title: Building a Professional Development Plan
Abstract: A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
Speaker(s):
- Andy Warren
Track and Room: Misc - N/A
Title: Performance Management – 2008 MDW - How Why
Abstract: Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.
Speaker(s):
- Janis Griffin
Track and Room: Performance - N/A
Title: Data Conversions: Steps, Tips and Best Practices
Abstract: In this session, we will cover the various stages/steps of a data conversion project including concept, project planning, analysis, development and QA. We will also discuss some best practices, and other considerations that might not be directly a part of the data conversion, but is related to, or can be impacted by it.
Speaker(s):
- Norm Bowen
Track and Room: DBA 1 - N/A
Title: Working With XML In SQL Server
Abstract: XML is a technology that Developers and DBAs alike share a love-hate relationship with; it’s powerful and flexible yet it can be bloated and difficult to work with at the same time. Regardless, XML has found a home in many applications - including SQL Server (e.g. execution plans) - so it’s important to understand how to work with it in your databases. This session will show you how to use the XML data type, perform basic operations on XML data, and how to use FOR XML to create XML from relational data. This isn’t a session to convince you to use XML, but to show you what you can do with XML when you do need to use it!
Speaker(s):
- Kendal Van Dyke
Track and Room: DBA 1 - N/A
Title: Extend your T-SQL Scripting with PowerShell
Abstract: I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.
Speaker(s):
- Maximo Trinidad
Track and Room: Misc - N/A
Title: From Ground to Cloud for Databases
Abstract: The cloud! Move everything to the cloud! No, wait, the cloud is awful! Don’t move anything to the cloud! Wait – what’s “the cloud”? Buck Woody, Microsoft’s “Real World DBA” will show you how to figure out where your data should live, based on actual decision points. You’ll learn about Windows and SQL Azure, and when it makes sense to put data locally or remotely.
Speaker(s):
- Buck Woody
Track and Room: DBA 2 - N/A
Title: Useful tools for a DBA and or Database Developer
Abstract: Just like any good tradesman understanding your tools is key to getting the job done accurately and timely. Are you Database Developer or DBA? If so are you familiar with the out of the box tools provide to us by Microsoft? During this session I will walk thru some of the SSMS tools I find useful and help me get the job done in an accurate and timely manner. We will also walk thru some of the tools shared with the development teams which they have found useful to complete their daily tasks.
Speaker(s):
- Daniel Taylor
Track and Room: DBA 2 - N/A
Title: SSIShare The Code Man
Abstract:
For many SSIS scenarios, a desired outcome is to implement logic or rules that are used in existing enterprise applications, only to do so in an a bulk data loading scenario. Many times the logic being applied is complex and multi-step. We will examine various scenarios where complex logic from shared code sources can be applied in SSIS processing scenarios.
1 How to use code from shared enterprise sources
- How to implement external code in script component
- How to implement external code in sql CLR
- Performance comparison.
Speaker(s):
- James McAuliffe
Track and Room: SSIS - N/A
Title: The Fundamentals of DBA-ism
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: DBA 1 - N/A
Title: Analysis - 0 to PowerPivot
Abstract: In this session, the attehdees will learn how to drive and build a PowerPivot solution and reports as they rotate through the podium as volunteers.
Speaker(s):
- Adam Jorgensen
Track and Room: BI 2 - N/A
Title: Mission Possible: Pervasive BI
Abstract: Making Business Intelligence pervasive throughout an organization has proven to be the “Holy Grail” for many companies – recognized as of immense value but also difficult to attain. In this session we will take a look at the definition, benefits, obstacles, and requirements of Pervasive BI, as well as techniques and technologies which have made SQL Server-based Pervasive BI a “Mission Possible” for many organizations. We will then take a look at a case study of a large internal corporate deployment of Pervasive BI built on SQL Server Analysis Services.
Speaker(s):
- Bob Abernethy
Track and Room: BI 1 - N/A
Title: SQL Smackdown SSIS vs T-SQL
Abstract: In this session, you’ll learn how to load a Data Warehouse using SQL Server Integration Services (SSIS) and T-SQL. You’ll see a battle between two database experts (Mike Davis and Luis E Figueroa), attempting to load the data warehouse 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):
- Mike Davis
Track and Room: SSIS - N/A
Title: Parallel Query Execution Deep Dive
Abstract: What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it’s use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker(s):
- Kevin Boles
Track and Room: Performance - N/A
Title: Becoming DAX: An Introduction …
Abstract: The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions.
Speaker(s):
- William E Pearson III
Track and Room: BI 1 - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: Performance - N/A
Title: SSIS Data Flow Buffer Breakdown
Abstract: This session will examine the different types of data flow components, execution trees, data buffers, performance metrics and logging mechanisms. In determining how the buffers are built and used, the developer will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The developer will further learn how to capture performance metrics to identifiably track these impacts. Finally, the session will take a look at the controls and effects of parallel package and parallel task execution.
Speaker(s):
- Eric Wisdahl
Track and Room: SSIS - 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: BI 1 - 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 Server environment using this awesome new feature!
Speaker(s):
- Jorge Segarra
Track and Room: Misc - N/A
Title: Transaction Log Deep Dive
Abstract: Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
Speaker(s):
- Kevin Boles
Track and Room: Performance - N/A
Title: Getting Started with MDX
Abstract: In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s):
- William E Pearson III
Track and Room: BI 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.
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).
Russell Fustino
Contact: http://www.clubfarpoint.com/Forums/blogs/russells_blog/
Russ Fustino heads up Developer Evangelism at ComponentOne as a Senior Developer Evangelist. He is also a highly experienced Windows Phone 7 software developer with a passion for conveying relevant, current, and future software development technologies and tools through live seminars, teaching, and internet video productions. Russ has a new innovative blog and interview video series with influentials, about current technology, ComponentOne products and developer community called ‘Russ Cam’!
Bob Abernethy
Contact: http://www.strategycompanion.com/m_home.aspx
Bob Abernethy is SVP GM of Strategy Companion Corporation. A veteran of Oracle Corporation and Siebel Systems, Bob brings over twenty years of software industry experience to his discussions with customers about their Business Intelligence implementations. Most recently, Bob has worked closely with many Fortune 500 and mid-sized companies on the deployment of Strategy Companion’s Analyzer BI solution.
Kyle Walker
I am a business intelligence consultant working for Pragmatic Works Consulting. I have a primary focus in SSIS and Data Warehouse development. I also have experience with SSRS and Crystal Report with Business Objects.
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.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Buck Woody
Twitter: - BuckWoodyMSFT
LinkedIn: Buck Woody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
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.
William E Pearson III
Twitter: - @Bill_Pearson
LinkedIn: William E Pearson III
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
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.
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.
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.
Brian K McDonald
Brian K. McDonald, MCDBA, MCSD is an Independent Business Intelligence consultant. Brian has served in many roles over his 14+ years in the IT industry. Brian was the lead author on Pro SQL Server 2012 Reporting Services (Apress) book, has written featured articles for industry leading websites and blogs on SQLServerCentral, SQLServerPedia and BIDN. Brian is an active member of the community and has presented at User groups, Code Camps, SQL Rally and SQLSaturday events across the South East.
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
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.
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).
Phillip E Rosen
Phillip E. Rosen is a Business Intelligence (BI) Developer who lives in the Miami, Florida area where he retired from the United States Marine Corps after 20 years of arduous service around the globe, combat tours in Operation Desert Storm 1991, Operation Iraqi Freedom 2004. He is a service disabled veteran who is employed as a virtual civil servant with the Department of Veteran’s Health Administration (VHA) based in Reno, Nevada. Phil conducts local and virtual training events/sessions for VHA BI developers employees about SQL Server 2008R2 Reporting Services, T-SQL queries, performance tuning and dashboards that are connected to analysis services data cubes. He has 3 years of experience developing BI dashboards using MS Excel which are rendered in Share Point Excel Services and as Excel workbooks for executive leadership to make efficient timely decision about finical, personnel staffing, and budgeting. Phillip has a wide range of BI experience with SQL Server as an accidental database administrator/developer of an instance of Microsoft SQL Server 2008 managing, maintaining, and updating it. His daily duties/responsibilities require the use of SQL Server 2008R2 client tools; Visual Studio 2008 Business Intelligence Development Studio (BIDS) and SQL Server Management Studio writing Transact-SQL (T-SQL) queries to develop ad hoc and custom reports. Phil enjoys discussing and learning about MS BI, applications tools.
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
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.
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
Rob Collie
Contact: http://powerpivotpro.com
Rob Collie is founder of PowerPivotPro, the 1st fully agile BI consulting firm that empowers companies to spur smarter business decisions in a fraction of the time and cost. A BI and analytics engineering leader during his 14-year career at Microsoft, Rob knows how to give companies a competitive advantage, and is a firm believer in creating solutions that can be replicated long after the partnership ends. Collie’s passion is to replace the methodologies of the traditional BI industry with business-empowered, immediate-impact tactics made possible by the recent breakthroughs in software, like Power BI. Author of 3 books, including the world’s No. 1-selling Power BI book, over 600 articles and whitepapers. https://powerpivotpro.com/
Herve Roggero
Twitter: - @hroggero
Contact: http://geekswithblogs.net/hroggero
Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.
Daniel Taylor
Twitter: - @DBABulldog
LinkedIn: Daniel Taylor
Contact: http://dbabulldog.wordpress.com/
Daniel Taylor started his DBA life at Nielsen Media Research Company working with Sybase ASE 11 thru 12.5, Sybase IQ, eventually moving to SQL server. Daniel has worked with SQL Server versions from 7.0 to 20012. Daniel also worked for Publix as Senior DBA, Technical Specialist and was the SQL Server team lead that supported over 2000 instances of SQL Server. Currently Daniel is a Sr. SQL Database Specialist at New York Life Tampa Division. You can find him on Twitter as @DBABullDog.
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” .
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.
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.
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.
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.
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
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.
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!
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.”
patrick thompson
Contact: http://www.standingwaiting.com
see http://www.standingwaiting.com/Resume/Resume.html
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.
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.
Michael Wells
Twitter: - @SqlTechMike
LinkedIn: Michael Wells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
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.
Chris Wolfley
Contact: http://www.nimblestorage.com/
Chris has spent 13 years in the technology field focusing on Server and Storage architectures. He has spent time working with customers and partners on designing enterprise solutions focused on effective data management and consolidation of server infrastructure. In his free time, Chris enjoys playing tennis and travelling throughout the Southeast.
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.
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.
Nathan Heaivilin
Just a DBA who wants to give back to the community in the way they have given to me and helped my development over the years.
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.
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.
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.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: