sqlsathistory

Nr: 673

Back to Main list

SQLSaturday #673 - Denver 2017

Start Time (24h) Speaker Track Title
08:30:00 Angela Henry BI Platform Architecture, Development Administration Intro to Integration Services (SSIS)
08:30:00 Chase Aucoin Enterprise Database Administration Deployment MySql using Containers and Windows Server 2016 for Active-Active deployments
08:30:00 Glenn Berry Enterprise Database Administration Deployment Analyzing I/O Subsystem Performance
08:30:00 Yuliya Quintela BI Platform Architecture, Development Administration Biml 101: Automation and Patterns
08:30:00 Carlos Bossy BI Platform Architecture, Development Administration Operationalizing Data Science
08:30:00 Patrick LeBlanc Professional Development How to Build your Brand and Become a Thought Leader
08:30:00 Rick Lowe Application Database Development Why Should I Care About ... Partitioned Views?
10:00:00 Tim Gorman Enterprise Database Administration Deployment Accelerating DevOps and TDM Using Data Virtualization
10:00:00 Vern Rabe Application Database Development Proper DataType Usage=Guaranteed Better Performance and Accuracy
10:00:00 Rushabh Mehta BI Information Delivery Power Query Tips and Tricks for Power BI
10:00:00 Eric Peterson Application Database Development SQL vs noSQL
10:00:00 Mindy Curnutt Professional Development Impostor Syndrome: Are You Faking It Will they Find Out?
10:00:00 Bill Fellows Application Database Development Metadata driven development
10:00:00 Gabriel Villa BI Platform Architecture, Development Administration Two Guys and a Transformation: ETL Best Practices and Techniques
10:00:00 Denver SQL Server User Group Other Sponsor Spotlight: Dell EMC - The Path to #GetModern
12:45:00 Christopher Wolff Cloud Application Development Deployment Amazon Web Services RDS with SQL Server
12:45:00 Scot Reagin BI Platform Architecture, Development Administration Agile Data Modeling with Data Vault
12:45:00 Kathi Kellenberger Enterprise Database Administration Deployment Kerberos Delegation Made Simple
12:45:00 Lynn Winterboer BI Information Delivery Behavior-Driven Design and Test Automation: Agile Enablement for DW and BI Teams
12:45:00 Glenn Berry Enterprise Database Administration Deployment Dr. DMV's Troubleshooting Toolkit
12:45:00 Levi Syck Cloud Application Development Deployment Stop Repeating Yourself – Automating Azure Data Movement With BimlScript
12:45:00 Michael Wall Professional Development Becoming a Master by Giving it All Away
12:45:00 Julia Renz BI Platform Architecture, Development Administration Even I Can Power BI!
14:15:00 Wendy Pastrick Application Database Development Why NULL is not a value (and other SQL gotchas)
14:15:00 Michael Fal Enterprise Database Administration Deployment Exploring the new SqlServer PowerShell module
14:15:00 TJay Belt Enterprise Database Administration Deployment PowerBI, from a DBA
14:15:00 Reeves Smith BI Information Delivery The New Revolution in Data Science, R integrated into SQL Server
14:15:00 Keith Tate Enterprise Database Administration Deployment Profiler is Dead! Long Live Extended Events!
14:15:00 Leslie Weed BI Platform Architecture, Development Administration Source Control and Database Projects - Just Do It
14:15:00 Jimmy May Enterprise Database Administration Deployment SQL Server 2016 Always On AGs Perf, Internals, Lessons Learned
15:45:00 Kellyn Pot'Vin-Gorman Cloud Application Development Deployment The Next Frontier- Opportunities When Migrating to the Cloud with Virtualization
15:45:00 Patrick LeBlanc BI Platform Architecture, Development Administration Introduction to Azure Analysis Services
15:45:00 Steve Wake BI Platform Architecture, Development Administration Make Power BI Your Own with the Power BI APIs
15:45:00 Rob Volk Application Database Development Tame Your Unruly Data With Constraints
15:45:00 Cathrine Wilhelmsen BI Platform Architecture, Development Administration Level Up Your Biml: Best Practices and Coding Techniques
15:45:00 Todd Kleinhans Strategy and Architecture The Life Cycle of a Query in Virtual Reality
15:45:00 Eddie Wuerch Enterprise Database Administration Deployment Never Lose Data! Digging Out From Corruption

SessionID: 65474

Intro to Integration Services (SSIS)

Back to calendar

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

Speaker: Angela Henry

Title: Intro to Integration Services (SSIS)

Abstract:

This session is a very basic introduction to Integration Services (SSIS). We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time. We’ll talk about packages, connections and project parameters and their respective tasks/properties. We’ll also cover some basic performance tuning to make your packages run faster.

SessionID: 66303

MySql using Containers and Windows Server 2016 for Active-Active deployments

Back to calendar

Event Date: 16-09-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chase Aucoin

Title: MySql using Containers and Windows Server 2016 for Active-Active deployments

Abstract:

Standing up a highly scalable data infrastructure can be a very time-consuming task especially in larger enterprises with multiple teams and data needs across multiple teams. In this session, we will see how to leverage containers and storage spaces in Windows Server 2016 to create highly reliable, highly scalable database deployments in just a few minutes.

You will be able to leave this session with some great thoughts on how to leverage containers for infrastructure and state management within your organization and have the knowledge to hit the ground running.

SessionID: 67990

Analyzing I/O Subsystem Performance

Back to calendar

Event Date: 16-09-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Berry

Title: Analyzing I/O Subsystem Performance

Abstract:

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

SessionID: 68061

Biml 101: Automation and Patterns

Back to calendar

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

Speaker: Yuliya Quintela

Title: Biml 101: Automation and Patterns

Abstract:

Biml (Business Intelligence Markup Language) is a programming language for creating business intelligence objects. It is a simple XML that can be extended with small nuggets of C# or VB code to automatically generate SQL scripts, SSIS packages and SSAS cubes. It will allow you to turn tedious repetitive tasks into reusable scripts - no more drag-and-dropping! Using Biml will significantly cut down development time, reduce errors and improve quality of your code. In this session, you'll find out everything you need to know to start with Biml development. Our focus will be on SSIS solutions.

SessionID: 68121

Operationalizing Data Science

Back to calendar

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

Speaker: Carlos Bossy

Title: Operationalizing Data Science

Abstract:

The challenge of developing a predictive model is the secret sauce that data science practitioners strive to achieve. While sophisticated predictive models can be game changers that give you a competitive edge, they must be nurtured and closely watched to ensure they perform as expected. This session shows attendees how to build a framework and develop a data model that handles prediction logging, prediction performance management, and analysis. A case study will show predictions can degrade and ultimately fail, further emphasizing the importance of tracking their performance.

SessionID: 69124

How to Build your Brand and Become a Thought Leader

Back to calendar

Event Date: 16-09-2017 - Session time: 08:30:00 - Track: Professional Development

Speaker: Patrick LeBlanc

Title: How to Build your Brand and Become a Thought Leader

Abstract:

Your personal brand is how you distinguish yourself from other people but how you develop and nurture your brand can be the difference between stagnation and opportunity in your career. We'll discuss your branding, the importance of taking control of your brand, and how to begin developing your personal brand. By the end of this session, you'll have a better idea of how to begin building your personal brand into something that can take your career to the next level.

SessionID: 69510

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 16-09-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Why Should I Care About ... Partitioned Views?

Abstract:

Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you wish you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and possibly even after 2016 SP1.

SessionID: 65497

Accelerating DevOps and TDM Using Data Virtualization

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00: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 should be automated so new features and fixes can be continuously quickly.

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 database size. "Storage is cheap" is not merely a lie, but more to the point it takes a lot of time to push terabytes around from place to place, and time itself is expensive and dear.

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.

SessionID: 65643

Proper DataType Usage=Guaranteed Better Performance and Accuracy

Back to calendar

Event Date: 16-09-2017 - Session time: 10: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: 66237

Power Query Tips and Tricks for Power BI

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Rushabh Mehta

Title: Power Query Tips and Tricks for Power BI

Abstract:

In this session, we will first learn how to expose organizational data using the data management gateway to Power BI. We will then look at how to use Power Query to acquire and cleanse data from organizational and external sources. As part of the session, we will also look at some tips and tricks to facilitate data acquisition and cleansing.

SessionID: 66371

SQL vs noSQL

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Eric Peterson

Title: SQL vs noSQL

Abstract:

A SQL perspective on noSql document databases.

What’s the difference between a SQL database and a document db? Why would you choose one over the other? What does the implementation look like? Are noSql databases taking over the world?

SessionID: 66575

Impostor Syndrome: Are You Faking It Will they Find Out?

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Professional Development

Speaker: Mindy Curnutt

Title: Impostor Syndrome: Are You Faking It Will they Find Out?

Abstract:

Have you ever thought to yourself “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

SessionID: 68035

Metadata driven development

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Bill Fellows

Title: Metadata driven development

Abstract:

The longer I've been coding, the less time I want to spend coding - at least, the boring, repetitious bits. In this talk, I'll share the approaches I've used to systematically generate SQL artifacts based on metadata and templates.

The approach is basic: Get data. Process through some templating engine. Collect output.

The specifics scenarios we'll cover

SessionID: 68127

Two Guys and a Transformation: ETL Best Practices and Techniques

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Gabriel Villa

Title: Two Guys and a Transformation: ETL Best Practices and Techniques

Abstract:

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gian helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.

SessionID: 69430

Sponsor Spotlight: Dell EMC - The Path to #GetModern

Back to calendar

Event Date: 16-09-2017 - Session time: 10:00:00 - Track: Other

Speaker: Denver SQL Server User Group

Title: Sponsor Spotlight: Dell EMC - The Path to #GetModern

Abstract:

To succeed in this new digital world, companies will require an IT Transformation. Dell EMC has announced a wave of innovations to help customers on their path towards a modern infrastructure and business agility.

Join us to learn how to innovate faster, create competitive advantage, improve IT operations, reduce costs and ultimately #GetModern.

Session presented by Bryan Walsh, Product Marketing Manager, Dell EMC

SessionID: 65502

Amazon Web Services RDS with SQL Server

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Cloud Application Development Deployment

Speaker: Christopher Wolff

Title: Amazon Web Services RDS with SQL Server

Abstract:

Are you wanting to make more SQL Servers but don't want to invest in more hardware? Then Relational Database Service (RDS) in Amazon Web Services (AWS) maybe the right choice for you. We will begin with creating a server using the Amazon Web Console, explore how to automate installation through Cloud Formation, show how to administrate the service, and walk through advanced features. Whether you are familiar with AWS or are brand new to it, this presentation should at least give you a good overview to decide if RDS is the right service for you.

SessionID: 66061

Agile Data Modeling with Data Vault

Back to calendar

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

Speaker: Scot Reagin

Title: Agile Data Modeling with Data Vault

Abstract:

Agility and Business Intelligence are two good things that often struggle to be good together. A primary cause of this struggle is the inability of traditional Data Warehouse models to respond to change in a (business) timely manner. Data Vault is an evolution of Enterprise Data Warehouse modeling that removes the barriers to Data Warehouse agility. A Data Vault warehouse eliminates re-engineering both of the data schema and ETL as the model evolves in response to changing business needs and definitions.

In this session we’ll compare modeling techniques in real world scenarios to understand how Data Vault can make your EDW more capable and agile.

SessionID: 66413

Kerberos Delegation Made Simple

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

Title: Kerberos Delegation Made Simple

Abstract:

Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required.

Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned. Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.

SessionID: 67989

Behavior-Driven Design and Test Automation: Agile Enablement for DW and BI Teams

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: BI Information Delivery

Speaker: Lynn Winterboer

Title: Behavior-Driven Design and Test Automation: Agile Enablement for DW and BI Teams

Abstract:

SessionID: 67991

Dr. DMV's Troubleshooting Toolkit

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Berry

Title: Dr. DMV's Troubleshooting Toolkit

Abstract:

Dynamic Management Views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.

SessionID: 68051

Stop Repeating Yourself – Automating Azure Data Movement With BimlScript

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Cloud Application Development Deployment

Speaker: Levi Syck

Title: Stop Repeating Yourself – Automating Azure Data Movement With BimlScript

Abstract:

Have you begun using Azure Data Factory (ADF) to copy data to and from Azure? Have you realized how fast ADF development becomes tedious and error-prone? Azure Data Factory can make it simple to process your data, but the minimal web UI and JSON configuration files make it easy to make a mistake. Your solution might have hundreds, or thousands, of files after you create datasets and activities for each source query or file. Finished development and need to make a design change? You could be looking at hours of manual updates. But you don’t have to settle for manual ADF development.

In this session I’ll introduce you to BimlScript and the BimlExpress add-in for Visual Studio and I'll demonstrate how to use these tools to automate the creation of ADF datasets and pipelines. I’ll use real-world examples to show you how automation can decrease your development time and encourage iterative development.

SessionID: 68095

Becoming a Master by Giving it All Away

Back to calendar

Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Professional Development

Speaker: Michael Wall

Title: Becoming a Master by Giving it All Away

Abstract:

It has been said that novices absorb knowledge like a sponge, intermediates hoard it for themselves, and masters just simply give it away.

The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? What happens when Bob takes off with one day of notice? How do you manage when Jane unfortunately has to spend a month in the hospital? All joking aside, the only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and current trends in knowledge transfer, the reasons why you should (and shouldn’t) pass on knowledge, and methods for making this happen in your workplace and in your life. Be prepared for an interactive and lively discussion and to walk away with some new concepts that are going to make you think about how you too can become a Master!

SessionID: 68149

Even I Can Power BI!

Back to calendar

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

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: 65478

Why NULL is not a value (and other SQL gotchas)

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Wendy Pastrick

Title: Why NULL is not a value (and other SQL gotchas)

Abstract:

Allowing NULL "values" in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.

SessionID: 67056

Exploring the new SqlServer PowerShell module

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Exploring the new SqlServer PowerShell module

Abstract:

If you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.

SessionID: 67661

PowerBI, from a DBA

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: TJay Belt

Title: PowerBI, from a DBA

Abstract:

Microsoft’s PowerBI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you.

You will be given permissions to an Azure DB, and get connected to this source. You will also need to have PowerBI desktop downloaded and installed. We will be using this to create the report during the session. So please come prepared to interact with the internet, with a cloud-based database you will be provided, and PowerBI Desk

SessionID: 68052

The New Revolution in Data Science, R integrated into SQL Server

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Reeves Smith

Title: The New Revolution in Data Science, R integrated into SQL Server

Abstract:

Data Science is an ever increasing topic in the Data Analytics space and the R language is at the center of most 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.

The R language is run as a desktop application and was not built with performance and scale required to accommodate Big Data. Revolution Analytics, a wholly owned subsidiary of Microsoft, has solved the performance and scaling issues of a desktop application by creating a more robust enterprise architecture. SQL Server 2016 brings the power of R and Revolution Analytics into the industry leading relational database.

This session will introduce R and demonstrate the functionality and power of using R within SQL Server.

This presentation is ideally suited for Business Intelligence professionals that are interested in understanding the new R Service that is being added to SQL Server.

SessionID: 68059

Profiler is Dead! Long Live Extended Events!

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Keith Tate

Title: Profiler is Dead! Long Live Extended Events!

Abstract:

Did you know that Profiler and SQL Trace are deprecated? I know it still works, but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool.

That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events. Profiler was a friend of mine, but it is time to embrace the new king!

SessionID: 68075

Source Control and Database Projects - Just Do It

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Weed

Title: Source Control and Database Projects - Just Do It

Abstract:

If you aren't using database projects you should be and if you aren't using any source control well..... NOW IS THE TIME. We'll review basic functionality and purpose of both and walk through how they work together. Let's talk about the type of foundation pieces you need to pay attention to and how to organize this into team and agile work. Lots of tips and tricks to remove the often experienced headaches that developers have experienced with implementing both of these items.

SessionID: 68204

SQL Server 2016 Always On AGs Perf, Internals, Lessons Learned

Back to calendar

Event Date: 16-09-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jimmy May

Title: SQL Server 2016 Always On AGs Perf, Internals, Lessons Learned

Abstract:

Always On Availability Groups (AGs) were introduced in SQL Server 2012. AGs significantly expanded our HA/DR options. However, in both SQL 2012 and SQL 2014 two limitations were extant in the code—both Network Transport and Log Redo significantly compromised performance. In SQL Server 2016, these limitations have been significantly improved.

Our work shows enhancements of 7x – 10x, allowing over 1/2GB/s (4Gb/s) across the wire. These improvements expand solutions options for Tier 1 OLTP and Data Warehouse workloads, Tier 1 and Tier 2 consolidation, and more. This presentation explains the improvements, characterizes the new solutions, and shows commodity servers and modern non-shared in-server flash storage showing the profound contrast between SQL Server 2014 vs. 2016. Doing so moves the performance bottleneck from the SQL Server codebase to the CPU where it belongs.

  1.   Revealing the fantastic perf enhancements in SQL Server 2016 AGs

  2.   Sharing SQL Server 2016 AGs

SessionID: 65468

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

Back to calendar

Event Date: 16-09-2017 - Session time: 15:45:00 - Track: Cloud Application Development 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: 65727

Introduction to Azure Analysis Services

Back to calendar

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

Speaker: Patrick LeBlanc

Title: Introduction to Azure Analysis Services

Abstract:

You have been wanting to using SQL Server Analysis Services, but just don't have the physical resources on-premises to set one up. Analysis Services has typically shipped with SQL Server on premises, but now it has been implemented as a fully managed service in Azure. Join this session to learn how to create a and deploy a model, load and refresh data using Azure functions, secure the model, view the model and a little about pricing.

SessionID: 66438

Make Power BI Your Own with the Power BI APIs

Back to calendar

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

Speaker: Steve Wake

Title: Make Power BI Your Own with the Power BI APIs

Abstract:

Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.

SessionID: 67994

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 16-09-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 68092

Level Up Your Biml: Best Practices and Coding Techniques

Back to calendar

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

Speaker: Cathrine Wilhelmsen

Title: Level Up Your Biml: Best Practices and Coding Techniques

Abstract:

Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript methods. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Start improving your code today and level up your Biml in no time!

SessionID: 68126

The Life Cycle of a Query in Virtual Reality

Back to calendar

Event Date: 16-09-2017 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in Virtual Reality

Abstract:

How would you like to learn about using Virtual Reality (VR) to present information? The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of data and explore what VR can do that for us that we have not been able to do in the past. VR can provide a way for people to see relationships and interact among data sets which can be difficult for computers to display visually on a flat screen.

The Life Cycle of a Query in Virtual Reality is built using Epic Games video game engine called Unreal Engine 4 (UE4). With native support for VR, UE4 has been used for applications beyond just video games. With the commercial availability of affordable VR headsets, data professionals can now create visually compelling environments that were almost impossible or extremely expensive just a few years ago on both PC and mobile devices.

SessionID: 68142

Never Lose Data! Digging Out From Corruption

Back to calendar

Event Date: 16-09-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddie Wuerch

Title: Never Lose Data! Digging Out From Corruption

Abstract:

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.

This site is open source. Improve this page.