SQLSaturday #408 - Houston 2015

Event Date: 06/13/2015 00:00:00

Event Location:

San Jacinto College - South Campus
13735 Beamer Rd
Houston, Texas

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Learn How To Build A Golden Record for Any Subject Over Lunch!

Abstract: Attend the lunch demo and see how you can use Master Data Services and Maestro to: • Create a golden record for any subject area in a matter of minutes Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? • Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? • Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting • Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise

Speaker(s):

Gene Webb

Track and Room: Business Intelligence - 1.115

Title: SQL Geography DataTypes and Applications

Abstract: At some point in your SQL life you will be asked to calculate or visualize geospatial data. Microsoft SQL server has unique optimizations and frameworks for handling just this circumstance. Not to be confused with Geometric data (square and linear), Geographic data offers even more complexity as you deal with the curvature of the earth and its radial impact on queries. Jared Nielsen is the Principal of the FUZION Agency and the CTO of Online and Digital for Universal Weather and Aviation and contends with geographic data on a daily basis. FIR Boundary intersection, optimized flight planning, weather map overlay and multi-level airspace computations all involve some very interesting SQL Server geographic manipulations that may be interesting for you to experience if you haven’t already. Please join me for an in-depth review with helpful resources to guide you on your way as you incorporate Geospatial data into your own applications.

Speaker(s):

Jared Nielsen

Track and Room: Application Development - 1.149

Title: A DBA’s pick of differences between SQL Server and Oracle

Abstract: In this session, I want to talk about 5 major differences between SQL Server and Oracle, namely:

Backup, Restore, Recovery (RMAN vs T-SQL/Powershell)
Schema (Single vs Multi tenants)
Alter Index Rebuild (defragmentation)
AWR, ASH vs DMV/DMF (Performance Trouble-shooting)
Data Guard Mode vs AO Availability Group Mode (synch, asynch).
I will reference my prior year presentation (SQLSaturday#308) how to automate Backup, Restore, Recover SQL Server, Alter Index for Defragmentation, and monitoring backups and agent jobs by using Powershell/T-SQL. I will also reference my prior year presentation (HASSUG 11/2012) Trouble-shooting with Active Session History (powershell and T-SQL). I will show Oracle 12C in Oracle SQL Developer. Target audiences should have SQL Server DBA working knowledge and basic knowledge in Oracle on these topics.

Speaker(s):

Jason Wong

Track and Room: DBA - 1.115

Title: Giving Feedback: How to Effectively Communicate to your Employees

Abstract: As a manager or team leader giving effective feedback is vital to the success of projects. In this session we will discuss soft skills and best practices to give feedback, performance improvement, and even disciplinary actions. Learn how to handle confrontation tactfully.

Speaker(s):

Christine Assaf

Track and Room: Professional Development - 1.149

Title: Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube

Abstract: New features have been added to the last couple of Excel releases in order to bring the most used desktop reporting application to a full-featured Business Intelligence reporting tool for Multidimensional Cubes. This session will be filled with demonstration of all these new features with slides only as references to more detailed explanations and uses. Pivot Tables will be the main focus of this 75-minute session with visual tools that enhance graphs and dashboards.

You will leave this session with your brain firing on all cylinders to create cool dashboards with color enhanced backgrounds to signal to users where they should focus their efforts. The new Timeline object makes you breathe a sigh of relief about report filtering by dates. Slicers will give you clues of what data is present. Indicators, data-driven formatting, and spark lines focus attention on what is important to the viewed data set.

Speaker(s):

Thomas LeBlanc

Track and Room: Business Intelligence - 1.147

Title: Building Bullet-Resistant SSIS Packages

Abstract: It’s 2:30 a.m., and you’ve just gotten that call no ETL developer wants to get: an SSIS package has failed unexpectedly. Immediately, you start asking yourself: “What could have caused this?”, “What do I do to fix the data from this failed execution?”, and, most importantly, “Could I design the package in such a way that this doesn’t happen again?”

In this demo-packed session, we will examine the design patterns and logistics of building error-resistant SSIS packages. Starting with the control flow, we’ll work through various tools and patterns that can be used to prevent, or at least handle appropriately, task-level errors. We’ll then move to the data flow, and discuss and demonstrate how to proactively address problem data to prevent unexpected package failures.

Speaker(s):

Tim Mitchell

Track and Room: Business Intelligence - 1.117

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract: Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

Speaker(s):

Christine Assaf

Track and Room: Professional Development - 1.149

Title: Getting started with Tabular Analysis Services

Abstract: This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.

Speaker(s):

Thomas LeBlanc

Track and Room: Business Intelligence - 1.117

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Abstract: What is master data management and why should I care about it? What does the master data services components of SQL Server do for me? Overview of all features of MDS How to build out an MDM subject area How to use MDS for reference data management How to use MDS for data quality How to use MDS with a data warehouse to improve data quality

Speaker(s):

Gene Webb

Track and Room: Business Intelligence - 1.147

Title: Managing Security in SSIS

Abstract: In the world of extraction, transformation, and loading (ETL), everything we do involves moving data from one point to another. However, very often the focus in SSIS package development is on functionality, not security. When building internal data transformation and movement processes, it is easy to forget that these operations broaden our security footprint, and must be actively managed to ensure that ETL doesn’t become the weak link in the security chain. In this presentation, we’ll discuss the security features in SQL Server Integration Services, while reviewing best practices for securing your ETL infrastructure while providing enough (but not too much) access to those ETL assets. Among the topics we’ll cover:  Properly securing connection passwords in SSIS  Using package protection levels  Restricting access to deployed packages  Using role-based security for SSIS deployment and execution  Using execution proxies

Speaker(s):

Tim Mitchell

Track and Room: Business Intelligence - 1.147

Title: The Life Cycle of a Query in VR

Abstract: Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in VR. We will follow a query from beginning to end and “runthrough” the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.

Speaker(s):

Todd Kleinhans

Track and Room: Application Development - 1.141

Title: Designing Stored Procedure Solutions

Abstract: With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven’t spent a lot of time in SQL development.

Speaker(s):

Jennifer McCown

Track and Room: Application Development - 1.141

Title: SSIS Performance Tuning with BimlScript

Abstract: You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:

Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
Automatically execute each package multiple times and record the results for analysis.
Determine which package version should be used in production.

The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.

Speaker(s):

David Stein

Track and Room: Business Intelligence - 1.117

Title: Tracing and Extended Events - 3 Methods to End the Madness

Abstract: In this Session, 3 different approaches to using Tracing and Extended Events will be covered.

The Long Running Query.
The Thousand Paper Cuts - De-Parameterization Aggregation
Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server).

With each of these approaches we will go over

Setting up both tradtional Traces and the newer Extended Events to capture the information you need. How to analyze and make sense of the captured data.

Lots of demos and take-away scripts in this session.

Speaker(s):

Mindy Curnutt

Track and Room: DBA - 1.148

Title: Mission Possible: Interactive Performance Troubleshooting - Index

Abstract: Performance troubleshooting is detective work. We’ll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these “needle in the haystack” issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we’ll focus primarily on improper indexing as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!

Speaker(s):

Jim Murphy

Track and Room: Performance - 1.142

Title: SQL Server Statistics – What Are The Chances?

Abstract: For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We’ll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

Speaker(s):

Lori Edwards

Track and Room: Performance - 1.113

Title: The Ins and Outs of SQL Indexes

Abstract: This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

Speaker(s):

Mindy Curnutt

Track and Room: Performance - 1.113

Title: Minion Maintenance and Backup Solutions

Abstract: The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable. In this session I’ll show you the benefits to Minion Reindex and Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.

Speaker(s):

Sean McCown

Track and Room: DBA - 1.115

Title: The Global Cloud and I

Abstract: This is a special session with multiple presenters showing how to utilize free-ish/no-charge Cloud Offerings (e.g., storage, apps) – available from around the Globe at this point-in-time Jun 2015. Even though the free-ish/no-charge offerings are steadily disappearing (e.g., Free Google Apps), this session will show content that applies to both personal/family and SMB’s (Small/Medium Businesses). Expect to walk away with goodies (-: as always :-) … and with answers to questions, such as: – How do I get started with the Global Cloud today?
– Any gotchas to keep in mind?
– After this session, where do I go for more … in Houston?

PRE-REQUISITE: None other than an interest to utilize the cloud.

NOTE: The 3 presenters, Tex (20+ year technologist), Valentino Zane (budding technologists), are with Hybrid Decisions#174; Corp and are presenting on behalf of the “Houston Cloud Cluster User Group”. #171;#177;#187;

Speaker(s):

Anthony {Tex} Moreign

Track and Room: Cloud - 1.148

Title: Flash Disk Alternatives for SQL Server Databases

Abstract: Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.

Speaker(s):

Bert Scalzo

Track and Room: Performance - 1.115

Title: What’s new in SQL 2016

Abstract: Come and enjoy your lunch while learning about what new and exiting changes are coming in SQL Server 2016.

Speaker(s):

Mark Moore

Track and Room: DBA - 1.113

Title: Wait Watchers - All Gain No Pain

Abstract: We’re all told to watch our weight and to exercise more. Join Dell Software who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided).

In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won’t be only be about how to fix that problem query, but we’ll also talk about how to improve overall performance for all your users.

Speaker(s):

Patrick Okeeffe

Track and Room: Performance - 1.148

Title: So what does it really take to get to four nines

Abstract: As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, Translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.

Speaker(s):

George Govantes

Track and Room: DBA - 1.142

Title: Enforce Best Practices with CMS and Policy Based Management

Abstract: If you manage a large environment then you know how hard it can be to make sure all your SQL Servers adhere to best practice settings and more importantly is making sure they stay that way. I’ll show you how to check those settings across all your servers with Central Management Server and how it can help you manage a disperse environment. You will also learn how to leverage the power of Policy Based Management to help you enforce those settings and standards in your enterprise. Best of all you will see how to get alerts sent to you when one of your standard settings is changed.

Speaker(s):

Ryan Adams

Track and Room: DBA - 1.142

Title: Beginning Powershell for DBAs 1.0

Abstract: The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

Speaker(s):

Sean McCown

Track and Room: PowerShell - 1.149

Title: The DBA Career Roadmap

Abstract: Nobody has a step-by-step plan for your career. But, you do need to know the general direction you’re heading in; which roads go that way (and which ones dead end); and what might be worth stopping for along the way. For example, working for a small shop might be a dead end career move, or it could be a fantastic shortcut to somewhere you really want to be. Getting that next certification might be a worthy way to spend your time, or it might be running around in circles.

Want to find out how to get to the next great place in your career? Get solid advice from the people who have already been there. If you want to be somewhere in five years, start moving today.

Speaker(s):

Jennifer McCown

Track and Room: Professional Development - 1.149

Title: Pivots, Cursors and Temp Tables, Oh Boy!!

Abstract: Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.

Speaker(s):

Steve Allison

Track and Room: Application Development - 1.141

Title: Crash Course on Flash-Based Storage–SQL Server

Abstract: Technical Details Flash vs. SSD—Why DBAs should care about the difference How Flash changes storage architecture designs How current storage architecture designs compare Two rather special Flash-based offerings from HGST

Speaker(s):

Bert Scalzo

Track and Room: Performance - 1.117

Title: Determining performance bottlenecks and how flash storage helps databases

Abstract: This session will give an overview of how to use SQL to find performance bottlenecks, determine their source and the effects of flash storage technology on database architecture. Also included is a live demo of SQL running on a flash storage array.

Flash storage is the new wave of technology hitting data centers and database design. With any new technology, knowledge is power. Flash storage comes with a new set of pros cons, new economics and changes in architecture that highlight what it has to offer while avoiding the common traps. Before migrating or testing, learn the what’s, how’s and when’s.

Speaker(s):

Matt Henderson

Track and Room: Performance - 1.147

Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS

Abstract: Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.

Speaker(s):

Bill Shields

Track and Room: Other - 1.141

Title: Working With Azure SQL Database

Abstract: Azure SQL Database is Microsoft Platform as a Service (PaaS) offering. Although similar to SQL Server, it does have some differences. This session covers best practices and use cases.

Speaker(s):

John Cook

Track and Room: Cloud - 1.148

Title: Windows Clustering for the DBA Part 1

Abstract: You need to implement AlwaysOn Failover Clustering or Availability Groups, but need help with the Windows Clustering part. This session will guide you to success. We’ll talk about how to plan your network, DNS, Active Directory, and storage. I’ll provide you with a check list you can use to plan your implementation. We’ll see how to choose the right quorum model for a robust failover configuration that ensures your database is always available.

Speaker(s):

Ryan Adams

Track and Room: DBA - 1.142

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract: Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.

Speaker(s):

Mike Byrd

Track and Room: Performance - 1.117

Title: AlwaysOn - Finally, A usable ‘mirror’!

Abstract: In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic fail-over using a real web app to see how well this feature works.

Speaker(s):

Jim Murphy

Track and Room: DBA - 1.141

Title: Understanding and Monitoring Tempdb

Abstract: Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.

Speaker(s):

Vicky Harp

Track and Room: Performance - 1.113

Title: Making the Leap from Developer to DBA

Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

Speaker(s):

Amy Herold

Track and Room: Professional Development - 1.149

Title: Parameter Sniffing the Good and the Bad

Abstract: Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

Speaker(s):

Lance Tidwell

Track and Room: Performance - 1.113

Title: Windows Clustering for the DBA Part 2

Abstract: In part 1 you learned how to plan your network, DNS, Active Directory, and storage. You know what you need to plan a successful implementation and now it’s time to put the plan into action. I’ll demonstrate setting up a multi-subnet cluster so you know exactly how to do it when you get back to the office. I’ll also show you things like Node Draining, Priority Startup, Cluster Aware Updating, and Dynamic Quorum that ensure your database is always available.

Speaker(s):

Ryan Adams

Track and Room: DBA - 1.142

Title: Quick DB Tuning Tips with Solarwinds Database Performance Analyzer (Ignite)

Abstract: Are you struggling with performance issues and your current tools aren’t providing any helpful answers? This presentation outlines a pragmatic response-time approach that any DBA can use—from new to expert–to tune SQL statements and quickly improve performance. Using real-life case studies, we’ll show you how to put this approach into action.

Speaker(s):

James Barnes

Track and Room: Performance - 1.142

Title: Analyze your query plan like a Microsoft Engineer!

Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate.

Speaker(s):

Daniel Janik

Track and Room: Performance - 1.113

Title: Log SQL Server Activity on a Budget

Abstract: SQL Server has some of the best monitoring tools out there. But what about that server you just discovered? And you’re all out of monitoring licences? Or, what if you need additional information that your monitoring tool isn’t providing? Or, would you like execution plans and lock information for further analysis? All this and more is possible using the industry standard sp_whoisactive, created by Adam Machanic, to monitor and log activity on your SQL Servers. This session will teach you how to log and query the wealth of information sp_whoisactive provides.

Speaker(s):

Rudy Rodarte

Track and Room: DBA - 1.115

Title: Just Enough SSIS Scripting to Be Dangerous

Abstract: SQL Server Integration Services has a number of tasks and components built into the standard toolbox, however there are times the functionality you are looking for just doesn’t exist. This session will introduce you to scripting in SSIS including script tasks and the three script components types; source, destination, and transformation. We will also discuss when to consider using custom and third party components over scripting. This session is not meant to teach you how to develop software with C# or Visual Basic, however coding examples will be demonstrated. Prior knowledge of programming is a benefit but not required.

Speaker(s):

David Valentine

Track and Room: Business Intelligence - 1.117

Title: Writing Your First BimlScript

Abstract: Everyone is talking about the advantages of Biml, but how do you get started? In this highly interactive presentation, I’ll guide you through the process of creating your first BimlScript. During the process we’ll cover the basics of Biml syntax, language options for generating BimlScript, recommended methods of storing and using metadata, and a lot more. As an added bonus, you’ll leave the presentation with BimlScripts you can adapt to use in your own environments using tools that you already have.

Speaker(s):

David Stein

Track and Room: Business Intelligence - 1.147

Title: Self-Service Business Intelligence with Power BI

Abstract: Microsoft recently introduced the Power BI Designer to empower self-service business intelligence charts, reports, and dashboards—without writing code. This session will begin with the Power BI Designer to build charts from data stored in SQL. Then we will bring those charts into a Power BI dashboard and review the options available there. Finally, we’ll examine the underlying technology: Power Query, Power View, and Power Pivot, which are free Excel 2013 add-ons that provide additional capability not yet available through the Power BI Designer.

Speaker(s):

Theresa Eller

Track and Room: Business Intelligence - 1.147

Title: T-SQL: Simple Changes That Go a Long Way

Abstract: Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance and functionality of your queries. We will dive into a few TSQL tricks with features that include Common Table Expressions, Table-Valued Parameters, OUTPUT INTO, Window Functions and COALESCE.

Speaker(s):

David Valentine

Track and Room: Application Development - 1.141

Title: Designing a Data Warehouse in SQL Server

Abstract: This will be an introduction to what a data warehouse is and how to build it using the BI stack tool Integration Services. It will mainly cover how to design a data warehouse, dimension tables and fact tables.

Speaker(s):

Robert Stewart

Track and Room: Business Intelligence - 1.117

Title: SQL Microsoft SQL Server for Developers

Abstract: Get a brief overview of the many facets of SQL Server from a developer’s point of view. From back ups to T-SQL hacks; this session has something for everyone.

Speaker(s):

Dane Schilling

Track and Room: Application Development - 1.141

Title: SQL Server Reporting Services - Zero to Automated Reports Today!

Abstract: Perhaps you’ve heard about the power of SQL Server Reporting Services. Or, you have created some basic reports and you’re ready to automate delivery. If so, this session is for you. You’ll learn how to create your first SSRS report using Business Intelligence Design Studio (BIDS) and deliver reports to the business automatically in under an hour.

Speaker(s):

Rudy Rodarte

Track and Room: Business Intelligence - 1.147

Title: Row Level Security in Azure SQL Databases using Hierarchies

Abstract: This session will show how an organizational asset hierarchy is leveraged together to provide predicate-based Row Level Security on tables in an Azure SQL Database without application changes.

Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating an Azure SQL Database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Excel.

Speaker(s):

Jamey Johnston

Track and Room: Cloud - 1.148

Title: The Binary Language of Music

Abstract: Take a fascinating journey into how our minds work and discover how binary and mathematical patterns found in music can be used to learn the underlying language of music theory and applied to other disciplines.

Speaker(s):

Brian Rigsby

Track and Room: Other - 1.148

Title: Care and Feeding of Your System Databases

Abstract: Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You’ll leave with a better understanding of these shared resources and how they affect your database applications.

Speaker(s):

Vicky Harp

Track and Room: DBA - 1.142

Title: Easy, Scalable Data Solutions in SQL Azure

Abstract: For companies looking to achieve data scalability without large capital expenses, SQL Azure provides a flexible, economical alternative to hosting your data on-prem. In this session we will demonstrate how to create a SQL Azure database and how to manage scalability and geo-replication. We will also explore how SQL Server Management Studio allows you to interact with your data on-prem, as well as key differences between SQL Server and SQL Azure. There will also be a demonstration of creating a SQL Azure API using Azure Mobile Services.

Speaker(s):

Brian Gogle

Track and Room: Cloud - 1.148

Title: 10 Tips for SQL Server Performance Monitoring

Abstract: SQL Server is a business-critical component for the line-of business applications and regular monitoring is essential in order to maintain optimal operations as well as to perform effective troubleshooting. Creating a performance baseline of the essential Windows Server and SQL Server performance metrics can help you to both track the health of your SQL Server instance as well as enable you to quickly troubleshoot performance problems. This session will cover the important tools that you can you can use to monitor your SQL Server instances, the essential system metrics to monitor and what they mean to your system’s performance.

Speaker(s):

Umair Khan

Track and Room: Performance - 1.149

Title: Let’s Get It Started - SQL Server installation and configuration

Abstract: We’ve all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We’ll also talk about unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.

Speaker(s):

Lori Edwards

Track and Room: DBA - 1.115

Title: SQL Server Permissions and Security Principals

Abstract: A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA’s, developers and system admins.

Speaker(s):

William Assaf

Track and Room: DBA - 1.115

Title: Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression

Abstract: Your databases are growing faster than your servers. Large tables consume ever-increasing amounts of storage while putting a drag on query response time. What’s a DBA to do? The data compression feature of SQL Server is one tool DBAs can use to save storage space and improve performance. In this presentation you will learn about the types of data compression, how to determine when compression is the right option, and how to make the magic happen

Speaker(s):

Justin Randall

Track and Room: Performance - 1.113

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Bill Shields

Twitter: - @HighTechBill

LinkedIn: Bill Shields

Contact: http://blogs.cisco.com/author/billshields

Bill is a Sr. Marketing Manager on the Cisco UCS Global Marketing team. He joined Cisco in November 2010. His duties include managing the development Cisco#39;s UCS TCO/ROI tools and providing sales team support, marketing for UCS Mini and UCS M-Series, and delivering server competitive analysis and positioning.

Bill#39;s certifications included a Six Sigma Green Belt from the American Society for Quality and the PMP from the Project Management Institute.

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.com

Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Bert Scalzo

LinkedIn: Bert Scalzo

Contact: http://www.bertscalzo.com/page3.html

Bert Scalzo is an Oracle ACE, author, speaker, consultant, and a major contributor for many popular database tools used by millions of people worldwide, including ERwin, ER/Studio, DBArtisan, Rapid SQL, Aqua Data Studio and TOAD. He has 30+ years of database experience and has worked for several major database vendors. He has BS, MS and Ph.D. in computer science plus an MBA. He has presented at numerous events and webcasts. His areas of key interest include data modeling, database benchmarking, database tuning and optimization, “star schema” ata warehousing, running databases on Linux or VMware, and using NVMe flash based technology to speed up database performance.

Jason Wong

Contact: http://dbace.us

Jason Wong has 25+ years experiences working as programmer, apps admin, IT Applications Manager, Sr. DBA in greater Houston area. He has been a SQL Server community speaker since 2008.

His career profile, education, publication, travel experiences, along with other interests can be found on his web site. (no commercials, no tracking)

http://dbace.us

Todd Kleinhans

Twitter: - @toddkleinhans

LinkedIn: Todd Kleinhans

Contact: https://toddkleinhans.wordpress.com/

Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/

Mark Moore

LinkedIn: Mark Moore

Contact: http://blogs.msdn.com/b/markm

Mark Moore is a Cloud Solutions Architect working for Microsoft in North Texas. Mark has been with Microsoft for 25 years serving in various roles in Services and Sales. Prior to Microsoft Mark worked at Digital Equipment Corporation serving Federal and Government customers in San Antonio, Texas. Mark currently resides with his Wife (Deanne) in the DFW area.

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

David Valentine

Twitter: - https://twitter.com/IngeniousSQL

LinkedIn: David Valentine

Contact: http://www.ingenioussql.com

Dave Valentine is a Development DBA with over 15 years of experience with SQL Server and development technologies, specializing in Business Intelligence and ingenious solutions. Dave has also been an Adjunct Professor at Metropolitan State University for the past 15 years educating students in Database Management and Application Development. Dave started giving back to the SQL community a few years ago by presenting at Local PASS Chapters, SQLSaturday Events, and blogging at IngeniousSQL.com.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Jared Nielsen

Twitter: - https://twitter.com/FUZIONAgency

LinkedIn: Jared Nielsen

Contact: http://www.FUZIONAgency.com

Rather than accepting the status quo, I believe in learning everything, and nothing, and mixing it all together until you have a strange, unique and ethereal blend of technology, marketing, knowledge, wisdom, creativity, passion, charity, caring, and humility. I think that being uncategorizable is the goal since life is the voyage, not the destination, so too should work be that extension of the undefinable so you

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Jim Murphy

Twitter: - http://www.twitter.com/sqlmurph

LinkedIn: Jim Murphy

Contact: http://sqlwatchmen.com/blogs/jim/

Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Jim Murphy

Twitter: - http://www.twitter.com/sqlmurph

LinkedIn: Jim Murphy

Contact: http://sqlwatchmen.com/blogs/jim/

John Cook

Twitter: - johnpaulcook

LinkedIn: John Cook

Contact: https://www.red-gate.com/simple-talk/author/johnpaulcook-2/

John Paul Cook is a psychiatric nurse practitioner and instructor of psychiatric nursing. He is former Data Platform Solutions Architect for Microsoft and before that a 9 time Microsoft MVP. John understands both the clinical aspects of healthcare and the technical aspects. He provides a unique perspective in being able to explain clinical concerns and issues to technical people. John is passionate about improving mental health in the community, including in the technical community.

Lori Edwards

Twitter: - www.twitter.com/loriaedwards

LinkedIn: Lori Edwards

Contact: http://www.sqlservertimes2.com

Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.

Justin Randall

Twitter: - jh_randall

LinkedIn: Justin Randall

Contact: http://blogs.sqlsentry.com/justinrandall

Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.

George Govantes

LinkedIn: George Govantes

SQL Architect and Senior SQL Database Administrator with over 20 years of experience turned Chief Information Security Officer, Certified Information Security Manager, and Governance Risk and Compliance Certified Professional that helps organizations develop cloud and on-prem Identity and Information Security programs. He also trains and consults in the area of IT leadership and the development of high-performance teams.

Dane Schilling

Contact: http://www.daneschilling.com

From modeling databases to writing complex reports Dane Schilling has utilized MS SQL Server nearly every working day for the last sevenyears.

Christine Assaf

Twitter: - https://twitter.com/HRTact

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

Christine Assaf is an experienced HR pro who is passionate about the mental health of employees, leadership, and organizations. She is a leadership development professional with over 15 years experience in human resources and 20 years in business management. She holds a BS in Business Management, received her HRM certification at LSU, and is finishing up her master’s degree at Colorado State University in Industrial and Organizational Psychology. She is a certified DDI Trainer, experienced public speaker, and is dedicated to teaching others about ways to support a culture of “expressiveness” in the workplace that creates connectivity.

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.

Rudy Rodarte

Twitter: - http://www.twitter.com/shadyrudy

Contact: http://www.rodolforodarte.com

Rudy Rodarte works at Dimensional Fund Advisors as a DBA optimizing existing TSQL code, deploying SQL Server 2012, and implementing DB change tickets. Previously, Rudy spent 3 years at HotSchedules.com maintaining databases used by all major restaurants in the US. Rudy also spent 9 years at Dell Inc, in Americas Services Parts creating and maintaining logistics databases that managed inventory in the Americas. Away from the keyboard, Rudy is a big fan of Liverpool Football amp; the Baylor Bears

David Valentine

Twitter: - https://twitter.com/IngeniousSQL

LinkedIn: David Valentine

Contact: http://www.ingenioussql.com

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.

Bert Scalzo

Contact: http://www.toadworld.com/members/bert_5f00_scalzo/blogs/default.aspx

Bert Scalzo is a renowned database expert, Oracle® ACE, author, and Chief Architect at HGST. With three decades of database experience, Bert’s webcasts garner high attendance and participation rates. Bert has an extensive academic background that includes a BS, MS, and Ph.D. in computer science, as well as an MBA. He wrote two books for SQL Server users: Introduction to SQL Server: Basic Skills for Any SQL Server User Database Benchmarking: Practical Methods for Oracle SQL Server.

Gene Webb

Twitter: - None

LinkedIn: Gene Webb

Contact: http://None

Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.

Anthony {Tex} Moreign

Twitter: - https://twitter.com/AnthonyTexM

LinkedIn: Anthony {Tex} Moreign

Contact: http://www.hccug.org

{Technologist | Speaker | Writer | Founder} … 25 years counting … – Founder Chief Architect, Hybrid Decisions® Corp (www.HybridDecisions.com | 2005) – Founder President, Houston Cloud Computing User Group (www.HCCUG.org | 2008) – for more info see http://linkedin.com/in/AnthonyTexM «±»

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.

Christine Assaf

Twitter: - https://twitter.com/HRTact

LinkedIn: Christine Assaf

Contact: https://www.hrtact.com

David Stein

Twitter: - @Made2Mentor

LinkedIn: David Stein

Contact: http://www.Made2Mentor.com

Gene Webb

Twitter: - None

LinkedIn: Gene Webb

Contact: http://None

Vicky Harp

Twitter: - vickyharp

Contact: http://vickyharp.com

Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.

James Barnes

James is a senior sales engineer focusing on Systems Management and Database Tools at SolarWinds. He has nearly 20 years of experience managing all manner of environments with experience in server, virtualization and storage technologies. He also has extensive experience developing software solutions in several languages. He lives with his wife and son in Austin TX.

Lori Edwards

Twitter: - www.twitter.com/loriaedwards

LinkedIn: Lori Edwards

Contact: http://www.sqlservertimes2.com

Robert Stewart

Contact: http://www.dbguidesign.com

Robert has been involved with SQL Server since it split from Sybase in the mid 1990s. He is currently the DBA/Enterprise Architect for TDECU. He was involved with HAL-PC for over 20 years. He is currently co-leader of the Database and GUI Design Workshop users group that meets the second Saturday of each month.

Vicky Harp

Twitter: - vickyharp

Contact: http://vickyharp.com

Matt Henderson

Twitter: - @DatabaseMatt

LinkedIn: Matt Henderson

DBA and architect for over 15 years focusing on high performance SQL Server applications and large scale data warehouses. Matt has been working with SQL on all-flash databases for several years and heads the program at Violin Memory for high performance database tuning for flash devices.

Lance Tidwell

Twitter: - @Lance_LT

Contact: http://lancetidwell.com

Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.

Steve Allison

Contact: http://steve.evengame.com/

I am an quot;Accidental DBAquot; who has been coding for nearly 40 years. I started in Basic with data files stored in text files. I have worked up building applications that needed data. In 2008 I took on a partner who allowed me to start focusing on data concerns. Since then, I have battled and self trained to learn the ins and outs of Microsoft SQL and we build and maintain professional cloud based solutions for small to medium sized businesses.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

Patrick Okeeffe

Patrick O’Keeffe is a Director of Software Engineering at Dell Software, where he specializes in the design and implementation of diagnostic and performance products for Microsoft SQL Server, and tools for data provisioning and publishing. Patrick has over 15 years’ experience in leading software development teams, software engineering and architecture and is based in the Dell Software Austin, TX facility. He can be contacted at Patrick.Okeeffe@software.dell.com and is @pokeeffe on Twitter.

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.

Thomas LeBlanc

Twitter: - TheSmilingDBA

LinkedIn: Thomas LeBlanc

Contact: http://Thomas-LeBlanc.com

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Rudy Rodarte

Twitter: - http://www.twitter.com/shadyrudy

Contact: http://www.rodolforodarte.com

Umair Khan

Twitter: - umairmoheet

LinkedIn: Umair Khan

Umair works as a product marketer in the infrastructure management customer solution unit. He has over seven years of experience working in the software industry with roles spanning from software development, IT management, marketing and pre-sales. Umair has an MBA in Solutions Marketing and Innovation, with an undergraduate degree in software engineering.

Brian Rigsby

Twitter: - @ZenDeveloper

Contact: http://zendeveloper.blogspot.com

Brian#39;s formal education is in music, but he is an eighteen year software development veteran. His unorthodox presentation style is both inspirational and entertaining.

Theresa Eller

Twitter: - https://twitter.com/SharePointMadam

LinkedIn: Theresa Eller

Contact: http://www.techresa.com

Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.

Brian Gogle

Twitter: - @briangogle

LinkedIn: Brian Gogle

Contact: http://briangogle.com

I have had a very diverse career that has always been very focused on insights and how they improve performance. I am currently the Data and Analytics Lead for the Central Region for Neudesic.

Prior to consulting I was Vice President of Information Services with Mosaic, a retail services company. leading a forty person team in the U.S. and Canada and architecting a Microsoft BI solution that was accessed by over 1,000 clients from over 140 retailers and retail manufacturers. Before joining Neudesic I served as the Data Management Practice Area Lead for Slalom Consulting in Dallas.

SQLSaturday #408 - Houston 2015

Sessions

Title: Learn How To Build A Golden Record for Any Subject Over Lunch!

Title: SQL Geography DataTypes and Applications

Title: A DBA’s pick of differences between SQL Server and Oracle

Title: Giving Feedback: How to Effectively Communicate to your Employees

Title: Excel 2013 Tips and Tricks for Displaying a Multidimensional Cube

Title: Building Bullet-Resistant SSIS Packages

Title: Mastering your Resume Interview: Tips to Get Hired

Title: Getting started with Tabular Analysis Services

Title: Introduction to Master Data Management (MDM) with SQL Server Master Data Services (MDS) for Beginner

Title: Managing Security in SSIS

Title: The Life Cycle of a Query in VR

Title: Designing Stored Procedure Solutions

Title: SSIS Performance Tuning with BimlScript

Title: Tracing and Extended Events - 3 Methods to End the Madness

Title: Mission Possible: Interactive Performance Troubleshooting - Index

Title: SQL Server Statistics – What Are The Chances?

Title: The Ins and Outs of SQL Indexes

Title: Minion Maintenance and Backup Solutions

Title: The Global Cloud and I

Title: Flash Disk Alternatives for SQL Server Databases

Title: What’s new in SQL 2016

Title: Wait Watchers - All Gain No Pain

Title: So what does it really take to get to four nines

Title: Enforce Best Practices with CMS and Policy Based Management

Title: Beginning Powershell for DBAs 1.0

Title: The DBA Career Roadmap

Title: Pivots, Cursors and Temp Tables, Oh Boy!!

Title: Crash Course on Flash-Based Storage–SQL Server

Title: Determining performance bottlenecks and how flash storage helps databases

Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS

Title: Working With Azure SQL Database

Title: Windows Clustering for the DBA Part 1

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Title: AlwaysOn - Finally, A usable ‘mirror’!

Title: Understanding and Monitoring Tempdb

Title: Making the Leap from Developer to DBA

Title: Parameter Sniffing the Good and the Bad

Title: Windows Clustering for the DBA Part 2

Title: Quick DB Tuning Tips with Solarwinds Database Performance Analyzer (Ignite)

Title: Analyze your query plan like a Microsoft Engineer!

Title: Log SQL Server Activity on a Budget

Title: Just Enough SSIS Scripting to Be Dangerous

Title: Writing Your First BimlScript

Title: Self-Service Business Intelligence with Power BI

Title: T-SQL: Simple Changes That Go a Long Way

Title: Designing a Data Warehouse in SQL Server

Title: SQL Microsoft SQL Server for Developers

Title: SQL Server Reporting Services - Zero to Automated Reports Today!

Title: Row Level Security in Azure SQL Databases using Hierarchies

Title: The Binary Language of Music

Title: Care and Feeding of Your System Databases

Title: Easy, Scalable Data Solutions in SQL Azure

Title: 10 Tips for SQL Server Performance Monitoring

Title: Let’s Get It Started - SQL Server installation and configuration

Title: SQL Server Permissions and Security Principals

Title: Putting the Squeeze on Large Tables: Improve Performance and Save Space with Data Compression

Speakers

Sponsors