SQLSaturday #661 - San Diego 2017

Event Date: 09/23/2017 00:00:00

Event Location:

UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, California

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: SQL Injections and How to Stop Them

Abstract: Right now, there are hackers all around the world trying to get into your web applications. How safe are you? By using a technique called SQL injections, hackers can wreak havoc on web applications by compromising security, manipulating data, choking system resources, retrieving sensitive information, and modifying database objects. Without proper precautions, attackers can even drop databases!

During the demo, we will take on a couple of different roles. As a hacker, we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.

Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them!

Speaker(s):

Jeff Prom

Track and Room: Strategy and Architecture - 111

Title: The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization

Abstract: Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security? This session builds on a full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the constraints to projects! The attendee will leave with a clear understanding of:

Principles of virtualization and why it’s the answer to so many challenges we face today.
How easy it is to secure data in the cloud using data masking features.
The ease of connecting to the cloud and migrating environments.
How to troubleshoot when issues arise and the tools available to diagnose issues.

Speaker(s):

Kellyn Pot’Vin-Gorman

Track and Room: Enterprise Database Administration Deployment - 111

Title: How to be the Most Important IT Person in the Room: Why Data Experts Own the Future

Abstract: Over the course of your career, you’ll learn many new techniques and best practices that you can take back to the office and use in your work to gain immediate improvements. But if you’re only interested in applying a handful of specific, tactical advantages, then you’ll miss out on the most exciting trend in the IT industry – our data-driven future. Share insights and inspirations in this talk with Kevin Kline, a founder and president emeritus of the Professional Association for SQL Server, to discover the broader trends that are pushing data professionals into greater prominence and strategies you can use to become the most respected, influential, and credible member of your organization’s technical staff.

Speaker(s):

Kevin Kline

Track and Room: Professional Development - 317

Title: A Masters Passport to Extended Events

Abstract: “As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times. It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - 317

Title: Bare Naked Skinny on SQL Server

Abstract: Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

Speaker(s):

Jason Brimhall

Track and Room: Enterprise Database Administration Deployment - 308

Title: From Zero to Hero: The New Powershell DBA

Abstract: Are you tired of doing mundane tasks repeatedly and wished there was something or someone to help? What if you could go from nothing to having amazing new code that would automate backups AND restores, query your inventory of servers and databases and give you some quick answers to managers, auditors and everyone else asking about your databases and servers.

In this session, you’ll learn about the Powershell community that is creating awesome solutions to ease your life as a DBA. This session is aimed at DBAs from zero to heroes who want to see the new Powershell DBA in action. Come see brand new techniques and demos and become the hero that others will envy.

Come and join me for a momentous session of PowerShell and SQL, full of demos and useful solutions that you will be able to take back to your workplace. This will improve your knowledge and skills, show you how the modern DBA will work and future proof your career by becoming a new Powershell DBA.

Speaker(s):

Andrew Nakamura

Track and Room: Enterprise Database Administration Deployment - 316

Title: End-to-End Troubleshooting Checklist for SQL Server

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon • Using Dynamic Management Views (DMVs) • Advanced Diagnostics Using Wait Stats • Reading SQL Server execution plan

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

Speaker(s):

Kevin Kline

Track and Room: Enterprise Database Administration Deployment - 317

Title: SQL server on containers – Part 2

Abstract: Please attend Part 1 before to get full usage of this session

Those of you remember physical server consolidation phase started with VM, and struggle to run SQL server on VM with predictable performance…. Since than this is biggest change in the way SQL will be installed. Windows 16 introduced containers support, headless NANO servers and SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. No matter you want to deploy SQL server on Linux or windows containers are the way…

Will show you how can you install 5 SQL server implementations in 5 minute with each dedicated SQL implementation taking 15 GB of space. Will show you how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and provide smooth application deployment…

This session is designed for seasoned SQL Server DBA Developers

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - 111

Title: Why should I care about … the plan cache?

Abstract: SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick’s “Why should I care” series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

Speaker(s):

Rick Lowe

Track and Room: Enterprise Database Administration Deployment - 301

Title: JSON and the Astronauts

Abstract: In one small step, SQL Server 2016 has taken a giant leap…to JSON! In this session, we’ll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we’ll learn to validate, read, and manipulate “unstructured” JSON data. We’ll get The Right Stuff to start developing, no previous JSON experience required. Let’s go where NoSQL has gone before!

Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.

Speaker(s):

Peter Kral

Track and Room: Application Database Development - 308

Title: More than introduction to SQL Server Reporting Services aka SSRS

Abstract: In this session, we will cover the Why and How of SSRS. We will briefly compare SSRS Report Manager/Portal vs. custom reporting development, go thru SSRS internals, and build one simple report from scratch. To spice up the session, we would also evaluate a code transparency technique and also build reports on reports or essentially SSRS on SSRS.

Speaker(s):

Steve Rezhener

Track and Room: BI Platform Architecture, Development Administration - 308

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract: Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you’ve looked at these and like what they can add in Power BI or classic BI scenarios, but haven’t had a chance to dive in and figure all of this out? Now is the time! SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.

Speaker(s):

Kerry Tyler

Track and Room: BI Platform Architecture, Development Administration - 316

Title: SQL Server 2016 and R Service introduction

Abstract: Introduction of R in SQL Server R service One of the biggest changes in SQL Server 2016 on the analytics front is the inclusion of R into the database engine. SQL Server R Services is the result of Microsoft’s acquisition of Revolution Analytics. R is a popular open-source data analysis language that’s used by data scientists, statisticians and data analysts for data analysis, data exploration and predictive modeling. R can produce both data analytic results and data visualizations. However, in the past, the use of R in an enterprise environment involved several challenges. By marrying R with its core data platform, Microsoft is signaling that it is serious about advancing its analytic offerings not only in the cloud, but on-premise as well. This presentation will tell why it’s important for SQL developer to know R and vice versa.

Speaker(s):

Peixin Wang

Track and Room: Professional Development - 316

Title: Cloud 9 on AWS

Abstract: Beginners through Advanced Would you like to:

Launch any top-ISV software pre-configured to work with AWS Services when you need to, paying only for what you use by the hour, launched at the click of a button?
Compare multiple top-ISV software solutions that are marketed to “solve the same problems” to see which is the best fit for free?
Implement state-of-the-art software or unique software needed for particular clients without licenses, implementations or management?
Have a “playground” of a plethora of intelligent software solutions to innovate improve your business?
Decrease the time it takes to plan, forecast, make decisions?
Increase developer productivity/operational efficiency? Come hear the biggest secret in maximizing the full offerings of AWS! Gartner claims because of AWS’ multi-year advantage over competitors, it has the largest ecosystem of top-line ISVs (1,000+ vendors, well-over 3,000 solutions) to augment AWS Services. Learn how to benefit!

Speaker(s):

Kim Schmidt

Track and Room: Cloud Application Development Deployment - 112

Title: Outsourcing database administration to your users.

Abstract: How outsource administrative tasks to your end user groups in a safe, secure, and repeatable pattern. Now you no longer have to pause and stop what you are doing to create that new login, and replicate it to your Disaster Recovery. You do not have to stop and perform a backup/restore to refresh the development environment. Empower your end users, let them do this on their own without compromising your security.

There will be a demo!

Speaker(s):

Stephen Mokszycki

Track and Room: Enterprise Database Administration Deployment - 309

Title: Better Report Management and Development Techniques

Abstract: Are you struggling with managing your Reporting Services implementation? Has it become clumsy, convoluted or just simply not great? This session, designed for users who are experienced with Report Manager, will highlight some methods to simplify and unify your Reporting Services implementation. See how to make your reports pop with polish while shortening your development time and easing your maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. The session will conclude with a look at how you can have a custom report footer, which you can use on any version of Reporting Services, that shows report utilization, performance details, stored procedures and data sets used in the report. Leave excited about how great your Reporting Services implementation can be.

Speaker(s):

Ted Stathakis

Track and Room: BI Platform Architecture, Development Administration - 309

Title: Self-driving Solutions on AWS

Abstract: This is your antidote to a boring lunchtime! Success is an AWS Marketplace game! Time is the new currency, so things absolutely, positively have to provide fast ROI. It’s everything you want to solve. Common sense, uncommon results. Betcha’ can’t eat just one! AWS Marketplace Solution demos: Botmetric is an intelligent cloud management solution for AWS to simplify the work of engineers, offering cost management/cloud governance, security/compliance, ops/cloud automation solutions to make cloud management E-A-S-Y! Zoomdata, a Visionary in Gartner Magic Quadrant for Business Intelligence and Analytics Platforms, delivers the fastest visual analytics for big data from any source, on premise in the cloud - without moving the data! Their micro-query architecture delivers results on billions of records in seconds, accelerating time-to-insight. Seeing is believing!

Speaker(s):

Kim Schmidt

Track and Room: Cloud Application Development Deployment - 112

Title: AlwaysOn from the Front Lines

Abstract: Ready? Aim? Fire AlwaysOn with the wizard and just keeping next’n next and you’ll Almost get AlwaysOn On. In a perfect world, it would just work? What do you do when it doesn’t? When the wizard breaks in the middle what are the troubleshooting steps you need to do? How do you test your background plan? Learn where to look and more importantly what to do when the wizard just ran out of magic dust and leaves you in the red! Learn from my mistakes which can save you hours of troubleshooting. Planning is the key to a successful implementation, but even that can be a challenge with hidden knowns.

Beginners as well as experts will learn from my experience with AlwaysOn. Don’t just keep pushing that NEXT button until you come and join my session.

Speaker(s):

Sitotpal Sarkar

Track and Room: Enterprise Database Administration Deployment - 311

Title: How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca

Abstract: In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective. We’ll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches. We’ll review the common performance problems which people encounter, and how to resolve them. Finally, we’ll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines. Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.

Speaker(s):

Denny Cherry

Track and Room: Enterprise Database Administration Deployment - 317

Title: SQL server on containers – Part 1

Abstract: Windows 16 introduced containers which has started a new era which will help with VM consolidation big time, the future of SQL Implementations is about installing SQL Server on Windows 16 NANO Server running as containers. It provides an isolated, resource controlled, predictable and portable operating environment inside a VM.

SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. Docker has industry-wide support with hosted services on Azure/AWS, monitoring, logging, orchestration. No matter you want to deploy SQL server on Linux or windows containers are the way…

This introductory session will help seasoned SQL Server DBA/Developers understand the basics of containers and windows 16 NANO servers running SQL Server 2016 17. in subsequent session Prakash will cover several demos and share scripts to start with containers

Speaker(s):

Prakash Heda

Track and Room: Enterprise Database Administration Deployment - 111

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Abstract: Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo-heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally, we’ll take a look at how standards can help quicken turnaround time when refactoring T-SQL. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.

Speaker(s):

Mickey Stuewe

Track and Room: Application Database Development - 309

Title: SSIS Project Deployment: The T-SQL Way

Abstract: Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you’re looking for a repeatable deployment method that can be source controlled, there’s another way…the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You’ll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments…the T-SQL way!

Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.

Speaker(s):

Peter Kral

Track and Room: Enterprise Database Administration Deployment - 308

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract: Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an “easy” button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.

Speaker(s):

Kerry Tyler

Track and Room: Application Database Development - 111

Title: Concurrency in SQL Server - a.k.a. What to do when your database has more than 1 user

Abstract: Have you ever worked on a database used by more than one person? ;-) If so, then this session is for you! In this session we’ll talk about what happens when multiple processes compete for the same resources (aka “Concurrency”). We’ll break down SQL Server’s isolation levels, and the trade-offs between concurrency and such scary-sounding things as “dirty”, “phantom” reads. There will be practical demo’s and some real-life examples “from the trenches”. There are a lot of misconceptions out there about this topic, you may be surprised!

Speaker(s):

Thomas Hull

Track and Room: Application Database Development - 112

Title: DBA 101 – Let’s Get It Started

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 go through 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: Enterprise Database Administration Deployment - 301

Title: Understanding Parameter Sniffing

Abstract: Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - 112

Title: Building a Dashboard in an Hour using Power BI

Abstract: Demonstrate the steps to import raw data from text file and Excel file into Excel 2016, and then build a dashboard using PowerPivot and Power BI.

Speaker(s):

Vazi Okhandiar

Track and Room: Analytics and Visualization - 301

Title: How I Met Your SQL Server

Abstract: Historical review of how SQL Server has evolved over the years; Significant additions and new features in some of the new versions; Which new versions were adopted more rapidly? Why not all new versions?! Have you always upgraded to every new version of SQL Server?

Speaker(s):

Ben Aminnia

Track and Room: Application Database Development - 311

Title: Diagnosing SQL Amnesia: Where is Your Memory Going?

Abstract: Memory problems in humans can be caused by injuries, traumatic events, or physical deficiencies, and interestingly enough the same holds true for SQL Server! In this preconference seminar you’ll learn about common patterns and problems that affect SQL Server memory usage and how to solve them, based on real world scenarios. From incorrectly-sized hardware for a specific workload to code and schema design challenges that tax SQL Servers memory usage, this seminar will give you the practical tools necessary to tackle even the most challenging memory problems.

Speaker(s):

Jonathan Kehayias

Track and Room: Enterprise Database Administration Deployment - 317

Title: But it worked great in Dev! Perfomance for Devs

Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.

Speaker(s):

Randy Knight

Track and Room: Application Database Development - 112

Title: Do More Than Just Talk

Abstract: Most of us can talk - we’ve been doing it since we were young. Unfortunately there can be a huge gap between talking and effective communication. While not all of us will be chosen for TED talks, there are methods we can use to keep our audience engaged and help our message to be understood whether you’re asking your boss for a raise or presenting a session at the PASS Summit. Understand the barriers to effective communication and learn to use words, tone, expression and behavior to enhance your communicate skills.

Speaker(s):

Lori Edwards

Track and Room: Professional Development - 301

Title: Understanding the SQL Server Transaction Log

Abstract: The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

Speaker(s):

Randy Knight

Track and Room: Enterprise Database Administration Deployment - 308

Title: SQL Server in Azure, One Year In

Abstract: What’s it like moving your SQL based application to the Cloud? There is a lot to consider before you make the leap. Azure VM (IaaS) or Service (PaaS)? Resource Manager or Classic Deployment, Authentication, Application Architecture, Networking, Backups, Migration Planning, Performance, Cost Estimating and Monitoring are issues that you will need to address for a successful implementation. During this session I will cover how these issues were addressed from planning stage one year ago to a production SQL server in Azure. Pickup tips and scripts. Learn from our mistakes and assumptions and avoid blind alleys.

Speaker(s):

Sergio Pacheco

Track and Room: Enterprise Database Administration Deployment - 316

Title: Processing Big Data with Azure Data Lake Analytics

Abstract: In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft’s new Big Data language, U-SQL.

Speaker(s):

Sean Forgatch

Track and Room: BI Platform Architecture, Development Administration - 316

Title: Building Your Way to Better Database Testing

Abstract: Test Data Builders. Ever heard of them? That’s ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they’ll fit your needs.

Speaker(s):

Phil Helmer

Track and Room: Application Database Development - 311

Title: New features of SSIS 2016

Abstract: We will discuss deprecated features, new features, and the still missing features. We will also test-drive some selected features, like Balance Data Distributor, OData, Control parts, and Expression Task.

Speaker(s):

Steve Rezhener

Track and Room: BI Platform Architecture, Development Administration - 308

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract: This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

Speaker(s):

Benjamin Nevarez

Track and Room: Application Database Development - 112

Title: Fun with SQL Server Spatial Data

Abstract: This session is an introduction to the spatial features in SQL Server. In this session, you will learn how to create, procure and leverage spatial data. You will be made aware of tools you can use to integrate your own spatial data with a variety of public data sources such as the Census Bureau, National Weather Service, etc. Functions and T-SQL commands related to spatial data analysis will be demonstrated. We will end the session by using the geometry data type to actually mimic a bitmapped picture using SQL (that’s the fun part!).

Speaker(s):

Mindy Curnutt

Track and Room: Application Database Development - 311

Title: Weird stuff I saw … while supporting a Java team

Abstract: After spending more than a decade completely devoted to the Microsoft stack, I did some time supporting a Java team. Yes, sure, Java is just another language so there aren’t really and issues that are absolutely unique to the Java world. But it is a different stack, different culture, and different group of folks giving bad advice to developers … just enough different to keep life interesting. Come hear about my misadventures with server side cursors, output parameters, integrated authentication, and NOCOUNT settings.

Speaker(s):

Rick Lowe

Track and Room: Application Database Development - 311

Title: Tuning SQL Server Transactional Replication

Abstract: If you worked with transactional replication at some point in your career, then you had to answer the dreaded question why is the data so old in the subscriber? Unable to find the culprit, you just re-synch the data, hate replication, and move on. Wonder what you could do differently? In this session, you will learn the moving parts, the bottlenecks, the tuning knobs, and perhaps to love replication.

Speaker(s):

Paul Ou Yang

Track and Room: Enterprise Database Administration Deployment - 301

Title: SQL Server Containers and Clones

Abstract: “Containers and Clones for SQL Server Development and Test”

Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database database cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.

Speaker(s):

Paul Stanton

Track and Room: Enterprise Database Administration Deployment - 309

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: Application Database Development - 309

Speakers

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

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Sergio Pacheco

Twitter: - @sergmis

LinkedIn: Sergio Pacheco

Contact: https://sergessqlnotes.wordpress.com/

Sergio Pacheco is Cloud and Data Platfom Admin for Mesilla Valley Transportation in Las Cruces, NM. He began his SQL Server career as an “Accidental DBA” in 2005 and is currently the Chapter Leader for the Las Cruces - El Paso SQL Server User Group. He enjoys problem solving, learning, implementing database solutions and working with great people. When he’s not working, he loves to share what he has learned and recharges by swimming competitively, mountain biking, trail running and making a mean Cochinita Pibil

Andrew Nakamura

Twitter: - @andrewn2010

LinkedIn: Andrew Nakamura

Contact: http://andynakamura.com

Andrew Nakamura is a SQL DBA at Keck Medicine of USC. His experience spans enterprise wide level of support using Powershell, DBATools and other custom scripts to maintain 115 servers with over 1600 databases. He has expertise in both Financial and Healthcare worlds and knows the challenges they face. He has presented in all Southern California SQLSaturdays and will continue to push bleeding edge solutions. He enjoys the command line syntax and wish like to play with Core Editions of Windows and SQL 2017. He’s added to his current passions of Azure, Automation, High Availability, Family and Faith, Toastmasters, and now, SQL on Linux. Long live the command shell!

Vazi Okhandiar

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

LinkedIn: Vazi Okhandiar

Contact: https://vaziok.wordpress.com/

Microsoft Certified and CTT+ Certified Trainer with over 20 years of experience in proving Information Technology (IT) training and consulting services to both small and large companies. Corporate Training included in Software Development, Project Management, Database Design and Database Administration at NR Computer Learning Center, mLogica, National University, DeVry Institute of Technology, Orange Coast College and Irvine Valley College. Extensive experience in Software Development, Mobile Application Development, Databases Design amp; Development and Project Management. Previously worked for Toyota, General Motors (GM), Computer Science Corporation (CSC) and Electronic Data Systems (now HP).

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.

Steve Rezhener

Twitter: - SteveRezhener

LinkedIn: Steve Rezhener

Contact: https://www.datasteve.com

Steve Rezhener is a database professional most enthusiastic about Microsoft BI stack. He started his IT career trying to outsmart Excel using VBA, moved to VB 6.0, VB.NET, C# and suddenly got addicted to SQL Server 2005 and related tools. His lunch menu for 10+ years consisted of SSIS SSRS with some occasional SSAS for breakfast. Steve is super excited about the innovation baked into AWS, Azure, PowerBI, and SQL Server 2017. Steve is a holder of relics such as DBA Microsoft certifications on SQL Server 2005 and SQL Server 2008. He is an organizer of SQLSaturday in Los Angeles (#SQLSatLA), LA Data Platform (aka SQLMalibu) and is an SQLSaturday speaker. When he isn’t dealing with data, he fixes a kitchen, plays an XBOX and enjoys his kids.

Jonathan Kehayias

Twitter: - @SQLPoolBoy

Contact: https://www.sqlskills.com/blogs/jonathan

Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.

Phil Helmer

Twitter: - @philhelmer

LinkedIn: Phil Helmer

Contact: http://www.philhelmer.com

Phil has been designing and building relational databases in a variety of industries ever since he first realized how many people don’t understand the limitations of Excel and sticky notes as databases. When he was a poor college student, that meant teaching himself MS Access. After moving to SQL Server 13 years ago, he found out about the PASS community and never looked back. He now spends his days developing databases using T-SQL, exploring data management tools techniques and trying to make sense of Microsoft’s marketing.

Steve Rezhener

Twitter: - SteveRezhener

LinkedIn: Steve Rezhener

Contact: https://www.datasteve.com

Jeff Prom

Twitter: - @JeffProm

LinkedIn: Jeff Prom

Contact: http://www.jeffprom.com

Jeff Prom is a Data and BI Developer with over 19 years experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Bridgepoint Education as a Business Intelligence Data Architect.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Kim Schmidt

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

LinkedIn: Kim Schmidt

Contact: https://awskimschmidt.com/

Kim Schmidt has been working in the technology industry for more than 10 years with an extremely broad array of titles and using very diverse technologies. She holds many industry certifications and awards. Companies Kim has worked for or with include Microsoft, Dun Bradstreet, Google, Amazon Web Services, and a couple of Augmented Reality companies. Kim also contracts for many of the leading data analytics independent software vendors in AWS Marketplace.

Kim has her own Cloud AWS Specialist company http://dataleader.io/ that focuses on end-to-end AWS Solutions, including Architecture, Data, Business Intelligence, Advanced Analytics, Coding, Migrations and more “AWS-goodness!” DataLeader is an AWS Partner and Vendor.

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Paul Ou Yang

LinkedIn: Paul Ou Yang

Contact: http://www.paulouyang.blogspot.com

Paul is a seasoned professional with vast experience in database administration, data visualization, and automation. He is a Microsoft Certified Master in SQL server and a Solutions Architect for Micron Technology, Inc. When he is not playing with his 3 children, he blogs at paulouyang.blogspot.com

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.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

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

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

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.

Benjamin Nevarez

Twitter: - @BenjaminNevarez

Contact: http://www.benjaminnevarez.com/

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design.

Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.

Jeff Prom

Twitter: - @JeffProm

LinkedIn: Jeff Prom

Contact: http://www.jeffprom.com

Peter Kral

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

LinkedIn: Peter Kral

Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Ben Aminnia

Contact: http://www.pointercorp.com

Ben Aminnia is a database architect / .NET developer / consultant at Pointer Corporation with over 25 years of experience in developing database systems and managing a team of SQL Server developers and DBAs. He’s also the architect of Virtual Information Portal (VIP) System and the past-president of Los Angeles SQL Server Professionals Group.

Kellyn Pot’Vin-Gorman

Twitter: - DBAKevlar

LinkedIn: Kellyn Pot’Vin-Gorman

Contact: http://dbakevlar.com

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Peter Kral

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

LinkedIn: Peter Kral

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Sean Forgatch

Twitter: - 4gatchsql

LinkedIn: Sean Forgatch

Contact: https://www.modern-dataengineering.com

Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQLSaturday Madison.

Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Sitotpal Sarkar

• Years of Database Administration, DBMS, RDBMS, T-SQL and SSIS experience. • Extensive experience in SQL Server 2005,to 2017 • SQL Server Clustering 2012 to 2017 and Always On Available Group • Log Shipping (2005,to 2017) • Performance Tuning(2005,to 2017) • Create, Backup, Restore Databases(2005,to 2017) • SQL Server Builds and Upgrade (2005,to 2017) • Database Management Process Documentation • SQL Server Disc space Management • Design, schedule and execute SQL server jobs involving Transact SQL, SSIS packages and DTS packages. • Created various triggers and MS-SQL tables in the databases using relational database principle. • Proficient in data transformation. • Experience working with a variety of ERP systems including P

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Lori Edwards

Twitter: - www.twitter.com/loriaedwards

LinkedIn: Lori Edwards

Contact: http://www.sqlservertimes2.com

Stephen Mokszycki

Twitter: - mokszs

LinkedIn: Stephen Mokszycki

Stephen.Mokszycki@outlook.com DBA for ~4+years, IT Professional for 7.5 years. Currently I am a Data Architect Worked with SQL 2000/2005/2008/2012/2014 I’m currently working on a small environments: 5 instances, 60 databases, 1TB of data
Previously I worked on a large environment: 300+ Instances, ~6000 databases, 10s TBs of data. Automation is my favorite tool.

Kim Schmidt

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

LinkedIn: Kim Schmidt

Contact: https://awskimschmidt.com/

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Peixin Wang

15 years working experience as SAS Programmer/Developer; 12 years plus Oracle Developer/DBA; 4 years plus Qlikview Developer/DBA; 8 years SQL Server Developer/DBA

Thomas Hull

Twitter: - @sdsql

LinkedIn: Thomas Hull

Thomas AJ Hull is a database professional based in San Diego, with 20+ years of SQL Server experience (since v6.5). AJ has worked as a consultant in the financial and biotech industries, and is currently a DBA Team Lead at Union Bank. He earned a BS in Engineering at Cornell University, and a master’s at Rochester. His certifications include MCSE: Data Platform MCSE: Data Management and Analytics. AJ enjoys mentoring developers and junior DBAs, and is always striving to learn more through continuing education and involvement in the SQL Server community. His goal is to pass along hard-earned knowledge with practical actionable advice, and believes that the best way to learn something is to teach it.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Paul Stanton

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

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

SQLSaturday #661 - San Diego 2017

Sessions

Title: SQL Injections and How to Stop Them

Title: The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization

Title: How to be the Most Important IT Person in the Room: Why Data Experts Own the Future

Title: A Masters Passport to Extended Events

Title: Bare Naked Skinny on SQL Server

Title: From Zero to Hero: The New Powershell DBA

Title: End-to-End Troubleshooting Checklist for SQL Server

Title: SQL server on containers – Part 2

Title: Why should I care about … the plan cache?

Title: JSON and the Astronauts

Title: More than introduction to SQL Server Reporting Services aka SSRS

Title: 45 Minutes to Your First SSAS Tabular Model

Title: SQL Server 2016 and R Service introduction

Title: Cloud 9 on AWS

Title: Outsourcing database administration to your users.

Title: Better Report Management and Development Techniques

Title: Self-driving Solutions on AWS

Title: AlwaysOn from the Front Lines

Title: How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca

Title: SQL server on containers – Part 1

Title: Changing Your Habits to Improve the Performance of Your T-SQL

Title: SSIS Project Deployment: The T-SQL Way

Title: Managing Your Schema with Database Projects in Visual Studio

Title: Concurrency in SQL Server - a.k.a. What to do when your database has more than 1 user

Title: DBA 101 – Let’s Get It Started

Title: Understanding Parameter Sniffing

Title: Building a Dashboard in an Hour using Power BI

Title: How I Met Your SQL Server

Title: Diagnosing SQL Amnesia: Where is Your Memory Going?

Title: But it worked great in Dev! Perfomance for Devs

Title: Do More Than Just Talk

Title: Understanding the SQL Server Transaction Log

Title: SQL Server in Azure, One Year In

Title: Processing Big Data with Azure Data Lake Analytics

Title: Building Your Way to Better Database Testing

Title: New features of SSIS 2016

Title: Dive into the Query Optimizer - Undocumented Insight

Title: Fun with SQL Server Spatial Data

Title: Weird stuff I saw … while supporting a Java team

Title: Tuning SQL Server Transactional Replication

Title: SQL Server Containers and Clones

Title: The Ins and Outs of SQL Indexes

Speakers

Sponsors