SQLSaturday #110 - Tampa 2012
Event Date: 03/10/2012 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: Building Your Own SQL Server Virtual Playground
Abstract: As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn’t enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up clustering? Or maybe you want to try out the latest SQL 2012 release candidate…virtualization offers a convenient way to do any or all of these. In this session we’ll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
Speaker(s):
- Kendal Van Dyke
Track and Room: - N/A
Title: SQL Server Security for Developers
Abstract: SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don’t see the point in applying such granular security. In this introductory level presentation we’ll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we’ll talk about why its so important to set security at the database and not just rely on the application enforced security.
Speaker(s):
- Andy Warren
Track and Room: - N/A
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 McDonald
Track and Room: - N/A
Title: Running SQL Server 2012 on Server Core: Why How
Abstract: Do you cringe every time “Patch Tuesday” rolls around? Does the idea of applying 70-80% fewer Windows patches on your SQL Servers appeal to you? Join us and learn about this and other benefits that can be achieved by running SQL Server 2012 (Denali) on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to.
Speaker(s):
- Michael Wells
Track and Room: - N/A
Title: Tame Your Unruly Data…With Constraints!
Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
Speaker(s):
- Rob Volk
Track and Room: - N/A
Title: It’s In There Somewhere!
Abstract: FileTable and Statistical Semantic Search In SQL 2012 It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. Using the new features of Statistical Semantic Search in SQL 2012 is like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will explore will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
Speaker(s):
- James McAuliffe
Track and Room: - N/A
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”
Speaker(s):
- Wayne Sheffield
Track and Room: - N/A
Title: Design and Implement BI Like Edison!
Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s):
- William E Pearson III
Track and Room: - N/A
Title: Service Broker - Why, When and Where?
Abstract: Messages, Queues, Contracts, Services, Routes, Endpoints, Transport and Dialog security…What could be easier to understand? While complexity of implementation is one of the factors that make us afraid of using service broker there is another one - we often don’t recognize the use cases where service broker would benefit a system.
This session focuses on the latter case. While it provides very high level overview of Service Broker Architecture, the goal of this presentation is to discuss WHEN to use Service Broker. This session outlines several service broker-friendly patterns and shows a few examples based on real life Service Broker implementations in both centralized and distributed systems.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: - N/A
Title: STOP! Consolidate and Listen!
Abstract: In today’s economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!
Speaker(s):
- Jorge Segarra
Track and Room: - N/A
Title: SQL Report Builder for Business Intelligence
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.
Speaker(s):
- David Eichner
Track and Room: - N/A
Title: Introduction to Execution Plan
Abstract: Ever wonder what happens when a query is processed? Got a process that is running slow at the office and your boss in looking at you for answers? Want to look like a hero to your boss for fixing something that no one else could figure out? Then you might want to consider this session. Execution plans tell you what steps were taken to generate the results sets you did. In analyzing these plans, you can figure out what you are doing that is not efficient, so you can fix it. This session will give you the foundation you will need to do analysis so you can write better code and help your company with their performance issues.
Speaker(s):
- Nathan Heaivilin
Track and Room: - N/A
Title: Little in the middle but got much [Write]Back
Abstract: Often missing from many BI projects is the ability for users to quickly and effectively submit data BACK to the reporting system. Luckily, when these reporting systems are built from a SSAS cube foundation, we have a potential answer.
Writeback is often an underused feature in SSAS cubes. In this session, attendees will learn how to create their own writeback partitions, and create end user interfaces to submit data to them in Excel. Also a deep-dive into the architecture of the writeback implementation in SSAS will be covered, as well as some limitations to the technology that are important to know before designing a solution.
Speaker(s):
- Josh Fennessy
Track and Room: - 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: - N/A
Title: Introduction to Master Data Services 2012
Abstract: Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization’s master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available out-of-the-box.
Speaker(s):
- Christopher Price
Track and Room: - N/A
Title: Introduction to Project Management
Abstract: The IT industry is now being dominated by projects. This session is designed to present a high-level foundational knowledge of the project management process as defined by the Project Management Institute. It will also focus on the tools that data professionals can use to deliver projects ontime and on budget.
Speaker(s):
- Richie Rump
Track and Room: - N/A
Title: Mobile Business Intelligence
Abstract: Get mobilized! Mobile business intelligence and mobile applications are hot in 2012. Learn how to leverage Microsoft Business Intelligence and SQL Server data platform technologies with a variety of mobile devices. The session will cover several options, tips, tricks, best practices and field lessons learned.
Speaker(s):
- Jen Underwood
Track and Room: - 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: - 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: - N/A
Title: What is BI Semantic Model and why should you care?
Abstract: Microsoft has shifted gears towards the new Business Intelligence Semantic Model (BISM) in SQL Server 2012. But what does it mean to Analysis Services cube developers? Join Jose to understand what BISM is and the Analysis Services roadmap. Jose will demo how to develop and deploy BISM models to the new Vertipaq engine and how to interface with them.
Speaker(s):
- Jose Chinchilla
Track and Room: - N/A
Title: What’s Buried in the Plan Cache?
Abstract: Creating a query plan can be a time consuming and expensive process. To avoid repeating these potentially costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.
Speaker(s):
- Christina Leo
Track and Room: - N/A
Title: Creating Dashboards with PerformancePoint Services
Abstract: Who wouldn’t want to create unbelievable dashboards that executives can get excited about? PerformancePoint Services is perfect tool for creating interactive dashboards viewable from inside SharePoint. In this session Devin will talk you through getting up and running with PerformancePoint and how to create a basic Dashboard including a KPI, Scorecard and Report.
Speaker(s):
- Devin Knight
Track and Room: - N/A
Title: Introduction to PowerShell Remoting
Abstract: The release of PowerShell version 2 introduced a new technology for managing Windows computers remotely. Everyone from desktop support to enterprise administrators can benefit from the capabilities available with PowerShell Remoting. Learn how it works, what it can do and why you want it enabled in your environment.
Speaker(s):
- Jason Hofferle
Track and Room: - N/A
Title: AlwaysOn - Finally, A usable ‘mirror’!
Abstract: In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic fail-over using a real web app to see how well this feature works.
Speaker(s):
- Jim Murphy
Track and Room: - N/A
Title: Index Internals
Abstract: This presentation looks behind the scenes of how SQL Server physically organizes the data on disk. We will talk about Heaps, B+Trees, RIDs, Keys, Seeks and Scans. The materials covered will allow you to make a more informed decision about what type of index to use when.
Speaker(s):
- Sebastian Meine
Track and Room: - N/A
Title: SkyDrive and Phone 7 App Photos!
Abstract: When you are working on a project that involves photos, where are you going to store your photos? How will you review your photos? A free solution would be nice, huh? ? Lots of storage would be nice as well! How about using photos in a Phone 7 app?Answer… SkyDrive. It’s great! It is a solution to for easy free way to share, print, download and review photos from just an individual, or from a team of multiple editors. To check, it out ahead of time, go to http://skydrive.live.com and the developer portal at: http://msdn.microsoft.com/en-us/windowslive. We will take a look at the SkyDrive Connect API’s and the SkyDrive Phone 7 app as well!
Speaker(s):
- Russell Fustino
Track and Room: - N/A
Title: Don’t Panic, DBAs! Databases on VMware made easy.
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: - N/A
Title: SQL 2012 DMV’s Extended Events
Abstract: As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV’s and Extended Events.
Speaker(s):
- Gareth Swanepoel
Track and Room: - N/A
Title: The Dirty Business of Auditing
Abstract: Auditing is often a dirty word among DBAs because it equates to more work with little perceived business value. However, auditing is a necessary evil for most businesses and it usually falls to the DBA to ensure SQL Server is properly audited. In this session we’ll look at what the operating system and SQL Server provide for us in order to meet the requirements of internal and external auditors, regulatory legislation, and even overbearing system owners who want to know everything about what’s going on in their application. We’ll consider what tools to use to quickly implement the properly level of auditing to meet the need.
Speaker(s):
- Brian Kelley
Track and Room: - N/A
Title: SQL - External Data Source for SharePoint Office
Abstract: In this session, we will examine how to create connections to an external data source (SQL Server) using SharePoint Designer. Once the External Data Content Type exists, we can display and manipulate the data within SharePoint using an External List. But you will see in this session that you can also surface the data to Outlook and use the data in a disconnected mode. You will also see how to use external data sources within a Word document template with the assistance of QuickParts. The final demonstration (time permitting) shows how you can use the external data in an InfoPath form.
Speaker(s):
- Michael Antonovich
Track and Room: - N/A
Title: SharePoint BI: The Basic Environment
Abstract: This session is an overview of the various BI solutions within SharePoint highlighting the scopes of each and who and what it takes to get them deployed. Starting with Excel, PowerPivot, Performance Point and InfoPath Services.
Speaker(s):
- Michael Hinckley
Track and Room: - N/A
Title: Rewriting bad T-SQL Code
Abstract: This session provides 2 case studies of poorly performing T-SQL code, and works through rewrites into better performing code.
Speaker(s):
- Jeffrey Garbus
Track and Room: - N/A
Title: BI in the Cloud
Abstract: In this session we will take a look at some strategies for building Business Intelligence solutions on the Windows Azure platform. We’ll see methods for transferring on-premises data to the cloud, report deployment to Windows Azure Reporting Services and options for performing ad-hoc analysis. We’ll look at some of the challenges faced when moving BI into the cloud, such as high-performance ETL, schema management and transient fault handling.
Speaker(s):
- David Liebman
Track and Room: - N/A
Title: PowerShell query for the T-SQL Developer
Abstract: This session will show the side-by-side similarity in building a PowerShell query vs T-SQL. I will demo some scripting techiniques in buidling a PowerShell query, building Hash table objects, ways to read and display the information. If the person knows how-to write T-SQL script, then it makes it easy to understand How-To write a PowerShell query.
Speaker(s):
- Maximo Trinidad
Track and Room: - N/A
Title: Fundamentals of Join Operations
Abstract: This is a wonderful session for those that don’t yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples. We will also show how bad performance can be when suboptimal joins are used.
Speaker(s):
- Kevin Boles
Track and Room: - N/A
Title: Super Fast Data Warehouse Dimension Loading
Abstract: In this session Luis will demonstrate how to use change tracking and Change Data Capture to very quickly update data warehouse dimensions. He will cover different SQL Server 2008 scenarios and the new Change Data Capture functionality in SSIS 2012.
Speaker(s):
- Luis Figueroa
Track and Room: - N/A
Title: Slowly Changing Dimensions
Abstract: Nearly every Data Warehouse, Data Mart, or OLAP Cube is challenged by changes over time. How do you report on a store that was in a different territory last year? What do you do when a product changes categories?
This session will show you how to design SQL Tables that model time and accurately model changes over time.
Speaker(s):
- Robert Hatton
Track and Room: - 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: - N/A
Title: Intro to SSRS
Abstract: Are you still ramping up on SSRS? In this session Chris will show you how to create your first SSRS report. In this session we will cover all of the basics including some best practices to get you up to speed when creating reports. This session was designed for someone with little to no experience with SSRS.
Speaker(s):
- Chris Albrektson
Track and Room: - N/A
Title: Design considerations for Enterprise datawarehouse
Abstract: This dession discusses the common design pitfalls when implementing EDW and how to avoid them. This session includes the realworld example too.
Speaker(s):
- Dr. Suresh Rajappa
Track and Room: - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: - 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.
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.
Jen Underwood
Twitter: - @idigdata
LinkedIn: Jen Underwood
Contact: http://www.impactanalytix.com/
Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.
Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
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.
Jose Chinchilla
Twitter: - SQLJoe
LinkedIn: Jose Chinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Brian Kelley
Twitter: - kbriankelley
LinkedIn: Brian Kelley
Contact: https://truthsolutions.wordpress.com/
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), accredited CISA trainer, and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, the Marathon of PASS, IT/Dev Connections, SQLConnections, the SSWUG Virtual Conferences, the Techno Security and Forensics Investigation
Jason Hofferle
Contact: http://www.hofferle.com
Jason is an IT Specialist for the US Department of Defense and has been an IT professional since 1997. His experience includes enterprise desktop engineering for a Fortune 500 financial institution and Active Directory design and support for local governments. He is currently a federal employee with the Defense Contract Management Agency, where he is a technical lead on Windows 7 and Virtual Desktop Infrastructure.
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.
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.”
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.
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.
Devin Knight
Twitter: - @knight_devin
LinkedIn: Devin Knight
Contact: http://devinknightsql.com
Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
Richie Rump
Twitter: - @jorriss
LinkedIn: Richie Rump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Robert Hatton
LinkedIn: Robert Hatton
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook.
Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
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.
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.
Wayne Sheffield
Twitter: - @DBAWayne
LinkedIn: Wayne Sheffield
Contact: http://blog.waynesheffield.com/wayne
Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne
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
Jim Murphy
Twitter: - http://www.twitter.com/sqlmurph
LinkedIn: Jim Murphy
Contact: http://sqlwatchmen.com/blogs/jim/
Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.
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.
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.
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!
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” .
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’!
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.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
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.
Christopher Price
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Josh Fennessy
Senior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.
When he’s not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)
Chris Albrektson
Contact: http://www.bidn.com/blogs/ChrisAlbrektson
Chris Albrektson is a Business Intelligence consultant for Pragmatic Works and is experienced in Reporting Services, Crystal Reports and Integration Services. Chris is an active member of the Jacksonville SQL Server User Group (JSSUG), and also volunteers/speaks at SQLSaturday and Code Camp events. He’s also a regular blogger on BIDN.com and recently a technical editor on SQL Server books.
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.
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 Hinckley
My current role is as Product Manager at Tangram. When I am not tinkering under my clients’ SharePoint project you’ll find me working on helping shape SharePoint Saturday strategy as a National Committee member and coordinators of the Tampa and South Florida events. Speaker # 2 David Griffiths MSCA, MCITP is a Director at Tangram.He has over 20+ years IT with 16 at the C-level.
Luis Figueroa
Contact: http://blog.extremebi.net
Luis Figueroa is an IT professional focused on delivering business solutions that leverage the Microsoft SQL Server platform. His area of expertise is Data Warehousing and Business Intelligence but he is passionate about all things SQL Server. With 10+ years of experience in the IT field, Luis has delivered data management solutions for companies in the Security, Online Marketing and Healthcare Industries. He is also the chapter leader of the MS BI user group of South Florida.
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.
Sebastian Meine
Twitter: - @sqlity
LinkedIn: Sebastian Meine
Contact: http://sqlity.net/en/blog/
Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.
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.
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.
Sponsors
The following is a list of sponsors that helped fund the event: