SQLSaturday #255 - Dallas 2013

Event Date: 11/02/2013 00:00:00

Event Location:

  • 416 Yates St
  • Arlington, Texas

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: A Systematic Approach to ETL Performance Tuning

Abstract: ETL performance tuning can be an especially challenging task, largely because of the number of moving parts in the process. From extracting the information from the source system, to staging in SQL Server and transforming into the relational data warehouse, to processing new information into the cube, there are so many things that can contribute to exceeding the specified batch window.

In this session, we’ll look at the high-level system as a whole and discuss possible areas contributing to a lag in performance. We’ll also talk about implementing instrumentation components to monitor all aspects of the ETL solution, using SSIS 2012’s Catalog. We’ll use this monitoring data and an example case study to walk through the process of tuning the ETL system to make sure the data warehouse is consistently available at the required time.

Speaker(s):

  • Erin Welker

Track and Room: Track 5 - N/A


Title: Table Partitioning: the Secret Weapon for your Big Data Problems.

Abstract: Is big data starting to slow you down? Is data growth putting your maintenance tasks in danger of not meeting your service level agreements? Do you wish you could archive old data with minimal impact to your tables during the archive process? Do you wish you could eliminate the majority of the data in your tables when you query them? If so, its time you consider implementing table partitioning to help with your general performance and to reduce your maintenance window for completing your maintenance tasks. In this session you will learn how table partitioning works and when it should be implemented. You will be able to understand how to initially configure partition functions and partition schemes to have a rock solid partitioned table. Finally, you will learn how to implement an automated sliding window to maintain your partitioned tables for ensuring optimal performance.

Speaker(s):

  • John Sterrett

Track and Room: Track 2 - N/A


Title: Wish you could live the glamorous consulting life?

Abstract: Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn’t start earlier? (and walk away from a cushy job).

I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I’ve learned the hard way. In this session you will lean sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life. An essential session for those thinking about this choice and/or those who are just starting out

Speaker(s):

  • Juan Soto

Track and Room: Track 6 - N/A


Title: Leveraging Flash Technologies for Increased SQL Server Performance

Abstract: Over the past few decades we have witnessed a chronic and widening imbalance among processor bandwidth, disk capacity, and access speed of disk. There has been an exponential increase in performance for CPU and network over the last several years, yet the speed of traditional drives has not kept pace. This suggests that the performance of an OLTP system would be seriously limited without a considerable improvement in I/O throughput. Since the market debut of flash memory SSD a few years ago, storage vendors have made a continued effort to overcome SSD’s poor random write performance and to provide stable and sufficient I/O throughput. Today we now have an extensive array (pun intended) of flash solutions that can provide real benefits to SQL Server deployments. In this session you will learn: • The evolution of disk and Flash storage • The Physics behind Flash • The Different types of Flash (Server, Hybrid and Storage) • How to leverage Flash to get the most out of SQL Server

Speaker(s):

  • Pat Sinthusan

Track and Room: Track 6 - N/A


Title: Tips and Tricks for architecting a BI infrastructure on SQL 2012 Power View

Abstract: Analytics is changing the surface of the industry, the speed of how we sell, look at data, analyze information. Users want to see traffic data meshed with order data, supply and inventory data, and then add up financial and geographical data. Simply put it, it is a huge explosion of data, where BigData is key. They need to analyze customer behavior, then take this information and tie in with customer 360 view, straight from Sales force to do demand generation. In this session you will see tips and tricks for setting up an enterprise infrastructure based on SQL Server 2012 Business Intelligence analytical tools Power View and PowerPivot that includes SharePoint 2013, SQL Server Engine 2012, SSIS 2012, Analysis Services Multidimensional, Tabular, and PowerPivot modes as well as SQL Reporting Services, PowerPivot and Power View. How to create OLAP cubes, PowerPivot data, and export to SSAS Tabular. Create reports with Power View based on the PowerPivot data extracted.

Speaker(s):

  • Reinaldo Kibel

Track and Room: Track 3 - N/A


Title: Real-Time Analytics with Power View and SSAS Tabular in DirectQuery Mode

Abstract: In this session we will explore how SQL Server Analysis Services Tabular, running in DirectQuery mode, can be used to power real-time analytics. In DirectQuery mode the data is guaranteed to be up-to-date, no refreshing or processing is necessary, because DirectQuery mode queries data stored in a SQL Server database. We will provide concepts and step-by-step examples of setting up a BI Semantic Model, including security, best practices for getting the most out of Power View and the differences between DirectQuery and the In-Memory VertiPaq cache, so you are equipped to start building real-time analytics solutions with SSAS and Power View.

Speaker(s):

  • Chaitanya Khaladkar

Track and Room: Track 5 - N/A


Title: Window Functions in SQL Server 2012

Abstract: Window functions are one of the coolest new things in SQL Server 2012, but they can be tricky to figure out. In this session we’ll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning.

Speaker(s):

  • Tim Costello

Track and Room: Track 4 - N/A


Title: Common Problems in Backup and Recovery and How to Handle Them

Abstract: The basic concepts behind taking a backup are well understood, but people are frequently surprised by the many ways backups can go wrong. First, we’ll explore the most common problems around SQL Server backup and recovery, so that you can spot any issues in your own environment. Then, we’ll talk about how to prevent these issues in the first place. The foundation of disaster recovery is having a verified backup in place, so the knowledge you’ll gain from this session could help to save your business.

Speaker(s):

  • Grant Fritchey

Track and Room: Track 1 - N/A


Title: SQL Server Permissions and Security Principals

Abstract: A review of 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.

Speaker(s):

  • William Assaf

Track and Room: Track 1 - N/A


Title: The ABCs of SSIS

Abstract: This presentation shows the basics of SSIS to help with automating database tasks, such as maintenance, importing and exporting data, or ETL transactions. The discussion will start with an understanding of when SSIS should be used vs. when a database object, such as a view or stored procedure. You will also learn about the different categories of transformations, see how to create a basic package, and how to use package configurations. Lastly, we will talk about the importance of organizing the overall SSIS structure.

Speaker(s):

  • Glenda Gable

Track and Room: Track 5 - N/A


Title: Women in Tech Panel

Abstract: This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women – and men – in tech. Everyone welcome to this very interactive session.

Speaker(s):

  • Kathi Kellenberger

Track and Room: Track 7 - N/A


Title: Extreme Design – A Real World 10+ Exabyte Data Warehouse

Abstract: A large number of people, including many at Microsoft have bought into the marketing BS called “Big Data”. When you hear “big data”, everyone automatically assumes that you have to do this in some other database platform being foisted on IT. Microsoft starts a sentence with “big data” and finishes the sentence with Hadoop. The implication all over the industry and from Microsoft itself is that SQL Server can’t handle “big data”. This session will walk you through the architecture and build out of a real world data warehouse, spanning over 600,000 SQL Servers, which is currently in excess of 10 Exabytes. We melted a set of Hadoop clusters before they even came close to what SQL Server was serving.

Speaker(s):

  • Mike Hotek

Track and Room: Track 4 - N/A


Title: Hacking the SSIS 2012 Catalog

Abstract: Integration Services 2012 offers a brand new way to store, log, and execute SSIS packages – the SSIS Catalog. How does the Catalog work? Can it be customized? Can it be extended? Yes it can! In this presentation, Andy Leonard shows you how!

Speaker(s):

  • Andy Leonard

Track and Room: Track 1 - N/A


Title: Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services

Abstract: Gain the knowledge, tips, and techniques you need to tune your Tabular models in SQL Server Analysis Services 2012. This session will begin by exploring the Tabular model architecture and explaining the factors that affect performance. We’ll then walk through tuning techniques and strategies specific to querying, processing, partitioning, and server configuration and demonstrate optimizing performance in some common scenarios. This session is based on the recently released white paper “Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services.”

Speaker(s):

  • Greg Galloway

Track and Room: Track 3 - N/A


Title: Turbo charge your DBA career

Abstract: You have been a DBA for so many years and struggle to decide on what next. Attend this session and find ways to rejuvenate your career to the next step.

Speaker(s):

  • Sri Sridharan

Track and Room: Track 7 - N/A


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: Track 5 - N/A


Title: Analytical MDM with Master Data Services 2012

Abstract: In this session we will take a deep dive in to Analytical Master Data Management and how it differs from Operational Master Data Management. We will examine how you can leverage SQL 2012 Master Data Services to manage your data warehouse dimensions and hierarchies. Come learn how you can leverage the new features of SQL 2012 Master Data Services to enroll business users in the process of master data management to reduce the burden on IT and as a result, maximize the value of your Master Data Management solution.

Speaker(s):

  • Jeff Johnston

Track and Room: Track 4 - N/A


Title: Writing Better Queries with Window Functions

Abstract: Learn how the new analytic functions introduced with SQL Server 2012 can take your T-SQL skills to the next level! Solve complicated requirements with better performing and easier to write queries.

Speaker(s):

  • Kathi Kellenberger

Track and Room: Track 7 - N/A


Title: Moving to Windows Azure SQL Database(WASD)

Abstract: Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database (WASD)? Are you a developer who is writing code for a cloud service that shall use SQL Database as the back-end? Come attend this talk by CSS engineers for guidance strategies you can use to make a smooth transition to this new platform. The content is based on lessons learnt supporting customers already using WASD and will touch upon topics like •How to get your data from on-premise SQL Server to WASD?•What are common DBA type tasks you will need to perform on WASD?•How can you troubleshoot query performance issues on WASD?

Speaker(s):

  • Rohit Nayak

Track and Room: Track 4 - N/A


Title: Tell Better Stories with Microsoft BI and PowerMap

Abstract: Storytelling seems to be a lost art form; in this fast-paced world people are more interested in getting as many bits of information as they can. But without a story, something to pull all the data together, the target audience will probably gloss over your message. Throwing a few numbers and charts at the reader has become pretty acceptable nowadays. But to make something truly memorable, and hopefully shared with someone else, you need some kind of story. You need something to tie it all together, to give it some meaning. That’s where Microsoft steps in with its latest addition to the Business Intelligence Analytics space with an add-in to Excel called PowerMap.

Speaker(s):

  • marek koenig

Track and Room: Track 3 - N/A


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: Track 6 - N/A


Title: Optimizing Stored Procedures

Abstract: In this talk 4 time MVP Mark Rosenberg will talk about SQL Server stored procedures and techniques you can use to optimize them. He will cover stored procedures from a developer’s point of view including table variables, common table expressions and temporary tables. Which do you use and when do you use it. There will also be a number of quick tips that anyone can use to improve query performance when they walk out of the session

Speaker(s):

  • Mark Rosenberg

Track and Room: Track 3 - N/A


Title: Interview Tips for Managers

Abstract: If you are a Manager needing some interviewing education - this is your course! This session focuses on basic interviewing guidelines, including: preliminary interviews, types of testing, secondary or follow-up interviews, while keeping in mind EEO guidelines and best practices. Learn tips and tricks of the trade from an HR guru who is “in the trenches.”

Speaker(s):

  • Christine Assaf

Track and Room: Track 6 - N/A


Title: Introduction to SQL Spatial Analysis and Reporting

Abstract: Most all data captured today is tied in some way to spatial elements. SQL Server has powerful functionality that will allow you to leverage this information to get deeper insights and make better decisions. We will walk through demonstrations of basic reporting and analysis involving place data. We will use “in house” analytical/spatial data along with openly available spatial data. Demos will show the various spatial functions for data analysis along with reporting using reporting services, powerview, and geoflow.

Speaker(s):

  • Mark Verret

Track and Room: Track 3 - N/A


Title: T-SQL Throwdown

Abstract: Join us for a game of SQL that combines fun, learning SQL, networking, and friendly competition with your peers. Create your team for a SQL-off against other teams. If you can write a SQL query, you have the skills required to play. Each team must bring a laptop with SQL Server 2012 Express and AdventureWorks 2012 pre-installed. Please read full rules here: http://www.sqlzen.com/t-sql-throwdown.html

Speaker(s):

  • Hakim Ali

Track and Room: Track 7 - N/A


Title: Nuts and Bolts of Table Compression

Abstract: Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results – they were surprising to me!

Speaker(s):

  • Mike Byrd

Track and Room: Track 4 - N/A


Title: Introduction to the XML source

Abstract: XML is all over the place. But how do you get that data into SQL Server? SSIS provides an XML Source, but it is not easy to use. In this session we will handle increasingly complex XML documents. After an introduction to using the XML Source with a single set of elements, we will look at how to work with multiple element sets. This includes hierarchically structured XML documents.

Attendees will be able to import simple XML using SSIS. They will be able to create import routines that pull data from different elements of more complex XML. They will understand the role the XML Schema plays in defining the XML data they import.

Speaker(s):

  • Russel Loski

Track and Room: Track 4 - N/A


Title: SQL Security Best Practices Shrinking Your Attack Surface

Abstract: Every industry has a governing body or standard that requires some layer of security to your data. In my travels I have come to realize that when someone mentions security, DBA’s tend to get frightened. This could be due to a lack of understanding of the requirements or not knowing what SQL Server offers to meet those requirements. In this session we will go over what SQL Server has to offer, Security Best Practices and how you can shrink your attack surface to meet Confidentiality, Integrity and Availability of your Servers and Data. In addition, attending this talk is worth 1.5 Continuing Education credits.

Speaker(s):

  • Matthew Brimer

Track and Room: Track 7 - N/A


Title: Nested Sets model for Trees Hierarchies

Abstract: Most newer SQL programmers use the adjacency list model for Trees Hierarchies in their DDL. This is not a relational approach and experienced programmers use the Nested Sets model. However, they do not know all of the programming idioms for the method. That is what this session is about.

Speaker(s):

  • Joe Celko

Track and Room: Track 1 - N/A


Title: SQL 2012 AlwaysOn Quickstart

Abstract: In this presentation I’ll explain what the new SQL 2012 AlwaysOn high availability and disaster recovery solution is all about. I’ll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We’ll discuss how these three things come together to protect your databases. We’ll finish with a dive into availability group configuration and the new capabilities it gives us.

Speaker(s):

  • Ryan Adams

Track and Room: Track 1 - N/A


Title: SSRS data driven subscription using SSIS

Abstract: SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports to the file system based on values stored in the database.

Speaker(s):

  • Russel Loski

Track and Room: Track 7 - N/A


Title: SQL Server 2014 – In memory OLTP Development

Abstract: One of the new features in SQL Server 2014, Hekaton aka In memory OLTP can change the landscape for applications that need extremely high performance write activity. In this session, we’ll do a deep dive into Hekaton from the implementation and development side to understand how an in memory OLTP table can work with your applications and the implications it has for application design.

Speaker(s):

  • Mike Hotek

Track and Room: Track 2 - N/A


Title: Master of All I Survey - track code changes and more across your environment

Abstract: Almost everyone’s seen it happen - problems due changes made on servers, be it SPs, index rebuilds, or even configuration changes. But what if you could look historically across servers and track down what changes were made when, by who, and from where? It exists, it’s already built into SQL Server standard edition from 2005-2014, and it’s easy to implement. Come learn what Event Notification is and why you’ll want it in your environment.

Speaker(s):

  • Michael Bourgon

Track and Room: Track 5 - N/A


Title: SQL Server Amnesia - Memory Troubleshooting

Abstract: Losing your memory is never fun. Well, I can’t help you with that, but I can help show you how SQL Server is using its memory, and why it can’t get more from Windows. Next, we will run through some demos on using Perfmon and DMVs to look inside SQL Server. These techniques even work on Grandpa SQL 2005 all the way to the latest version, and no matter how old you get, you’ll never forget these tips. When we finish, you’ll be able to return to the office on Monday ready to troubleshoot your performance problems with new tips.

Speaker(s):

  • Steven Ormrod

Track and Room: Track 5 - N/A


Title: Make Your SSIS Packages Run Faster: 15 Quick Tips

Abstract: When reviewing your ETL processes, the No. 1 question is always, “Does it work as expected?” Closely following that question is the ubiquitous, “How fast does it run?” This session’s tips are targeted at improve the latter. In this session, we’ll focus on SSIS package performance, quickly reviewing 15 of the most common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.

Speaker(s):

  • Tim Mitchell

Track and Room: Track 2 - N/A


Title: Let’s Hadoop!

Abstract: This session provides a demonstration-rich introduction to the fundamentals of Hadoop and the Microsoft implementation, HDInsight. If you have heard of Hadoop but have struggled to get started with the technology, this session is for you.

Speaker(s):

  • Bryan Smith

Track and Room: Track 2 - N/A


Title: SQL Transaction Log Internals

Abstract: The transaction log plays a most critical role in any SQL Server database. In this session, Microsoft Premier Field Engineer and SQL Server Certified Masters (MCM) Denzil Ribeiro will discuss the importance of the transaction log and the roles it plays inside the database engine. He will look at how logging and recovery works, composition of log records, common logging patterns, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database

Speaker(s):

  • Denzil Ribeiro

Track and Room: Track 3 - N/A


Title: Biml - The Next Step in Agile Data Warehousing

Abstract: Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

Speaker(s):

  • David Stein

Track and Room: Track 1 - N/A


Title: Intro to SharePoint BI

Abstract: Microsoft SharePoint is a collaboration software that provides a web based portal for business intelligence, content management and document sharing. In this session we start with an overview of the basics by sharing a SQL table as a ‘List’ using Sharepoint and SSIS. Next we move on to fun stuff of integrating SQL Server Reporting Services integration. Finally we look at how to give users dynamic PowerPivot analysis in a dashboard.

Speaker(s):

  • Allen Smith

Track and Room: Track 6 - N/A


Title: Physical Join Operators

Abstract: SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

Speaker(s):

  • Ami Levin

Track and Room: Track 2 - N/A


Title: Explore and Troubleshoot the power-packed new features of SQL Server 2014

Abstract: Many administrators and users are not aware of the full extent of the changes and new features that are coming in newest release of SQL Server 2014. This session will explore the new features, how to use them as well as how to troubleshoot them when something goes wrong with the new features. We will cover all the changes from High Availability, Performance, Scalability and Manageability. Of course will be walking through some demos as well. We will get you ready for the newest release of SQL Server 2014.

Speaker(s):

  • Suresh Kandoth

Track and Room: Track 2 - N/A


Title: Without A SQLTrace-Getting To Know Extended Events

Abstract: If you have wanted to learn how to use Extended Events and have had a hard time trying to figure out where to start then this session is for you. This session is designed for someone that has never used Extended Events before. After this session you will know the basics of how to setup and use this highly scalable and configurable architecture to trouble shoot server issues. You will see how to use them in SQL 2008 and how they have been beefed up in SQL 2012. This will be a demo rich session so come prepared to finally get to know Extended Events.

Speaker(s):

  • AJ Mendo

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

marek koenig

Twitter: - http://twitter.com/marekkoenig

LinkedIn: marek koenig

Contact: http://blog.slalom.com/author/marekkoenig/

Marek Koenig is a BI consultant with Slalom Consulting. He specializes in geospatial visualization. In his free time he enjoys cycling, tennis, or anything else outdoors.

Hakim Ali

Twitter: - @forhakim

LinkedIn: Hakim Ali

Contact: http://www.sqlzen.com/blog

Database developer and designer with valuable experience on and a great liking for SQL Server. Trying to get the word out on developing SQL Server databases with Visual Studio.

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

Erin Welker

Twitter: - sqlbigirl

Erin Welker, a consulting professional whose passion is SQL Server, has worked with the product since version 1.11. She has served as the data warehouse architect on projects for several globally recognized companies. She has also presented on SQL Server topics at several conferences and is the author of various whitepapers, articles, and book chapters on SQL Server and data warehousing.

Matthew Brimer

Twitter: - @sqlcenturion

LinkedIn: Matthew Brimer

Contact: http://www.sqlcenturion.com

Matthew Brimer has 10 years experience with SQL Server, 3 of which was spent as a Database Security expert for a Department of Defense Agency and 5 as the Database/Security Manager for a leading Pharmacy Services Company. These days Matt can be found helping customers get the most out of the Databases/Servers/Networks as a Consultant for InterWorks. Matt also holds several Security and Microsoft Certifications, is the President of OKC SQL PASS Chapter and is the former Event Chair for SQLSaturday Oklahoma City.

Mike Hotek

Contact: http://www.ChampionValleyPress.com

Michael is the Senior BI Architect at CBRE in Dallas, TX. He has been building SQL Server systems and database management best practices for over 20 years having worked with thousands of companies and on the largest, most complicated platforms in the world. Michael has delivered hundreds of sessions and training events around the world and has published numerous articles along with 9 books. He is currently working on a multi-book series on SQL Server 2012.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Suresh Kandoth

Suresh Kandoth has worked with Microsoft for more than 10 years. Suresh is currently with the SQL Server Escalation team in Las Colinas. Suresh has deep expertise with many components of the SQL Server Storage Engine and experience with solving some of the most challenging and complex problems in the SQL Server core engine area. Special interests include core debugging and database corruption.

Greg Galloway

LinkedIn: Greg Galloway

Contact: http://www.artisconsulting.com/blogs/GregGalloway

Greg Galloway is a BI architect with Artis Consulting in Dallas, Texas and a Microsoft Data Platform MVP. He is a coordinator on open-source projects including BI Developer Extensions (formerly BIDS Helper), the Analysis Services Stored Procedure project, and OLAP PivotTable Extensions. He was a co-author of the Analysis Services Tabular Performance Guide.

Mark Verret

Mark Verret is the IT Manager for the LSU Highway Safety Research Group. He has over 20 years experience in the IT field. He has worked with SQL Server for the past 12 years implementing Business Intelligence and data warehousing related projects.

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/

Steven Ormrod

Twitter: - @DBOrmrod

Contact: http://stevenormrod.com

Steven Ormrod is a Database Administrator. He focuses on high-availability and clustering, with a dash of performance tuning thrown in for fun. His environments consist of hundreds of servers spread across multiple countries. He is on the board of directors for the Austin, Texas PASS Chapter and speaks at user groups and SQLSaturdays. Steven holds a BS in Computer Science and a Masters of Education. He is a SQL Server MCM.

Jeff Johnston

Jeff Johnston is the Business Intelligence Practice Leader for Artis Consulting. Based in Dallas, TX, Jeff provides guidance for client engagements, solution strategy, Microsoft partnership and sales execution. Jeff has spoken at various Microsoft events including MSBIC and SharePoint Techfest. Jeff holds an MBA in Strategy Entrepreneurship and has several Microsoft certifications including MCITP-BI, MCDBA, and MCSD.

Michael Bourgon

Twitter: - @mbourgon

LinkedIn: Michael Bourgon

Contact: http://thebakingdba.blogspot.com

Michael Bourgon started his IT career by performing tech support and managing Sybase databases on Unix starting in 1995, before moving to SQL Server 7… continuing all the way to SQL Server 2017. His focus on automation has led him to such diverse topics as Service Broker, WMI, Table Partitioning, Shell scripting, In-Memory Tables, and Powershell. He’s currently a senior DBA with a large healthcare company, dealing with millions of transactions of day and managing hundreds of servers. In his spare time he rides a bicycle, reads science fiction, blogs about SQL Server and Baking, and tries to raise his daughter to be a geek, too.

Chaitanya Khaladkar

Contact: http://www.gnetgroup.com

Chaitanya Khaladkar is a Solutions Architect with GNet Group, a gold certified IW and BI partner. He has in-depth experience in developing architectures, and leading business productivity projects that span the entire Microsoft Business Productivity and Business Intelligence platform. Chaitanya has worked on several successful solution development projects to build rich web and collaborative applications on SQL Server and SharePoint since 2005.

Russel Loski

Twitter: - sqlmovers

LinkedIn: Russel Loski

Contact: http://www.sqlmovers.com

Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

AJ Mendo

Twitter: - @SQLAJ

Contact: http://sqlaj.wordpress.com/

AJ has over 14 years of experience working with a variety of databases. He has worked for military, civilian, and federal government organizations supporting a wide variety of applications.

AJ is a frequent speaker at user groups, SQLSaturday#39;s, and PASS Virtual Chapters, and is a board member POSSE and CACTUSS. He is a PASS Programs Committee volunteer, and he loves being a part of the SQL Community.

Rohit Nayak

Twitter: - sqlrohit

LinkedIn: Rohit Nayak

Rohit Nayak is a Senior Program Manager in the SQL Server product team at Microsoft, with a focus on the Security and Connectivity for SQL Database.

Tim Costello

Twitter: - timcost

LinkedIn: Tim Costello

Contact: http://www.timcost.com

Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.

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.

Joe Celko

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008).

Mr. Celko’s past columns include: Columns for Simple-Talk (Redgate Software); “CELKO” in INTELLIGENT ENTERPRISE magazine (CMP); BMC’s DBAzine.com e-magazine; “SQL Explorer” in DBMS (Miller-Freeman); “Celko on SQL” in DATABASE PROGRAMMING DESIGN (Miller-Freeman); “WATCOM SQL Corner” in POWERBUILDER DEVELOPERS’ JOURNAL (SysCon); “SQL Puzzle” in BOXES ARROWS (Frank Sweet Publishing); “DBMS/Report” in SYSTEMS INTEGRATION (Cahner-Ziff); “Data Desk” in TECH SPECIALIST (RD); “Data Points” in PC TECHNIQUES (Coriolis Group); “Celko on Software” in COMPUTING (VNC Publications, UK), “SELECT * FROM Austin” (Array Publications, The Netherlands), and he was editor for the “Puzzles Problems” section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, “Celko on SQL”, on CompuServe.

Mark Rosenberg

Contact: http://geekswithblogs.net/markrosenberg

Mark Rosenberg has been writing software with Microsoft technologies since 1997. He has been speaking to user groups and at code camps since 2005 and been a certified trainer Since 2007.

Mark likes to talk to developers and has been talking to anyone who will listen. He is very active in the community, both speaking at user groups and on the board of 2 user groups in Southern California.

He currently is working as an senior development instructor at New Horizons in Austin, TX

Juan Soto

Twitter: - jsoto22

LinkedIn: Juan Soto

Contact: https://accessexperts.com/blog/

I’m the President of IT Impact, a Microsoft Access MVP and a frequent author on the official Microsoft Access blog as well as the first Access developer to be profiled on their site. I’m also a frequent speaker at Access User Groups throughout the USA, covering subjects such as SQL Server with Access as well as providing tools and resources for Access developers on the web. My expertise is optimizing Access with SQL Server and helping SQL Server DBAs understand how to design tables for Access.

Reinaldo Kibel

Twitter: - @sqlmii

LinkedIn: Reinaldo Kibel

With over 20 years of experience in Microsoft SQL Server technology, working in one of the largest MS SQL installation in the world at Dell and having worked at Microsoft, Reinaldo is a consultant, an architect and leader in the database technology area. Reinaldo is an advisory and provides direct feedback to Microsoft SQL Server Product team part of Technology Adoption Program with MS on versions 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017 leader at Dell. Reinaldo has written case studies, white papers and videos on Data technology available at Microsoft and Dell web sites. Reinaldo has presented at Ignite, SQL Summit, SQLSaturdays, and 24HOP as well as local users group in TX.

Glenda Gable

Contact: http://sql313.com

Glenda has worked with databases in some form or another for 13 years, and loves working with data. She has worked in the healthcare, state park, construction licensing, and not-for-profit industries. Glenda has worked with all facets of Business Intelligence, from software installation and maintenance to report/cube development and deployment, and the ETL transactions in between. She now focuses on planning and optimizing the full ETL process, and learning more about database administration.

Allen Smith

Contact: http://www.cognitiveinfo.com

Allen Smith is a business intelligence and data warehouse builder, speaker and trainer. Allen has an MBA in Computer Sciences and has worked in database services and data warehousing since 1998. Allen has a MCTS certification in Business Intelligence. Allen is a Sr. Business Intelligence Lead at Devon Energy. He enjoys sushi, traveling to obscure places, fixing Rubik’s cubes and prefers Marvel over DC.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Denzil Ribeiro

Twitter: - denzilribeiro

LinkedIn: Denzil Ribeiro

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

Denzil Ribeiro is a Principal Program Manager in the Azure SQL Database team. He is a Microsoft Certified Master (MCM) and has 15+ years of experience working with high scale SQL Server and Data pipeline architectures. Prior roles included stints in SQLCAT focusing on top tier customer scalability engagements across the data pipeline , SQL Server Escalation Engineer in CSS and Premier Field Engineer working with our top tier customers.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

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.

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.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

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.

Sri Sridharan

Contact: http://sqlrocks.com/

Sri is the President of North Texas SQL Server User Group. Sri has been involved with SQL Server since version 4.2 and has held various roles developer/dba/ architect / pre-sales over the years. He is largely responsible for some of few features in SQL 2008 like TDE and tools like MAPS. Sri holds a Bachelor’s Degree in Physics , Masters in Computer Information Systems and an MBA in Finance. His wife Hema, made sure he got a 3rd Masters in parenting their 2 sons.

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.

Bryan Smith

LinkedIn: Bryan Smith

Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.

Mike Hotek

Contact: http://www.ChampionValleyPress.com

Michael is the Senior BI Architect at CBRE in Dallas, TX. He has been building SQL Server systems and database management best practices for over 20 years having worked with thousands of companies and on the largest, most complicated platforms in the world. Michael has delivered hundreds of sessions and training events around the world and has published numerous articles along with 9 books. He is currently working on a multi-book series on SQL Server 2012.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O’Reilly Media, as an author for PluralSight and LinkedIn Learning.

Pat Sinthusan

Contact: https://communities.netapp.com/

Pat Sinthusan is currently working for NetApp as a Reference Architect responsible for validating new SQL Server Solutions on the NetApp storage platform. In the past, he worked as a Sr. Database Administrator for 15 years with Hasbro and the City of Seattle. Pat has designed and implemented database infrastructures for the entire range of environments (development and production) using various storage technologies, and he#39;s been working with SQL Server since 4.21B.

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.

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.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page