Nr: 877
SQLSaturday #877 - Boston 2019
SessionID: 98392
VMware Technologies and Microsoft SQL Server
Event Date: 14-09-2019 - Session time: 08:45:00 - Track: Sponsor/Other
Speaker: Andrew Nielsen
Title: VMware Technologies and Microsoft SQL Server
Abstract:
SessionID: 91605
All About Temporary Objects
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Development
Speaker: Edward Pollack
Title: All About Temporary Objects
Abstract:
Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.
In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, discussing their differences, how they work, and the optimal scenarios for using each of them.
SessionID: 91850
Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration
Speaker: Chris Seferlis
Title: Azure SQL Managed Instances - A mostly full-featured SQL Server in the Cloud
Abstract:
In this session we will compare the offerings of Azure SQL Databases, then dig in and show what separates SQL Managed Instances from the rest. We’ll take a look at challenges that previously prevented migrations to Azure, the current features available, some common architectures, and backup and restore options.
SessionID: 94857
Back to the Basics: T-SQL 101
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Development
Speaker: Deborah Melkin
Title: Back to the Basics: T-SQL 101
Abstract:
Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together.
This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
SessionID: 95522
Introduction To SQL Server In Containers
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Development
Speaker: Grant Fritchey
Title: Introduction To SQL Server In Containers
Abstract:
SessionID: 95669
Demystifying Always On Availability Groups
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration
Speaker: Allan Hirt
Title: Demystifying Always On Availability Groups
Abstract:
Always On Availability Groups (AGs) have evolved since their introduction in SQL Server 2012. Not only is there the “classic” form of AGs, but now there are Basic Availability Groups, Distributed Availability Groups, Domain Independent Availability Groups, and Read Scale Groups. Also complicating the picture is virtualization, hyperconverged, the public cloud, Linux, as well as containers which is new to SQL Server 2019. Come to this session to learn what AGs are – and are not – today, the differences between the various AG and deployment options, and how you can harness the power of them in your environments.
SessionID: 96139
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration
Speaker: Surbhi Pokharna
Abstract:
SessionID: 96144
SQL Server Take Over: Establishing a Baseline
Event Date: 14-09-2019 - Session time: 10:00:00 - Track: Administration
Speaker: Lowry Kozlowski
Title: SQL Server Take Over: Establishing a Baseline
Abstract:
SQL Server Take Over: Establishing a Baseline
Performance assessment and tuning for the beginner DBA
Have you ever inherited a group of servers with not a lot of documentation to accompany them? Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly.
The server is running slowly... or is it? Slow compared to what? Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly gather information, review the results and get an action plan on the next step in performance tuning.
SessionID: 91608
Advanced T-SQL Development with latest features.
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development
Speaker: Alex Grinberg
Title: Advanced T-SQL Development with latest features.
Abstract:
SessionID: 93215
SSIS and Containers
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Administration
Speaker: Andy Leonard
Title: SSIS and Containers
Abstract:
SessionID: 95569
Journey from Software Developer to AI Developer
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Professional Development
Speaker: Rahat Yasir
Title: Journey from Software Developer to AI Developer
Abstract:
SessionID: 95925
Keys to a Healthy Relationship with SQL Server
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development
Speaker: Andy Levy
Title: Keys to a Healthy Relationship with SQL Server
Abstract:
Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.
In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.
SessionID: 96080
Running Azure SQL Database Securely
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Administration
Speaker: Bill Wilder
Title: Running Azure SQL Database Securely
Abstract:
In this session we review the key differences around identity management and authentication (including multi-factor authentication), managing server credentials (or, even better, not needing to in some cases), how to audit logins (probably not what you expect), an overview of encryption and data masking options, and the supporting role of Azure Key Vault. We will also touch on compliance and disaster recovery to give the complete picture of powerful features you'll definitely want to know about to protect your data.
This talk will cover relevant capabilities for both traditional Azure SQL Databases and the newer Azure SQL Managed Instances.
This talk assumes you are already familiar with SQL Server or another enterprise database.
SessionID: 96092
Add Time Intelligence to Power BI
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Analytics/BI
Speaker: Sunil Kadimdiwan
Title: Add Time Intelligence to Power BI
Abstract:
When is Time Period based calculations useful in Power BI? Quick answer - ALWAYS! Business users need to know measures such as: What was Sales, what was the change compared to last-year, year-to-date? Did our Expenses go down, compared to similar period last year? etc.
In this session you will learn how to use and apply DAX functions in Power BI, to
develop Time and Date based dimensions and measures that will help answer such
questions.
SessionID: 96140
Should This Be Normalized? When Database Normalization Seems Abnormal
Event Date: 14-09-2019 - Session time: 11:15:00 - Track: Development
Speaker: Chris Voss
Title: Should This Be Normalized? When Database Normalization Seems Abnormal
Abstract:
SessionID: 96764
Supercharge your ETL Development with Advanced SSIS Components
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Daniel Cai
Title: Supercharge your ETL Development with Advanced SSIS Components
Abstract:
Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting.
In this session, we will introduce you to our collection of 200 advanced SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector.
In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.
SessionID: 97993
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Jay Rajendran
Abstract:
Google Cloud Platform enables you to exit non-differentiating, capital intensive activities like hardware procurement and maintenance. Retire hardware, improve server utilization and deploy your Windows and SQL Workloads in an open cloud environment. Google enables extending your SQL database with advanced Server-less Analytics and AI/ML offerings. Deliver a complete platform without the burden of provisioning, scaling and upgrading infrastructure. This session will provide a walk-through of Google's approach to running Windows/SQL workloads in the Cloud and architectural patterns to address your needs.
SessionID: 97997
Women-In-Technology (Models and Mentors)
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Deborah Melkin
Title: Women-In-Technology (Models and Mentors)
Abstract:
Join our panelists as we discuss "Models and Mentors".
SessionID: 98356
Going Beyond Monitoring With SentryOne
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Andy Yun
Title: Going Beyond Monitoring With SentryOne
Abstract:
Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
SessionID: 98382
Successfully Virtualizing SQL Server on vSphere: Doing It Right
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Oleg Ulyanov
Title: Successfully Virtualizing SQL Server on vSphere: Doing It Right
Abstract:
• vCPU allocation and deep dive in vNUMA
• Memory allocation and configurations options
• Storage configuration best practices including PMem/NFS/Snapshots
• Network configuration myths and best practices
It all that you want to know about virtual platform configuration but hesitated to ask! Directly from the source with the ton of hands-on from VMware Professional Services.
SessionID: 98500
SQL 2019 new features
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: George Walters
Title: SQL 2019 new features
Abstract:
SQL Server 2019 - new features
SessionID: 98548
Increasing SQL Server Availability Options Using SIOS DataKeeper
Event Date: 14-09-2019 - Session time: 12:35:00 - Track: Sponsor/Other
Speaker: Allan Hirt
Title: Increasing SQL Server Availability Options Using SIOS DataKeeper
Abstract:
SessionID: 93553
We Need To Talk Security
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration
Speaker: Joe Gavin
Title: We Need To Talk Security
Abstract:
Unless you've been stranded on a deserted island for years you've heard about all the data breaches that seem to happen every day.
This means data security has never been more important which means SQL Server security has never been more important.
We'll take a high level look at security starting with physical security, see the two authentication modes, differences between logins and users, troubleshooting some common login issues, see how to gain access to a SQL Server and wrap up with security similarities and differences between on premise SQL Server and Azure SQL Database.
SessionID: 93751
Unexplored Features of SQL Server
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Development
Speaker: Hasan Savran
Title: Unexplored Features of SQL Server
Abstract:
Every new version of SQL Server adds new features, some of these features are rarely talked about. Join me in this practical session to learn about some of the uncommon but useful features and data types of SQL Server.
We will start with exploring the hierarchyid, geometry and geography data types of SQL Server. We will look at the Temp tables and find a way to cache Temp tables for a better performance. We will cover sparse, rowversion columns and finish the session by showing a way to remove ORM from web applications by using JSON functions of SQL Server.
SessionID: 94843
Data Science 101: An Introduction to Data Science Using Python
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Analytics/BI
Speaker: Ganesh Lohani
Title: Data Science 101: An Introduction to Data Science Using Python
Abstract:
Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
SessionID: 95500
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Development
Speaker: Andy Yun
Abstract:
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.
SessionID: 96102
Why should I care about ... the plan cache?
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration
Speaker: Rick Lowe
Title: Why should I care about ... the plan cache?
Abstract:
Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.
SessionID: 96425
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration
Speaker: Jack Corbett
Abstract:
Prerequisites: Basic PowerShell knowledge. Some SQL Server Administration experience
SessionID: 98023
Event Date: 14-09-2019 - Session time: 13:30:00 - Track: Administration
Speaker: Daniel Cai
Abstract:
SessionID: 91659
What's New in SQL Server 2019: 100% Demos
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development
Speaker: Brent Ozar
Title: What's New in SQL Server 2019: 100% Demos
Abstract:
You haven't installed SQL Server 2019 yet, and you don't want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don't have time to rewrite all your queries or learn new languages - you just want the database to go faster.
I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.
No slides here - not even an about-me slide. Let's dive into some queries!
SessionID: 93279
Approaching Zero: Minimizing Downtime During Deployments
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development
Speaker: Kevin Feasel
Title: Approaching Zero: Minimizing Downtime During Deployments
Abstract:
SessionID: 93658
Become a T-SQL Pivoting Ninja in 59.5 Minutes Or Less
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Analytics/BI
Speaker: Peter Doyle
Title: Become a T-SQL Pivoting Ninja in 59.5 Minutes Or Less
Abstract:
Would you like to create Pivot Tables in SQL with ease?
Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.
Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris.
*Not Possible
SessionID: 93684
Become the Most Valuable Player: Soft Skills for the Hard Market
Event Date: 14-09-2019 - Session time: 14: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: 94526
Organizational Security Compliance with SQL 2012 through 2016/2017
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Administration
Speaker: George Walters
Title: Organizational Security Compliance with SQL 2012 through 2016/2017
Abstract:
You need to deal with more security requirements in your role. How can SQL Server features help you comply? We will delve into Audit, Compliance, and Encryption. SQL 2016/2017 features like Always Encrypted will be detailed at the end.
SessionID: 94565
Introduction to GitHub
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development
Speaker: Joshua Higginbotham
Title: Introduction to GitHub
Abstract:
Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.
- Initial setup of a Repository in GitHub.
- Build Issue templates for new features, bugs, or custom tasks.
- Securing the check-in/merge process to your root branch.
- Integrating GitHub with other productivity tools to keep on top of changes.
SessionID: 96004
Cosmic DBA - Cosmos DB for SQL Server Admins and Developers
Event Date: 14-09-2019 - Session time: 14:45:00 - Track: Development
Speaker: MIKE DONNELLY
Title: Cosmic DBA - Cosmos DB for SQL Server Admins and Developers
Abstract:
NoSQL is not just about having eventual consistency. Switching from a relational database to a NoSQL data store like Cosmos DB is a mind shift for SQL DBAs and developers used to thinking in terms of tables. Schema-free doesn’t mean you don’t have to think about the schema, but it does allow for faster changes and some interesting design patterns.
This session will include a quick outline of Cosmos DB. Then it will move on to describe how indexing works, what the consistency levels all mean, and how your JSON should be designed based on your query patterns. And, I will toss in a high-level overview of the JavaScript triggers, stored procedures, and user defined functions for free. All of this will be presented using examples that are informed by my experience trying to convert a global application from SQL Server to Cosmos DB using the document model.
SessionID: 91736
Upgrading SQL Server - Prepare for Success!
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration
Speaker: Mike Walsh
Title: Upgrading SQL Server - Prepare for Success!
Abstract:
It's (past) time to upgrade your SQL Server(s)! Where do you start? What version should you pick? How do you migrate? What about the downtime? ARGH!
Come to this session and take the stress out of your SQL Server upgrade project. In this session, we'll walk through all you need to think about and do before, during, and after your upgrade for success. We'll answer your upgrade questions, but you'll also leave with the right questions to ask everyone else as you prepare for a successful SQL Server upgrade project.
We'll talk about successful upgrade checklists, best practices, why roulette is better than in-place upgrades, and how to minimize the strain on your users and teams during the upgrade. You'll leave with a working start on your upgrade checklist and plans, too!
Come on! Ditch those SQL Server 2008, 2012, and 2014 instances! Also, yes, we'll chat about the cloud some, too.
SessionID: 92341
CYA for the DBA
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration
Speaker: Matthew Anderson
Title: CYA for the DBA
Abstract:
Do you practice restores on a regular basis, but others in your organization do not? Are you worried that a restore may not be complete? As a DBA you are responsible for much more than simply backup and recovery of databases. This session will go over how to backup some SQL Server objects like Alerts, DBMail, LinkedServers, SQL Agent properties, and others with PowerShell.
I have not always trusted others to be able to restore a machine. This talk walks through how to CYA in the event of an emergency by backing up SQL objects other than just the databases.
SessionID: 93476
Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration
Speaker: Thomas Grohser
Title: Persistent Memory and Hybrid Buffer Pool - The good, bad and ugly
Abstract:
SQL Server 2019 will introduce us to a new feature called Hybrid Buffer Pool. The ability of placing database files into "Memory" that does not lose its content in case of a power outage. This session will explore when it makes sense to use this feature and when not to use it.
SessionID: 95547
Introduction into SQL Server 2019 Big Data Cluster
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Analytics/BI
Speaker: Sergiy Lunyakin
Title: Introduction into SQL Server 2019 Big Data Cluster
Abstract:
SQL Server 2019 allows you to deploy a scalable cluster of SQL Server, HDFS and Spark in Kubernetes. It brings you new capabilities to integrate structured and non-structured data, create data virtualization on top of it and integrate AI with it. Sounds amazing, right?
Join me in this session and I show you how it is easy to deploy this cluster and start using it, capabilities it provides and how to manage it. We also review some use cases that are relevant to this solution.
SessionID: 95570
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Administration
Speaker: Eddy Djaja
Abstract:
SessionID: 95698
How to audit and prevent unwanted user actions.
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Development
Speaker: John Miner
Title: How to audit and prevent unwanted user actions.
Abstract:
Abstract:
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
9 - Which of these techniques apply to an Azure SQL database?
SessionID: 96721
Data Pipeline Best Practices for an Increasingly Cloudy World
Event Date: 14-09-2019 - Session time: 16:00:00 - Track: Development
Speaker: Adam Machanic
Title: Data Pipeline Best Practices for an Increasingly Cloudy World
Abstract: