sqlsathistory

Nr: 584

Back to Main list

SQLSaturday #584 - Colorado Springs 2017

Start Time (24h) Speaker Track Title
08:30:00 Thane Schaffer Application Database Development Introduction to SQL
08:30:00 Susantha Bathige Enterprise Database Administration Deployment Statistics and New Cardinality Estimator Model
08:30:00 Meagan Longoria BI Platform Architecture, Development Administration Up Close and Personal with the Tabular SSAS DMVs
08:30:00 Warren Sifre Advanced Analysis Techniques Introduction to Azure Machine Learning
08:30:00 Steve Jones Professional Development Branding Yourself for a Dream Job
08:30:00 Rick Lowe Application Database Development Weird Stuff I Saw While ... Working With Heaps
09:45:00 William E Pearson III BI Platform Architecture, Development Administration Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI
09:45:00 Tracy Boggiano Strategy and Architecture Disaster Recovery Where to Begin
09:45:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization
09:45:00 Trayce Jordan Enterprise Database Administration Deployment Finding root cause for unexplained Availability Group failover
09:45:00 Brian Hansen Enterprise Database Administration Deployment Visualize Your Transaction Log
09:45:00 Scot Reagin Information Delivery Data Integration: the neglected hero of your information environment
11:00:00 Marcus Hopfinger Enterprise Database Administration Deployment My Top 10 Favorite Replication Tricks
11:00:00 Steve Jones Strategy and Architecture Bringing DevOps to the Database
11:00:00 Christopher Wolff Enterprise Database Administration Deployment Continuous Deployments using SSDT
11:00:00 Reeves Smith Analytics and Visualization Introduction to Data Science with R
11:00:00 Julia Renz Analytics and Visualization Even I Can Power BI!
11:00:00 Gabriel Villa Cloud Application Development Deployment Getting Started with Databases on Amazon Web Services
12:15:00 Craig Allen Enterprise Database Administration Deployment SQL Performance Best Practices
13:30:00 Cher Fox Other Test Automation: Agile Enablement for DW and BI Teams
13:30:00 Tim Gorman Enterprise Database Administration Deployment Accelerating DevOps and TDM Using Data Virtualization
13:30:00 Patrick Geselbracht BI Information Delivery Power BI on Azure Analysis Services
13:30:00 Jeff Renz Application Database Development Introduction To Azure DocumentDB
13:30:00 Paul Nielsen Professional Development So you want to launch a software company
13:30:00 Carlos Bossy BI Platform Architecture, Development Administration Business Intelligence in the Cloud
14:45:00 Steve Wake BI Information Delivery Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting
14:45:00 Adam Koehler Enterprise Database Administration Deployment Isolation Levels – Understanding Transaction Temper Tantrums
14:45:00 David Brown Advanced Analysis Techniques How to Use Analytics (and Data Science) to Get a Promotion
14:45:00 Michelle Haarhues Professional Development On the Doorsteps - Women in Technology
14:45:00 Michelle Poolet Strategy and Architecture Get Into the Goldilocks Zone: Managing SQL Transaction Log VLF Growth
14:45:00 Michael Fal Cloud Application Development Deployment Intro to Azure SQL Databases

SessionID: 54558

Introduction to SQL

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Thane Schaffer

Title: Introduction to SQL

Abstract:

A fast and furious overview of the fundamentals of SQL (Structured Query Language), its history, language fundamentals of the data definition, data manipulation, data control, and transaction control language aspects.

SessionID: 56316

Statistics and New Cardinality Estimator Model

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Susantha Bathige

Title: Statistics and New Cardinality Estimator Model

Abstract:

Statistics in SQL Server plays a major role creating execution plan which essentially decides server performance. If you get a good execution plan the server performance is good otherwise it will impact negatively on the server performance. SQL Server 2014 introduced new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is a major redesign to the Query Optimizer since SQL Server 7.0. In this session, I'm going to talk about how statistics is used to generate the execution plan, how execution plan changes with new CE model with demos.

SessionID: 57133

Up Close and Personal with the Tabular SSAS DMVs

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Meagan Longoria

Title: Up Close and Personal with the Tabular SSAS DMVs

Abstract:

Did you know that we got new Dynamic Management Views (DMVs) for the SQL 2016 SSAS Tabular models that also work with Power BI? They can be used to monitor the health of your database as well as to retrieve useful metadata. In this session, you'll learn how to access and query SSAS DMVs as well as important data points found in the DMVs. Then I'll demonstrate my Tabular Model Documenter based upon the DMVs and explain how I built it. You'll walk away with a tool that automatically documents your tabular model, saving you from tedious manual documentation.

SessionID: 57957

Introduction to Azure Machine Learning

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 59323

Branding Yourself for a Dream Job

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Professional Development

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 61075

Weird Stuff I Saw While ... Working With Heaps

Back to calendar

Event Date: 25-03-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Weird Stuff I Saw While ... Working With Heaps

Abstract:

We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

SessionID: 56384

Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: William E Pearson III

Title: Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Abstract:

For many new Power BI implementations, initial self-service and team objectives are soon met, and the natural evolution of Power BI turns to an organizational focus. In other scenarios, the enterprise seeks to preserve its investments in "classic BI" by integrating Power BI with Analysis Services and the underlying data warehouse.

In this session, Data Platform (SQL Server / BI) MVP and SSAS Maestro Bill Pearson explores the construction of organizational BI solutions, wedding the "traditional" solutions with the reporting and analysis power of Power BI. We'll focus upon the components of a "traditional" solution, up to the semantic model (with SQL Server Analysis Services as an example), and then explore paths to the implementation of an end-to-end enterprise solution that uses Power BI as the presentation layer. This session applies, in most respects, to Analysis Services 2012 and above.

SessionID: 56503

Disaster Recovery Where to Begin

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: Tracy Boggiano

Title: Disaster Recovery Where to Begin

Abstract:

So you have a good backup strategy in place, but now you have to think about a disaster recovery. Where do you start and what are your options? SQL Server offers several options, but then how do you choose the right one to meet your business requirements? In this session, we will go over some of the common DR options including log shipping, replication, mirroring, clustering, and AlwaysOn. Then we will talk about how to choose the best one to meet your business needs.

SessionID: 56566

The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization

Abstract:

Cloud is everywhere and the database administrator is caught in the middle. How do you know where to start and what to migrate first? How do you perform consolidation planning and ensure data security? This session builds on a full demonstration, along with tips and tricks to show how the DBA can secure their environment to allow a self-service option so they no longer are the constraints to projects! The attendee will leave with a clear understanding of:

SessionID: 56751

Finding root cause for unexplained Availability Group failover

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Trayce Jordan

Title: Finding root cause for unexplained Availability Group failover

Abstract:

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.

SessionID: 59831

Visualize Your Transaction Log

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Visualize Your Transaction Log

Abstract:

SessionID: 61130

Data Integration: the neglected hero of your information environment

Back to calendar

Event Date: 25-03-2017 - Session time: 09:45:00 - Track: Information Delivery

Speaker: Scot Reagin

Title: Data Integration: the neglected hero of your information environment

Abstract:

Every organization struggles to ensure data is up to date and consistent across multiple systems. Often this results in the development of layers of system to system data integrations or repetitive and manual processes intended to support operational and reporting needs.

Enterprise Data Warehouses and Marts are often the only stores that provide single point access to data sourced from multiple systems - but these stores can be expensive and complicated to build and maintain and tend to lag behind business need.

Data Lakes offer the promise of fast inexpensive data acquisition but without specialized tools lack the structure that makes their data accessible and useful to the business.

A managed Data Integration platform can provide both efficient data management across systems and a shared, single point, store of data sourced from all participating systems. A Data Integration platform solution is not technology or tool specific and can provide immediate and continuing value.

SessionID: 54712

My Top 10 Favorite Replication Tricks

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marcus Hopfinger

Title: My Top 10 Favorite Replication Tricks

Abstract:

Replication can be intimidating and a bit confusing. I will show you my ten favorite tricks for working with replication that will show you how you can replicate from multiple sources to multiple destinations, chose the appropriate method of replication and, if desired, put the data in a different schema with a different collation at the destination than it was at the source. I will also cover various methods of managing your publications, agent properties and distribution schedules. This presentation assumes a basic knowledge of configuring distribution and creating a basic publication and subscription.

SessionID: 59322

Bringing DevOps to the Database

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Steve Jones

Title: Bringing DevOps to the Database

Abstract:

DevOps is a hot topic in today's software development world. However most of the knowledge and experience with DevOps is based around application software and ignores the database. We will examine how the concepts and principles of DevOps can be applied to database development by looking at both automated comparison analysis as well as migration script management. Automated building, testing, and deployment of database changes will be shown.

SessionID: 59710

Continuous Deployments using SSDT

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Christopher Wolff

Title: Continuous Deployments using SSDT

Abstract:

Many of us feel pressure to deploy changes to our database more often and more reliably. SSDT gives us a number of options to set up continuous integration and eventually, continuous deployment. Learn how to create and customize DACPACs, Published Profiles, and SQLPackage.exe to automate your deployment process. Whether you want to update QA or smoothly get changes to production, this session will give you the tips and tricks you need to get started.

SessionID: 60965

Introduction to Data Science with R

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Reeves Smith

Title: Introduction to Data Science with R

Abstract:

Data Science is the gaining popularity but what does it really mean?

Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.

SessionID: 61051

Even I Can Power BI!

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Julia Renz

Title: Even I Can Power BI!

Abstract:

Power BI Desktop is so intuitive when it comes to creating reports that even a 13 year old can do it. In fact I'm 13 and I can do it! Don't believe me? Come to my session as I demonstrate how to import data, create dashboards, and publish them to the Power BI service.

SessionID: 61108

Getting Started with Databases on Amazon Web Services

Back to calendar

Event Date: 25-03-2017 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Gabriel Villa

Title: Getting Started with Databases on Amazon Web Services

Abstract:

Are you looking to understand what IaaS or PaaS really mean? Perhaps you are not sure of virtual, high available relational or NoSQL databases. Get started with the basics of managed services and platforms for running databases on AWS. Hear how to use managed relational databases such as MS SQL Server with minimal administration. Also discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.

SessionID: 63692

SQL Performance Best Practices

Back to calendar

Event Date: 25-03-2017 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Craig Allen

Title: SQL Performance Best Practices

Abstract:

Learn tip and tricks for configuring SQL Server for maximum performance, including: metrics, configurations, disk layout, virtualization considerations, and infrastructure.

SessionID: 54601

Test Automation: Agile Enablement for DW and BI Teams

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Other

Speaker: Cher Fox

Title: Test Automation: Agile Enablement for DW and BI Teams

Abstract:

SessionID: 56842

Accelerating DevOps and TDM Using Data Virtualization

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Accelerating DevOps and TDM Using Data Virtualization

Abstract:

DevOps is the merger of app development, testing, and IT ops. All tasks from coding to testing to operations must be automated so that new features and fixes can be continuously delivered.

Test Data Management (TDM) is the optimization of the process of software quality, ensuring that applications properly work according to their specifications.

Constraining both DevOps and TDM is data, which has grown enormous and complex. "Storage is cheap" is not merely a lie, but beside the point. It takes a lot of time to push terabytes around from place to place, and time is expensive.

Provisioning a full environment for each developer or tester on each task of each project seems unrealistic, when each might require terabytes of storage. So, everyone is limited to working in a small shared dev/test environments that are refreshed only every few months, and code quality suffers, and the pace of delivery fails to live up to requirements.

Data virtualization is the solution. Come learn.

SessionID: 57553

Power BI on Azure Analysis Services

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Patrick Geselbracht

Title: Power BI on Azure Analysis Services

Abstract:

The level of effort to integrate a tabular SQL Server Analysis Services (SSAS) cube with Power BI became significantly easier with the release of Azure Analysis Services. Setup, configuration and maintenance of an On Premise gateway for direct query and scheduled data refreshes is no longer required. Leveraging the default Azure Analysis Services integration with Power BI, developers can focus on modeling cubes and creating beautiful dashboards and reports. In this session, we will explore the setup of an Azure Analysis Services as compared to the use of as an On Premise Analysis Services data source for Power BI.

We will discuss modeling security patterns in Analysis Services in conjunction with Power BI. We will also demonstrate a direct query connection of On Premise and Azure Analysis Services cubes to Power BI. Additionally, we will highlight leveraging Power BI functionality including reports, dashboards, and QA of an Analysis Services data set.

SessionID: 61049

Introduction To Azure DocumentDB

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Jeff Renz

Title: Introduction To Azure DocumentDB

Abstract:

Developers are interested in consuming and processing very large amounts of data as quickly as possible. Microsoft Azure DocumentDB is a NoSQL document database service designed for modern mobile and web applications which require fast reads and writes of unstructured data feeds. Azure DocumentDB natively supports JSON documents which is a key performance feature.

In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript. Finally, I will compare performance and feature difference between SQL Server 2016 and Azure DocumentDB.

SessionID: 61117

So you want to launch a software company

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: Professional Development

Speaker: Paul Nielsen

Title: So you want to launch a software company

Abstract:

You love working with people and you love delivering solutions, and you want to be your own boss. You think you have a great idea and you're ready to jump. The startup space is a completely different world. MVP means Minimum Viable Product. I took that plunge and converted my SQL MPV to a startup MVP. In this lesson I'll pass on as much as possible about launching a software startup - beginning with the Business Model Canvass. (note: I'm also the chair of Colorado Springs Startup Week and on the board of Peak Startup)

SessionID: 61473

Business Intelligence in the Cloud

Back to calendar

Event Date: 25-03-2017 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Carlos Bossy

Title: Business Intelligence in the Cloud

Abstract:

Is it time to move some of your Business Intelligence framework to the cloud? With so many cloud-enabled tools and platforms available today, including Azure Data Warehouse, Azure Analysis Services, Azure Data Lake, PowerBI, and many more, it has become a choice to consider for data architects. In addition to live demonstrations, Carlos will discuss data architectures and strategies that would benefit by using these new technologies. Come see some of these new features in action, allowing you to determine if it’s right for you and your architecture.

SessionID: 54542

Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting

Abstract:

SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile (previously DataZen reports), Paginated (SSRS RDL reports), KPIs (new standalone Key Performance Indicators), and Power BI (now Power BI can be managed in SSRS for an on-premises solution). All of these report types can now be managed in SSRS for a single reporting solution.

We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!

SessionID: 54567

Isolation Levels – Understanding Transaction Temper Tantrums

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Koehler

Title: Isolation Levels – Understanding Transaction Temper Tantrums

Abstract:

In this session we will review Isolation levels and how they affect applications that run on SQL Server. We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole. We will also explore different ways to relieve these tantrums, and make your applications play nice together.

SessionID: 56297

How to Use Analytics (and Data Science) to Get a Promotion

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Advanced Analysis Techniques

Speaker: David Brown

Title: How to Use Analytics (and Data Science) to Get a Promotion

Abstract:

Who has difficulty communicating the value of databases across their organization? Who wants to make more of a difference using database systems? Who is dissatisfied with their job and feels under-appreciated?

Welcome to my world. I've worked for years as a consultant, and I started in this situation, but I began making a living helping folks crawl their way out. Along the way, I got my Microsoft MVP, and I've helped many organizations make millions of more dollars through my consulting efforts. I'd like to help you, too.

SessionID: 56728

On the Doorsteps - Women in Technology

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Professional Development

Speaker: Michelle Haarhues

Title: On the Doorsteps - Women in Technology

Abstract:

Women make up over half of the workforce, and yet there are still discrepancies in pay and in the number of women in certain industries. Technology is one of the industries where women are drastically underrepresented. What factors in industry and society have contributed to these outcomes?

In this session, we will discuss the effects of trends in industry such as college graduation of women in technology fields, and women currently in tech or in positions of leadership. And, even important to us, how the contributions of women in PASS affect our community. This will be an open discussion with input from the audience encouraged.

SessionID: 59808

Get Into the Goldilocks Zone: Managing SQL Transaction Log VLF Growth

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Strategy and Architecture

Speaker: Michelle Poolet

Title: Get Into the Goldilocks Zone: Managing SQL Transaction Log VLF Growth

Abstract:

Are your transaction logs ballooning? Are the VLF numbers out of control? What can you do about it?

Let's start with "what's a VLF and why do I care?" and move forward into learning how to shrink VLFs (a temporary solution) and how to resize SQL Server transaction log files (a more permanent solution) for greater server stability, better performance during server startup, backups, and restores, and to minimize storage space requirements.

The SQL Server transaction log is a critical piece of SQL Server's ability to ensure that data is maintained exactly as the user input or modified the data. The transaction log must, at times, grow in size in order to do its job. When a transaction log’s growth gets out of control (too large, too many segments), then SQL Server’s ability to perform as it should is negatively impacted. Too-large transaction log files cause longer database start up, backup and restore times, and will require more storage space on disk. Learn how to control VLF gro

SessionID: 59810

Intro to Azure SQL Databases

Back to calendar

Event Date: 25-03-2017 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Michael Fal

Title: Intro to Azure SQL Databases

Abstract:

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.