Nr: 847
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
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
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
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
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
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.
- Source to Target mapping documents can be used to generate the code to effect the mapping.
- Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
- Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
- Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
SessionID: 90509
SQL Server on AWS - Elastic Compute Cloud vs Relational Database Service
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!
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
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.
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
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
Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Azure Cloud Technologies
Speaker: Leonard Lobel
Title: Introduction to Azure Cosmos DB
Abstract:
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
Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Data Analytics
Speaker: Warren Sifre
Title: Introduction to BI Architecture
Abstract:
SessionID: 89460
3 Keys to Successful Consulting
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
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?
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
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
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
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
Event Date: 13-04-2019 - Session time: 09:45:00 - Track: Database Administration
Speaker: Brodie Brickey
Title: SSIS Basics
Abstract:
SessionID: 88311
Not your Dad's SQL Server; Contemporary twist on a classic standby.
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
Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Professional Development
Speaker: Mitchell Bottel
Abstract:
SessionID: 89523
Table Indexing for the .NET Developer
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
Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Database Administration
Speaker: Monica Rathbun
Abstract:
SessionID: 90143
Event Date: 13-04-2019 - Session time: 11:00:00 - Track: Database Administration
Speaker: Vern Rabe
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
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
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
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:
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
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
Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other
Speaker: Kathi Kellenberger
Title: WIT: Women in Technology Panel Discussion
Abstract:
SessionID: 90681
Amazon Web Services: Using SQL Server on AWS
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
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
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:
SessionID: 92276
Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other
Speaker: Adam Zagorski
Abstract:
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
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
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
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
Event Date: 13-04-2019 - Session time: 12:30:00 - Track: Other
Speaker: SQLSaturday Orange County
Abstract:
SessionID: 88638
Event Date: 13-04-2019 - Session time: 13:30:00 - Track: Azure Cloud Technologies
Speaker: Grant Fritchey
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
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
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
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
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
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
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:
SessionID: 90525
Containers, Pods, and Databases- The Future of Infrastructure
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
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
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
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
Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Database Administration
Speaker: Grant Fritchey
Title: Exploring Execution Plans
Abstract:
SessionID: 89245
Successfully Virtualizing SQL Server on vSphere - Straight from the Source
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
Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Database Administration
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
What happens during checkpoints? Lazywrites?
How are IOs handled with regards to transaction logs and database?
What happens when transaction logs and databases grow or shrinks?
SessionID: 89584
Event Date: 13-04-2019 - Session time: 14:45:00 - Track: Database Administration
Speaker: John Wells
Abstract:
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
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:
SessionID: 90301
SSRS - Thinking Outside the Report
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
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:
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
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:
SessionID: 89994
Using Azure Databricks to Develop Scalable Data Solutions
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:
SessionID: 90142
SQL Security, Encryption, Compliance
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
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
Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Data Analytics
Speaker: Steve Rezhener
Abstract:
SessionID: 90468
What is Biml and why are SSIS developers excited about it?
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:
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
Event Date: 13-04-2019 - Session time: 16:00:00 - Track: Database Administration
Speaker: Andrew Nakamura
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
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: