sqlsathistory

Nr: 624

Back to Main list

SQLSaturday #624 - Chattanooga 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Andrew Loree	Enterprise Database Administration Deployment	SQL Server 2017 (Linux and Beyond)
08:30:00	Brian Carrig	Cloud Application Development Deployment	Running SQL Server in AWS
08:30:00	Brian Beswick	BI Platform Architecture, Development Administration	SSAS 2016 Tabular - Diving into the new features
08:30:00	Kevin Hill	Enterprise Database Administration Deployment	SQL Server Security model, in plain English
08:30:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
08:30:00	Rick Lowe	Application Database Development	Why should I care about ... the plan cache?
08:30:00	Paul Southerland	BI Information Delivery	Self Service BI – ETL and More From A Business Unit User’s Perspective
09:45:00	Tim Gorman	Enterprise Database Administration Deployment	Accelerating DevOps and TDM Using Data Virtualization
09:45:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
09:45:00	David Patrick	BI Information Delivery	Microsoft and Big Data - An Overview of the Power Tools and more!
09:45:00	Jeff Foushee	Application Database Development	Transforming Data using the T-SQL PIVOT / UNPIVOT operators
09:45:00	Eric Cobb	Enterprise Database Administration Deployment	How To Be The DBA When You Don't Have A DBA
09:45:00	Daniel Glenn	BI Platform Architecture, Development Administration	Power BI SharePoint - A Marriage Made in Redmond
09:45:00	Mindy Curnutt	Application Database Development	The Ins and Outs of SQL Indexes
09:45:00	Elizabeth Noble	Application Database Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
09:45:00	Shabnam Watson	BI Platform Architecture, Development Administration	Performance Monitoring SQL Server Analysis Services
11:00:00	Samir Behara	Application Database Development	Increase Your Coding Speed in SQL Server Management Studio
11:00:00	Christopher Sims	Application Database Development	I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search
11:00:00	Ed Watson	BI Platform Architecture, Development Administration	Introduction to SQL Server Integration Services
11:00:00	Ryan Wade	Advanced Analysis Techniques	Leveraging SQL Server R Services to Perform Advanced Analytics
11:00:00	Kevin Wilkie	Application Database Development	The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT
11:00:00	Kerry Tyler	BI Platform Architecture, Development Administration	45 Minutes to Your First SSAS Tabular Model
11:00:00	Robert Verell	Enterprise Database Administration Deployment	New Features in SQL Server 2017
13:15:00	Louis Davidson	Application Database Development	Database Design Fundamentals
13:15:00	Teo Lachev	BI Information Delivery	Understanding Power BI Premium
13:15:00	Stacia Varga	BI Platform Architecture, Development Administration	Reduce, Reuse, Recycle: Automating Your BI Framework
13:15:00	Russel Loski	Cloud Application Development Deployment	Querying Semistructured Data in Azure Data Lake with USQL
13:15:00	Mike Robbins	Other	PowerShell Non-Monolithic Script Module Design
13:15:00	Paco Gonzalez	Advanced Analysis Techniques	Enterprise Machine Learning with R and SQL Server 2016 2017
13:15:00	Dan Evans	Advanced Analysis Techniques	Perceptual Intelligence with Cortana Analytics
14:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Monitoring Availability Groups
14:30:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
14:30:00	Thomas Chan	Enterprise Database Administration Deployment	Secure/Encrypt SQL Server Database With TDE
14:30:00	Naomi Williams	Enterprise Database Administration Deployment	SQL Server Internals
14:30:00	Ryan Wade	Analytics and Visualization	R-ternatives in Power BI
14:30:00	Kevin Boles	Other	SQL Server 2016 SP1 ROCKS!!
14:30:00	Matt Martin	Enterprise Database Administration Deployment	5 Ways to Bypass or Ensure Security
14:30:00	Tamera Clark	Enterprise Database Administration Deployment	Reduce your DBA ( DEV) task list by using Microsoft BI tools
15:45:00	Tim Warner	Enterprise Database Administration Deployment	Install and Configure SQL Server with Windows PowerShell Desired State Configuration
15:45:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
15:45:00	Kevin Boles	Enterprise Database Administration Deployment	On-Demand Creation of Dev/Test Databases with SQL Clone
15:45:00	Azhagappan Arunachalam	Application Database Development	Excel with DAX
15:45:00	Richard Weiss	Cloud Application Development Deployment	A Tour of Cloud Data Platforms as a Service
15:45:00	William Wolf	Application Database Development	Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
15:45:00	Simon Kingaby	BI Platform Architecture, Development Administration	Using Biml to Automate the Generation of SSIS Packages

SessionID: 61099

SQL Server 2017 (Linux and Beyond)

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: SQL Server 2017 (Linux and Beyond)

Abstract:

Microsoft has leveled the RDBMS playing field, with SQL Server vNext (aka SQL Server 2017), allowing you to deploy and run SQL Server on a variety of operating systems and container solutions.

In this session, we will look at the background of SQL Server’s move to non-Windows platforms, cover how to install using package deployment on Linux and image-containers with Docker. Focus will cover administration and tools that you can leverage while running SQL Server on non-Windows platforms, including migration and current feature function limitations.

SessionID: 61709

Running SQL Server in AWS

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Brian Carrig

Title: Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.

SessionID: 62869

SSAS 2016 Tabular - Diving into the new features

Back to calendar

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

Speaker: Brian Beswick

Title: SSAS 2016 Tabular - Diving into the new features

Abstract:

Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

SessionID: 63360

SQL Server Security model, in plain English

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Hill

Title: SQL Server Security model, in plain English

Abstract:

What is the difference between a Login and a User? What is a schema? Why can I view one table but not another?

If the security portion of SQL Server is confusing to you, you are not alone. Join me for a short overview of the SQL Server security model, using non-technical terms. We will look at it from the point of view of something we are all familiar with, so that you will remember it 6 months or a year or more down the road.

This will be a highly interactive session, designed for you to be able to absorb the info without having to take notes. Bring coffee and learn!

SessionID: 63987

Crash Course on Better SQL Development

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 64582

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

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Rick Lowe

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

Abstract:

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

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 65051

Self Service BI – ETL and More From A Business Unit User’s Perspective

Back to calendar

Event Date: 24-06-2017 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Paul Southerland

Title: Self Service BI – ETL and More From A Business Unit User’s Perspective

Abstract:

A business user is responsible for implementing a new electric power system modeling application and has to gather data from hundreds of diverse sources to set up the model. Reference data sources included a multitude of different data types, including historical time series, commodity forward pricing curves, and power plant operating characteristics. The user discovers the “power’ in Power Query and is able to meet the implementation deadline due to the Power Query’s rich tool set. The business user continues to find Power Query to be a useful tool in daily tasks as a Power System Resource Planning Specialist. Witness practical examples of Power Query’s Extract, Transform, Load (ETL) functionality applied to getting and reshaping data to perform the analyst’s daily tasks.

SessionID: 59603

Accelerating DevOps and TDM Using Data Virtualization

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45: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: 59653

New Instance, Now what?

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 59690

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 59771

Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45: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: 61495

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

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45: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: 61715

Power BI SharePoint - A Marriage Made in Redmond

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45: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: 63842

The Ins and Outs of SQL Indexes

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: The Ins and Outs of SQL Indexes

Abstract:

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

SessionID: 64500

Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Back to calendar

Event Date: 24-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Abstract:

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.

SessionID: 65086

Performance Monitoring SQL Server Analysis Services

Back to calendar

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

Speaker: Shabnam Watson

Title: Performance Monitoring SQL Server Analysis Services

Abstract:

SQL Server Analysis Services (SSAS) servers need continued maintenance and monitoring post deployment to production; however, many projects forgo this part and the overall system performance can suffer.

Join this session to learn how to monitor and evaluate the performance of your SSAS server. You will learn what to measure and how to determine acceptable ranges of those measurements for your environment. You will see demos of Task Manager, Perfmon and SQL Server Extended Events to get insights into your SSAS server’s health, identify the most common issues in production, and make recommendations for changes to SSAS developers on your team.

If you have experience with SSAS development and are interested in learning about SSAS from the server side, this session is for you. This session focuses on SQL Server Analysis Services in multidimensional mode but many of the concepts apply to tabular mode as well.

SessionID: 59796

Increase Your Coding Speed in SQL Server Management Studio

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Samir Behara

Title: Increase Your Coding Speed in SQL Server Management Studio

Abstract:

Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed?

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

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

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: Application Database Development

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

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00: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: 63667

Leveraging SQL Server R Services to Perform Advanced Analytics

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: Advanced Analysis Techniques

Speaker: Ryan Wade

Title: Leveraging SQL Server R Services to Perform Advanced Analytics

Abstract:

SQL Server 2016 is packed with many great features. One of those features is the integration of R in SQL Server via SQL Server R Services. This integration gives us the ability to perform very sophisticated analytics against data inside the database and data warehoused in big data environments such as Spark Hadoop.

In this session I will demonstrate how to productionize models developed by your data scientist via SQL Server R Services. I will demonstrate how to manage the whole process using an IDE that many of us have grown to love, Visual Studio.

SessionID: 63905

The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Kevin Wilkie

Title: The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT

Abstract:

This session will show in-depth how to use both PIVOT and UNPIVOT. We'll go in depth on why you would use it, how you would use it, why it's set up the way it is, and along the way show you numerous tips and tricks.

SessionID: 64586

45 Minutes to Your First SSAS Tabular Model

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kerry Tyler

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract:

Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you've looked at these and like what they can add in Power BI or classic BI scenarios, but haven't had a chance to dive in and figure all of this out? Now is the time!

SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.

SessionID: 64593

New Features in SQL Server 2017

Back to calendar

Event Date: 24-06-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Verell

Title: New Features in SQL Server 2017

Abstract:

Microsoft has moved to 18 month releases for new versions of SQL Server. With that, we're getting new features sooner! In this session, Robert Verell and Dan Evans will cover the new features of 2017, including Graph Database, Adaptive Query Processing, and the Azure Migration Assistant.

SessionID: 62784

Database Design Fundamentals

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 63796

Understanding Power BI Premium

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Teo Lachev

Title: Understanding Power BI Premium

Abstract:

Microsoft Power BI has enjoyed a lot of attention and success since it became generally available in July 2015. But its licensing model and cloud-hosted limitations barred wide adoption, especially with larger organizations. The recently introduced Power BI Premium will change all of this. Join this session to learn how Power BI Premium will allow your organization to achieve:

• Flexibility to license by capacity • Greater scale and performance • Extending on-premises reporting with Power BI Report Server • Embedded analytics

SessionID: 64272

Reduce, Reuse, Recycle: Automating Your BI Framework

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Reduce, Reuse, Recycle: Automating Your BI Framework

Abstract:

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, and SSIS packages that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.

SessionID: 64360

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Russel Loski

Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract:

Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

SessionID: 64554

PowerShell Non-Monolithic Script Module Design

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: Other

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

Enterprise Machine Learning with R and SQL Server 2016 2017

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: Advanced Analysis Techniques

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server 2016 2017

Abstract:

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

SessionID: 64591

Perceptual Intelligence with Cortana Analytics

Back to calendar

Event Date: 24-06-2017 - Session time: 13:15:00 - Track: Advanced Analysis Techniques

Speaker: Dan Evans

Title: Perceptual Intelligence with Cortana Analytics

Abstract:

Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. Come learn more around how you can take action by going beyond looking in the rear-view mirror to predicting what’s next. Enhance your business applications with machine intelligence to evolve from simple descriptive analytics to prescriptive recommendations. See some of the new ways to infer intent with vision, face, speech, text and sentiment analysis to customize responses and drive appropriate actions in a secure, compliant and scalable way leveraging SQL Server, Azure and Power BI. Expect to leave the discussion understanding new trends in analytics and how you can apply value to your organization.

SessionID: 61330

Monitoring Availability Groups

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Monitoring Availability Groups

Abstract:

So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups. We will discuss what metrics to look at, what they mean, and what you need to alert on. You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts. This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.

SessionID: 61528

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 63259

Secure/Encrypt SQL Server Database With TDE

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Secure/Encrypt SQL Server Database With TDE

Abstract:

TDE, Transparent Database Encryption, is a Microsoft built-in solution to protect sensitive information by encrypting entire SQL Server database. TDE encrypts and decrypts the data on the fly with minimum overhead and no code change at all on the development or application side.

SessionID: 63461

SQL Server Internals

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 63668

R-ternatives in Power BI

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Ryan Wade

Title: R-ternatives in Power BI

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI.

There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, and you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

SessionID: 63699

SQL Server 2016 SP1 ROCKS!!

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Other

Speaker: Kevin Boles

Title: SQL Server 2016 SP1 ROCKS!!

Abstract:

SQL Server 2016 SP1 is probably one of the top 3 announcements for SQL Server ... EVER!! Many previously Enterprise Edition only features were opened up to lower SKUs, including SQL Express! Memory usage scenarios changed DRASTICALLY too! This session will be a medium-to-high-level overview of these absolutely incredible changes. If you are like most entities and NOT on SQL Server Enterprise Edition you WILL want to be there after hearing this talk!

SessionID: 63832

5 Ways to Bypass or Ensure Security

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Martin

Title: 5 Ways to Bypass or Ensure Security

Abstract:

In this class, we will walk through 5 ways you can bypass SQL Server security, but then we will also demonstrate how to close off those loopholes. You will be surprised at some of the tactics presented and might even recognize a past experience based on one of the loopholes presented. Inevitably, even some of the best SQL security professionals will walk out with a face-palm and realize they’ve got a lot of work to do come Monday morning to plug these loopholes.

SessionID: 66145

Reduce your DBA ( DEV) task list by using Microsoft BI tools

Back to calendar

Event Date: 24-06-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tamera Clark

Title: Reduce your DBA ( DEV) task list by using Microsoft BI tools

Abstract:

Are you a DBA or DBA Dev with access to the Microsoft BI Stack? Why not utilize some of these amazing tools to make your life a little easier?

Are you working without fancy monitoring and reporting tools? Do you dream of having time to pull data into Excel ans show you management staff what is going on? Do you run queries to answer questions for projects or at the department's request on a regular basis? Wanna know what is going on with your report server?

Come to this "BI for the Engine Guy" session and let me help you make visualizations for all your engine's health care needs and your user's (customer) data demands.

SessionID: 59605

Install and Configure SQL Server with Windows PowerShell Desired State Configuration

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Warner

Title: Install and Configure SQL Server with Windows PowerShell Desired State Configuration

Abstract:

This session accomplishes three goals: (1) Gets you up to speed on what DSC is and how it works; (2) Improves your ability to configure SQL Server by using administrative automation; and (3) Gives you some valuable practical experience with Windows PowerShell.

SessionID: 59677

R For the SQL Server Developer

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 61809

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

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Boles

Title: 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 need to find disk space, provision, etc.

In this session we will examine how SQL Clone uses disk virtualization to enable quick, easy and even automated creation of database copies that are just MB in size.

SessionID: 63017

Excel with DAX

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Azhagappan Arunachalam

Title: Excel with DAX

Abstract:

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it). PowerBI also uses DAX for all the formula expressions. We'll cover the basics of DAX, and go over some time intelligence functions.

SessionID: 63388

A Tour of Cloud Data Platforms as a Service

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Richard Weiss

Title: A Tour of Cloud Data Platforms as a Service

Abstract:

With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.

SessionID: 64146

Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Back to calendar

Event Date: 24-06-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: William Wolf

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract:

Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.

By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.

SessionID: 65050

Using Biml to Automate the Generation of SSIS Packages

Back to calendar

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

Speaker: Simon Kingaby

Title: Using Biml to Automate the Generation of SSIS Packages

Abstract:

So you need to move data from 75 tables on the mainframe to new tables in SQL Azure. Do you: a) hand code one package to load all 75 tables, b) hand code 75 packages that move a table each, or c) wish there was a better way?

There is! Business Intelligence Markup Language (Biml) can automate the creation of packages so that they all follow the same script. In this beginner level session, we will create some simple metadata to be able to generate multiple packages and their associated connection managers. You will see Biml in action. You will see the XML that Biml uses to define packages and connections. You will see the C# code that Biml uses to fetch metadata and dynamically generate packages in SSIS. And you will see packages and connection managers generated from Biml before your very eyes.

This site is open source. Improve this page.