sqlsathistory

Nr: 593

Back to Main list

SQLSaturday #593 - Birmingham 2017

Start Time (24h) Speaker Track Title
08:30:00 Ed Watson BI Platform Architecture, Development Administration Introduction to SQL Server Integration Services
08:30:00 Robert Bishop Enterprise Database Administration Deployment Hostile Takeover
08:30:00 Robert Verell Application Database Development Vote or Die: Which is Faster?
08:30:00 Doug McClurg BI Platform Architecture, Development Administration Operationalizing Digital and Enterprise Data in Hybrid Azure
08:30:00 Jeff Foushee Application Database Development Transforming Data using the T-SQL PIVOT / UNPIVOT operators
08:30:00 Christopher Sims .NET and Web Programming I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search
09:40:00 Louis Davidson Application Database Development Let Me Finish... Isolating Write Operations
09:40:00 Jamey Johnston Analytics and Visualization Code Like a Pirate ... Intro to R and Data Science Tools in MS
09:40:00 Damu Venkatesan BI Information Delivery Self-Service ETL with Microsoft Power Query
09:40:00 Mike Robbins PowerShell PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell
09:40:00 William Wolf Application Database Development Blue Collar SQL Tricks - Make Standard Edition Work for you.
09:40:00 Eric Cobb Enterprise Database Administration Deployment How To Be The DBA When You Don't Have A DBA
10:50:00 Julie Smith BI Platform Architecture, Development Administration Power BI in the Wild
10:50:00 William Assaf Enterprise Database Administration Deployment SQL Admin Best Practices with DMVs
10:50:00 Janis Griffin Enterprise Database Administration Deployment Welcome To the 2016 Query Store!
10:50:00 Daniel Glenn BI Platform Architecture, Development Administration Power BI SharePoint - A Marriage Made in Redmond
10:50:00 Stuart Ainsworth Strategy and Architecture The Future of the DBA: DevOps, the Cloud Paradigm, and the Micros
10:50:00 Kevin Boles Enterprise Database Administration Deployment Rapid On-Demand Creation of Dev/Test Databases with SQL Clone
13:00:00 Karlyn LeBlanc Professional Development Whip Away Stress at Home Work to Create a Better You
13:00:00 William E Pearson III BI Platform Architecture, Development Administration Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI
13:00:00 Teo Lachev BI Platform Architecture, Development Administration Embed Interactive Reports in Your Apps
13:00:00 Jeff Reinhard Enterprise Database Administration Deployment Table Partitioning Intro and make that a sliding window too!
13:00:00 Paul Ferrill Analytics and Visualization Getting Started with SQL Server R Services
13:00:00 Mike Robbins PowerShell PowerShell Non-Monolithic Script Module Design
14:10:00 Patrick LeBlanc BI Information Delivery Introduction to the Power BI Desktop
14:10:00 Kevin Wilkie BI Platform Architecture, Development Administration Learning R And Talking About Football
14:10:00 Rob Volk Application Database Development Tame Your Unruly Data With Constraints
14:10:00 Samir Behara Application Database Development 25 SSMS Tips and Tricks to boost your Productivity
14:10:00 Mike Lawell Application Database Development Execution Plans for Mere Mortals
14:10:00 Sven Aelterman Cloud Application Development Deployment Azure SQL Database: 12 Things To Know
15:20:00 Matthew Bowers Professional Development SQL and BI Business Value
15:20:00 William Assaf Enterprise Database Administration Deployment SQL + SharePoint: Best Friends Forever
15:20:00 Louis Davidson Professional Development Discuss Your Career (Panel)
15:20:00 Robb Schiefer Strategy and Architecture TDD with Chef, DSC and Pester
15:20:00 Tim Radney Enterprise Database Administration Deployment Azure SQL Database for the Production DBA
15:20:00 William Wolf Application Database Development Stop Doing That! 5 Common T-SQL Anti-Patterns

SessionID: 56259

Introduction to SQL Server Integration Services

Back to calendar

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

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 56557

Hostile Takeover

Back to calendar

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

Speaker: Robert Bishop

Title: Hostile Takeover

Abstract:

In the spirit of Tim Ford's year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the "health" of the server.

SessionID: 57332

Vote or Die: Which is Faster?

Back to calendar

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

Speaker: Robert Verell

Title: Vote or Die: Which is Faster?

Abstract:

Ever wondered what's faster between a bulk insert and BCP? What about index seek vs index scan? This session will review multiple topics of SQL Server that include development, ETL, and administration. In the spirit of our recent election, this session will feature having the ability to debate and vote on which of each technology you think we will be best, and if your "candidate" wins, your votes will be entered into a drawing; so the more votes you win the more chances you get!

SessionID: 59586

Operationalizing Digital and Enterprise Data in Hybrid Azure

Back to calendar

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

Speaker: Doug McClurg

Title: Operationalizing Digital and Enterprise Data in Hybrid Azure

Abstract:

Many companies match, merge, and enrich their customer data on premises in the enterprise, but their most valuable marketing systems operate and leverage customer data off premises in the digital realm. Moreover, digital data tends to manifest itself in an semi-structured (clickstream) and unstructured (images) format while enterprise data still tends to be structured. How do you combine customer behavior and attributes to drive marketing in a world such as this? Because this is only a 60 minute session, I am going to layout and demo an architecture as well as discuss production implications in terms of IT and the Business.

SessionID: 59773

Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Back to calendar

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

Speaker: Jeff Foushee

Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Abstract:

Ever wish your horizontal data were vertical for easier data storage, as well as vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating "OUTER JOIN" or "UNION” so often that you wind up back in Kansas when you read them aloud? Join Jeff Foushee as he explains SQL Server's lesser-known PIVOT and UNPIVOT operators using SQL 2016. After this session, you will no longer need to rotate your monitor!

SessionID: 61047

I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Back to calendar

Event Date: 18-03-2017 - Session time: 08:30:00 - Track: .NET and Web Programming

Speaker: Christopher Sims

Title: I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Abstract:

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.

SessionID: 56471

Let Me Finish... Isolating Write Operations

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Let Me Finish... Isolating Write Operations

Abstract:

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

SessionID: 59768

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Analytics and Visualization

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

Come to this session to get an introduction to the R language including:

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 61281

Self-Service ETL with Microsoft Power Query

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: BI Information Delivery

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query

Abstract:

In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel PowerBI. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".

SessionID: 61460

PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell 101: The No-Nonsense Beginner’s Guide to PowerShell

Abstract:

Interested in PowerShell but not sure how to get started? Already have some experience but still having trouble with the basic concepts? This session is for you! Learn to easily figure out what the commands are and how to use those commands without searching the Internet. Extend PowerShell’s functionality to manage products like SQL Server. During this presentation, Microsoft MVP Mike F Robbins will demonstrate several of the core PowerShell cmdlets along with writing one-liners and basics scripts. We’ll discuss how to prevent resume generating events when making changes with PowerShell. Learn what objects, properties, and methods are along with how they’re used in PowerShell. Not a developer? PowerShell is one of those technologies that you can be extremely effective with whether you’re a developer or an IT Pro.

SessionID: 61487

Blue Collar SQL Tricks - Make Standard Edition Work for you.

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Application Database Development

Speaker: William Wolf

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Abstract:

You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!

SessionID: 61494

How To Be The DBA When You Don't Have A DBA

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Cobb

Title: How To Be The DBA When You Don't Have A DBA

Abstract:

Not everyone has a full time Database Administrator on staff, and in many cases the responsibility of managing the database server falls on you, the developers. But as long as the backups are running successfully you're good, right? Not exactly. There is ongoing maintenance required to help ensure that your databases are running smoothly. Are your statistics out of date? Are your indexes fragmented? When was the last time the databases were checked for corruption? Has your SQL Server been tuned to fit your workload, or are you still running with the less optimal default settings?

Tailored to the "Non-DBA", this session will cover these topics and more to ensure that you can avoid some performance issues you may not even realize you're having. Discussing server settings, database configurations, and recommended maintenance, you will leave this session with the knowledge (and scripts!) you need to help ensure that your SQL Server and databases are in top shape.

SessionID: 56283

Power BI in the Wild

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Julie Smith

Title: Power BI in the Wild

Abstract:

Power BI is constantly evolving; this session is an overview of the current abilities and ways to implement Power BI, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Pricing models, and intro to SSRS 2016 Preview with Power BI.

SessionID: 56585

SQL Admin Best Practices with DMVs

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: William Assaf

Title: SQL Admin Best Practices with DMVs

Abstract:

In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.

SessionID: 57097

Welcome To the 2016 Query Store!

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Welcome To the 2016 Query Store!

Abstract:

One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type information it holds and how you can use it to analyze performance issues. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 57593

Power BI SharePoint - A Marriage Made in Redmond

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Daniel Glenn

Title: Power BI SharePoint - A Marriage Made in Redmond

Abstract:

We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.

SessionID: 62867

The Future of the DBA: DevOps, the Cloud Paradigm, and the Micros

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Strategy and Architecture

Speaker: Stuart Ainsworth

Title: The Future of the DBA: DevOps, the Cloud Paradigm, and the Micros

Abstract:

We’re on the cusp of exciting times for database development and administration; data storage is set to explode in volume over the next 5 years by as much as 500%. Companies are struggling to manage traditional relational databases and several forms of Big Data, including dark, binary, and streaming data. New theories of development, administration, and data management have matured, but what impact do they have on DBA’s? What are the concepts and skills needed for future career growth?

Come explore how DevOps and the Cloud Paradigm have developed to address modern software delivery challenges. We’ll also examine how the Microsoft Data Platform provides a framework for career paths for SQL Server professionals.

SessionID: 62980

Rapid On-Demand Creation of Dev/Test Databases with SQL Clone

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Boles

Title: Rapid On-Demand Creation of Dev/Test Databases with SQL Clone

Abstract:

Imagine a world where developers and testers could run production-like environments on their own workstations, created on-demand and self-serviced. Raising tickets and waiting hours or days to get operations to deliver test databases would be a thing of the past.

With Redgate's new tool, SQL Clone, this world now exists. Administrators and developers can create their own database copies in SECONDS using just MEGABYTES of disk space without ever touching production. Developers can see how their application behaves in a production-scale environment during both development and troubleshooting and operations no longer needs to be involved to find disk space, provision, etc. You can quickly make a series of "throw-away" copies of a database to run a variety of scenarios against without going through the usual full backup/restore cycle repeatedly.

In this session we will examine how SQL Clone uses disk virtualization to enable quick, easy and even automated creation of database copies

SessionID: 56257

Whip Away Stress at Home Work to Create a Better You

Back to calendar

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

Speaker: Karlyn LeBlanc

Title: Whip Away Stress at Home Work to Create a Better You

Abstract:

If you are a working professional there is a chance that stress has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

SessionID: 56381

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

Back to calendar

Event Date: 18-03-2017 - Session time: 13:00: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: 58177

Embed Interactive Reports in Your Apps

Back to calendar

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

Speaker: Teo Lachev

Title: Embed Interactive Reports in Your Apps

Abstract:

You have the app. You have the data. What if your app could put the power of analytics everywhere decisions are made and allow your customers to gain insights? Modern apps with data visualizations built-in have the power to inform decisions in context—for any user and on any device. Join us to discover how you can embed data analytics in any app and on one device powered by Azure and Power BI Embedded. Learn how to:

SessionID: 60962

Table Partitioning Intro and make that a sliding window too!

Back to calendar

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

Speaker: Jeff Reinhard

Title: Table Partitioning Intro and make that a sliding window too!

Abstract:

I walk-through the entire process of discovering a situation that would benefit from a partitioned table, designing the partition key and scheme, and implementation. Then also creating a sliding window partition, both adding new partitions and rolling out older ones, all on an AdventureWorks table, so that all the scripts can be used by participants later for practicing.

SessionID: 61229

Getting Started with SQL Server R Services

Back to calendar

Event Date: 18-03-2017 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Paul Ferrill

Title: Getting Started with SQL Server R Services

Abstract:

This session will walk through getting started with Microsoft R services including both the in-database and stand alone versions of R Server. We'll use Visual Studio with the R Tools for Visual Studio for demos to include basic command line examples plus how to visualize results.

SessionID: 61459

PowerShell Non-Monolithic Script Module Design

Back to calendar

Event Date: 18-03-2017 - Session time: 13:00:00 - Track: PowerShell

Speaker: Mike Robbins

Title: PowerShell Non-Monolithic Script Module Design

Abstract:

Creating a script module in PowerShell is a very simplistic process, but there are a number of reasons why you might not want to create one huge monolithic PSM1 script module file that contains all of your module’s functions. During this session, Microsoft MVP Mike F Robbins will demonstrate how to separate each of your module’s functions into its own dedicated PS1 file that’s dot-sourced from your script module’s PSM1 file along with discussing this design methodology and the challenges that it creates. Many times resolving one problem seems to create more problems such as cmdlets from other modules showing up as being exported by your module. The solution to these problems and more will be provided during this session. Mike will also demonstrate using a Pester test to validate that all of the functions are indeed exported along with using a function to help automate the module manifest update process when additional functions are added to your module.

SessionID: 56901

Introduction to the Power BI Desktop

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: BI Information Delivery

Speaker: Patrick LeBlanc

Title: Introduction to the Power BI Desktop

Abstract:

Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.

SessionID: 57160

Learning R And Talking About Football

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Wilkie

Title: Learning R And Talking About Football

Abstract:

R -- it's included in SQL Server 2016. What can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who is the best qb in the league right now, statistically?

We'll go over the basics of R and how to do things with it, plus items such as:

SessionID: 59369

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

SessionID: 59899

25 SSMS Tips and Tricks to boost your Productivity

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Samir Behara

Title: 25 SSMS Tips and Tricks to boost your Productivity

Abstract:

Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.

By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.

SessionID: 59925

Execution Plans for Mere Mortals

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 61000

Azure SQL Database: 12 Things To Know

Back to calendar

Event Date: 18-03-2017 - Session time: 14:10:00 - Track: Cloud Application Development Deployment

Speaker: Sven Aelterman

Title: Azure SQL Database: 12 Things To Know

Abstract:

Up and running with Azure SQL Database already? This session will provide a grab bag of 12 how-to items you'll need to know to successfully keep your database running. Among those, we'll cover PowerShell for Azure SQL DB, geo-replica and other disaster recovery features and monitoring. As Azure SQL DB rapidly gains capabilities, rest assured that this session covers the latest!

SessionID: 56421

SQL and BI Business Value

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Professional Development

Speaker: Matthew Bowers

Title: SQL and BI Business Value

Abstract:

Determining business value for SQL and BI in the enterprise. Establishing a business case, purpose of a business case, business case components, SQL and BI Value, value in the Cloud.

Have you been challenged determining value? Identifying the basic problem? Communicating the business benefit? This session is a great business introduction to these concepts! Helping IT leaders bridge the gap between IT and business!

Participants will learn about the basics of determining business value for a solution.

SessionID: 56589

SQL + SharePoint: Best Friends Forever

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Enterprise Database Administration Deployment

Speaker: William Assaf

Title: SQL + SharePoint: Best Friends Forever

Abstract:

Learn from two subject matter experts about best practices to make your SQL Server and SharePoint servers play nice together forever. It will be a 50/50 split of best practices for administering SharePoint farms and their underlying SQL Servers. With a special section on AlwaysOn Availability Groups! William Assaf is a SQL Server MCSE and Kevin Grohoske is a SharePoint SME, both are Principal Consultants in their fields at Sparkhound.

SessionID: 56736

Discuss Your Career (Panel)

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Professional Development

Speaker: Louis Davidson

Title: Discuss Your Career (Panel)

Abstract:

As a database professional, you have plenty of choice in your career path. Should you stay at the same company for 20 years, or change every few years? Much depends on what matters most to you. Do you want higher income, regular work hours, training, vacation time, group insurance, job security, lots of travel, telecommuting, or the possibility to advance to management? The panel will give their observations and experience over decades of experience. Discussion will include at least one person who has spent over 19 years with the same employer, one person who has changed careers very recently, and everyone in attendance who is willing to give an opinion.

SessionID: 59827

TDD with Chef, DSC and Pester

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Strategy and Architecture

Speaker: Robb Schiefer

Title: TDD with Chef, DSC and Pester

Abstract:

Configuration management is currently all the rage in the DevOps space right now but few are investing in the quality of their configuration code like they do with application code. Yet, all the same benefits apply resulting in a faster feedback loop and ultimately cost/time savings.

In this session we will cover how to develop Chef cookbooks (with DSC resources) by writing rspec/Pester tests first. We will review how the red-green-red-green process ensures we have valid and useful tests. For good measure we will also show how mocking works to help isolate your tests. In addition to simple "hello world" demos we will also demo the real-world Chef cookbooks we wrote for our custom order processing system.

Chef, Kitchen, rspec, PowerShell, DSC and Pester make for a power combination when used together to write tests which drive the development of your configuration code. Come hear how we use this stack of tools to write our configuration code at EBSCO with high quality.

SessionID: 61070

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 61490

Stop Doing That! 5 Common T-SQL Anti-Patterns

Back to calendar

Event Date: 18-03-2017 - Session time: 15:20:00 - Track: Application Database Development

Speaker: William Wolf

Title: Stop Doing That! 5 Common T-SQL Anti-Patterns

Abstract:

There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!

This site is open source. Improve this page.