Nr: 766
SQLSaturday #766 - Houston 2018
| Start Time (24h) |
Speaker |
Track |
Title |
| 08:30:00 |
Jeffrey Garbus |
Enterprise Database Administration Deployment |
Indexing for performance |
| 08:30:00 |
Faheem Ismat |
Cloud Application Development Deployment |
Cloudy DBA, Amazon (AWS) and SQL Server |
| 08:30:00 |
John Wells |
Application Database Development |
Fundamentals That Will Improve Your Query Performance! |
| 08:30:00 |
Andy Warren |
Enterprise Database Administration Deployment |
Lessons Learned from Two Years as a Devops DBA |
| 08:30:00 |
Adam Saxton |
Professional Development |
How to build your personal brand |
| 08:30:00 |
Derek Wilson |
BI Platform Architecture, Development Administration |
Data Vault on SQL Server Tabular Model and Power BI |
| 08:30:00 |
Thomas Norman |
Application Database Development |
Consistent Deployments / Team Development |
| 08:30:00 |
John Sterrett |
Enterprise Database Administration Deployment |
DIY: SQL Server Monitoring for your Enterprise |
| 09:45:00 |
Angela Tidwell |
Professional Development |
Become the Most Valuable Player: Soft Skills for the Hard Market |
| 09:45:00 |
William Assaf |
Enterprise Database Administration Deployment |
What's New In SQL Server 2017 |
| 09:45:00 |
Ryan Casey |
BI Platform Architecture, Development Administration |
Data Modeling for the Modern Data Warehouse |
| 09:45:00 |
Jim Miller |
BI Platform Architecture, Development Administration |
Populating a Data Warehouse with SSIS and Biml Patterns |
| 09:45:00 |
Dainius Sutkevicius |
Enterprise Database Administration Deployment |
How to transition from Profiler to Extended Events and why you should consider. |
| 09:45:00 |
Ryan Adams |
Cloud Application Development Deployment |
Azure SQL Managed Instance the New Hotness |
| 09:45:00 |
Jamey Johnston |
Enterprise Database Administration Deployment |
Enterprise Row Level Security in SQL Server and Power BI |
| 09:45:00 |
Kerry Tyler |
Application Database Development |
Managing Your Schema with Database Projects in Visual Studio |
| 09:45:00 |
Tim Mitchell |
BI Platform Architecture, Development Administration |
Loading a Data Warehouse with SSIS |
| 11:00:00 |
Robert Stewart |
BI Platform Architecture, Development Administration |
Kimball Methodology - Facts and dimensions |
| 11:00:00 |
Kim Brushaber |
Strategy and Architecture |
GDPR: How it impacts companies outside of Europe |
| 11:00:00 |
Jeff Mlakar |
Enterprise Database Administration Deployment |
Environmental SQL Server Troubleshooting |
| 11:00:00 |
Andy Warren |
Professional Development |
Patterns for Managing Your Career Learning Needs |
| 11:00:00 |
Ryan Adams |
Application Database Development |
Learning Columnstore Indexes |
| 11:00:00 |
Lance Tidwell |
Application Database Development |
Introduction to Execution Plans |
| 11:00:00 |
Shawn Weisfeld |
Cloud Application Development Deployment |
Get insights from data with Cognitive Services |
| 11:00:00 |
Jay Falck |
Enterprise Database Administration Deployment |
Introduction to Linux for SQL Server Professionals |
| 12:30:00 |
Mark Moore |
Other |
SQL Azure, SQL DW, SQL Managed Instances 101 |
| 12:30:00 |
Diane Schuster |
BI Platform Architecture, Development Administration |
CozyRoc: Dynamic Data Flows in SSIS Without Programming |
| 12:30:00 |
Eric Huckabay |
Professional Development |
Trusting your data |
| 12:30:00 |
Chris Randvere |
Enterprise Database Administration Deployment |
Proactive monitoring with Redgate SQL Monitor |
| 12:30:00 |
Craig Allen |
Enterprise Database Administration Deployment |
#GetModern SQL Server infrastructure with Dell EMC |
| 12:30:00 |
Jack Bailey |
Enterprise Database Administration Deployment |
Simplifying SQL Data Protection (with Rubrik) |
| 13:30:00 |
Kevin Feasel |
Enterprise Database Administration Deployment |
Securing SQL Server |
| 13:30:00 |
Christine Assaf |
Professional Development |
Mastering your Resume Interview: Tips to Get Hired |
| 13:30:00 |
Franklin Gamboa |
Enterprise Database Administration Deployment |
From the grave: Horror stories from the Microsoft SQL Server CSS archives |
| 13:30:00 |
Mike Byrd |
Application Database Development |
In-Memory Indexes: SpaceX® Performance! |
| 13:30:00 |
John Sterrett |
Enterprise Database Administration Deployment |
Automate the Pain Away with Query Store and Automatic Tuning |
| 13:30:00 |
Adam Saxton |
BI Platform Architecture, Development Administration |
Power BI Security Deep Dive |
| 13:30:00 |
Kris Hokanson |
Application Database Development |
That's bad mkay! (How to quantify when things aren't right) |
| 13:30:00 |
Robert Verell |
Enterprise Database Administration Deployment |
Migration Basics |
| 14:45:00 |
Jason Awbrey |
Professional Development |
The Independent Developer - Lessons Learned from 4+ Years of Self Employment |
| 14:45:00 |
Steven Tidwell |
Application Database Development |
Dynamic SQL: Tables, Parameters and More |
| 14:45:00 |
Russel Loski |
Cloud Application Development Deployment |
Querying Semistructured Data in Azure Data Lake with USQL |
| 14:45:00 |
Tracy Boggiano |
Enterprise Database Administration Deployment |
Monitoring Availability Groups |
| 14:45:00 |
Amy Herold |
Enterprise Database Administration Deployment |
Hi, my name is Powershell, let's be friends! An Intro to PoSH |
| 14:45:00 |
Kerry Tyler |
Enterprise Database Administration Deployment |
Tuning Like CSS: With These Tools There's No Need Call Support |
| 14:45:00 |
David Stein |
BI Platform Architecture, Development Administration |
Azure Data Factory V2 and SSIS Automation With Biml |
| 14:45:00 |
Tim Mitchell |
BI Platform Architecture, Development Administration |
Change Detection in SQL Server |
| 16:00:00 |
Kevin Feasel |
Application Database Development |
Data Cleansing With SQL And R |
| 16:00:00 |
Steve Hughes |
Cloud Application Development Deployment |
Cosmos DB for the Data Professional |
| 16:00:00 |
Jennifer McCown |
Application Database Development |
Beginning T-SQL |
| 16:00:00 |
Sean McCown |
Enterprise Database Administration Deployment |
Monster Text Manipulation: Regular Expressions for the DBA |
| 16:00:00 |
Anthony {Tex} Moreign |
Strategy and Architecture |
SQL on Linux ¦ Microsoft ♡ Linux ¦ Cloud is mostly Linux …… but I'm/WE're Windows based? |
| 16:00:00 |
Daniel Janik |
Enterprise Database Administration Deployment |
A DBA's guide to full stack performance troubleshooting |
| 16:00:00 |
Tamera Clark |
BI Platform Architecture, Development Administration |
45 min to build your first SSRS report |
| 16:00:00 |
Robert Tidwell |
Other |
The Benefits of Gaming |
SessionID: 76914
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 76951
Cloudy DBA, Amazon (AWS) and SQL Server
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Speaker: Faheem Ismat
Title: Cloudy DBA, Amazon (AWS) and SQL Server
Abstract:
Cloud (AWS, Azure, Google or whatever else out there) is a reality now and for most of the organizations question is not "if", it is "When".
Cloud has and will continue to transform DBA's role from tactical to strategic. We will start our session with a quick discussion about Cloudy DBA and cloud computing fundamentals.
After that we will dive deep into Amazon and explore different options for running SQL Server database in AWS. We will compare available options, evaluate their differences and suitability for different workloads. We will also cover cloud migration approaches, connectivity, AD Authentication, backup and recovery, performance, monitoring, HA/DR, security, compliance, licensing and related best practices.
SessionID: 78288
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Application Database Development
Speaker: John Wells
Abstract:
SessionID: 80045
Lessons Learned from Two Years as a Devops DBA
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Andy Warren
Title: Lessons Learned from Two Years as a Devops DBA
Abstract:
Join me as I talk about lessons learned from two years on a Devops team. Process, source control, changes that block, rolling back changes, out of band changes, and more! I still don't have all the answers (or maybe even all the questions), but I can say this - DBA's have nothing to fear and a lot to gain when an org adopts a devops culture.
SessionID: 80502
How to build your personal brand
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Professional Development
Speaker: Adam Saxton
Title: How to build your personal brand
Abstract:
You have a tremendous opportunity to build your personal brand. It doesn't matter if you work for a large corporation, or as an independent consultant. In this session, I'll walk you through how to leverage the learnings I've made while building my Guy in a Cube brand. Take an inside look at how I think about our content and how you can use that to gain attention to your brand!
SessionID: 80527
Data Vault on SQL Server Tabular Model and Power BI
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Derek Wilson
Title: Data Vault on SQL Server Tabular Model and Power BI
Abstract:
In this session, you will learn the basics of building a data vault to organize and store your companies disparate data on SQL Server. Learn how Hubs, Links, and Satellite tables create options for storing a variety of data from multiple systems. The data vault structures will then be used as the data source to create views designed for SQL Server Analysis Services Tabular models. Finally, Power BI will be used to visual the data for your end users.
SessionID: 82072
Consistent Deployments / Team Development
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Application Database Development
Speaker: Thomas Norman
Title: Consistent Deployments / Team Development
Abstract:
Unless you are developing code by yourself, you face challenges of working with several team members. Different people are changing code which affects the code someone else is working on. In addition, there will be teams working on different projects at the same time. In the middle of the projects, an emergency fix needs to be deployed to Production. So where is the code, when do you shared it with others, when do you get the code that has been shared, where is the production code branch located. How do I branch and when do merge? How do I get a release branch? Let me share with you how we are handling this area of DevOps.
SessionID: 83875
DIY: SQL Server Monitoring for your Enterprise
Event Date: 23-06-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: John Sterrett
Title: DIY: SQL Server Monitoring for your Enterprise
Abstract:
SessionID: 76893
Become the Most Valuable Player: Soft Skills for the Hard Market
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Professional Development
Speaker: Angela Tidwell
Title: Become the Most Valuable Player: Soft Skills for the Hard Market
Abstract:
Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!
SessionID: 76957
What's New In SQL Server 2017
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: William Assaf
Title: What's New In SQL Server 2017
Abstract:
From the lead author of SQL Server 2017 Administration Inside Out by Microsoft Press, come learn in technical detail what’s new for developers, admins, and users of Microsoft SQL Server 2017, including labs and demos. We'll discuss the new features for the platform, high availability, maintenance, and TSQL syntax.
SessionID: 77063
Data Modeling for the Modern Data Warehouse
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Ryan Casey
Title: Data Modeling for the Modern Data Warehouse
Abstract:
I this session, we will discuss why we model data, the different modeling types, and different modeling techniques. We will explore why and when to use different modeling techniques and we will explain how to use dimensional modeling when developing data warehouses, SSAS Cubes, and Power BI Analytics.
“Real World” sample model diagrams will be used to explain these different modeling techniques in an attempt to bring a more tangible aspect to the theoretical aspects of the discussion.
Why Model Data
The Value of Enterprise Data
Business Benefits of Data Modeling
Different Model Types
Conceptual / Logical / Physical
Dimensional
Different Modeling Techniques
Star Snow Flake Schema
Slowly Changing Dimensions
Many to Many Relationships
SessionID: 77775
Populating a Data Warehouse with SSIS and Biml Patterns
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jim Miller
Title: Populating a Data Warehouse with SSIS and Biml Patterns
Abstract:
Attend to see how Biml can revolutionize your SSIS development!
SessionID: 78368
How to transition from Profiler to Extended Events and why you should consider.
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Dainius Sutkevicius
Title: How to transition from Profiler to Extended Events and why you should consider.
Abstract:
Why don’t we take a closer look using straightforward examples in order to figure out what it’s all about, because learning Extended Events is fun and easy.
In this session we will cover the following:
-- How to create an extended event session using an existing trace.
-- How to create XE (Extended Events) in UI (User interface) from the ground up.
-- How to analyze the data.
-- What to watch out for in terms of performance.
SessionID: 80055
Azure SQL Managed Instance the New Hotness
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Speaker: Ryan Adams
Title: Azure SQL Managed Instance the New Hotness
Abstract:
You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and maintain an operating system and SQL Server. You looked at Azure SQL DB, but there are some limitations that prevent you from migrating to this service. Don't worry, you're not stranded. There is a new option designed to "Lift and Shift" your workload to Azure PaaS. It's a brand new offering that just came out of private preview and into public preview. We'll discuss this new offering, its advantages, and how you can migrate with ease.
SessionID: 80392
Enterprise Row Level Security in SQL Server and Power BI
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Jamey Johnston
Title: Enterprise Row Level Security in SQL Server and Power BI
Abstract:
The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/2017 and Azure SQL DB with predicate based RLS and in Power BI, as well.
This session will show how organizational asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/2017, Azure SQL Database and Power BI without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.
Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS.
SessionID: 80935
Managing Your Schema with Database Projects in Visual Studio
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Kerry Tyler
Title: Managing Your Schema with Database Projects in Visual Studio
Abstract:
SessionID: 83953
Loading a Data Warehouse with SSIS
Event Date: 23-06-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Tim Mitchell
Title: Loading a Data Warehouse with SSIS
Abstract:
Data warehouses and ETL processes are an essential part of business decision-making. In an age where big data and NoSQL solutions, traditional data warehouse architectures and ETL tools to feed them (such as SQL Server Integration Services) remain critical to providing reliable, repeatable, and auditable answers.
SQL Server Integration Services has evolved into an ideal tool for loading data warehouses. Its modular design and variety of load tools allow it to process most any data warehouse load design (full load, incremental load, or near real-time), while its data flow transformations and scripting tools make it flexible enough to handle complex reshaping and cleansing required of data warehouse loads.
In this session, we will discuss and demonstrate loading a data warehouse using SQL Server Integration Services. We will briefly cover some ETL best practices for data warehouse loads, and will demonstrate how these practices can be implemented using SSIS.
SessionID: 76895
Kimball Methodology - Facts and dimensions
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Robert Stewart
Title: Kimball Methodology - Facts and dimensions
Abstract:
We will take a deep dive into the Kimball methodology for building a true star schema data store with fact and dimension tables. We will go into the types of facts tables and what you can do with the data. We will look at the granularity that you should and need to store for analytics at every possible level. There will be files available after the presentation of everything that we will cover.
SessionID: 77320
GDPR: How it impacts companies outside of Europe
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Strategy and Architecture
Speaker: Kim Brushaber
Title: GDPR: How it impacts companies outside of Europe
Abstract:
SessionID: 77365
Environmental SQL Server Troubleshooting
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Jeff Mlakar
Title: Environmental SQL Server Troubleshooting
Abstract:
In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
SessionID: 80046
Patterns for Managing Your Career Learning Needs
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Professional Development
Speaker: Andy Warren
Title: Patterns for Managing Your Career Learning Needs
Abstract:
Most of us want to "keep up" with changes in the technologies we use and most of us feel like we're failing to do so. Can that be right? Is it possible to learn what what we need to learn in order to stay current and still have time for a life outside of work? It is!
This presentation is about patterns you can apply to how and when you learn. My goal is to give you the ideas and techniques that will help you learn effectively and do so for your entire career - something you can use for 40 years!
Attendees - bring your lists. Bring the list of stuff of you want to learn or think you should learn. Take a few minutes to write down the challenges you've had in 'keeping up'. We'll discuss some during the session and I'll be available afterward for one on one conversations for the rest!
SessionID: 80057
Learning Columnstore Indexes
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Ryan Adams
Title: Learning Columnstore Indexes
Abstract:
If you have a large database or data warehouse things just got a lot faster for you using Columnstore Indexes. You will learn when to use a Columnstore Index and the difference between Non-Clustered and Clustered Columnstore. We will discuss their advantages over row store indexes and get into the internals of how these new indexes are arranged and loaded.
SessionID: 80372
Introduction to Execution Plans
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Lance Tidwell
Title: Introduction to Execution Plans
Abstract:
In this session we will take a look at the basics of execution plans. We will discuss what they are, how they are made, and how they are used. We will explore some of the common operators seen in execution plans and their functions. Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries. Also we will go through some of the recent changes in SQL Server that effect execution plans. Those being the new cardinality estimator, query store, and adaptive query processing.
SessionID: 80436
Get insights from data with Cognitive Services
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Speaker: Shawn Weisfeld
Title: Get insights from data with Cognitive Services
Abstract:
How can you take advantage of Artificial Intelligence without being a data scientist? Cognitive Services allow you use Artificial Intelligence to enrich your data through simple API calls. In this session, we will demonstrate the Cognitive Services and brainstorm how we can apply these to our applications.
SessionID: 81980
Introduction to Linux for SQL Server Professionals
Event Date: 23-06-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Jay Falck
Title: Introduction to Linux for SQL Server Professionals
Abstract:
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.
SessionID: 82535
SQL Azure, SQL DW, SQL Managed Instances 101
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: Other
Speaker: Mark Moore
Title: SQL Azure, SQL DW, SQL Managed Instances 101
Abstract:
Need more SQL but you have run out of hardware on premises? How about SQL in the cloud? In this session we will discover what Azure is with a high level overview of Azure and we will dive into three of Azure’s Data offerings, Azure SQL Database (SQL Server) and Azure SQL Datawarehouse (PDW) and our newest offering SQL Server Managed Instances. We will walk through setting up an Azure environment for the first time and how to deploy and use Azure SQL Database and Azure SQL Datawarehouse. The discussion will also include defining IaaS, PaaS and SaaS
SessionID: 83205
CozyRoc: Dynamic Data Flows in SSIS Without Programming
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Diane Schuster
Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming
Abstract:
This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
SessionID: 83389
Trusting your data
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: Professional Development
Speaker: Eric Huckabay
Title: Trusting your data
Abstract:
People make decisions based on two qualities: intent and competency. Said another way: trust and data. We all think we are providing the customer with good data. But many of the systems we use to provide that data are completely opaque to the average end user. How can we win their trust?
SessionID: 83704
Proactive monitoring with Redgate SQL Monitor
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Chris Randvere
Title: Proactive monitoring with Redgate SQL Monitor
Abstract:
SessionID: 83744
#GetModern SQL Server infrastructure with Dell EMC
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Craig Allen
Title: #GetModern SQL Server infrastructure with Dell EMC
Abstract:
This discussion will cover new and upcoming infrastructure technologies, such as Flash, Storage Class Memory, NVMe, and NVDIMM. These exciting new technologies can super charge your database and transaction log performance.
SessionID: 83909
Simplifying SQL Data Protection (with Rubrik)
Event Date: 23-06-2018 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Jack Bailey
Title: Simplifying SQL Data Protection (with Rubrik)
Abstract:
When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!
SessionID: 76936
Securing SQL Server
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Kevin Feasel
Title: Securing SQL Server
Abstract:
SessionID: 76960
Mastering your Resume Interview: Tips to Get Hired
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Mastering your Resume Interview: Tips to Get Hired
Abstract:
Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.
SessionID: 76993
From the grave: Horror stories from the Microsoft SQL Server CSS archives
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Franklin Gamboa
Title: From the grave: Horror stories from the Microsoft SQL Server CSS archives
Abstract:
Do you like dread stories? Join me while I narrate a few horror stories from the real life, featuring the production server that was down for hours, or the Database corrupted to the bone, or the lethal demon that spreaded thru all the network. In this session, we will examinate a few stories, and how the issue was easy to avoid, if the best practices would have been there since the beggining.
SessionID: 77858
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Application Database Development
Speaker: Mike Byrd
Abstract:
SessionID: 77859
Automate the Pain Away with Query Store and Automatic Tuning
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: John Sterrett
Title: Automate the Pain Away with Query Store and Automatic Tuning
Abstract:
Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause of seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using new features in SQL Server 2016 and SQL Server 2017 called Query Store and Automatic Tuning.
SessionID: 80499
Power BI Security Deep Dive
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Adam Saxton
Title: Power BI Security Deep Dive
Abstract:
One hot topic with Power BI is security, in this deep dive session, we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored and we even look at how to leverage additional Azure services to secure it even more.
SessionID: 82041
That's bad mkay! (How to quantify when things aren't right)
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Application Database Development
Speaker: Kris Hokanson
Title: That's bad mkay! (How to quantify when things aren't right)
Abstract:
We've all heard that things like nested views, cursors, and under/over-indexed tables are bad...but why? What is the real cost of the badness that abounds in the database world? What's really going on when you run that query against a view of a view of a view. How can you quantify what happens when that cursor ends up running the same simple query thousands of times. And how can indexes really impact the way SQL Server decides to solve your queries. In this session we'll talk about the basics of how to read query plans and use extended events to understand why all these things can be big resource drains on a SQL Server. Good times should be had by all.
SessionID: 82076
Migration Basics
Event Date: 23-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Robert Verell
Title: Migration Basics
Abstract:
So you've got SQL Server instances that need to be moved off of old hardware or need a version upgrade for functionality and support purposes. Where do we begin? What pieces do we need to consider and how are we going to get them moved? What kind of window do we need to move everything?
We'll cover all of these things and more, as well as querying the attendees on what to do next during certain steps to ensure you have your mind in the right place. Migrations can be tedious, but if planned properly, they can be easy and expand your knowledge for SQL Server.
This session does not cover dbaas migrations
SessionID: 76947
The Independent Developer - Lessons Learned from 4+ Years of Self Employment
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Professional Development
Speaker: Jason Awbrey
Title: The Independent Developer - Lessons Learned from 4+ Years of Self Employment
Abstract:
In October 2013 I left my full time job with benefits and a regular paycheck. Over three years later, I’ve managed to keep my family fed and a roof over their heads. Here’s what I’ve learned along the way about the plusses (many) and minuses (a few) and challenges (many) of life as an independent software developer.
SessionID: 77025
Dynamic SQL: Tables, Parameters and More
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Application Database Development
Speaker: Steven Tidwell
Title: Dynamic SQL: Tables, Parameters and More
Abstract:
SessionID: 77068
Querying Semistructured Data in Azure Data Lake with USQL
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Cloud Application Development Deployment
Speaker: Russel Loski
Title: Querying Semistructured Data in Azure Data Lake with USQL
Abstract:
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
SessionID: 78758
Monitoring Availability Groups
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Tracy Boggiano
Title: Monitoring Availability Groups
Abstract:
You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.
SessionID: 80422
Hi, my name is Powershell, let's be friends! An Intro to PoSH
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Amy Herold
Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH
Abstract:
Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.
SessionID: 80934
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Kerry Tyler
Abstract:
But what if you could bypass support and do all of this analysis yourself?
In this session, you'll learn how to use battle tested tools to analyze your workload and error logs. Armed with this information, you'll understand the root cause of the problem and propose solutions to performance and stability problems.
SessionID: 82056
Azure Data Factory V2 and SSIS Automation With Biml
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: David Stein
Title: Azure Data Factory V2 and SSIS Automation With Biml
Abstract:
In this session you will learn the advantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.
All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.
SessionID: 82873
Change Detection in SQL Server
Event Date: 23-06-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Tim Mitchell
Title: Change Detection in SQL Server
Abstract:
Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the data – only that which is new or changed since the last load. For that to work properly, there must be a reliable system for detecting delta data touched since the most recent load.
In this session, we will review the tools and design patterns available in SQL Server for performing change detection. From source detection methods including change tracking and change data capture, to in-flight comparisons using hashed values, and even brute-force methods as a last resort, we’ll cover the spectrum of change detection tools in SQL Server.
SessionID: 76937
Data Cleansing With SQL And R
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Kevin Feasel
Title: Data Cleansing With SQL And R
Abstract:
SessionID: 77568
Cosmos DB for the Data Professional
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Cloud Application Development Deployment
Speaker: Steve Hughes
Title: Cosmos DB for the Data Professional
Abstract:
What you will learn
- Basics of Cosmos DB, the what, where and how
- Enterprise considerations for the data pro when using Cosmos DB
- How to create a Cosmos DB and get more hands on experience with the technology
SessionID: 78770
Beginning T-SQL
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Jennifer McCown
Title: Beginning T-SQL
Abstract:
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
SessionID: 80404
Monster Text Manipulation: Regular Expressions for the DBA
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Sean McCown
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract:
Here you’ll learn:
• The most useful regular expression commands.
• The appropriate times to use regular expressions.
• How to use regular expressions to write code for you.
• How to incorporate regular expressions into large tasks and combine them with other methods.
SessionID: 80870
SQL on Linux ¦ Microsoft ♡ Linux ¦ Cloud is mostly Linux …… but I'm/WE're Windows based?
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Strategy and Architecture
Speaker: Anthony {Tex} Moreign
Title: SQL on Linux ¦ Microsoft ♡ Linux ¦ Cloud is mostly Linux …… but I'm/WE're Windows based?
Abstract:
SQL Server on Linux - yaaay! …wait, what? …isn't that a whole new/open world of tech and licensing options? …and they need the info when? …but I'm already overloaded + the next build of windows is … [vent away] …?!
SPOILER: You actually become MORE valuable, the more you partake in the Linux world! (interested?)
PAUSE: Windows Server folks went through this a few years ago with the Cloud. I was a guest on TechNet-Edge Radio with John Weston speaking about it, recording on www.HybridDecisions.com
AUDIENCE: Anyone (dev/pro/biz) interested in the new/open world of SQL Server on Linux (your competition/opportunity?), the newSQL DB options, and possible quick demos
SPEAKER DISCLOSURE: Tex (20+ year technologist) Zane (burgeoning technologist), are with Hybrid Decisions®/2005, a multi-competency Microsoft Gold Partner consistently since year-1 … doing Linux (originally C/Unix folks who embraced Microsoft Linux, i.e., ol' dogs :-) … speaking on behalf of HCCUG.org/2008
«±»
SessionID: 81967
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Daniel Janik
Abstract:
What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.
Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
SessionID: 82053
45 min to build your first SSRS report
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You've been BI curious and now you've been given access to SSRS and you want to make a report. Or, you're a DBA or DBA Dev and could use a report to reduce daily task. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll use SSRS (SQL Server Reporting Services) 2016. The query makes no difference, this time it's all about the output.
SessionID: 82868
The Benefits of Gaming
Event Date: 23-06-2018 - Session time: 16:00:00 - Track: Other
Speaker: Robert Tidwell
Title: The Benefits of Gaming
Abstract:
Studies show that people today are more stressed than ever. We will discuss how playing video games can benefit your life. We will explore how to de-stress your mind, build team work strategies, exercise your body, and improve your communication skills all through play! But wait, there's more! Video games can also be very educational! So take some time for yourself, and let's play!