Nr: 797
SQLSaturday #797 - Boston 2018
SessionID: 85333
SQL Server running with VMware , Rich History ; Brilliant Future
Event Date: 22-09-2018 - Session time: 08:45:00 - Track: Keynote
Speaker: Mike Adams
Title: SQL Server running with VMware , Rich History ; Brilliant Future
Abstract:
SessionID: 83334
Documenting your SQL Server environment with PowerShell
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Administration
Speaker: Matthew Anderson
Title: Documenting your SQL Server environment with PowerShell
Abstract:
Finding a free and simple method to gather information about my SQL Server environment was difficult. Using a combination of PowerShell, the dbatools module, and a PowerBI report I finally found something that works for me. I hope it can be helpful for you as well.
SessionID: 83396
10 Years of Highs and Lows as an Independent Consultant
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Professional Development
Speaker: Allan Hirt
Title: 10 Years of Highs and Lows as an Independent Consultant
Abstract:
2017 marked the 10th anniversary of when I left the world of being a full time employee to being an independent consultant. Back then I was just trying to make it to year two. Ten years later, I've learned a lot and I'm still standing with a few battle scars to prove it. Join me as I discuss what it takes to be (and survive as) a consultant, lessons learned - both good and bad, and how you can apply the principles of consulting even if you are a full time employee to step up your game.
SessionID: 84294
T-SQL Tips Tricks to Make Your Life Easier!
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Development
Speaker: Andy Yun
Title: T-SQL Tips Tricks to Make Your Life Easier!
Abstract:
Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.
This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.
This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!
SessionID: 84444
Introduction to Azure SQL Data Warehouse
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Cloud
Speaker: Derik Hammer
Title: Introduction to Azure SQL Data Warehouse
Abstract:
On-premises data warehouse solutions are typically a large up-front capital expense which expensive boundaries to expansion. This led my organization to look to the cloud. In this session, I cover the basics of Azure SQL Data Warehouse, its architecture, and why you should be interested in combining the flexibility and scalability of the cloud with a massively parallel processing data warehouse.
SessionID: 84721
Data Protection Privacy in the World of Database DevOps
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Development
Speaker: Grant Fritchey
Title: Data Protection Privacy in the World of Database DevOps
Abstract:
SessionID: 84890
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Administration
Speaker: Surbhi Pokharna
Abstract:
SQL Server database engine doesn’t differentiate between workloads but Resource Governor can and gives flexibility for resource allocation preference. You can prioritize you workload based upon importance.
In this session we will deep dive to learn how to use Resource Governor to cap different facets of CPU, Memory, IOPs utilization with demos and examples.
SessionID: 84993
Python in SQL Server 2017
Event Date: 22-09-2018 - Session time: 10:00:00 - Track: Analytics/BI
Speaker: Chris Hyde
Title: Python in SQL Server 2017
Abstract:
SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!
In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
SessionID: 83077
Tracking Index Usage Like a Pro!
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Administration
Speaker: Edward Pollack
Title: Tracking Index Usage Like a Pro!
Abstract:
Knowing which indexes are used most (or least) often can help us determine which are no longer
needed, or which could use some tweaking. Keeping track of indexes that are missing and could greatly help performance allows us to solve related performance problems before they become disasters.
In this session, we will discuss how SQL Server tracks index utilization and the ways that we can persist this data for future use. Once we have a collection process in place, we can easily report on it and make smart decisions using months of collected data.
SessionID: 83119
DAX and the tabular model
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Analytics/BI
Speaker: Steve Simon
Title: DAX and the tabular model
Abstract:
With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
SessionID: 83227
Extended Events: What are they and How do I use them
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Administration
Speaker: Dave Bland
Title: Extended Events: What are they and How do I use them
Abstract:
Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!
SessionID: 83297
Azure Databricks = Azure + Spark + Machine Learning Collaboration
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Analytics/BI
Speaker: Bryan Cafferky
Title: Azure Databricks = Azure + Spark + Machine Learning Collaboration
Abstract:
SessionID: 83347
Faster SSIS
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Analytics/BI
Speaker: Andy Leonard
Title: Faster SSIS
Abstract:
Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2017 Integration Services (SSIS 2017) packages.
We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.
Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
SessionID: 83963
SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Cloud
Speaker: Rick Lowe
Title: SQL Server on Amazon Web Services - 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: 84944
Event Date: 22-09-2018 - Session time: 11:15:00 - Track: Development
Speaker: Bhavna Mangal
Abstract:
This session will also cover CosmosDB Explorer in Public View. It can be used to access the database with read-only or read-write permissions without requiring access to Azure subscription.
SessionID: 85188
Rubrik-Simplifying SQL Data Protection
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: Sponsor
Speaker: Chris Lumnah
Title: Rubrik-Simplifying SQL Data Protection
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: 85274
Going Beyond Monitoring With SentryOne
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: Sponsor
Speaker: Andy Yun
Title: Going Beyond Monitoring With SentryOne
Abstract:
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: 85281
Architecting SQL Server on VMware vSphere - Doing it Right!
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: Sponsor
Speaker: Oleg Ulyanov
Title: Architecting SQL Server on VMware vSphere - Doing it Right!
Abstract:
The session will cover both the design and the configuration of a SQL Server virtual machine with the special focus on:
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 tom of hands-on from the Professional Services
SessionID: 85452
Delivering SQL Server High Availability on Microsoft Azure
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: Sponsor
Speaker: Michael Traudt
Title: Delivering SQL Server High Availability on Microsoft Azure
Abstract:
You can use Microsoft Azure to quickly build, deploy, scale and manage your SQL Server databases, while seamlessly integrating SIOS DataKeeper for synchronized data and high availability.
SessionID: 85674
WIT panel discussion
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: WIT
Speaker: Deborah Melkin
Title: WIT panel discussion
Abstract:
Join us for a WIT panel discussion with some of today's #PASSWIT speakers. We'll talk about being seen and heard in the community.
SessionID: 85732
How to Get Management Buy-In for Compliant Provisioning Software
Event Date: 22-09-2018 - Session time: 12:35:00 - Track: Sponsor
Speaker: Dustin Abney
Title: How to Get Management Buy-In for Compliant Provisioning Software
Abstract:
As a DBA you are aware of the ever-growing challenge of protecting your Production data when being leveraged outside of your Production environment. You understand the need for third-party software to protect this sensitive data but might not be trained in the arts of influencing the management decision process to ensure that essentials get purchased. Redgate will show you how to get management support for crucial software purchases in your organization.
SessionID: 83081
Networking 101: Building professional relationships
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Professional Development
Speaker: Ray Kim
Title: Networking 101: Building professional relationships
Abstract:
Networking. You keep hearing that word throughout your career development, but you don't know much about it, much less, how to do it. You want to connect with technical and data professionals, so you attend events such as SQL Saturday and your local user group. But what about your book club, your gym, your church group, or your kid's soccer game? Those are prime -- and overlooked -- opportunities to network!
In this interactive session, we will discuss networking -- what it is, why it's important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn't previously have!
SessionID: 83340
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Development
Speaker: Varsham Papikian
Abstract:
SSMS (SQL Server Management Studio) is probably the most used application for working with SQL Server. Many of us use it on a daily basis. SSMS is a complex application and it has many 'hidden' features that some of us are not aware of. Yet using them will allow us to be achieve more and be more efficient. During the session I will demonstrate many such 'hidden' features that could be very useful.
SessionID: 83345
Understanding Power BI Administration and Security
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Analytics/BI
Speaker: Ginger Grant
Title: Understanding Power BI Administration and Security
Abstract:
SessionID: 83409
BI Infrastructure in Azure: Points to Consider
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Analytics/BI
Speaker: Paresh Motiwala
Title: BI Infrastructure in Azure: Points to Consider
Abstract:
Success of a good BI infrastructure is measured by two most important factors:
a) Better access to data and
b) Increased operational efficiency
How can you set up your own BI infrastructure in the cloud to address these?
What components do we consider?
We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well.
We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes.
We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
SessionID: 84496
Containerized databases: SQL Server and DevOps
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Administration
Speaker: Ned Otter
Title: Containerized databases: SQL Server and DevOps
Abstract:
What are containers? When would you use them? Are they supported for production? Do they run on Windows? Do they run on Linux? Can they persist data?
These are just a few of the questions we will answer in this session. Containers are all the rage today - don't get left behind!
SessionID: 84722
Exploring Execution Plans
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Development
Speaker: Grant Fritchey
Title: Exploring Execution Plans
Abstract:
SessionID: 85027
The Case for Change: Identifying and Remedying Bad Code
Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Development
Speaker: Amy Herold
Title: The Case for Change: Identifying and Remedying Bad Code
Abstract:
How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.
SessionID: 83087
Database Project Makes Deployment Consistent
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Administration
Speaker: Thomas Norman
Title: Database Project Makes Deployment Consistent
Abstract:
The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
SessionID: 83096
What's new in SQL Server 2017
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Development
Speaker: Hasan Savran
Title: What's new in SQL Server 2017
Abstract:
SessionID: 83310
Organizational Security Compliance with SQL 2012 through 2016/2017
Event Date: 22-09-2018 - 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: 83332
Azure Data Factory V2 /ETL in the clouds
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Analytics/BI
Speaker: Christian Cote
Title: Azure Data Factory V2 /ETL in the clouds
Abstract:
Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is now able to integrate your SSIS loads and do lots of work with your data in Azure. In this session, you will learn the new features of Azure Data Factory V2 and how SSIS packages can be triggered from it.
This session will also introduce concepts like the modern data warehouse and what are the new challenges that comes with data integration both on-premise and cloud based.
SessionID: 83349
Case study: How we simulated a lights-out data center DR test
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Administration
Speaker: Michael O'Leary
Title: Case study: How we simulated a lights-out data center DR test
Abstract:
Traditional DR tests may include application-specific recovery tests, or perhaps your workplace holds an annual "DR weekend" when you test the recoverability of your applications, and measure yourself against your own RPO's and RTO's.
With our applications now running in cloud, whether IaaS, PaaS, or SaaS, we typically must trust vendors' SLA's, and sometimes must design our own DR plan.
This case study is a real-world story about how we decided to test our DR plans when our various applications run in the cloud. We used Azure Site Recovery, Azure Backup Services, some Inf-as-Code solutions, a lot of automation, and some pre-configured but powered down infrastructure. I'd be happy to share our lessons learned.
SessionID: 83401
From (User) Story to Tables: Read Between the Lines to Find Your Data
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Development
Speaker: Deborah Melkin
Title: From (User) Story to Tables: Read Between the Lines to Find Your Data
Abstract:
If you work in an agile environment, design requirements often come to us as stories with the phrase: "As a type of user, I want to ..."
For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.
That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together.
This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
SessionID: 84170
Inventory your data with Azure Data Catalog
Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Administration
Speaker: Beth Wolfset
Title: Inventory your data with Azure Data Catalog
Abstract:
Data, data, everywhere - how do you keep track of what data you have and let your consumers know? In the library, the card catalog has been replaced with an online searches. In this talk, we will show how Azure Data Catalog tops Dewey when searching for your data sources, and how this is a component of your Data Governance strategy.
SessionID: 83200
Supercharging Backups and Restores For Fun and Profit
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Administration
Speaker: Bob Pusateri
Title: Supercharging Backups and Restores For Fun and Profit
Abstract:
Super-fast queries are an essential part of any business process, but speed will never be more important than during a disaster when you need to restore from backup. Come and see how both backups and restores can be tuned just like a query. In this demo-intensive session, we will discuss the different phases of the backup and restore processes, how to tell how long each of them is taking, and which are the easiest to significantly speed up. You just might be surprised how simple it is to achieve dramatic results - cutting your backup and restore times by 75% or more is absolutely possible using the methods covered here.
SessionID: 83208
A DBAs guide to the proper handling of corruption
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Administration
Speaker: Brandon Leach
Title: A DBAs guide to the proper handling of corruption
Abstract:
Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption.
First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll also look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.
Then we will move onto how to respond to some common example of corruption. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
SessionID: 83503
Effective Data Warehouse Storage Patterns
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Development
Speaker: John Miner
Title: Effective Data Warehouse Storage Patterns
Abstract:
Abstract:
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning?
2 – Database sharding for daily information.
3 – Working with files and file groups.
3 – Partitioned views for performance.
4 – Table and Index partitions.
5 – Row Data Compression.
6 – Page Data Compression.
7 – Programming a sliding window.
8 – What is different in Azure SQL database?
SessionID: 83624
Shaving off Microseconds
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Development
Speaker: Thomas Grohser
Title: Shaving off Microseconds
Abstract:
This session is a compilation of extreme techniques I had to use over time to make very fast operations go a bit faster. It will cover multiple areas (indexing, table design, data access layer, schemas, object naming, datatypes, collations physical data placement and more. All examples given in this session are from real world cases of some of the most demaning workloads in the world.
SessionID: 84826
Power up SSRS 2017 with Power BI Report Server
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Analytics/BI
Speaker: Sunil Kadimdiwan
Title: Power up SSRS 2017 with Power BI Report Server
Abstract:
Power BI Report Server is a superset of SSRS 2017 that includes on-premise hosting of Power BI reports.
PBIRS provides us a modern solution for enterprise reporting and mobile business intelligence where you can apply your own terms of governance and distribute reports behind your organizations firewall.
In this session you will learn how to develop and publish Power BI reports (.PBIX) in Power BI Report Server, including custom visuals.
I will also show how you can develop and host Mobile reports, KPI and Paginated reports. You can view these on your browser or on any device (iOS, Android and Windows). I will round off this session with custom branding, add sharable comments, and (yes!!) the newest feature addition of Excel Workbooks.
SessionID: 84845
How to get your Dream Job: Resume job hunting tips
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Professional Development
Speaker: Andy Mallon
Title: How to get your Dream Job: Resume job hunting tips
Abstract:
What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream.
In this session, we'll talk about how I got where I am, and how you can get to where you want to be. In addition to sharing my journey, I'll give some helpful tricks to getting your next job. You'll learn how to write a resume that gets you noticed, how to navigate interviews, and learn how to decide if a potential job and employer is right for you.
Bring your own resume to this session, and I'll provide you some personal (and private) feedback on what I would do to help improve your resume so you can land your Dream Job.
Slides handouts available on GitHub: http://am2.co/dream-job-ppt
SessionID: 84943
Tune Like a Guru - The Big Three!
Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Administration
Speaker: Kevin Boles
Title: Tune Like a Guru - The Big Three!
Abstract: