SQLSaturday #40 - South Florida 2010
Event Date: 07/31/2010 00:00:00
Event Location:
- Devry University - South Florida
- 2300 SW 145 Ave
- South Florida, 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: Change Data Capture a tool for BI,DR,Audit more
Abstract: Change Data Capture (CDC) is one of the newest features available for SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore.
On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as Business Intelligence, Disaster Recovery, Auditing, Debugging, Documentation and more.
Speaker(s):
- Jose Chinchilla
Track and Room: DBA3 - N/A
Title: SQL and SEO - More Money Per Query
Abstract: Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing.
Speaker(s):
- Jared Nielsen
Track and Room: Misc - N/A
Title: Database design with performance in mind
Abstract: One of the biggest benefits of SQL Server is simplicity. Developer creates a database, write a few T-SQL statements and everything is up and running.. until the system grows up and starts to introduce performance problems. And infinite loop begins: Refactor -> Deploy -> Refactor -> Deploy ->.. In a few years developer has gray hairs and ton of experience.
The purpose of this session is sharing this experience helping to avoid some of the typical issues for the systems working under heavy load. The session gives the overview of how SQL Server stores data, what criteria Query Optimizer uses choosing the index, how data is locking - essential knowledge when you expect system to handle thousands transactions per second.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: DBA2 - N/A
Title: BLITZ! One Hour SQL Server Takeovers
Abstract: You’re minding your own business in your corner office - well, no, you’re a DBA, so it’s just your cubicle - when somebody says, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.
Speaker(s):
- Brent Ozar
Track and Room: DBA2 - N/A
Title: Why SQL Server DBAs should learn PowerShell
Abstract: I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.
Speaker(s):
- Ronald Dameron
Track and Room: DBA4 - N/A
Title: Building Business Contacts at IT Conferences
Abstract: Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. Best-selling author and networking expert, Don Gabor will guide you through the conversation process to make networking will be easier and more productive. Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come.
Speaker(s):
- Don Gabor
Track and Room: Misc - N/A
Title: Creating a C# Runtime Dynamic SSIS Designer
Abstract: SSIS enables us to quickly create deployable packages to move/manipulate data. Things do however get a bit challenging when source and destination tables are not known at package design time or when a requirement exists to have an already-deployed package support schema changes in source tables. One solution to this problem is to leverage our ability to create and execute an SSIS package dynamically in code.
In this session we will take a look at a complete project for a C# Runtime SSIS Package Designer, taking as input a set of table names and dynamically generating both destination Access tables then creating, validating, saving and executing an SSIS Package at runtime with logging enabled to demonstrate the various package steps.
Speaker(s):
- Sam Abraham
Track and Room: Dev - N/A
Title: The DBA Script Thumb
Abstract: This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and yes even 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries.
Speaker(s):
- Rodney Landrum
Track and Room: DBA1 - N/A
Title: Introduction to SharePoint 2010 BI and PowerPivot
Abstract: Lets take your BI implementation to the next level with SharePoint 2010 BI and PowerPivot. We’ll go through excel services, performancepoint services, and pulling it all together in SharePoint 2010.
Speaker(s):
- Adam Jorgensen
Track and Room: BI1 - N/A
Title: Locking and Blocking for Developers
Abstract: Locking, blocking, waits.. Why developers should care? Those things are for DBA. But what if you don’t have DBA in the team? What if DBA complaints directly to your boss?
This session will provide you an overview how SQL Server Lock Manager works; how different isolation levels affect the system; gives you bird-eye view of SQLOS and Sql Server Waits; provide you the guidelines how to minimize the locking, avoid deadlocks and improve concurrency of the system. It also shows you a couple of basic methods how to troubleshot problems related with locking and concurrency.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: DBA2 - N/A
Title: Log Shipping vs. Replication; the Great Debate
Abstract: Many SQL Server DBA’s are tasked with the responsibility of choosing an appropriate disaster recovery, reporting, or failover solution for their organization. Much of the time the choice comes down to replication versus log shipping. And while both solutions can be extremely effective, there are both subtle major differences between them that can guide you to choose one over the other. This presentation gets to the nuts and bolts of the two technologies, and helps you make an educated recommendation and implementation.
Speaker(s):
- Troy Gallant
Track and Room: DBA3 - N/A
Title: SQL University 101: Starting the SQL Journey
Abstract: On my blog I’ve started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know (we won’t be covering basic T-SQL in this session, just tasks and concepts). This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources!
Speaker(s):
- Jorge Segarra
Track and Room: DBA3 - N/A
Title: Getting familiar with Query Optimizer
Abstract: Why my queries are so slow? Why SQL does not use that index? What “Hash Match” means? Do we really need to upgrade the hardware?
It’s essential to know how query optimizer works if you want to design effective solutions. This session will give you an overview of how query optimizer generates query plans, how to read them, how SQL Server executes queries and show a few optimization tricks.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: DBA2 - N/A
Title: Advanced Parameters in SQL Server Reporting Servic
Abstract: In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code.
Speaker(s):
- Mike Davis
Track and Room: BI1 - N/A
Title: SQL Server Memory Deep Dive
Abstract: Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server’s health and performance.
Speaker(s):
- Kevin Boles
Track and Room: BI2 - N/A
Title: Multi-Server Management with SQL Server 2008+
Abstract: Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver queries, SQL Server Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits.
Speaker(s):
- Argenis Fernandez
Track and Room: DBA1 - N/A
Title: Working with SQL Server - SQLPS
Abstract: Will demo a series of way to take advantage of SQL Server 2008 - SQLPS to work with you different version so SQL Servers. See how powerfull the POSH command prompt can be to monitor and manage your SQL Servers. I will also demo the Invoke-SQLCmd cmdlet. There will be lots of samples.
Speaker(s):
- Maximo Trinidad
Track and Room: DBA4 - N/A
Title: SQL University 201: Managing a SQL Server pt 2
Abstract: In our 101 session we did a high level overview of the world of SQL Server and how things work within that environment. In this session we’ll dive a little deeper and talk about important tasks expected of a DBA such as backups and restores, general maintenance, understanding various resources and virtualization of SQL Server. Attending the 101 session is not a pre-requisite so feel free to join us and continue our SQL Server education!
Speaker(s):
- Jorge Segarra
Track and Room: DBA3 - N/A
Title: Understanding the SSIS Data Flow
Abstract: In this session Mike will show you how to build a data flow using many different sources, transforms and destination. Learn how to use the some of the most commonly used transforms in SSIS. You will also learn how to troubleshoot a data flow using Data Viewers.
Speaker(s):
- Mike Davis
Track and Room: BI1 - 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? 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: BI2 - N/A
Title: Taking SSIS to the Next Level
Abstract: This session will show you some of the more complex feature available in SSIS. These features can help your packages run more smoothly and handle problem areas better. See how to enable features like checkpoints and transactions on your packages. You will also learn how to use the native logging features to track package executions.
Speaker(s):
- Michael Mollenhour
Track and Room: BI2 - N/A
Title: Dynamically Configuring SSIS Packages
Abstract: In this session, you’ll learn how to control your SSIS packages in a more powerful way by using expressions. The expression language is a bit of an elusive language that can be used to make any component in SSIS dynamic. Then, you’ll learn how to use configuration files to externalize the configuration of your package and lastly how to pass variables into a package. Also learn how to use parent child packages and environment variables.
Speaker(s):
- Mike Davis
Track and Room: BI1 - N/A
Title: Advanced TSQL Solutions
Abstract: The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven’t been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.
Speaker(s):
- Kevin Boles
Track and Room: BI2 - N/A
Title: Sneak Preview: SAPIEN’s Visual PowerShell 2011
Abstract: Preview SAPIEN Technologies’ new dedicated PowerShell editor: Visual PowerShell 2011 The next generation in PowerShell graphical user interface (GUI) creation. Visual PowerShell 2011 builds upon PrimalForms 2009 and adds a plethora of new features and enhancements. New additions include Script Debugging, Multi-Form Support, Built in Console, Snippets and more. The demonstration will cover:
- Creating GUIs for PowerShell
- Creating SQL Query GUIs using the Database Browser
- Packaging your GUIs and scripts into executables
- Cover new features such as Snippets, PowerShell Console, WMI Browser and more
- Creating Projects for Multi-Form GUIs
- Integrated Help and PrimalSense
Speaker(s):
- David Corrales
Track and Room: DBA4 - N/A
Title: PowerShell for the Data Professional
Abstract: In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each tasks we will explore the benefits is using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet about PowerShell.
Speaker(s):
- Aaron Nelson
Track and Room: DBA4 - N/A
Title: Introduction to Transactional Replication
Abstract: SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.
Speaker(s):
- Troy Gallant
Track and Room: DBA3 - N/A
Title: ITIL V3 for the Database Administrator
Abstract: Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework.
Speaker(s):
- Timothy McAliley
Track and Room: DBA3 - N/A
Title: Using PowerShell with SQL Server Agent
Abstract: Come over and see how to work with SQL Server Agent using PowerShell. Lot’s of sample, tips and tricks. Displaying jobs, their properties, and creating PowerShell steps. We are going to see the difference between SQLPS, SMO, and PowerShell V2. Also, I will be show some scripting tools very useful for the DBA’s.
Speaker(s):
- Maximo Trinidad
Track and Room: DBA4 - N/A
Title: Introduction to SQL Azure
Abstract: This session will provide an introduction to the Azure platform and
Speaker(s):
- Joe Healy
Track and Room: Azure - N/A
Title: Mapping with SQL Server 2008, Silverlight and Bing
Abstract: Learn how to use the spatial data types in SQL Server, load spatial data from the web, and display your geographic information using Bing Maps and Silverlight.
Speaker(s):
- Telmo Sampaio
Track and Room: Dev - N/A
Title: Insight Into Your Indexes With DMVs
Abstract: Identify and remdiate index fragmentation. Gather information about unused indexes that may be causing your instances unnecessary overhead and impacting performance. Even find out what indexes you may want to create to make your databases perform better: all with the use of SQL Server Dynamic Management Objects.
Speaker(s):
- Tim Ford
Track and Room: DBA1 - N/A
Title: Building a Shard for SQL Azure using .NET 4.0
Abstract: In this session I will discuss what it takes to build a shard against SQL Azure. Shards allow developers to access data across a farm of SQL Server or SQL Azure databases transparently. This session places a strong focus on C# and evaluates .NET 4.0 and shows you how to leverage the Task Parallel Library (TPL) and the new Caching namespace to achieve greater performance access SQL Azure. View http://enzosqlshard.codeplex.com/ for information about this shard.
Speaker(s):
- Herve Roggero
Track and Room: Azure - N/A
Title: Don’t Be Trigger Happy: Safe Use of Triggers
Abstract: Triggers can be a handy tool in the toolbox, but many times they are used improperly because of a lack of understanding of how they work. This session will give an overview of the different types of triggers available in SQL Server and then will focus on specifically on the safe use of DML triggers. We will talk about when to use triggers and touch on other options. I will demonstrate of both safe and unsafe triggers.
Speaker(s):
- Jack Corbett
Track and Room: DBA1 - N/A
Title: Building Blocks to Analysis Services
Abstract: In this session you will learn some of the basics to getting you started with Analysis Services. Key terms and as well as best practices will be discussed for developing an Analysis Services Cube.
Speaker(s):
- Michael Mollenhour
Track and Room: BI2 - N/A
Title: SQL Azure Performance
Abstract: Let’s talk Azure!!! SQL Azure is the Microsoft SQL Server database in the cloud and it comes packed with cool capabilities. Let’s review its performance footprint and how to go about designing high performance applications with SQL Azure. We will discuss Sharding, network latency, asynchronous operations and much more! Some of this content is taken directly out of the upcoming book on Pro SQL Azure, from APress.
Speaker(s):
- Herve Roggero
Track and Room: Azure - N/A
Title: You don’t need Talent to Succeed
Abstract: You don’t need Talent to Succeed, but Everything else Counts
This session helps you trigger our natural abilities that go unused for years. Once you discover that these are already part of you (us), you will be able to apply them to advance your career, your relationships and your life. You can manage your career and your life—it’s not about balance. Talent is overrated.
Speaker(s):
- Hector Hernandez
Track and Room: Misc - N/A
Title: Top 10 SQL Mistakes and Mis-Steps
Abstract: Join this beginner-level session in which we’ll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen.
Speaker(s):
- Tim Ford
Track and Room: DBA1 - N/A
Title: T-SQL 0-60 (zero- sixty from Standing 2 Sprinting)
Abstract: In T-SQL 0 - 60 we’ll discuss Transact SQL for SQL Server. We’ll discuss four major sections: 1 IDE (SSMS) Queries http://tinyurl.com/cattotsql1 2 Query View vs. Design View http://tinyurl.com/cattotsql2 3 Stored Procedures http://tinyurl.com/cattotsql3 4 Sky is the Limit (advanced topics). http://tinyurl.com/cattotsql4 At the end of the seesion we’ll understand how to query data in SSMS using T-SQL
Speaker(s):
- @ccatto Catto
Track and Room: Dev - N/A
Title: Getting Out from Behind the Curtain - The New DBA
Abstract: The days of hiding amongst rows of servers, focusing purely on operational tasks are quickly coming to an end. This presentation will provide a high level overview of how to boost your value to your organization by automating the mundane operational tasks and focusing on supporting new development. Topics covered will include tools and techniques available for automation, integration with development teams and relationship management.
Speaker(s):
- David Levy
Track and Room: DBA1 - N/A
Title: Developing Application with SQL Azure
Abstract: This session will dive into what it takes to develop application for SQL Azure.
Speaker(s):
- Scott Klein
Track and Room: Azure - N/A
Title: Database Partitioning: The Basics
Abstract: In this session I will go over what database partitioning is and what the structures are to implement it. I will present all of the basic SQL structures that it takes to implement partitioning as well as some general discussion of how to choose the right partitioning key, use of file groups in partitioning, partitioned index alignment, and multi-partitioning.
Speaker(s):
- Elijah Baker
Track and Room: DBA2 - N/A
Title: Cool Stuff with SSRS
Abstract: This session will provide a great detailed look at SSRS.
Speaker(s):
- Shervin Shakibi
Track and Room: BI1 - N/A
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract: At it’s heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
Speaker(s):
- Rodney Landrum
Track and Room: BI2 - N/A
Title: Disaster Recovery Planning for Hurricane Alley
Abstract: Brent will cover the basics of SQL Server’s DR options including log shipping, mirroring, replication and more. He’ll explain the pros and cons of each, and teach you how to pick the right method for your application. You’ll also learn some of the things that burned him during several hurricanes and role swaps. No DRP experience required - Brent will show you the ropes.
Speaker(s):
- Brent Ozar
Track and Room: DBA2 - N/A
Title: Automate ID Administration w/ PowerShell SQLPSX
Abstract: I will demonstrate how I automated ID provisioning using PowerShell, SQLPSX, and our corporate standard job scheduler.
Speaker(s):
- Ronald Dameron
Track and Room: DBA4 - N/A
Title: Tips Tricks for dynamic SSRS Reports
Abstract: This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application.
Speaker(s):
- Pam Shaw
Track and Room: BI1 - 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.
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.
Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
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.
Dmitri Korotkevitch
Contact: http://www.actsoft.com
Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Management solutions. Back-end database handles around 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates.
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.
Timothy McAliley
Twitter: - sysframeworks
LinkedIn: Timothy McAliley
I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.
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.
Don Gabor
Twitter: - https://twitter.com/DonGabor
LinkedIn: Don Gabor
Contact: http://dongabor.blogspot.com/
Don Gabor is a networking expert, communications trainer, and the author of the best-seller, “How to Start a Conversation and Make Friends,” plus 10 books and audio programs on networking, conversation, and public speaking. His books have been translated into more than 25 languages.
Don was a media spokesperson for Grand Marnier, Frito-Lay, and Sprint and is a frequent media guest. His books have been featured in hundreds of media interviews, including on “60 Minutes” with Andy Rooney.
Jack Corbett
Twitter: - http://twitter.com/unclebiguns
LinkedIn: Jack Corbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016.
Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control.
Jack has presented at many user groups and SQLSaturday even
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Dmitri Korotkevitch
Contact: http://www.actsoft.com
Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Management solutions. Back-end database handles around 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates.
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.
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.
Dmitri Korotkevitch
Contact: http://www.actsoft.com
Dmitri Korotkevitch is Director of Development at Actsoft - Tampa based company developing GPS Tracking and Mobile Management solutions. Back-end database handles around 2000 TPS during the peak time. Dmitri holds MCPD and MCITP - Sql Server 2005 2008 Database Developer and 2008 Database Administrator certificates.
Sam Abraham
Contact: http://www.samabraham.net
Sam Abraham is a senior software Developer in South Florida; A strong believer in learning through sharing and the value of community fellowship, Sam has been actively involved in the local community as leader of the WPB Users’ Group and former member of the board of directors at the South Florida Chapter of the Project Management Institute (PMI). Sam is a Project Management Professional (PMP), Certified Scrum Master (CSM) and is Microsoft-certified in Web Development and SQL Server.
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” .
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.
Scott Klein
Scott Klein is a SQL Azure MVP and co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States.. Scott is also a veteran author and speaker, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the recently released Pro SQL Azure.
David Levy
Contact: http://adventuresinsql.com
IT Professional with 10 years experience, largely in a software development role. Exclusively a DBA for more than 2 years, responsible for support of large e-commerce portal, internal sales application and EDI system supporting more than 40 developers at a large computer solutions provider. Previous industries include healthcare, finance and commercial print. Previous speaking engagements include SQLSaturday #31.
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” .
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.
Shervin Shakibi
Contact: http://geekswithblogs.com/shervin
Shervin Shakibi is a Microsoft Regional Director and the lead Developer Technoloies Instructor. In addition to being an author and Technical editor on many .NET books he has been a popular speaker at events such as Microsoft Tech Ed, PDC and Developer Days. Shervin has been developing Enterprise applications since 1987 and a Microsoft Certified Trainer since 1994. Experienced in the delivery of scalable, stable and open enterprise-level.
David Corrales
Contact: http://www.sapien.com
David Corrales has a Masters in Computer Engineering from FIU. He has been Senior Software Engineer for SAPIEN Technologies for two years bringing you such software advancements as PrimalSQL, PrimalXML and PrimalForms. You can read his blogs at blog.sapien.com.
Joe Healy
Microsoft Employee
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.
Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
Telmo Sampaio
Great guy!
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.
Troy Gallant
Contact: http://www.troygallant.com
Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.
Pam Shaw
Twitter: - @PamShaw
LinkedIn: Pam Shaw
Contact: http://sqlpam.wordpress.com/
Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.
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.
Argenis Fernandez
Contact: http://www.sqlps.com
Argenis Fernandez is a Data Platform MVP, Microsoft Certified Master, VMware vExpert and Principal Data Management Architect for Pure Storage. He has worked with SQL Server for over 19 years and enjoys high-end OLTP databases, virtualization, performance troubleshooting, high availability, disaster recovery, best practices, and dealing with hard problems. Previously a Senior Consultant for Microsoft, he is also a Microsoft Certified Master, and founder of the PASS Security Virtual Chapter.
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
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.
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
Troy Gallant
Contact: http://www.troygallant.com
Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.
Jared Nielsen
Jared Nielsen believes that a “Jack of All Trades Is Master of None… Except Himself”™. His twenty year career has spanned projects in “wires and pliers” networking, database architecting, software design, marketing strategy, sales management, training and documentation, business administration, entrepreneurial investment, public company creation, and strategic analysis and consulting. Billing himself as “an IT guy that actually speaks English”, he has managed to effectively bridge the gap between IT and Sales, IT and Marketing, and IT and Executive Management in a way that multiplies revenue for each project he works on. Always willing to speak his mind and challenge the status quo, he is featured throughout the world including the front page of the Wall Street Journal, Wired Magazine, the German Financial Times, Slash Dot, CNN (television, CNN.com and iReport.com), and thousands of blogs throughout the Internet. His work can be seen with companies such as Interline Brands / Barnett (formerly BNTT:NASDAQ), Hughes Supply/ Home Depot / HD Supply (formerly HUG:NYSE), Yahoo! Sports (YHOO:NASDAQ), CBS Television (CBS:NYSE), SAP Andina del Caribe (Caribbean Division), and automotive sector including Tire Kingdom, Big O Tires, Merchants Tire, and NTB, as well as dozens of other high profile projects that have multiplied in revenue due to his influence.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.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.
Elijah Baker
Elijah Baker is an 18 year veteran using SQL Server with the past 10 years being focused mostly on development. He has worked in all levels of SQL Server development from the JR developer up to the lead and architect positions. Currently he is working a PaySpan Inc. which processes medical payments and data. Elijah has become an expert on Partitioning to allow PaySpan’s largest database, 8TB+ 10 billion+ rows, to continue growing as needed without any significant performance degradation.
Michael Mollenhour
Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.
@ccatto Catto
Contact: http://www.ChrisCatto.com
Catto enjoys the .NET community. He currently is employed by MovieTickets.com located Boca Fla as a Software Engineer. Catto uses many technologies to provide solutions for team members, management customers. Catto graduated from Florida Atlantic University with bachelors in Computer Science has continued his education by his involvement in the .NET community recently became a MCP.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.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.
Michael Mollenhour
Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.
Hector Hernandez
Hector Hernandez career has expanded for over 31 years of corporate experience with IBM as a Global Enablement Technology Executive. Today he is a Career Life changing Champion, and has done 100s of inspirational career and life changing talks based on his personal success starting at the bottom of the corporate ladder.
Being a minority himself, Mr. Hernandez knows what it takes to succeed. He emigrated to the U.S. with his family in 1966, grew up in South Florida, and applied to IBM seven times before they ever took notice. He started as a tape librarian on 3rd shift; he’s traveled from continent to continent bringing his energy, enthusiasm, and sensible advice to organizations and individuals across the globe.
He speaks on technology, innovation, career and life making decisions. He not only believes, but he’s proof that you don’t need talent to succeed, but everything else counts. He’s an inventor and has a B.A. in management from Barry University and Executive MBA in Patent Commercialization from Florida Atlantic University.
Sponsors
The following is a list of sponsors that helped fund the event: