sqlsathistory

Nr: 847

Back to Main list

SQLSaturday #847 - Orange County 2019

Start Time (24h) Speaker Track Title
08:30:00 Suresh Datla Data Analytics Power BI Security - End to End
08:30:00 Mitchell Bottel Database Administration Tips, Tricks and Secrets for the SQL Professional
08:30:00 Kathi Kellenberger T-SQL Introductions Introduction to T-SQL Windowing Functions
08:30:00 Monica Rathbun Professional Development I'm It - Survival Techniques for the Lone DBA
08:30:00 Kevin Mackey Other Don't just code it—Generate It
08:30:00 Rick Lowe Azure Cloud Technologies SQL Server on AWS - Elastic Compute Cloud vs Relational Database Service
08:30:00 PEIXIN WANG Data Analytics Move Over Dexter! We are Building a Enterprise Machine Learning Lab!
08:30:00 Sitotpal Sarkar Database Administration The Fast and Easy Methods to Automate your SQL Server builds
08:30:00 SUNG WOOK KANG Azure Cloud Technologies [Step by Step] How to Start SQL Server Docker container.
08:00:00 Ted Stathakis Other First Timer Orientation
09:45:00 Leonard Lobel Azure Cloud Technologies Introduction to Azure Cosmos DB
09:45:00 Warren Sifre Data Analytics Introduction to BI Architecture
09:45:00 Mohammad Darab Professional Development 3 Keys to Successful Consulting
09:45:00 Kathi Kellenberger T-SQL Introductions Querying SQL Server for Beginners
09:45:00 Simon Cho Azure Cloud Technologies [StepByStep] SQL Server on Container? What is Kubernetes?
09:45:00 Michellea David Database Administration Centralized SSIS
09:45:00 Ted Stathakis Presentation Visualization Reporting Services 2016: New Features Smart Migration Strategy
09:45:00 Jeff Prom Other Mastering Master Data Services
09:45:00 Brodie Brickey Database Administration SSIS Basics
11:00:00 Hasan Savran Other Not your Dad's SQL Server; Contemporary twist on a classic standby.
11:00:00 Mitchell Bottel Professional Development Effective Communication and Self Promotion for the IT Introvert (YOU!)
11:00:00 Denny Cherry Database Administration Table Indexing for the .NET Developer
11:00:00 Monica Rathbun Database Administration Performance Tuning, Getting the Biggest Bang for Your Buck
11:00:00 Vern Rabe Database Administration Better Query Performance from Proper Statistics Management
11:00:00 Ike Ellis Data Analytics Introduction to DAX
11:00:00 Meagan Longoria Presentation Visualization Practical Power BI Report Design Tips for the Non-Artist
11:00:00 Andrew Karcher T-SQL Introductions Back to Basics - The SELECT Statement
11:00:00 Alicia Moniz Data Analytics How to Introduce your Data Scientists to CI/CD
12:30:00 Kathi Kellenberger Other WIT: Women in Technology Panel Discussion
12:30:00 Vlad Vlasceanu Other Amazon Web Services: Using SQL Server on AWS
12:30:00 Diane Schuster Other CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:30:00 Trent Mera Other Quest: Real-time Monitoring with Spotlight on SQL Server and Foglight
12:30:00 Adam Zagorski Other Enmotus: Real-Time Storage Tiering for Performance and Capacity
12:30:00 SQLSaturday Orange County Other Dell EMC: SQL Server Get Modern Architecture
12:30:00 SQLSaturday Orange County Other Ledgent Technology: Resume, Interview Salary Negotiation Tips
12:30:00 Kevin Kline Other SentryOne: 5 Critical Considerations When Moving to the Cloud
12:30:00 SQLSaturday Orange County Other Data Advantage Group: Meta Data Management Governance
13:30:00 Grant Fritchey Azure Cloud Technologies Disaster Recovery High Availability on the Azure Data Platform
13:30:00 Armando Lacerda Professional Development DBA vNext
13:30:00 Jeff Iannucci Database Administration Faster Transactions: Query Tuning for Data Manipulation
13:30:00 John Morehouse Azure Cloud Technologies Azure Basics for the DBA
13:30:00 Brett Powell Azure Cloud Technologies Power BI Administration Solutions
13:30:00 Bill Fellows T-SQL Introductions What's new for Developers - SQL Server 2014-2017
13:30:00 Benjamin Nevarez Database Administration Dive into the Query Optimizer - Undocumented Insight
13:30:00 Joseph D'Antoni Database Administration Containers, Pods, and Databases- The Future of Infrastructure
13:30:00 Phil Robinson Data Analytics Power BI Desktop Tips and Best Practices for Projects and Data Preparation
14:45:00 Charles Embry Jr Professional Development Imposter Syndrome How to work through it
14:45:00 Hasan Savran Data Analytics How to use GeoSpatial Data in SQL Server
14:45:00 Grant Fritchey Database Administration Exploring Execution Plans
14:45:00 Deji Akomolafe Azure Cloud Technologies Successfully Virtualizing SQL Server on vSphere - Straight from the Source
14:45:00 Kevin Kline Database Administration SQL Server Internals and Architecture
14:45:00 John Wells Database Administration Simplify your Daily Tasks with DBATools!
14:45:00 John Morehouse Database Administration Temporal Tables – The New Hotness in Data Auditing
14:45:00 Elaena Bakman Other SSRS - Thinking Outside the Report
14:45:00 Patrick Partin Presentation Visualization What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf
16:00:00 Marsha Pierce Database Administration How To Talk To Your Storage Admin
16:00:00 Ginger Grant Data Analytics Using Azure Databricks to Develop Scalable Data Solutions
16:00:00 Thomas Hull Database Administration SQL Security, Encryption, Compliance
16:00:00 Vazi Okhandiar Presentation Visualization Building a Dashboard in an Hour using PowerPivot Power BI
16:00:00 Steve Rezhener Data Analytics Introduction to SSIS, and third-party tools like MelissaData and CozyRoc
16:00:00 Bill Fellows Other What is Biml and why are SSIS developers excited about it?
16:00:00 Andrew Nakamura Database Administration Do-It-Yourself Performance Monitoring
16:00:00 Randy Knight Professional Development Soft skills for Geeks: Don't be a flat boxer

SessionID: 88065

Power BI Security - End to End

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Data Analytics

Speaker: Suresh Datla

Title: Power BI Security - End to End

Abstract:

Their many aspects to consider when securing Power BI applications. Starting with authentication all the way to Row Level Security and everything in between. We will discuss the different elements as well as best practices.

SessionID: 88577

Tips, Tricks and Secrets for the SQL Professional

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Database Administration

Speaker: Mitchell Bottel

Title: Tips, Tricks and Secrets for the SQL Professional

Abstract:

Ever heard the term, "work smarter, not harder". A mantra to live by in my book. Over the years, I have seen, forgotten, seen again and forgotten again all of the shortcuts, tips and tricks we all take for granted. SO like a good DBA, I started to document and share all of these commands and shortcuts to share. Come see and learn many of the everyday shortcuts in SQL Server Management Studio (SSMS) that will help make your life easier on a daily basis.

SessionID: 89430

Introduction to T-SQL Windowing Functions

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: T-SQL Introductions

Speaker: Kathi Kellenberger

Title: Introduction to T-SQL Windowing Functions

Abstract:

T-SQL windowing functions can simplify many complex queries. They are the best thing that has happened to the T-SQL language in years, but many database professionals and developers haven’t heard about them.

They were initially introduced with SQL Server 2005. In 2012, Microsoft added several new functions that let you do things like pull values from different rows without a performance penalty. Attend this session to learn how T-SQL windowing functions apply to many real world examples.

SessionID: 89803

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 90503

Don't just code it—Generate It

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Other

Speaker: Kevin Mackey

Title: Don't just code it—Generate It

Abstract:

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.

Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.

SessionID: 90509

SQL Server on AWS - Elastic Compute Cloud vs Relational Database Service

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Azure Cloud Technologies

Speaker: Rick Lowe

Title: SQL Server on AWS - Elastic Compute Cloud vs Relational Database Service

Abstract:

Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.

SessionID: 90661

Move Over Dexter! We are Building a Enterprise Machine Learning Lab!

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Data Analytics

Speaker: PEIXIN WANG

Title: Move Over Dexter! We are Building a Enterprise Machine Learning Lab!

Abstract:

Dexter and Dee Dee are at it again! They managed to save the city with his super intellect and sister's hyperactive charm. We won't have to keep our lab a secret as you attend this session. Learn how to build your own Machine Learning Lab, without the keeping it underground. We will cover the fundational knowledge to get started because you don't want you blowing up things in production. Learn step-by-step in my demo to build a full lab so you too can save the city…or at least get started with Machine Learning today.

SessionID: 90718

The Fast and Easy Methods to Automate your SQL Server builds

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Database Administration

Speaker: Sitotpal Sarkar

Title: The Fast and Easy Methods to Automate your SQL Server builds

Abstract:

Are you still clicking around the SQL Server GUI installation? Have you seen the many new features that are different from version to version? Wouldn't it be nice to standardize your SQL installations so that on every new release there wasn't much to change, but were still able to take advantage of new features? Attend this session and we'll walk through some of the installation scripts that I have tested and built from SQL 2008 to SQL 2017.

After this session, you'll learn the benefits you can do from a command line install, quickly provision SQL Servers and prepare for future releases without too much maintenance. You'll also learn how to take advantage of updates and new features by adding a few options into your script.

SessionID: 90731

[Step by Step] How to Start SQL Server Docker container.

Back to calendar

Event Date: 13-04-2019 - Session time: 08:30:00 - Track: Azure Cloud Technologies

Speaker: SUNG WOOK KANG

Title: [Step by Step] How to Start SQL Server Docker container.

Abstract:

What is SQL Server Docker? How are existing SQL Server environments different from the concept of using SQL Server Docker?

During the given session, I'd like to go over the basic theory of the docker, how to install SQL Server on it, and a few important things to check while operating it.

SessionID: 91587

First Timer Orientation

Back to calendar

Event Date: 13-04-2019 - Session time: 08:00:00 - Track: Other

Speaker: Ted Stathakis

Title: First Timer Orientation

Abstract:

If this is your First Time at a SQLSaturday come for this quick introduction and get some tips on how to best do the day.

SessionID: 88928

Introduction to Azure Cosmos DB

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Azure Cloud Technologies

Speaker: Leonard Lobel

Title: Introduction to Azure Cosmos DB

Abstract:

This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency.

We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda

SessionID: 89043

Introduction to BI Architecture

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Data Analytics

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: 89460

3 Keys to Successful Consulting

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Keys to Successful Consulting

Abstract:

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.

SessionID: 89632

Querying SQL Server for Beginners

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: T-SQL Introductions

Speaker: Kathi Kellenberger

Title: Querying SQL Server for Beginners

Abstract:

New to SQL Server but curious how to get started with queries? Attend this session to learn the basics. You'll learn how to return data from a table, and then filter and order the results.

SessionID: 89740

[StepByStep] SQL Server on Container? What is Kubernetes?

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Azure Cloud Technologies

Speaker: Simon Cho

Title: [StepByStep] SQL Server on Container? What is Kubernetes?

Abstract:

Docker and Kubernetes are becomes very hot industry since last couple of years.

SQL Server used to run only on Physical machine. Now, it's not any more strange or wrong that SQL server run on VM.

This session is designed for understanding about container and how SQL server could run on container.

There are 2 types of applications, Stateless and Stateful. We will go over the difference between them and will deliver the detail cases how SQL server could adjust in Container environment.

Therefore, developer or DBA could choose better architecture in various conditions.

Within this session will cover what the market demand is and what SQL server can do on the demand.

SessionID: 89875

Centralized SSIS

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Database Administration

Speaker: Michellea David

Title: Centralized SSIS

Abstract:

Store SSIS on one SQL Server in a centrally managed location. Easily scale resources to handle SSIS execution, keep the ETL workload away from other databases, and standardize multiple SQL instances using the same SSIS package without opening Visual Studio. Review logs in one centralized location. Centralized SSIS is available in version SQL Server 2012 and later.

SessionID: 90253

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Presentation Visualization

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: 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 create mobile reports. The session will cover tips for a smart migration to 2016.

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: 90265

Mastering Master Data Services

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Other

Speaker: Jeff Prom

Title: Mastering Master Data Services

Abstract:

Master Data Services enables you to manage a master set of your organization's data. You can organize the data into models, create rules for updating the data, and control who updates the data. With Excel, you can share the master data set with other people in your organization. Data stewards can use Excel to help manage the data repository and ensure that your MDS data is always up-to-date and accurate.

In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.

SessionID: 90674

SSIS Basics

Back to calendar

Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Database Administration

Speaker: Brodie Brickey

Title: SSIS Basics

Abstract:

Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program.

SessionID: 88311

Not your Dad's SQL Server; Contemporary twist on a classic standby.

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Other

Speaker: Hasan Savran

Title: Not your Dad's SQL Server; Contemporary twist on a classic standby.

Abstract:

New versions of SQL Server have great new additions and features. I will cover the following features in this session.

Linux Support Graph Tables Intelligent Query Processing Resumable Online Index Rebuild How to run R/Python with Machine Learning Services In-Memory Tables (Let's create NoSQL DB in SQL Server)

SessionID: 88576

Effective Communication and Self Promotion for the IT Introvert (YOU!)

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Mitchell Bottel

Title: Effective Communication and Self Promotion for the IT Introvert (YOU!)

Abstract:

Self-promotion is often confused with bragging, but most of the time it is the best tool to advance your career. In this session we talk about how self-promoting is the first step to creating your brand. Many IT Professionals struggle with how to stand out in a room, be noticed in a pile of resumes or maneuver for promotions. By learning to network and communicate effectively, these hurdles are converted into advancement ladders. Self-Promotion and Networking are skills and therefore can be taught and learned. We will discuss ways to use social media, communities and other avenues to increase your brands visibility online. Equally important is your ability to interact with co-workers, clients and management face to face. We will discuss ways to meet and network with other individuals and give you the tools to stand out from your peers. Building and engaging with a large network will increase your worth to both your current and future employer. Transform into a Networking Master.

SessionID: 89523

Table Indexing for the .NET Developer

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Denny Cherry

Title: Table Indexing for the .NET Developer

Abstract:

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012+ databases. We will also be looking into the new indexing features that are available in SQL Server 2012+ (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.

SessionID: 89802

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 90143

Better Query Performance from Proper Statistics Management

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Database Administration

Speaker: Vern Rabe

Title: Better Query Performance from Proper Statistics Management

Abstract:

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.

SessionID: 90287

Introduction to DAX

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Data Analytics

Speaker: Ike Ellis

Title: Introduction to DAX

Abstract:

Many people use Power BI without tapping into the true power of DAX. Some think that DAX is an advanced topic, used only by power users, but anyone can learn DAX. Come to this session to see easy and accessible ways to implement DAX in your work with Power BI. We'll simplify difficult topics like how to use Time Intelligence, CALCULATE, ALL, and FILTER. We'll learn the difference between functions with similar names, so you'll know when and when not to use them.

SessionID: 90470

Practical Power BI Report Design Tips for the Non-Artist

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Presentation Visualization

Speaker: Meagan Longoria

Title: Practical Power BI Report Design Tips for the Non-Artist

Abstract:

You don't have to be super artistic to make professional looking Power BI reports. We'll walk through several design concepts borrowed from web design and cognitive psychology and then apply them to a Power BI report. You'll learn practical steps to enhance your reports that you can do today, even if you don't consider yourself artistic.

SessionID: 90670

Back to Basics - The SELECT Statement

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: T-SQL Introductions

Speaker: Andrew Karcher

Title: Back to Basics - The SELECT Statement

Abstract:

If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same.

In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.

SessionID: 91585

How to Introduce your Data Scientists to CI/CD

Back to calendar

Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Data Analytics

Speaker: Alicia Moniz

Title: How to Introduce your Data Scientists to CI/CD

Abstract:

Do your data scientists have a hard time reproducing results? Is there confusion amongst the team about which scripts are being used by their models and where those scripts are located?

Creating a data science model is just part of the machine learning development process. How do you help your data scientists to operationalize their code?

Azure offers the right tools and services that make the process seamless. In this session, we will walk you through a simple process of integrating Python or R code in VSCode with Azure Devops capabilities.

SessionID: 89633

WIT: Women in Technology Panel Discussion

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: Kathi Kellenberger

Title: WIT: Women in Technology Panel Discussion

Abstract:

Join us as women from the Data Platform community talk about working in tech. These amazing women are Michellea David, Elaena Bakman, Meagan Longoria, and Alicia Moniz. The session will be hosted by Kathi Kellenberger, co-leader of the PASS WIT Virtual Group.

SessionID: 90681

Amazon Web Services: Using SQL Server on AWS

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: Vlad Vlasceanu

Title: Amazon Web Services: Using SQL Server on AWS

Abstract:

Amazon Web Services (AWS) offers the ability to run SQL Server both as a managed service part of the Amazon Relational Database Service (Amazon RDS), as well as letting you deploy your own custom solution on Amazon EC2. Learn how to deploy SQL Server on AWS, and get to know the capabilities Amazon RDS offers to help you operate SQL Server more efficiently at scale.

SessionID: 91899

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

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. In contrast, COZYROC's 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 into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. 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. In t

SessionID: 91978

Quest: Real-time Monitoring with Spotlight on SQL Server and Foglight

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: Trent Mera

Title: Quest: Real-time Monitoring with Spotlight on SQL Server and Foglight

Abstract:

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

SessionID: 92276

Enmotus: Real-Time Storage Tiering for Performance and Capacity

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: Adam Zagorski

Title: Enmotus: Real-Time Storage Tiering for Performance and Capacity

Abstract:

Do you want the highest performing SSD for your storage?

Does your budget limit how much capacity you can buy? Do you wish you could afford performance and capacity?

If you answered “Yes” to these questions then this session is for you. Automated Real-Time tiering allows you to blend the performance storage of your choice with cost effective storage. Your queries run fast because Machine Intelligence automatically moves your active data to your performance storage.

Future proof your storage. As needs change or faster storage media becomes available, you can upgrade to newer faster storage without taking your system offline.

SessionID: 92616

Dell EMC: SQL Server Get Modern Architecture

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: SQLSaturday Orange County

Title: Dell EMC: SQL Server Get Modern Architecture

Abstract:

The pillars will work with any size environment, from the small and agile to the very large and complex SQL database landscape. There IS a valid solution for all environments. All the pillars work in concert to complement each other across all feature sets and integration points.

 Accelerate – To not only accelerate and Future-Proof the environment but completely modernize your SQL infrastructure. A revamped perspective on storage, leveraging RAM and other memory technologies, to maximum effect.  Protect – Protect your database with industry leading backups, replication, resiliency and self-service Deduplicated copies.  Reuse – Reuse snapshots. Operational recovery. Dev/Test repurposing. CI/CD pipelines. Aligning along these pillars will bring efficiency and consistency to a unified approach of data estate management. The combination of a strong, consistent, high-performance architecture supporting the database platform will make your IT team the modernization execution masters.

SessionID: 92943

Ledgent Technology: Resume, Interview Salary Negotiation Tips

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: SQLSaturday Orange County

Title: Ledgent Technology: Resume, Interview Salary Negotiation Tips

Abstract:

Join Jen Lunde of Ledgent Technology for this session on Resume Writing, Interview Preparedness, Salary Negotiation and Personal Branding. You will learn how to craft the perfect resume to land an interview, how to negotiate a salary you can get excited about, and how to brand yourself as an expert in your space! We will cover the Do’s and Don’ts for writing your Resume and how to make yours stand out. We will also discuss the Interview Process, how to prepare and what to expect. We will then talk about how to approach Salary Negotiation, and finally Personal Branding to position yourself as an expert in your craft. We will wrap the Session with Questions and Answers.

SessionID: 92944

SentryOne: 5 Critical Considerations When Moving to the Cloud

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: Kevin Kline

Title: SentryOne: 5 Critical Considerations When Moving to the Cloud

Abstract:

Migrating an existing on-premises SQL Server application to the cloud can be a daunting task that consists of many complicated steps. In this webinar, we will focus on what is perhaps the MOST important step of the process – those that lead up to the actual move to the cloud.

We will dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider. We will cover: • The importance of cleansing your data before a major migration • Fully documenting your data sources and metadata • Choosing from many different tools and techniques to actually move data • How to test data for fidelity • How to maintain parallel systems during transitional phases We'll also share demos and overviews of native features within SQL Server that enable you to move data, as well as show powerful tools from the SentryOne product set that can make data migrations painless. Join us for this informative panel

SessionID: 92989

Data Advantage Group: Meta Data Management Governance

Back to calendar

Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other

Speaker: SQLSaturday Orange County

Title: Data Advantage Group: Meta Data Management Governance

Abstract:

CCPA and GDPR have left many of us second guessing if our organization is 100% in compliance. MetaCenter provides a platform to support regulatory compliance requirements while reducing IT costs at 3X the ROI of competing solutions. Come learn how MetaCenter’s metadata management and data governance capabilities are providing automation to leading Enterprise around the world to document their information assets and automate data lineage analysis.

SessionID: 88638

Disaster Recovery High Availability on the Azure Data Platform

Back to calendar

Event Date: 13-04-2019 - Session time: 13:30:00 - Track: Azure Cloud Technologies

Speaker: Grant Fritchey

Title: Disaster Recovery High Availability on the Azure Data Platform

Abstract:

While the Azure platform provides built-in safety mechanisms, these are not always well understood. Further, a good architect will ensure redundancy even within an already protected system. This session will show how the Azure Platform as a Service (PaaS) offerings such as Azure SQL Database, Azure MySQL and Azure Managed Instance, are built and maintained by Microsoft to provide protection for your vital information. We’ll also go over methods you can employ to add additional protection to your systems. Moving to the cloud and taking advantage of all that it offers doesn’t mean your data is automatically, fully protected. The knowledge from this session will help to ensure a higher degree of safety, faster recovery, and more up-time for your databases on the Azure Data Platform.

SessionID: 89306

DBA vNext

Back to calendar

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

Speaker: Armando Lacerda

Title: DBA vNext

Abstract:

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.

SessionID: 89873

Faster Transactions: Query Tuning for Data Manipulation

Back to calendar

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

Speaker: Jeff Iannucci

Title: Faster Transactions: Query Tuning for Data Manipulation

Abstract:

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.

SessionID: 89882

Azure Basics for the DBA

Back to calendar

Event Date: 13-04-2019 - Session time: 13:30:00 - Track: Azure Cloud Technologies

Speaker: John Morehouse

Title: Azure Basics for the DBA

Abstract:

It's not a question of 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: 90376

Power BI Administration Solutions

Back to calendar

Event Date: 13-04-2019 - Session time: 13:30:00 - Track: Azure Cloud Technologies

Speaker: Brett Powell

Title: Power BI Administration Solutions

Abstract:

SessionID: 90467

What's new for Developers - SQL Server 2014-2017

Back to calendar

Event Date: 13-04-2019 - Session time: 13:30:00 - Track: T-SQL Introductions

Speaker: Bill Fellows

Title: What's new for Developers - SQL Server 2014-2017

Abstract:

Have you been too busy to explore the new developer features in 2014+? This session is for you! We're going to work through solving problems more effectively using the new capabilities built into SQL Server.

Topics covered will include JSON, string splitting and aggregation, data masking, row level security, graph processing, and too many "minor" features to mention.

SessionID: 90480

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

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

Speaker: Benjamin Nevarez

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.

SessionID: 90525

Containers, Pods, and Databases- The Future of Infrastructure

Back to calendar

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

Speaker: Joseph D'Antoni

Title: Containers, Pods, and Databases- The Future of Infrastructure

Abstract:

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.

SessionID: 90646

Power BI Desktop Tips and Best Practices for Projects and Data Preparation

Back to calendar

Event Date: 13-04-2019 - Session time: 13:30:00 - Track: Data Analytics

Speaker: Phil Robinson

Title: Power BI Desktop Tips and Best Practices for Projects and Data Preparation

Abstract:

SessionID: 88195

Imposter Syndrome How to work through it

Back to calendar

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

Speaker: Charles Embry Jr

Title: Imposter Syndrome How to work through it

Abstract:

At one point or another most of us have had that feeling. You feel like you are about to be fired at any moment, like it is only a matter of time until they find out you don't know what you are doing and you are out of your depth. Or maybe you are sitting in a meeting with a group of your peers discussing the project you are working on. You see what you believe to be a large flaw in the current project, yet you do not speak up as you feel like you and not qualified enough to voice your concern. When your coworkers or boss pay you a compliment and try to express how impressed they are with you work or value as an employee do you try to diminish the complement or your value? If you have ever been in one of the situations above you have probably had a case of Imposter Syndrome. In this session we will discuss what Imposter Syndrome is, how it affects people and most importantly how to identify it in yourself and others and some techniques to help you break out of these feelings.

SessionID: 88313

How to use GeoSpatial Data in SQL Server

Back to calendar

Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Data Analytics

Speaker: Hasan Savran

Title: How to use GeoSpatial Data in SQL Server

Abstract:

If you would like to learn about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.

SessionID: 88639

Exploring Execution Plans

Back to calendar

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

Speaker: Grant Fritchey

Title: Exploring Execution Plans

Abstract:

Getting started reading execution plans is very straight forward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you’ll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.

SessionID: 89245

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Azure Cloud Technologies

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: 89530

SQL Server Internals and Architecture

Back to calendar

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

Speaker: Kevin Kline

Title: SQL Server Internals and Architecture

Abstract:

SessionID: 89584

Simplify your Daily Tasks with DBATools!

Back to calendar

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

Speaker: John Wells

Title: Simplify your Daily Tasks with DBATools!

Abstract:

Did you ever wonder if there was one tool you could use to simplify your daily tasks without much effort? There is and it is DBATools! This is an incredible PowerShell Module that will make your life easier. Whether you want to do a quick backup and restore, copy a login to another server, check server settings, check logs, manage a server or do a full migration.

Don’t have any experience with PowerShell? Don’t worry because you don’t have to. Some incredible people in this community have already done the work for you! Come join me in this demo heavy session and we will get you prepared to take advantage of this incredible tool!

SessionID: 89884

Temporal Tables – The New Hotness in Data Auditing

Back to calendar

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

Speaker: John Morehouse

Title: Temporal Tables – The New Hotness in Data Auditing

Abstract:

A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.

SessionID: 90301

SSRS - Thinking Outside the Report

Back to calendar

Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Other

Speaker: Elaena Bakman

Title: SSRS - Thinking Outside the Report

Abstract:

Most of us use SSRS to create reports, maybe send out notifications or provide data outputs for users to consume, but what if you needed to give your user the ability to run a job on demand, or modify data or execute a SSIS package? Can SSRS do that? Yes it and I will show you how.

SessionID: 90451

What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Back to calendar

Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Presentation Visualization

Speaker: Patrick Partin

Title: What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf

Abstract:

Like many of you, I've been fortunate enough to work in places where the budgets were non-existent, the systems were always crashing, and what tools we did have, were good for some, not all. For those fighting fires and wearing multiple hats, you're used to, but still scared of "hey, what just happened?"

In this session, I'll show you how to install, configure, and build your own dashboard with Grafana, and utilize InfluxDB and Telegraf, which I believe will help you fight your fires better than before. If you're like me, you've at times wished you had a way to easily display and create your own metrics, and after this, you'll be well on your way to do so. You can also integrate in monitoring, alerting, and so much more, all for the low, low, price of whatever your time is worth.

SessionID: 89495

How To Talk To Your Storage Admin

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Database Administration

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 89994

Using Azure Databricks to Develop Scalable Data Solutions

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Data Analytics

Speaker: Ginger Grant

Title: Using Azure Databricks to Develop Scalable Data Solutions

Abstract:

Worried about performance when processing a Data Lake or other large data store? Need to develop in a collaborative environment and visualize the results in Power BI? Azure Databricks, one of the newer components added to Azure, allows users to connect to data sources such as Azure Data Lake, Azure Blob Storage, Azure SQL DW, Cosmos DB, Azure DB, and SQL Server and stream the data using Apache Spark to process data for a machine learning [ML] solution and provide the data to Power BI for visualization. Azure Databricks can deliver a very quick way of processing data by adding nodes to increase performance for large data analysis tasks. Azure Databricks also includes a collaborative workspace so that using Azure Active Directory, allowing teams of people to collaboratively develop code in a notebook in R or Python and implement the notebook as an Azure Databrick job. The step-by-step demos will include all you need to know to implement Databricks.

SessionID: 90142

SQL Security, Encryption, Compliance

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Database Administration

Speaker: Thomas Hull

Title: SQL Security, Encryption, Compliance

Abstract:

In today's regulatory environment, expertise in security and compliance are table stakes in the DBA job market. Industries that manage customer data (finance, health care, etc.) have strict protocols required by law and enforced by audits, which are kind of like a month-long root canal but not as fun.

In this presentation we'll cover regulatory standards, security basics and best practices, and the various encryption options available in SQL Server (Backups, TDE, Column, AlwaysEncrypted). We'll also cover monitoring/logging, go over some new features, and some bonus material on dealing with audits.
I look forward to seeing you there!

SessionID: 90214

Building a Dashboard in an Hour using PowerPivot Power BI

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Presentation Visualization

Speaker: Vazi Okhandiar

Title: Building a Dashboard in an Hour using PowerPivot Power BI

Abstract:

Demonstrate the steps to use the raw data in a text file to build a dashboard using PowerPivot and Power BI.

SessionID: 90309

Introduction to SSIS, and third-party tools like MelissaData and CozyRoc

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Data Analytics

Speaker: Steve Rezhener

Title: Introduction to SSIS, and third-party tools like MelissaData and CozyRoc

Abstract:

We will discuss SSIS basics, and demo third-party tools like MelissaData and CozyRoc

SessionID: 90468

What is Biml and why are SSIS developers excited about it?

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Other

Speaker: Bill Fellows

Title: What is Biml and why are SSIS developers excited about it?

Abstract:

This session is designed for you, the experienced SSIS developer who's been hearing about the Business Intelligence Markup Language, Biml, but has not taken the plunge. We will cover what the Biml language is and how using your familiar development tools, SQL Server Data Tools, SSDT, and BIDS Helper, you will be able to streamline the creation of SSIS packages.

We will work through progressively more complex examples from a "Hello World" equivalent to a to a full fledged, audited, truncate and reload pattern based on an external metadata repository.

You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.

SessionID: 90676

Do-It-Yourself Performance Monitoring

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Database Administration

Speaker: Andrew Nakamura

Title: Do-It-Yourself Performance Monitoring

Abstract:

If you had an unlimited budget, any problem is easy to fix. But when users complain and your boss is hovering around your desk, and you don't have Platinum bucks, what can you do to ensure your SQL Servers are maintained and optimized properly? In this session, we'll dive through performance monitoring and building baselines using open source scripts that give you super powers to even go back in time and diagnose problems that are no longer available.

Do you have processes that block or deadlocks queries but are no longer running? Do you have power users that do some questionable reports or a rogue developer with sysadmin access? How do you resolve them if they're not using the system when you have eyes on them?

Finally, you will walk away from this session with a plan that can be implemented tomorrow and never be caught off guard again. You will look like a superhero that can be proud of performance monitoring system that you built yourself. Come join the fun!

SessionID: 90697

Soft skills for Geeks: Don't be a flat boxer

Back to calendar

Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Professional Development

Speaker: Randy Knight

Title: Soft skills for Geeks: Don't be a flat boxer

Abstract:

If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you. However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.