SQLSaturday #49 - Orlando 2010

Event Date: 10/16/2010 00:00:00

Event Location:

  • Seminole Community College
  • 100 Weldon Boulevard
  • Orlando, Florida

PDF of Schedule

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: Transactional Replication: Beyond The Basics

Abstract: Transactional replication can support synchronizing from as few as a hundred to as many as hundreds of millions or more of changes a day across multiple servers. However, replication is more than clicking your way through wizards; Monitoring and tuning are required to achieve optimal performance and the number of processes involved increase the likelihood that problems can (and usually will) occur. This session is for DBA already familiar with the basics of transactional replication and looking to go beyond the setup wizards to gain a deeper understanding of the technology. We’ll cover monitoring techniques, calibrating performance, and troubleshooting common replication problems plus share some tricks and tips.

Speaker(s):

  • Kendal Van Dyke

Track and Room: DBA2 - N/A


Title: SQL and SEO - Making Money with SQL Server

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 Fundamentals

Abstract: In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming “difficulties” are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).

Speaker(s):

  • Louis Davidson

Track and Room: TSQL - N/A


Title: SQL Backups Recovery

Abstract: Backing up SQL Server is not just about database files anymore. This session gives a brief refresher of basic database backup techniques then moves to a discussion about all the other SQL components you should be backing up (and may have forgotten about). Bring your horror stories to share with all. Session also covers the order in which to restore / recovery your database backups.

Speaker(s):

  • Brandie Tarvin

Track and Room: DBA - N/A


Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs

Abstract: For DBAs PowerShell provides a simple but powerful way to automate everyday tasks. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space, Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

Speaker(s):

  • Aaron Nelson

Track and Room: Powershell - N/A


Title: As a DBA, Where Do I Start?!

Abstract: Whether you are new to the role of DBA, being “forced” to take on its responsibility or joining a new company with previous experience, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the “itties” of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority form. Throughout this interactive discussion we will also look at some of the available tools and scripts to help see where our environments rate. Mike emphasizes our role as “Protector of the Data” as a DBA throughout.

Speaker(s):

  • Mike Walsh

Track and Room: DBA2 - N/A


Title: Planning your ETL architecture with SSIS

Abstract: The complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poorly planned and executed ETL project will inevitably lead to maintenance nightmares, low reliability of the system, or worse yet, to the failure of the project. In this session, we will use ETL best practices to make a requirements checklist you can use in your next ETL implementation, and will demonstrate how you can use SSIS to implement and meet such requirements. If you already learned the basics about SSIS and now want to take your ETL solutions to the next level, or if you became an SSIS developer/architect by accident and wonder what do you need to succeed, then this is the right session for you.

Speaker(s):

  • Rafael Salas

Track and Room: SSIS - N/A


Title: Reporting Services Delivery Mechanisms (mini)

Abstract: On demand reporting is the most common type of report request using SQL Server Reporting Services, but did you know that there are other options available to you? In this mini session, Brian is going to go over all of the delivery mechanisms built into SQL Server Reporting Services that will allow you to take full advantage of Microsoft’s robust reporting platform.

Speaker(s):

  • Brian McDonald

Track and Room: BI - N/A


Title: Automate Login Administration Compliance Reports

Abstract: Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX).

Speaker(s):

  • Ronald Dameron

Track and Room: Powershell - N/A


Title: PowerShell 2.0 Beyond the Dirty Dozen

Abstract: Now that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment.

Speaker(s):

  • Aaron Nelson

Track and Room: Powershell - N/A


Title: Optimize Resources with MAP

Abstract: Are you looking for tools to plan and optimize your database resources and investments? See how the Microsoft Assessment and Planning (MAP) Toolkit 5.0 can help you optimize your SQL Server infrastructure and accelerate migration planning to SQL Server 2008 R2. Learn how to inventory your infrastructure for discovery of SQL Server databases and engine instances—information you can use to optimize hardware and database resources, reduce administrative costs and streamline software licensing needs–all essentials for cost effective IT planning and operations.

Speaker(s):

  • Kathi Kellenberger

Track and Room: DBA - N/A


Title: Introduction to SQL Server Statistics

Abstract: This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you’re a DBA or trying to get by without one, this session will give you the information you need to know.

Speaker(s):

  • Andy Warren

Track and Room: Misc - N/A


Title: Zen and the Art of Writing SQL Query - Part 2

Abstract: Become a Zen master in the art of writing SQL queries! Explore the advanced topics of grouping, pivoting, and ranking with practical hands-on examples. Aggregating at multiple levels, transposing one or more columns, and isolating ranges may all seem like difficult tasks. Learning the fundamentals and applying simple steps will show you the way to master SQL query writing!

Speaker(s):

  • Plamen Ratchev

Track and Room: TSQL - 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 querie, Utility 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: DBA2 - N/A


Title: CDC + SSIS = SCD

Abstract: Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions using features that are all native to SQL Server 2008.

Speaker(s):

  • Patrick LeBlanc

Track and Room: SSIS - N/A


Title: Securing your Data Warehouse

Abstract: In this Session Mike will demonstrate how to leverage Active Directory Groups and Users to secure your DataWarehouse. He will demonstrate how to secure both Column and row level info in Transactional queries all the way to AS Queries.

Speaker(s):

  • Michael Mollenhour

Track and Room: BI - N/A


Title: Speaking, Should I? (MINI)

Abstract: I have been speaking for a while now. My first speaking engagement was at the inaugural Baton Rouge SQL Server User Group in May 2008. Was I nervous? Sure I was, but I quickly realized that I enjoyed it. Should you cross the line of attendee to speaker? Join me as I share my experiences as a speaker and what I think it takes to become a good speaker. You never know, you may realize that you should be speaking instead of in the audience.

Speaker(s):

  • Patrick LeBlanc

Track and Room: SSIS - N/A


Title: DBA Script Thumb 2010

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 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: DBA - 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: Performance - 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: Performance - N/A


Title: Configuration Domination: Taking Control of SQL (M

Abstract: We all know that every environment is different, so how can we expect the default SQL Server installation to be optimized for each one. In this session, we will look at some of the configuration options you can change after you have installed SQL Server to maximize performance, security, and reliability. We will also cover the configuration changes you should make that are often overlooked after your server or your database has been upgraded.

Speaker(s):

  • Ken Simmons

Track and Room: DBA - N/A


Title: SSIS Configurations, Expressions and Constraints

Abstract: This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.

Speaker(s):

  • Eric Wisdahl

Track and Room: SSIS - N/A


Title: Spatial Queries in SQL 2008

Abstract: A quick tour of the spatial data features of SQL Server 2008. Will create several different queries to determine geographic proximity between points. The second half of the session is devoted to wiring SQL Server spatial data into Bing Maps using ASP.Net.

Speaker(s):

  • Michael Stark

Track and Room: TSQL - N/A


Title: Why a DBA Should Learn PowerShell (MINI)

Abstract: Powershell is the newest scripting language from Microsoft and it goes across the Windows platform, including SQL Server. So it’s new and exciting, but is it ready for prime time? Is it worth the effort to learn? How will it help you? Join PowerShell advocate and user Ron Dameron for a quick discussion of why he things knowing Powershell is a key skill for a SQL Server DBA.

Speaker(s):

  • Ronald Dameron

Track and Room: Powershell - 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: Powershell - N/A


Title: BI Pivot Tables Charts, Not a 1 Tool Exercise

Abstract: This session begins with a simple SQL database with several related tables. It then shows how to import those tables to create a simp;le cube in Analysis Services. Given a simple, but functional cube, the session then goes into Excel to use the cube in Pivot Tables and Pivot Charts. Finally, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to see and use your results.

Speaker(s):

  • Michael Antonovich

Track and Room: BI - N/A


Title: Red Gate Software - Ingeniously simple tools

Abstract: In this session Shawn McGehee, DBA and former developer and Friend of Red Gate, will illustrate the disk space,processing time and integrated feature benefits of using SQL Backup and show how best to manage database changes within SSMS using Red Gate’s new tool SQL Source Control. Engage in this lunchtime session for your chance to win one of two free licenses for SQL Source Control and other Red Gate swag.

Speaker(s):

  • Shawn McGehee

Track and Room: Sponsor Demo - N/A


Title: Data Warehousing with SQL Server 2008

Abstract: In this session you will learn about using Microsoft SSIS and SQL Server 2008 to host a data warehouse. We will work through an introduction to data warehousing and look at how we can use the Microsoft tools to build a small data warehouse.

Speaker(s):

  • Wes Dumey

Track and Room: BI - N/A


Title: Zero to Dashboard in 60 minutes

Abstract: Build your first PerformancePoint dashboard along with Adam in this demo rich session. We’ll cover how PerformancePoint works and then build some great content together.

Speaker(s):

  • Adam Jorgensen

Track and Room: BI - N/A


Title: Women in Technology (WIT)

Abstract: This is a general round table discussion about women in technology. This presentation is open to men as well.

Speaker(s):

  • Kathi Kellenberger

Track and Room: Sponsor Demo - N/A


Title: Profiling: It’s Okay in SQL Server

Abstract: Learn how to use SQL Server Profiler/Trace to troubleshoot SQL Server performance and errors. This session will cover how to use Profiler to capture SQL Server events, creating server-side traces, creating custom templates, saving trace data, and interpreting trace data.

Speaker(s):

  • Jack Corbett

Track and Room: Misc - N/A


Title: SQL Server Partitioning from A to Z

Abstract: We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

Speaker(s):

  • Kevin Boles

Track and Room: Performance - N/A


Title: Automating Routine Maintenance

Abstract: You have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.

Speaker(s):

  • Ken Simmons

Track and Room: DBA2 - N/A


Title: SSIS - Data Flow Buffer Breakdown

Abstract: An advanced session which will attempt to break down areas of the data flow buffer. In examining how the buffers are built and used, the user will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The session will further take a look at the effects of parallel package and parallel task execution.

Speaker(s):

  • Eric Wisdahl

Track and Room: SSIS - N/A


Title: XML 101 for the SQL Developer

Abstract: This session defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML.

Speaker(s):

  • Michael Antonovich

Track and Room: TSQL - N/A


Title: Response Time Analysis of SQL Server Performance

Abstract: Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance.

Speaker(s):

  • David Waugh

Track and Room: Sponsor Demo - N/A


Title: Zen and the Art of Writing SQL Query - Part 1

Abstract: Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!

Speaker(s):

  • Plamen Ratchev

Track and Room: TSQL - N/A


Title: What Are You Waiting For?

Abstract: It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

Speaker(s):

  • Thomas LaRock

Track and Room: Performance - N/A


Title: Parts of Facebook: Cassandra and MapReduce

Abstract: Apart from Google, Facebook is the 800lb Gorrilla in the internet space. They process 135TB of click data day, 1.2 million images a second. How do they do it? This session will look at two of the tools in the Facebook toolbox and talk about what makes them tick and how they fit with a Sql environment.

Speaker(s):

  • patrick thompson

Track and Room: Misc - N/A


Title: Windows PowerShell Best Practices for SQL DBA’s

Abstract: Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.

Speaker(s):

  • Ed Wilson

Track and Room: Powershell - N/A


Title: R2 Reporting Services, The New Stuff

Abstract: In this session Mike shows you the new features in Reporting Services R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.

Speaker(s):

  • Mike Davis

Track and Room: BI - N/A


Title: Policy-Based Management in a Nutshell

Abstract: We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

Speaker(s):

  • Jorge Segarra

Track and Room: DBA2 - 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: DBA - N/A


Title: expressor data integration software product demons

Abstract: What do you do when SSIS can’t handle your data volumes or data sizes? Join expressor software for a discussion and demonstration of their data integration software. expressor software allows organizations to reuse the most labor-intensive elements of data integration projects, deliver superior data processing performance, and reap significant cost savings in both development and project lifecycle management and in hardware and software licensing.

Speaker(s):

  • Andrew Szalaji

Track and Room: Sponsor Demo - N/A


Title: Everything you wanted to know about IDENTITY colum

Abstract: A look at the various properties of identity columns. We will discuss how identity columns behave in triggers and replication. We will look at the property functions and catalog views to retrieve metadata about identity columns. We will also see how to override default identity information and specify a value, and reseed an identity column.

Speaker(s):

  • Jonathon Moorman

Track and Room: TSQL - N/A


Title: How to Make a Killer Presentation (MINI)

Abstract: The naked truth about engaging your audience in a lively and entertaining presentation where both speaker and attendees have fun. Note that neither the presenter or the attendees will be naked for this great how-to session!

Speaker(s):

  • Plamen Ratchev

Track and Room: Performance - N/A


Title: Designing a highly available SQL Environment

Abstract: SQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget.

Speaker(s):

  • Tim Beamer

Track and Room: DBA - 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: DBA2 - N/A


Title: Moving Data with SQL Azure and SSIS

Abstract: SQL Azure allows you to host your data in SQL Server in the cloud. That provides some big benefits in scalability and management. However, it leaves open the question, “How do you get your data into / out of the cloud?” At some point, you are going to need to move data to or from an on-premise store to SQL Azure. In this session, we’ll discuss the available options for this, including SSIS, the Sync Framework, and BCP. We’ll cover the pros and cons for each. We’ll drill into one of the options, SSIS, in detail, and review performance options and potential issues that you may encounter when doing this.

Speaker(s):

  • John Welch

Track and Room: SSIS - N/A


Title: Developing Applications with SQL Azure

Abstract: This session will provide and detailed look at developing applications with SQL Azure. It will begin by providing an overview of existing functionality SQL Azure provides, then delve in to utilizing the features and technology to migrate existing applications as well as develop new applications with SQL Azure.

Speaker(s):

  • Scott Klein

Track and Room: Misc - N/A


Title: Troubleshooting Tips (MINI)

Abstract: Join ace DBA and troubleshooter Brandie Tarvin for a fast and furious look at some ways you might get to the bottom of a problem in a hurry. Just fifteen minutes and you could learn something that might save the day (or get cheaper car insurance!).

Speaker(s):

  • Brandie Tarvin

Track and Room: TSQL - N/A


Title: Learning SSIS under 1 hour

Abstract: In this session I will cover the most important SSIS control flow and data flow tasks to jumpstart DBAs into SSIS in SQL Server 2008. The session will focus on loading a de-normalized Data Warehouse from different sources.

Speaker(s):

  • Jose Chinchilla

Track and Room: SSIS - N/A


Title: Choosing Indexes For Performance

Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

  • Jeffrey Garbus

Track and Room: Performance - N/A


Title: Information Builders

Abstract: Learn more about Information Builders

Speaker(s):

  • Scott Schledwitz

Track and Room: Sponsor Demo - N/A


Title: Documenting BI (mini)

Abstract: Sherri McDonald will be presenting a tool that documents your major SQL Server components and the “entire” BI stack. Your team can now view historical data from SQL Server Databases, Integration Services, Analysis Services and Reporting Services in a format that is easy to navigate and understand. See a visual snapshot of your environment that includes images of their SSIS packages, ER Diagrams as well as an Impact Analysis Object Lineage.

Speaker(s):

  • Brian McDonald

Track and Room: Misc - N/A


Title: Introduction to Execution Plans

Abstract: This is an introductory level session on execution plans. You will learn how to read them, what a number of the operators are, and then some real world example of how to use them, things to look for, and ways to make your queries run more efficiently.

Speaker(s):

  • Nathan Heaivilin

Track and Room: Performance - N/A


Title: Introduction 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):

  • Devin Knight

Track and Room: BI - N/A


Title: ETL with PowerShell

Abstract: In this session we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

Speaker(s):

  • Chad Miller

Track and Room: Powershell - N/A


Title: Cassandra, Mongo and Mapreduce (MINI)

Abstract: It’s not always an all SQL Server world. Come see some benchmarks and tips on when and where they alternatives are best used.

Speaker(s):

  • patrick thompson

Track and Room: DBA2 - N/A


Title: Data Encryption and Key Management in SQL

Abstract: Overview of data encryptions and key management that is build into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.

Speaker(s):

  • Said Salomon

Track and Room: DBA - 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: Misc - 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.

Brandie Tarvin

Database Administrator by day and Author by night Brandie Tarvin sails pirate-populated waters, fights evil robots in disguise and turns kingdoms into chaotic rebellious city-states all while coding ETL processes and protecting real-world data from corruption. If it weren’t for her, someone else would have the job and where would be the fun in that?

Brandie’s first computer experience was with a State-of-the-Art Commodore 64 brought home by her father, who informed her that “computers are NOT toys” and would not let her use it until she learned how to program. In late 2003, she turned her hobbies of programming, MUSHing and assisting friends with generic tech support into a full time career as a database administrator. She’s been stuck in the fabulous and bizarre world of professional IT work ever since.

Currently, Brandie is a Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQLSaturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.

Ed Wilson

Twitter: - ScriptingGuys

LinkedIn: Ed Wilson

Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog

Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd, Tech Ready, Geek Ready, SQL Rally and various SQLSaturday conferences. A Microsoft-certified trainer he has taught scripting to Microsoft Premier Customers worldwide. He has written 11 books including 9 on Windows scripting that were published by Microsoft Press. His Windows PowerShell 3.0 Step by Step for MSPress is a current best seller.

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.

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.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

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.

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

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.

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.

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.

Brandie Tarvin

Contact: http://www.brandietarvin.net

Brandie Tarvin (MCITPDBA, MCTS, MCDBA) is a senior Database Administrator Developer for Allstate Dealer Services in Jacksonville. She has published several articles on SQLServerCentral.com, trains her co-workers in SQL Server, and has previously presented at several SQLSaturday events and JSSUG meetings. She also writes fiction and freelances for Catalyst Game Labs in her spare time.

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.

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.”

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

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.

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.

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” .

Eric Wisdahl

Twitter: - @EricWisdahl

LinkedIn: Eric Wisdahl

Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.

Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.

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.

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.

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.

Jonathon Moorman

LinkedIn: Jonathon Moorman

Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

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.

Eric Wisdahl

Twitter: - @EricWisdahl

LinkedIn: Eric Wisdahl

Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.

Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

Tim Beamer

Contact: http://content.dell.com/us/en/enterprise/by-service-type.aspx?redirect=1

Tim Beamer has served 17 years in the technology industry in a variety of roles. Whether as a Systems Administrator, Systems Analyst, or Systems Engineer, the solutions developed by Tim have always been in response to mission critical needs either for his customers or the company he worked for. Currently Tim serves as a Technology Evangelist for the Microsoft Consulting Practice at Dell with responsibility for the United States of America and Canada.

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.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

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

Wes Dumey

Contact: http://www.durableimpact.com

Wes Dumey is a Senior Consultant for Durable Impact Systems, a Florida-based provider of business intelligence solutions. Wes has experience working with many Fortune 500 clients. Wes grew up in Missouri and is a Cheif’s fan, even when it’s difficult to be one. He enjoys flying airplanes and traveling helping executives solve business issues through the use of business intelligence.

Said Salomon

Said Salomon has over 25 year experience as an IT Professional. He has a vast array of abilities in the field in the areas of Network, Desktop Support, DBA, Staff Project Management, Application Software Development, Business Analysis and Quality Assurance. Said carries Microsoft certifications as a MCTS, MCPS, and MCNPS, and multiple certifications from the Insurance Institute of America. Current Said is a DBA at Unitrin Direct Insurance. Secretary of Philadelphia SQL Server User Group (PSSUG). I am also the SQL Track lead for the Philly Dot Net Code Camps.

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. In his spare time he is the Project Coordinator/Developer of Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is also a frequent speaker at SQL Server users groups, SQLSaturdays and Code Camps.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.

Michael Mollenhour

Contact: http://www.bidn.com/people/MikeMollenhour

Mike is currently a SQL BI Architect for Pragmatic Works in Jacksonville FL. He started his career in databases over 15 years ago with DBase. He later progressed to Sybase and started working with SQL Server 6.5 in the late 1990’s. Since then he has worked with many clients in multiple sectors with High Availability, data warehousing, SSIS, SSAS, SSRS, Data Mining, and performance tuning. Mike has spoken at several events including SQLSaturday and several Microsoft launch events.

Patrick LeBlanc

Contact: http://www.patrickdleblanc.com

Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events.

Andrew Szalaji

Contact: http://www.expressor-software.com

Andrew Szalaji and Jyoti Gupta work for Expressor

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.

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.

Scott Schledwitz

Contact: http://ecuity.wordpress.com

Senior Consultant in BI and Data Architecture for Information Builders. * Deploy solutions to clients in the grovernment, financial services and healthcare sectors. * Developed the ARRA Fund Manager, a compliance reporting tool used by states and municipalities for federal funds reporting. * Author of ‘No Nerds’ and ‘The Brave, New Front’ - articles printed in Computerworld. * 2010 Recipient of the Business Intelligence Competency Center Visionary Award.

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.

Kathi Kellenberger

Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx

Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “SQL Server MVP Deep Dives.” In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.

Kathi Kellenberger

Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx

Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of “Beginning T-SQL 2008” and co-author of “Professional SQL Server 2005 Integration Services” and “SQL Server MVP Deep Dives.” In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.

Thomas LaRock

Twitter: - @SQLRockstar

LinkedIn: Thomas LaRock

Contact: http://thomaslarock.com

Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.

Ken Simmons

Twitter: - @KenSimmons

Contact: http://cybersql.blogspot.com

Ken Simmons is a DBA, Developer, and Microsoft SQL Server MVP. He is the coauthor of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010).

Michael Stark

 Michael Stark has been developing software since 1992.  He has worked for both large and small companies.  He has worked in a variety of platforms and environments.  He prefers the newer technologies and enjoys learning new skills and applying them as solutions to existing processes.  He prefers client facing software development projects.  He gets personal satisfaction with build products that make business life easier for the end user.  Mr. Stark is originally from Miami, Florida and currently resides in Tampa, Florida.  In between the two he has live in Atlanta, Detroit, Deland, and Madrid Spain.

patrick thompson

Contact: http://www.standingwaiting.com

see http://www.standingwaiting.com/Resume/Resume.html

Scott Klein

Scott Klein is President of Blue Syntax, a consulting and services firm specializing in SQL Azure. Scott is a Microsoft SQL Server MVP and author of several books including Professional SQL Server 2005 XML, Professional LINQ, Professional Entity Framework 4.0, and Pro SQL Azure. Scott runs the South Florida SQL Server Users Group.

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.

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.

Patrick LeBlanc

Contact: http://www.patrickdleblanc.com

Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical and Financial Industries. He is also the founder of TSQLScripts.com, SQLLunch.com and the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events.

David Waugh

Contact: http://www.confio.com

David Waugh is the main man at Confio.

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.

Mike Walsh

Twitter: - mike_walsh

LinkedIn: Mike Walsh

Contact: https://www.straightpathsql.com

Mike Walsh is an experienced SQL Server professional and has worked with SQL Server since version 6.5. He has been in the role of DBA, developer, and performance tuner, but always leans on his DBA and tuning experience. He has been awarded the SQL Server (now Data Platform) designation 6 times since 2011 and is a current MVP. He runs a SQL Server consultancy focused on DBA services and cloud enablement. He has spoken several times at PASS and regional events. In his spare time, he runs a small farm with his family in rural New Hampshire and is a call Firefighter in his small town.

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).

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.

patrick thompson

Contact: http://www.standingwaiting.com

see http://www.standingwaiting.com/Resume/Resume.html

Shawn McGehee

Contact: http://www.gulfcoastsql.com

Shawn McGehee is the Senior Database administrator for a nationwide health care company currently residing in the Orlando area. He has been working in the IT industry for over 12 years and came from a development background before he moved into database administration in 2004. Shawn has contributed to several online publications and speaks at SQLSaturdays, Code Camps and local user group meetings as much as possible. Shawn was also a co-author on the 2008 Reporting Services book from Apress.

Ken Simmons

Twitter: - @KenSimmons

Contact: http://cybersql.blogspot.com

Ken Simmons is a DBA, Developer, and Microsoft SQL Server MVP. He is the coauthor of Pro SQL Server 2008 Administration (Apress, 2009), Pro SQL Server 2008 Mirroring (Apress, 2009), and Pro SQL Server 2008 Policy-Based Management (Apress, 2010).

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.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page