sqlsathistory

Nr: 696

Back to Main list

SQLSaturday #696 - Redmond 2018

Start Time (24h) Speaker Track Title
08:30:00 Armando Lacerda Enterprise Database Administration Deployment Unleashing Stretched Databases
08:30:00 Christian Wade BI Platform Architecture, Development Administration Modeling and Analytics Features Coming in Azure Analysis Services
08:30:00 Amit Banerjee Application Database Development Running applications on Azure Database for PostgreSQL/MySQL
08:30:00 Tim Gorman Enterprise Database Administration Deployment Accelerating Development and Testing Using Data Virtualization
08:30:00 Greg Larsen Enterprise Database Administration Deployment Blurring your Data with Dynamic Data Masking
08:30:00 Vern Rabe Application Database Development It's Time for a Change: Temporal Table Support in SQL Server 2016
08:30:00 Rick Lowe Enterprise Database Administration Deployment Why should I care about ... the plan cache?
09:45:00 Christopher Sims BI Platform Architecture, Development Administration Getting graphy with CosmosDB Graph API with Gremlin
09:45:00 Armando Lacerda Enterprise Database Administration Deployment SQL Server Tricks for Storage and I/O Performance in the cloud
09:45:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment DevOps for the DBA
09:45:00 John Sterrett Cloud Application Development Deployment An Introduction to Azure SQL Database for DBA's
09:45:00 Maxwell Myrick Enterprise Database Administration Deployment SQL Server Then and Now: Changing the State of Long-held Beliefs
09:45:00 Tim Gorman Information Delivery Reducing The Surface Area Of Risk in Data Security
09:45:00 Ben Miller Application Database Development Gathering Trending Data with PowerShell
09:45:00 Davide Mauri Strategy and Architecture Serverless Computing: Azure Functions, Logic Apps and Azure SQL and CosmosDB
09:45:00 Arnie Rowland Information Delivery Prevent Presentation Paralysis
11:00:00 Janis Griffin Enterprise Database Administration Deployment HiHo! HiHo! SQL Server on Linux, We Go!
11:00:00 Maxwell Myrick Professional Development The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You?
11:00:00 Sourabh Agarwal Enterprise Database Administration Deployment Troubleshooting Always On Availability Group Failovers
11:00:00 Vern Rabe Application Database Development Proper DataType Usage=Guaranteed Better Performance and Accuracy
11:00:00 Ben Miller Enterprise Database Administration Deployment SQL Server Encryption
11:00:00 Russel Loski Cloud Application Development Deployment Querying Semistructured Data in Azure Data Lake with USQL
11:00:00 Scott Stauffer Analytics and Visualization Power BI for the Faint of Heart - Building an Interactive Report
13:30:00 Simon Cho BI Platform Architecture, Development Administration Build ETL efficiently (10x) with Minimal Logging
13:30:00 Kevin Feasel Application Database Development APPLY Yourself
13:30:00 Kalen Delaney Application Database Development A Look Inside SQL Server Distribution Statistics
13:30:00 Joe Chang Enterprise Database Administration Deployment Rethink Server Sizing
13:30:00 Russel Loski BI Platform Architecture, Development Administration Managing SSRS Reports using PowerShell and SSRS Web Services (60 minutes)
13:30:00 Davide Mauri Application Database Development Back to the Roots: When indexes are not enough
13:30:00 SQLSaturday Redmond Other Five Lighting sessions (click here to see them)
13:30:00 Paul Turley BI Platform Architecture, Development Administration The Nine Realms of Power BI
15:15:00 Andrew Cook Cloud Application Development Deployment Xamarin Data Syncing
15:15:00 Kevin Feasel Enterprise Database Administration Deployment Securing SQL Server
15:15:00 Kellyn Pot'Vin-Gorman Application Database Development Oracle vs. SQL Server- The War of the Indices
15:15:00 Arvind Shyamsundar Enterprise Database Administration Deployment Advanced SQL Server troubleshooting with SQLCallStackResolver
15:15:00 Kun Cheng Enterprise Database Administration Deployment SQLCAT: A customer story of Distributed AG strategy for Hybrid Architecture (Cloud agnostic)
15:15:00 Yana Berkovich BI Platform Architecture, Development Administration Enjoy Your Power Responsibly; Governance for PowerBI O365
15:15:00 Michael Wall Advanced Analysis Techniques Introduction to Log Parser: Log What?
15:15:00 Sumit Kumar Analytics and Visualization Machine Learning Services in SQL Server 2017

SessionID: 68856

Unleashing Stretched Databases

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Armando Lacerda

Title: Unleashing Stretched Databases

Abstract:

This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.

SessionID: 68905

Modeling and Analytics Features Coming in Azure Analysis Services

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christian Wade

Title: Modeling and Analytics Features Coming in Azure Analysis Services

Abstract:

Microsoft Azure Analysis Services SQL Server Analysis Services help you build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. Join this session for a look forward to what's coming in soon! The demos will cover new features to be announced for enterprise-grade BI models in the cloud.

SessionID: 69262

Running applications on Azure Database for PostgreSQL/MySQL

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Amit Banerjee

Title: Running applications on Azure Database for PostgreSQL/MySQL

Abstract:

Azure Database for MySQL and Azure Database for PostgreSQL are managed database services built for developers using the community edition of MySQL and PostgreSQL. Learn how you can leverage these new choices of managed database services to build scalable, secure and intelligent apps. Using insights from current customer scenarios and through live demos, we walk through the service management capabilities, best practices to move your databases to the service, and also focus on how the Microsoft Azure ecosystem of app and data services is unlocking the potential of MySQL and PostgreSQL in the Azure cloud platform.

In this session, we will show you how you can develop on Azure and deploy solutions without having to worry about high availability, disaster recovery, monitoring and other common operational and administration tasks!

SessionID: 71285

Accelerating Development and Testing Using Data Virtualization

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Accelerating Development and Testing Using Data Virtualization

Abstract:

Constraining everything in development and testing is database size. Storage is a bottleneck, and while faster SSD/Flash is available, it is still too expensive due to the size of many databases, especially in DEV and TEST. More to the point, it takes a lot of time to push terabytes around, and time itself is expensive. The old joke about "good, fast, and cheap -- pick any two" is so true with data.

Providing full databases for each developer or tester on each task of each project seems unrealistic, when each copy might require terabytes of storage, so for decades everyone has limited themselves to working in shared dev/test environments that are refreshed only every few months, where conflicts occur, quality suffers, and things move slowly.

Come learn why data virtualization is the solution to a problem everyone knows.

Good, fast, and cheap -- have all three with data virtualization. Be able to clone data quickly, and remove the biggest constraint to development and testing.

SessionID: 71678

Blurring your Data with Dynamic Data Masking

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Greg Larsen

Title: Blurring your Data with Dynamic Data Masking

Abstract:

In this talk Greg will explore the new Data Masking feature, that came out with SQL Server 2016. Greg will be discussing:

• Why you should mask your data • The 4 different masking functions • Security around Dynamic Data Masking • Benefits, drawbacks and programming considerations around Dynamic Data Masking • How to crack Dynamic Data Masking Greg’s talk will also contain a number Dynamic Data Masking demos. After attending this session, Attendee will gain a solid understanding of Dynamic Data Masking and the considerations they should take into account when rolling out this new feature.

SessionID: 71718

It's Time for a Change: Temporal Table Support in SQL Server 2016

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: It's Time for a Change: Temporal Table Support in SQL Server 2016

Abstract:

Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system-maintained “history” tables to track all changes to the table data.

In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information.

SessionID: 71897

Why should I care about ... the plan cache?

Back to calendar

Event Date: 10-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

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 drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 68811

Getting graphy with CosmosDB Graph API with Gremlin

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Christopher Sims

Title: Getting graphy with CosmosDB Graph API with Gremlin

Abstract:

CosmosDB was announced at Build 2017 as an extension to Microsoft's DocumentDB offering and is positioned to be a key component of the Microsoft Data Platform. In this session, we will explore CosmosDB's graph API that is built using Apache's TinkerPop and Gremlin projects. Graph databases allow you to build a powerful data model that explores connections and paths between data. At the end of this session, attendees will have a solid understanding of what a graph database is and how you can use Gremlin and the .NET API to interact with a graph database.

SessionID: 68854

SQL Server Tricks for Storage and I/O Performance in the cloud

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Armando Lacerda

Title: SQL Server Tricks for Storage and I/O Performance in the cloud

Abstract:

SQL Performance strategies for on premises deployment don't translate straight through to the cloud. SQL Server 2016 brought much more integration and performance options for cloud database deployment. In this session we will see through multiple demos how to benefit from the storage options in Azure storage and make SQL Server break the sound speed!

SessionID: 69384

DevOps for the DBA

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps for the DBA

Abstract:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.

SessionID: 69589

An Introduction to Azure SQL Database for DBA's

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: John Sterrett

Title: An Introduction to Azure SQL Database for DBA's

Abstract:

Are you interested in learning about Azure SQL Databases but are not sure where you should start learning? Platform as a service (PaaS) databases are here and adoption is growing. In this session, you will learn how to take your current DBA skills and utilize them with Azure Databases. We will focus on getting started, migrating databases, disaster recovery, performance, and security.

SessionID: 70088

SQL Server Then and Now: Changing the State of Long-held Beliefs

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Maxwell Myrick

Title: SQL Server Then and Now: Changing the State of Long-held Beliefs

Abstract:

We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.

SessionID: 71286

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Information Delivery

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.

Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.

SessionID: 71725

Gathering Trending Data with PowerShell

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Ben Miller

Abstract:

Join me in the quest to become a PowerShell DBA! Learn how to improve your career by quickly accessing logistical information within a database rich environment. Discover how PowerShell tools can enable you to gather and store information in a functioning repository, placing views and functions from a day, a week, or even a year ago, right at your fingertips!

SessionID: 71803

Serverless Computing: Azure Functions, Logic Apps and Azure SQL and CosmosDB

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: Davide Mauri

Title: Serverless Computing: Azure Functions, Logic Apps and Azure SQL and CosmosDB

Abstract:

Azure offers many options in that space and two of them are particulary interesting: Azure Function and Azure Logic Apps. What are you needs? Hanlding data coming from a form? Invalidating cached data when a file changes? Responding to an external event like new customer added to your CRM? Everything can be done very easily and with the language of your choice, or even via an easier workflow-like approach, that doesn't even require you to write code. No matter which approach you decide to take, you'll need to store data somewhere. Depending on the scenario you may want to use the new multi-API CosmosDB or the well established Azure SQL. In this session we'll see how all the mentioned technologies can help us to have architectural choices to be more efficient and effective in our job.

SessionID: 73671

Prevent Presentation Paralysis

Back to calendar

Event Date: 10-02-2018 - Session time: 09:45:00 - Track: Information Delivery

Speaker: Arnie Rowland

Title: Prevent Presentation Paralysis

Abstract:

Stop fretting about giving presentations -you CAN decide to become more confident, come across more polished, and actually present with authority. In this session, you will learn and pick up some great tips about how to better prepare, and then present, technical material. You WILL leave with an improved sense of possibility!

Arnie will guide you with techniques to better understand and match the audience's expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience's attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don't miss this session!

SessionID: 69914

HiHo! HiHo! SQL Server on Linux, We Go!

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: HiHo! HiHo! SQL Server on Linux, We Go!

Abstract:

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:

  1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
  2. How to install, maintain and backup SQL Server on Ubuntu Linux systems
  3. Several useful Linux commands to monitor/manage SQL Server

SessionID: 70089

The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You?

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Professional Development

Speaker: Maxwell Myrick

Title: The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You?

Abstract:

Accomplished IT staff looking to make the next step in their career development are often tempted to abandon the traditional full-time employee role for that of a self-managed consultant. The biggest challenge is how to know which role is the best fit for you. This session will discuss the pros/cons of self-managed consulting with an eye to the skills it takes to really be successful on the outside. For those that fit, we will also cover several of the hidden traps of consulting, what you need to get started, and the six skills that you absolutely have to have (or rent) to make a go of it. Whether you are looking at this type of move near-term or just keeping your options open, this talk will give you the real-life lessons to make that next step with confidence.

SessionID: 70779

Troubleshooting Always On Availability Group Failovers

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sourabh Agarwal

Title: Troubleshooting Always On Availability Group Failovers

Abstract:

SessionID: 71719

Proper DataType Usage=Guaranteed Better Performance and Accuracy

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: Proper DataType Usage=Guaranteed Better Performance and Accuracy

Abstract:

It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types.

In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.

SessionID: 71727

SQL Server Encryption

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.

SessionID: 71821

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00: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: 73889

Power BI for the Faint of Heart - Building an Interactive Report

Back to calendar

Event Date: 10-02-2018 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Scott Stauffer

Title: Power BI for the Faint of Heart - Building an Interactive Report

Abstract:

You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive piece de ré·sis·tance on the visual design surface!

SessionID: 69056

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Cho

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract:

This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

SessionID: 69286

APPLY Yourself

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 71491

A Look Inside SQL Server Distribution Statistics

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Kalen Delaney

Title: A Look Inside SQL Server Distribution Statistics

Abstract:

Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics to see how they are used to come up with the estimates. We’ll also discuss changes in the cardinality estimator in recent versions and look at some new metadata that gives us more statistics information.

Goals: • Explore the output of DBCC SHOW_STATISTICS • Describe when the density information is useful • Look at some problem scenarios for which the statistics can’t give good estimates • Understand why cardinality estimation involves more than just the statistics

SessionID: 71624

Rethink Server Sizing

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Joe Chang

Title: Rethink Server Sizing

Abstract:

Does it seem strange server sizing articles automatically assume that a 2-socket system, with some number of cores, is the right solution, excepting a 4-socket for extreme circumstances? Or is this accepted because that’s what everyone assumes absent rational technical explanation based on recent generation components? There were once valid reasons for multi-socket as the baseline system, but the world has changed since then. Were your database and application architected together to achieve high memory locality on a NUMA system? If this question cannot definitely be answered in the affirmative, then more than likely a single socket system is the best server platform for database transaction processing. This is not an option currently offered by the major cloud providers.

SessionID: 71820

Managing SSRS Reports using PowerShell and SSRS Web Services (60 minutes)

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russel Loski

Title: Managing SSRS Reports using PowerShell and SSRS Web Services (60 minutes)

Abstract:

When you have to do something more than once, you should script it! That’s true for SQL Server maintenance tasks. It’s also important for Business Intelligence projects as well. Microsoft has provided web services to manage your reporting service and to download reports in various forms. In this session I demonstrate how to leverage these web services from PowerShell to handle common SSRS administrative tasks: uploading and copying a report; checking the parameter values, setting the parameter defaults, scheduling a cache refresh. I addition, I demonstrate how to download a report top PDF using PowerShell. You will not only come away with a set of PowerShell scripts to manage your SSRS server, you will learn how to work around some of the less intuitive features of PowerShell to use and extend these scripts.

SessionID: 71832

Back to the Roots: When indexes are not enough

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Davide Mauri

Title: Back to the Roots: When indexes are not enough

Abstract:

SessionID: 72628

Five Lighting sessions (click here to see them)

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: Other

Speaker: SQLSaturday Redmond

Title: Five Lighting sessions (click here to see them)

Abstract:

1. Temp Tables Table Variables by Vern Rabe.

This talk will explain how to select between temp tables and table variables.
  1. Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints by Rick Lowe Ever hear NOLOCK is bad? Ever use one (or a hundred) anyway? Come see some of the bad things that can happen when NOLOCK hints are abused.

  2. Change Data Capture in SQL Server, SSIS, Master Data Services by Swagatika Sarangi. In This session, you will see a demonstration of implementing Change Data Capture in SQL Server 2017 and Master Data Services web UI 2017.

  3. A look at what is required to get an Alexa application up and running on Azure Functions where voice is the UI By Andrew Cook

  4. 15 speaking tips in 15 minutes by Arne Rowland.

SessionID: 72922

The Nine Realms of Power BI

Back to calendar

Event Date: 10-02-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Paul Turley

Title: The Nine Realms of Power BI

Abstract:

Planning a Power BI solution need to understand options choices? There is much to consider as you discover your inner Data Avenger. Like the old story of the 4 Blind Men The Elephant, if you ask 4 people to describe Power BI; you will likely get 4 answers. Power BI solutions have 9 Realms. It's easy to get started but things can get complicated quickly... Should you import your data use the cloud service? or keep your data on-premises using the gateway? Should you use DirectQuery or direct access to Analysis Services, multidimensional or tabular, in Azure or on-prem? What's the best method to secure data control user access? What to license? How will users access dashboards reports? Can it be embedded? A hammer or other tools?

From simple desktop published reports, to enterprise-scale and highly-secured solutions; we will demystify all these options provide a roadmap to conquer the Nine Realms; from Midgard to Asgard, and from Desktop to Power BI Avenger.

SessionID: 68927

Xamarin Data Syncing

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Andrew Cook

Title: Xamarin Data Syncing

Abstract:

How can your users continue to use your mobile application while offline? A look into how and why to make a mobile app work where a data connection is not available and how to keep that data synchronized between the device, cloud and other devices.

Offline sync allows users to interact with a mobile application, viewing, adding, or modifying data, even where there isn't a network connection. Changes are stored in a local database, and once the device is online, the changes can be synced with the web service.

SessionID: 69289

Securing SQL Server

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Feasel

Title: Securing SQL Server

Abstract:

A default SQL Server installation is reasonably secure, but quot;reasonably securequot; doesn't cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.

SessionID: 69385

Oracle vs. SQL Server- The War of the Indices

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Kellyn Pot'Vin-Gorman

Title: Oracle vs. SQL Server- The War of the Indices

Abstract:

This session is for the love of technology and learning. Its based off research performed on objects, design and code built as similar as possible to see how Oracle and SQL Server compare in performance, usage and storage of indices. Environments were built on-prem and in the cloud to view differences in different cloud support of database engines and based off trusted measurements in each platform so as to dig into how the use case was built, the similarities and the differences in each.

Based off this use case, enhanced builds of more advanced index features and discussions of the advantages, reasons for the introduction and how it's effected the direction of each product, the DBAs who are responsible for them and resources.

Takeaways are:

  1. Receive a strong education on platform differences between Oracle and SQL Server.
  2. Discover hidden insight on index storage and costs.
  3. Learn about great tips on maintaining index health

SessionID: 69949

Advanced SQL Server troubleshooting with SQLCallStackResolver

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Arvind Shyamsundar

Title: Advanced SQL Server troubleshooting with SQLCallStackResolver

Abstract:

Troubleshooting spinlock contention, strange wait types, AVs and asserts is no longer a black box. With the availability of SQLCallStackResolver (http://aka.ms/sqlstack) you can start uncovering the true reasons for a particular behavior within SQL Server, without having to open WinDbg! This tool can potentially save you a call to Microsoft Support (or at least go much better prepared to them!) In this session you will be presented live demos of how SQLCallStackResolver has helped in real-life cases, both for SQL Server on Windows and SQL Server on Linux. Latch contention, spinlock contention, AVs are no longer a mystery with this tool. Come and see how you can tackle the most difficult and advanced SQL Server troubleshooting scenarios yourself!

SessionID: 70006

SQLCAT: A customer story of Distributed AG strategy for Hybrid Architecture (Cloud agnostic)

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kun Cheng

Title: SQLCAT: A customer story of Distributed AG strategy for Hybrid Architecture (Cloud agnostic)

Abstract:

Come to learn how an enterprise customer moves from on-premises to cloud with hybrid design leveraging SQL Server Always-on and distributed availability group across cloud platforms (Azure AWS).

SessionID: 70494

Enjoy Your Power Responsibly; Governance for PowerBI O365

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Yana Berkovich

Title: Enjoy Your Power Responsibly; Governance for PowerBI O365

Abstract:

PowerBI is used in many organizations, but how to govern it? this question is still a work in progress. All those features and capabilities and the limitless world of self-service BI, how are the users affected by that? How is IT? Some best practices, lessons learned and fun facts about the platform.

I will be talking about why do we need governance in Power BI? Groups and PowerB, permission management, limitations and how it correlates with other O365 applications.

SessionID: 71744

Introduction to Log Parser: Log What?

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Advanced Analysis Techniques

Speaker: Michael Wall

Title: Introduction to Log Parser: Log What?

Abstract:

Log Parser is one of Microsoft’s best and most under recognized tools. Originally designed to read IIS and system logs, its simple complexity makes it a true “swiss army knife” of a tool. With its ability to read multiple log and text formats and then spit them out in a myriad of formats, it can be used to quickly analyze large amounts of data and present them in a readable format.

This presentation will start with some basic uses of Log Parser, explain some of the core features, demonstrate some of the challenges, and finally focus on using Log Parser to decrypt SSRS logs. These decrypted logs can then be used as a monitoring system.
As with most things, there are multiple ways to accomplish a task. Log Parser will be a welcome addition to your tool belt!

SessionID: 74016

Machine Learning Services in SQL Server 2017

Back to calendar

Event Date: 10-02-2018 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Sumit Kumar

Title: Machine Learning Services in SQL Server 2017

Abstract:

Machine Learning Services with Python and R support has transformed SQL Server into a powerful end to end AI platform. Come learn about the advantages of doing in-database machine learning using R and Python languages and get the latest in this technology.