sqlsathistory

Nr: 740

SQLSaturday #740 - Orange County 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Marsha Pierce	Database Administration	Mom Rules for Managing Enterprise Database Environments
08:30:00	Charles Embry Jr	Database Development	The Mac DBA, using Docker and SQL Operations Studio
08:30:00	Mohammad Darab	Professional Development	3 Lessons Learned in Successful Consulting
08:30:00	Armando Lacerda	BI Architecture, Development Administration	Insights with massive data ingestion and Power BI
08:30:00	Suresh Datla	BI Analytics, Visualization Presentation	Power BI Adoption Framework
08:30:00	Eric Bragas	Azure Cloud	Deep Dive in Azure Data Factory V2
08:30:00	Joseph D'Antoni	Azure Cloud	Azure Infrastructure
08:30:00	Randy Knight	Database Development	But it worked great in Dev! Perfomance for Devs
09:45:00	Jeff Prom	Database Development	Stop Wasting Valuable Time and Resources - Performance Tune Your Jobs
09:45:00	Melody Zacharias	Professional Development	Confidence: The Fuel For Action
09:45:00	Chris Hyde	BI Analytics, Visualization Presentation	Python in SQL Server 2017
09:45:00	John Morehouse	Azure Cloud	Azure Basics for the DBA
09:45:00	Vern Rabe	Database Administration	It's Time for a Change: Temporal Table Support in SQL Server 2016/17
09:45:00	Rick Lowe	Database Administration	Why Should I Care About ... Partitioned Views?
09:45:00	Peter Kral	BI Architecture, Development Administration	SSIS Project Deployment: The T-SQL Way
09:45:00	Ted Stathakis	BI Architecture, Development Administration	Reporting Services 2016: New Features Smart Migration Strategy
11:00:00	Martin Schoombee	BI Analytics, Visualization Presentation	Power BI: What you need to know
11:00:00	Rie Irish	Professional Development	Let Her Finish: Supporting Women's Voices in Technology
11:00:00	Armando Lacerda	Azure Cloud	Microsoft Azure for SQL Server Professionals - Get your head in the cloud
11:00:00	Andrew Nakamura	Database Administration	Transforming Your Brain with SQL 2017 with Linux
11:00:00	Jonathan Stewart	BI Architecture, Development Administration	An introduction to the magical world of BIML!
11:00:00	Elaena Bakman	Database Development	The Magic of SSISDB
11:00:00	PEIXIN WANG	BI Architecture, Development Administration	SQL Server plays a pivot role in data sciences and business intelligence
11:00:00	Brandon Leach	Database Administration	Introduction to powershell for the SQL Server DBA
12:30:00	Diane Schuster	BI Architecture, Development Administration	CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:30:00	SQLSaturday Orange County	Professional Development	Ledgent : Resume Best Practices
12:30:00	SQLSaturday Orange County	Database Administration	RedGate: Extending DevOps to SQL Server
12:30:00	SQLSaturday Orange County	Database Administration	Dell: #GetModern with Dell EMC
12:30:00	SQLSaturday Orange County	BI Analytics, Visualization Presentation	DesignMind: Sponsor Showcase Session
12:30:00	SQLSaturday Orange County	Database Administration	Quest: Realtime Monitoring Workload Analysis with Spotlight on SQL Server
12:30:00	SQLSaturday Orange County	Database Administration	SQL Solutions Group: The DBA Is Dead. Long Live the Remote DBA.
13:30:00	Rie Irish	Professional Development	Well, actually... How to not be THAT guy in IT
13:30:00	Deji Akomolafe	Database Administration	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
13:30:00	Warren Sifre	BI Architecture, Development Administration	Introduction to Big Data
13:30:00	Taiob Ali	Azure Cloud	Azure Automation: Your SQL Agent in the Cloud
13:30:00	Steve Rezhener	BI Architecture, Development Administration	Introduction to SQL Server Integration Services, what's new in SSIS 2016, and a test-drive
13:30:00	Ike Ellis	BI Analytics, Visualization Presentation	60 Reporting Tips in 60 Minutes
13:30:00	Brandon Leach	Database Administration	Data Pages, Allocation Units, IAM chains... Best Practice Edition
13:30:00	Andrew Karcher	BI Architecture, Development Administration	Foundations of a Data Driven Organization
14:45:00	Phil Robinson	BI Architecture, Development Administration	Data Wrangling for Reporting Analytics using Power BI
14:45:00	Simon Cho	Database Development	[StepbyStep] SQL server Index operation for beginner to expert.
14:45:00	Warren Sifre	BI Architecture, Development Administration	Introduction to BI Architecture
14:45:00	Amy Herold	Professional Development	Making the Leap from Developer to DBA
14:45:00	Grant Fritchey	Database Development	The Query Store and Query Tuning in SQL Server
14:45:00	Jonathan Stewart	BI Analytics, Visualization Presentation	From problem to Power BI: A journey in data visualization
14:45:00	Eric Bragas	Azure Cloud	Modern ETL with Azure Data Factory, Data Lake, and SQL Database
14:45:00	Thomas Hull	Database Administration	Concurrency in SQL Server - Managing More Than 1 User
16:00:00	Vazi Okhandiar	BI Analytics, Visualization Presentation	Building a Dashboard in an Hour using PowerPivot Power BI
16:00:00	Omar Masri	BI Architecture, Development Administration	Database Security in an Insecure World
16:00:00	Taiob Ali	Database Administration	Performance Troubleshooting made easier - new features in Management Studio !
16:00:00	Melody Zacharias	Azure Cloud	Azure Data Catalog – Turning Unused Assets into Usable Knowledge
16:00:00	John Wells	Database Development	Fundamentals That Will Improve Your Query Performance!
16:00:00	Grant Fritchey	Database Administration	Data Protection Privacy in the World of Database DevOps
16:00:00	Denny Cherry	Database Administration	Storage For the DBA
16:00:00	Leonard Lobel	Database Development	New SQL Server 2016 Security Features for Developers

SessionID: 72871

Mom Rules for Managing Enterprise Database Environments

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Database Administration

Speaker: Marsha Pierce

Title: Mom Rules for Managing Enterprise Database Environments

Abstract:

Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

SessionID: 72953

The Mac DBA, using Docker and SQL Operations Studio

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Database Development

Speaker: Charles Embry Jr

Title: The Mac DBA, using Docker and SQL Operations Studio

Abstract:

In this session we will go over the steps involved with getting a Database Dev environment set up on your Mac using SQL Server on Linux,Docker and SQL Operations Studio. We will go over installation of Docker and SQL Server, tips and tricks on data persistence in Docker, and how to connect and work with SQL Server running Docker using SQL Operations Studio.

SessionID: 73208

3 Lessons Learned in Successful Consulting

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Lessons Learned in Successful Consulting

Abstract:

SessionID: 74134

Insights with massive data ingestion and Power BI

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: BI Architecture, Development Administration

Speaker: Armando Lacerda

Title: Insights with massive data ingestion and Power BI

Abstract:

We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.

You will learn:

• Power BI limits for accommodate data refresh and streaming datasets • Develop strategies for continuous and discrete data capturing for Power BI • Azure services options for near real time dashboards Power BI • SQL Server features to source discrete dataset for Power BI

SessionID: 77080

Power BI Adoption Framework

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: Suresh Datla

Title: Power BI Adoption Framework

Abstract:

One of the most critical areas of any application is Adoption. Power BI is no exception. In this session, I'll speak about some of the strategies, best practices, and experiences to increase adoption

SessionID: 77092

Deep Dive in Azure Data Factory V2

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Azure Cloud

Speaker: Eric Bragas

Title: Deep Dive in Azure Data Factory V2

Abstract:

Azure Data Factory V2 represents a major new release to the Microsoft's cloud data integration tool, and a complete paradigm shift from V1. We'll discuss which changes are the most significant and which features have stayed the same. Then, we'll dive into the inner workings of Data Factory V2 so we can discuss common usage patterns, such as loading data from multiple tables with a single pipeline, incrementally pulling data from source systems, and other data warehouse loading techniques.

SessionID: 78860

Azure Infrastructure

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Azure Cloud

Speaker: Joseph D'Antoni

Title: Azure Infrastructure

Abstract:

In this session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.

Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.

As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations.

SessionID: 80491

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 14-04-2018 - Session time: 08:30:00 - Track: Database Development

Speaker: Randy Knight

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, execution 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.

SessionID: 72481

Stop Wasting Valuable Time and Resources - Performance Tune Your Jobs

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Database Development

Speaker: Jeff Prom

Title: Stop Wasting Valuable Time and Resources - Performance Tune Your Jobs

Abstract:

We all know that execution plans and indexes are important pieces to performance tuning jobs. However, they are definitely not the only tools in the toolbox. This session will take a more high-level, holistic, approach to performance tuning jobs and their components. We will talk about where to start, how to identify problem areas, and many ways to improve performance. Many of the topics covered in the presentation come from real-world situations I've encountered. One example describes how we stopped a job after 13 hours and were able to tune it down to 8 minutes. Adding additional hardware is not always an option or the answer. Do more with what you have and tune your jobs. I'll show you how.

SessionID: 73220

Confidence: The Fuel For Action

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Professional Development

Speaker: Melody Zacharias

Title: Confidence: The Fuel For Action

Abstract:

Confidence is the fuel for action. How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try? The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?” Come explore this exciting topic with me, and we will see what we can accomplish together!

SessionID: 73293

Python in SQL Server 2017

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: BI Analytics, Visualization Presentation

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 73748

Azure Basics for the DBA

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Azure Cloud

Speaker: John Morehouse

Title: Azure Basics for the DBA

Abstract:

It's not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new found knowledge will help propel your career into the new landscape.

SessionID: 74190

It's Time for a Change: Temporal Table Support in SQL Server 2016/17

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: Vern Rabe

Title: It's Time for a Change: Temporal Table Support in SQL Server 2016/17

Abstract:

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.

SessionID: 74368

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: Rick Lowe

Title: Why Should I Care About ... Partitioned Views?

Abstract:

Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and possibly even after 2016 SP1.

SessionID: 75832

SSIS Project Deployment: The T-SQL Way

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: BI Architecture, Development Administration

Speaker: Peter Kral

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.

SessionID: 78984

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 14-04-2018 - Session time: 09:45:00 - Track: BI Architecture, Development Administration

Speaker: Ted Stathakis

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract:

With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality in SSRS 2016: A look at the new Report Manager interface, Mobile reports, KPIS and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to take an existing report and make it mobile friendly.

The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.

SessionID: 73134

Power BI: What you need to know

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: BI Analytics, Visualization Presentation

Speaker: Martin Schoombee

Title: Power BI: What you need to know

Abstract:

This session will explore every aspect of Power BI…from the technology used behind the scenes and the tenant/service in Azure, to data refresh options and development best practices. We’ll cover everything you need to know (and more) before you embark on your first Power BI project.

SessionID: 73544

Let Her Finish: Supporting Women's Voices in Technology

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices in Technology

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 74135

Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Azure Cloud

Speaker: Armando Lacerda

Title: Microsoft Azure for SQL Server Professionals - Get your head in the cloud

Abstract:

Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos.

You will learn: • Basic elements of Azure cloud ecosystem • VM disks specifics for SQL 2016/2017 • Azure SQL Database and Elastic pools • Azure Data Warehouse and Cosmos DB

SessionID: 74322

Transforming Your Brain with SQL 2017 with Linux

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Database Administration

Speaker: Andrew Nakamura

Title: Transforming Your Brain with SQL 2017 with Linux

Abstract:

By now, most of us heard of SQL on Linux when it was first released. It was also on the announcement of SQL 2017 which caught most of us by surprise, being that SQL 2016 was just released 16 months prior. Most of us were still using SQL 2008 and barely getting our organizations to adopt SQL 2012. The IT infrastructure we serve today probably wouldn't benefit from Linux since most of our servers are tightly woven with the Microsoft platform solution. So why bother learning SQL 2017 on Linux? Attend this session to find valuable lessons for every data professional should know whether Linux or Windows.

SessionID: 74423

An introduction to the magical world of BIML!

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: BI Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 75822

The Magic of SSISDB

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Database Development

Speaker: Elaena Bakman

Title: The Magic of SSISDB

Abstract:

The purpose of this presentation is to provide a better understanding of SSISDB and how it can be utilized to make the lives of developers and DBAs easier.

This presentation will demonstrate how to use SSISDB to script out deployments of folders, projects, environments and packages, and dynamically assign environment variables. We will write scripts to run our SSIS packages and use SSRS to kick them off. We will learn how to create SSRS Reports that recreate the All Executions and All Messages built-in reports and make them available to user developers.

SessionID: 77039

SQL Server plays a pivot role in data sciences and business intelligence

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: BI Architecture, Development Administration

Speaker: PEIXIN WANG

Title: SQL Server plays a pivot role in data sciences and business intelligence

Abstract:

Data science, Artificial Intelligence (AI), machine learning or Big Data are currently hot topics. there are many applications are claimed to provide full fledged functions on these fields and to cover the all the business users' need. In this session we will provide demo that how SQL server plays a pivot role for data analyst (developer, data scientist) to start over. As the first step is to get and store the relevant data from and to SQL Server, we will present how some of most popular data analysis applications (including Qlikview, Tableau, PowerBI, SAS, R and Python) connect to SQL server and run some basic data analysis procedures.

SessionID: 77996

Introduction to powershell for the SQL Server DBA

Back to calendar

Event Date: 14-04-2018 - Session time: 11:00:00 - Track: Database Administration

Speaker: Brandon Leach

Title: Introduction to powershell for the SQL Server DBA

Abstract:

In this introductory session we will introduce the basic concepts of powershell and show how we can utilize it to begin automating common tasks. In addition to the concepts below, we will also delve a bit into how the DBA role is changing and what we can learn from developers in regards to automation.

Tooling (Getting your developer environment setup) Variables Parameters Working with Strings Using Invoke-SQL and the SQL Server Management objects (SMO) Extensibility (installing and managing third party cmdlets) A brief introduction to the DBAtools.io cmdlets

Finally we will tie all this together with real world examples.

SessionID: 78573

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: BI Architecture, Development Administration

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 78790

Ledgent : Resume Best Practices

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: Professional Development

Speaker: SQLSaturday Orange County

Title: Ledgent : Resume Best Practices

Abstract:

In this session on Resume Writing and Interview Preparedness, you will learn how to craft the perfect resume to capture your dream employer’s attention! We will cover the Do’s and Don’ts for writing your Resume, Cover Letters, and how to make yours stand out. We will also discuss the Interview Process. Having a great Resume to get selected for an Interview is the first step, but then what? We will talk through all the most common steps of the Interview process, how to prepare, and how to follow up to give yourself the best shot of landing your dream job. We will wrap the Session with Questions and Answers to leave everyone feeling confident about their ability to write a Resume and prepare for an Interview.

SessionID: 78791

RedGate: Extending DevOps to SQL Server

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: Database Administration

Speaker: SQLSaturday Orange County

Title: RedGate: Extending DevOps to SQL Server

Abstract:

Most organizations are under pressure to speed up the software delivery cycle, whether that’s to respond more quickly to the needs of the business, the needs of your customers or just to keep up with the competition. Unfortunately the database is commonly considered a bottleneck. Without the right processes in place, database change management can slow things down, adding risk, uncertainty, and getting in the way of development and operations working together to deliver. Any organization that wants to fully benefit from a DevOps approach is going to have to overcome some specific challenges presented by the database. This session will teach you how to take DevOps principles and practices and apply them to SQL Server so that you can speed up the database delivery cycle at the same time you protect the information contained within.

SessionID: 78792

Dell: #GetModern with Dell EMC

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: Database Administration

Speaker: SQLSaturday Orange County

Title: Dell: #GetModern with Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 78793

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: SQLSaturday Orange County

Abstract:

Come learn what DesignMind can do for you!

SessionID: 78794

Quest: Realtime Monitoring Workload Analysis with Spotlight on SQL Server

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: Database Administration

Speaker: SQLSaturday Orange County

Title: Quest: Realtime Monitoring Workload Analysis with Spotlight on SQL Server

Abstract:

In this overview you’ll see how Spotlight on SQL Server gives you real-time performance alerts and brings together all of your critical SQL Server metrics into a single dashboard-style screen, color-coded for problem severity and clickable for rapid diagnostics. You’ll also see how Spotlight’s Wait Event and Workload Analysis screens enable a deep dive into which queries caused exactly how much of each type of workload at particular times.

SessionID: 80492

SQL Solutions Group: The DBA Is Dead. Long Live the Remote DBA.

Back to calendar

Event Date: 14-04-2018 - Session time: 12:30:00 - Track: Database Administration

Speaker: SQLSaturday Orange County

Title: SQL Solutions Group: The DBA Is Dead. Long Live the Remote DBA.

Abstract:

Over the past decade, the rate of change in the industry has accelerated exponentially and the always fluid role of a DBA has morphed to the point where many organizations don’t even have the role anymore or it is combined with other duties. What does this mean for the DBA? For developers? For organizations? While we certainly don’t have all the answers, we’ve been doing this for a very long time and have seen lots of trends and buzzwords come and go. This session will be a fun and open discussion on these trends and how outsourcing the mundane so your key people can focus on the highest value activities may be the best way to go for many organizations.

SessionID: 72354

Well, actually... How to not be THAT guy in IT

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: Rie Irish

Title: Well, actually... How to not be THAT guy in IT

Abstract:

Unless you've been in a cave, you've seen articles lately on what it's like to be a woman in tech. In 2017, waves of blogs and news articles tell us about those extreme examples of misogyny. Only they aren't fringe, one-off stories. It's happening to women you know.

IT can be an inhospitable place for women. Some call it a "bro-grammer" culture. Compared to men, women are leaving IT at 2.5x and are interrupted 3x as often. Our credentials are called into question. We're called emotional or aggressive. We have our own job explained to us. Sometimes its subtle. Other times it's overt. There's always that one guy who ruins it for the rest of you. It doesn't have to be that way. Most of the guys we work with are stand-up, respectable WIT allies. The problem is, you don't always notice when it happens. Learn what those subtle forms of sexism look like at work. Learn how you can stop that guy in his tracks. Learn how to not BE that guy, even when you're just trying to help.

SessionID: 72814

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: Database Administration

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i

SessionID: 73004

Introduction to Big Data

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: BI Architecture, Development Administration

Speaker: Warren Sifre

Title: Introduction to Big Data

Abstract:

We will discuss what exactly is Big Data. How it is defined? What technologies are involved? How it is leveraged? Why is it so exciting? What does this mean to me?

SessionID: 73157

Azure Automation: Your SQL Agent in the Cloud

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: Azure Cloud

Speaker: Taiob Ali

Title: Azure Automation: Your SQL Agent in the Cloud

Abstract:

You want to migrate your on premise SQL Database to cloud, and soon recognize that SQL Agent is not available. You heard the promise of spinning up databases on demand and turn off/dial down when not in use. Do you want to do this manually each time? Azure Automation comes to rescue. It is a service for simplifying cloud management. Using Azure Automation long-running, manual, error-prone, and frequently repeated tasks can be automated to increase reliability, efficiency, and time to value for your organization.

In this demo intensive session I will show you how to setup Azure Automation, walk you through a runbook example (a compilation of routine procedures and operations), execute runbook on demand and also show how to schedule the same. At the end of this session you will have solid understanding about how to automate Azure services including replacing SQL Agent functionality using Azure automation, and conveniently encapsulate within the common Azure portal experience.

SessionID: 74008

Introduction to SQL Server Integration Services, what's new in SSIS 2016, and a test-drive

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: BI Architecture, Development Administration

Speaker: Steve Rezhener

Title: Introduction to SQL Server Integration Services, what's new in SSIS 2016, and a test-drive

Abstract:

We will have an introduction to ETL, ETL software landscape and Microsoft SQL Server Integration Services a.k.a. SSIS in greater details. We will also discuss what's new in SSIS 2016. For the hands-on section, we will create a simple SSIS package and test-drive some selected features, like Balance Data Distributor, Control parts, and Expression Task.

SessionID: 74126

60 Reporting Tips in 60 Minutes

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: BI Analytics, Visualization Presentation

Speaker: Ike Ellis

Title: 60 Reporting Tips in 60 Minutes

Abstract:

SessionID: 77995

Data Pages, Allocation Units, IAM chains... Best Practice Edition

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: Database Administration

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Best Practice Edition

Abstract:

SessionID: 78009

Foundations of a Data Driven Organization

Back to calendar

Event Date: 14-04-2018 - Session time: 13:30:00 - Track: BI Architecture, Development Administration

Speaker: Andrew Karcher

Title: Foundations of a Data Driven Organization

Abstract:

What is Data Driven? You might have heard someone at your organization say you need to be more data driven, but what does it mean? How does your organization need to change to be able to support being data driven?

As you might imagine it is a little bit more complicated that just saying the words or putting together a few charts. This session will talk about the fundamental things that you need to think about to move to being more data driven. It is a combination of people, process, policy and technology. This session will give you a lot to think about how to apply the principles of being data applies to your company.

SessionID: 72426

Data Wrangling for Reporting Analytics using Power BI

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: BI Architecture, Development Administration

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics using Power BI

Abstract:

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse.

Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.

SessionID: 72758

[StepbyStep] SQL server Index operation for beginner to expert.

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: Database Development

Speaker: Simon Cho

Title: [StepbyStep] SQL server Index operation for beginner to expert.

Abstract:

Understanding Index internal operation is very important.

It is a fundamental knowledge of performance tuning and troubleshooting. However, Index internal seems very hard to understand because many materials explain it a very complicated way.

This presentation covers from basic concept of index to all of internal index structure. I will explain the index structure very simple concept. Therefore, all developer who attends this session could understand how index work with a Clustered index and a Non-clustered index together. Furthermore, this presentation will share very important tip how to troubleshooting index issue. This presentation would very help not only who does not know index but also, who know very well index internal.

SessionID: 73003

Introduction to BI Architecture

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: BI Architecture, Development Administration

Speaker: Warren Sifre

Title: Introduction to BI Architecture

Abstract:

There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We will go over an ideal architecture design and explain the various elements and tools that make up this architecture. We will use the Microsoft BI Stack as a perspective, but architecture can be replicated with various vendor tools.

SessionID: 73299

Making the Leap from Developer to DBA

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: Professional Development

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

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

SessionID: 74141

The Query Store and Query Tuning in SQL Server

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: Database Development

Speaker: Grant Fritchey

Title: The Query Store and Query Tuning in SQL Server

Abstract:

For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.

This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.

SessionID: 74425

From problem to Power BI: A journey in data visualization

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: BI Analytics, Visualization Presentation

Speaker: Jonathan Stewart

Title: From problem to Power BI: A journey in data visualization

Abstract:

Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

SessionID: 77093

Modern ETL with Azure Data Factory, Data Lake, and SQL Database

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: Azure Cloud

Speaker: Eric Bragas

Title: Modern ETL with Azure Data Factory, Data Lake, and SQL Database

Abstract:

The modern data warehouse architecture is changing, and the world of Azure tools that are enabling these changes are also forcing us to reevaluate the patterns we're using to load these warehouses. In this session, we'll discuss some of the prescient design patterns and technologies used to implement a scalable data warehouse ETL pipeline using Azure technologies such as: Data Lake, Data Factory V2, and SQL DB. We'll cover everything you need to know to architect your next cloud data warehouse and dive into the technical details of implementing each of these components.

SessionID: 78165

Concurrency in SQL Server - Managing More Than 1 User

Back to calendar

Event Date: 14-04-2018 - Session time: 14:45:00 - Track: Database Administration

Speaker: Thomas Hull

Title: Concurrency in SQL Server - Managing 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!

SessionID: 72078

Building a Dashboard in an Hour using PowerPivot Power BI

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: BI Analytics, Visualization Presentation

Speaker: Vazi Okhandiar

Title: Building a Dashboard in an Hour using PowerPivot 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.

SessionID: 72553

Database Security in an Insecure World

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: BI Architecture, Development Administration

Speaker: Omar Masri

Title: Database Security in an Insecure World

Abstract:

Database security is a hot topic, especially with all the recent breaches of major public companies. We know that behind every application or website somewhere lies a database with sensitive information. We also know that companies are pushing data access to an ever growing number of devices, including tablets, cell phones and smart watches. The Internet of Things (IoT) only heightens security concerns. So how do you protect your databases? What are your options, and what ramifications exist with each option? This presentation will provide a high level summary of prevailing database security options along with their pros and cons. Furthermore, an ideal two factor authentication solution is presented for education and consideration.

SessionID: 73158

Performance Troubleshooting made easier - new features in Management Studio !

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Database Administration

Speaker: Taiob Ali

Title: Performance Troubleshooting made easier - new features in Management Studio !

Abstract:

SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.

SessionID: 73219

Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Azure Cloud

Speaker: Melody Zacharias

Title: Azure Data Catalog – Turning Unused Assets into Usable Knowledge

Abstract:

Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community. This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization. The reason for this is simple: We live in the information age. Being able to leverage the data you gather is the invitation you need just to compete in information age.

ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day. By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use. By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.

SessionID: 73849

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Database Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

SessionID: 74139

Data Protection Privacy in the World of Database DevOps

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Database Administration

Speaker: Grant Fritchey

Title: Data Protection Privacy in the World of Database DevOps

Abstract:

SessionID: 74151

Storage For the DBA

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Database Administration

Speaker: Denny Cherry

Title: Storage For the DBA

Abstract:

One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

SessionID: 74441

New SQL Server 2016 Security Features for Developers

Back to calendar

Event Date: 14-04-2018 - Session time: 16:00:00 - Track: Database Development

Speaker: Leonard Lobel

Title: New SQL Server 2016 Security Features for Developers

Abstract:

With the release of SQL Server 2016, the database engine has been greatly enhanced for security, with three new features that you’ll learn about in this demo-packed session. With dynamic data masking (DDM), you can fully or partially conceal sensitive columns from query results. Masking does not modify data on in the table, it simply hides data from users that don’t have permission to see it. Row-level security (RLS) also hides data from unauthorized users, but at the row level. With RLS, you can create your own security policy to control which users can read or write specific rows in the table. Finally, Always Encrypted (AE) uses client-side encryption to ensure that data is encrypted in flight, not just at rest. Furthermore, the encryption keys are accessible only to the client. This guarantees that data cannot be decrypted on the server, easing the migration path to the cloud for users with highly sensitive data.

This site is open source. Improve this page.