sqlsathistory

Nr: 544

SQLSaturday #544 - Spartanburg 2016

Start Time (24h)	Speaker	Track	Title
02:30:00	Brandon Leach	Enterprise Database Administration Deployment	Bringing Balance to the SQL Server Force with Resource Governor
02:30:00	Shabnam Watson	BI Platform Architecture, Development Administration	A SQL Developer’s Guide to MDX Basics
08:15:00	Vazi Okhandiar	Analytics and Visualization	Building a PowerPivot BI Dashboard
08:15:00	Ryan Brickey	Enterprise Database Administration Deployment	Policy Based Management: Introduction and Implementation
08:15:00	Tracy Boggiano	Enterprise Database Administration Deployment	Query Store Primer
08:15:00	Azhagappan Arunachalam	Cloud Application Development Deployment	Getting to know U-SQL
08:15:00	Andy Tabisz	Application Database Development	Creating Access Web Apps with Power BI Integration
08:15:00	Ben DeBow	Enterprise Database Administration Deployment	Surviving Your Peak Database Load
09:30:00	Geoff Hiten	Enterprise Database Administration Deployment	Moving Day - Successful SQL Migrations
09:30:00	Andy Leonard	BI Platform Architecture, Development Administration	Using Biml as an SSIS Design Patterns Engine
09:30:00	Nathan Boster	Application Database Development	Write Queries Faster with AutoHotKey
09:30:00	Melissa Coates	Analytics and Visualization	Building Blocks of Cortana Intelligence Suite in Azure
09:30:00	Thomas Norman	Cloud Application Development Deployment	Beginning Azure
10:45:00	Kevin Feasel	BI Platform Architecture, Development Administration	Peanut Butter Chocolate: Integrating Hadoop with SQL Server
10:45:00	Andy Leonard	BI Platform Architecture, Development Administration	Use Biml to Automate SSIS Design Patterns
10:45:00	Ed Watson	Enterprise Database Administration Deployment	Backup Strategies are for Losers...of Data!
10:45:00	Aaron Nelson	Enterprise Database Administration Deployment	Do Awesome Things with PowerShell in 5 minutes or Less
10:45:00	Justin Randall	Enterprise Database Administration Deployment	Automating SQL Server Administration Using SQLCMD
10:45:00	Mike Lawell	Application Database Development	Execution Plans for Mere Mortals
10:45:00	Rafael Salas	Analytics and Visualization	Enabling Advanced Data Preparation Capabilities for Your Business
13:15:00	Kevin Feasel	Analytics and Visualization	Introducing Azure ML
13:15:00	Ed Watson	BI Platform Architecture, Development Administration	Introduction to SQL Server Integration Services
13:15:00	Aaron Nelson	Enterprise Database Administration Deployment	Achieve More in Less Time by Using SQLPS
13:15:00	Justin Randall	Enterprise Database Administration Deployment	SQL Server 2016 In-Memory OLTP for DBAs
13:15:00	Kiran Math	Analytics and Visualization	Extract, Tranform And Load - Using R
14:30:00	Tracy Boggiano	Strategy and Architecture	Disaster Recovery Where to Begin
14:30:00	Brandon Leach	Application Database Development	Partitioning Basics: Treating Your Tables Like Legos
14:30:00	George Walkey	Enterprise Database Administration Deployment	Using Powershell to Document SQL Server
14:30:00	Thomas Norman	Enterprise Database Administration Deployment	Encrypting Data within Sql Server
14:30:00	Paco Gonzalez	Analytics and Visualization	Enterprise Machine Learning with R and SQL Server
14:30:00	Robert Eder	Enterprise Database Administration Deployment	Designing highly flexible PowerShell Scripts
15:45:00	Brandon Leach	Enterprise Database Administration Deployment	Data Pages, Allocation Units, IAM chains... Oh My!
15:45:00	Jana Sattainathan	Analytics and Visualization	Small Scale Data Collection Using PowerShell - Going NSA Style!
15:45:00	Silvia Doomra	Cloud Application Development Deployment	Seamlessly Scaling Azure SQL DB with Elastic Database Tools
15:45:00	Patrick Keisler	Enterprise Database Administration Deployment	Policy Based Management - Beyond the Basics
15:45:00	Paco Gonzalez	Analytics and Visualization	Introduction to Artificial Intelligence

SessionID: 48739

Bringing Balance to the SQL Server Force with Resource Governor

Back to calendar

Event Date: 20-08-2016 - Session time: 02:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Bringing Balance to the SQL Server Force with Resource Governor

Abstract:

Balancing the needs of different groups of users on your servers isn't always easy. Competing workloads and business priorities can present a challenging problem to DBAs. Between maintenance, operational, and reporting queries, you can find yourself rather constrained in terms of performance.

Resource Governor is one the most underused features available to enterprise edition users of SQL Server. In this session, we delve into the basics of the Resource Governor feature in SQL Server and when, why, and how you should use it. We look at the types of issues this feature can help resolve. We delve into various components of the feature, such as a classifier function, workload groups, and resource pools and how those components change the behavior of SQL Server. We bring all this together with a sample implementation. Along the way, we look at best practices and questions to answer to ensure a successful implementation.

SessionID: 52638

A SQL Developer’s Guide to MDX Basics

Back to calendar

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

Speaker: Shabnam Watson

Title: A SQL Developer’s Guide to MDX Basics

Abstract:

In this session we will first explore data organization in SSAS in multidimensional mode using AdventureWorks sample database. Then we will review a couple of MDX and SQL queries that return the same results and continue to learn MDX fundamentals by running queries in SSMS. We will see how certain queries are much easier to write in MDX, especially when it comes to querying data with hierarchies such as a date rollup. Finally, we will learn how to capture MDX queries generated by Excel and SSMS, to use as practical examples of how to write MDX queries.

SessionID: 48695

Building a PowerPivot BI Dashboard

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Analytics and Visualization

Speaker: Vazi Okhandiar

Title: Building a PowerPivot BI Dashboard

Abstract:

Demonstrate the steps to import raw data from text file, Access database and Excel file into Excel 2013, and then build a BI dashboard using PowerPivot and Power Map.

SessionID: 48934

Policy Based Management: Introduction and Implementation

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Brickey

Title: Policy Based Management: Introduction and Implementation

Abstract:

In this session users will be introduced to the concepts and capabilities of Policy Based Management. We will review the basics of what policies are, the process for setting up new policies, evaluating policies against an environment, and scaling policies across an environment.

SessionID: 49312

Query Store Primer

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise.

SessionID: 50800

Getting to know U-SQL

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Cloud Application Development Deployment

Speaker: Azhagappan Arunachalam

Title: Getting to know U-SQL

Abstract:

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

SessionID: 52540

Creating Access Web Apps with Power BI Integration

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Andy Tabisz

Title: Creating Access Web Apps with Power BI Integration

Abstract:

SessionID: 53508

Surviving Your Peak Database Load

Back to calendar

Event Date: 20-08-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben DeBow

Title: Surviving Your Peak Database Load

Abstract:

Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these timeframes is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.

SessionID: 48810

Moving Day - Successful SQL Migrations

Back to calendar

Event Date: 20-08-2016 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Geoff Hiten

Title: Moving Day - Successful SQL Migrations

Abstract:

Moving day is one of life's most stressful times. Details drown you, critical items consume time and attention, and there is always someone demanding you get something done now. This is true whether you are moving your personal residence or your data platform. SQL Server migrations are a core competency for a DBA. This presentation will give you a strong structured process for a successful SQL Server migration using real-world examples and experiences.

SessionID: 49127

Using Biml as an SSIS Design Patterns Engine

Back to calendar

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

Speaker: Andy Leonard

Title: Using Biml as an SSIS Design Patterns Engine

Abstract:

Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

How to build and execute your first Biml file!
How to design a single SSIS package using Biml
How to rapidly build multiple SSIS packages using Biml

SessionID: 50666

Write Queries Faster with AutoHotKey

Back to calendar

Event Date: 20-08-2016 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Nathan Boster

Title: Write Queries Faster with AutoHotKey

Abstract:

AutoHotKey (AHK) is an open source Windows application used to create macros, hot keys, and "text expansions". Nathan has used this program for years in many different ways, but he finds it especially useful in SQL Server Management Studio. Come and see how AHK can put a library of code snippets--and full queries--at your fingertips.

SessionID: 51055

Building Blocks of Cortana Intelligence Suite in Azure

Back to calendar

Event Date: 20-08-2016 - Session time: 09:30:00 - Track: Analytics and Visualization

Speaker: Melissa Coates

Title: Building Blocks of Cortana Intelligence Suite in Azure

Abstract:

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

SessionID: 51125

Beginning Azure

Back to calendar

Event Date: 20-08-2016 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

Speaker: Thomas Norman

Title: Beginning Azure

Abstract:

The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let's put SQL Server into the cloud!

SessionID: 49044

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 49128

Use Biml to Automate SSIS Design Patterns

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Use Biml to Automate SSIS Design Patterns

Abstract:

Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

How to rapidly build multiple SSIS packages using Biml
How to apply different SSIS Design Patterns using Biml
How to automate SSIS Design Patterns using Biml

SessionID: 50476

Backup Strategies are for Losers...of Data!

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Watson

Title: Backup Strategies are for Losers...of Data!

Abstract:

Defining and documenting a backup strategy in today's data platform is simply not enough to prevent a major catastrophe. For that, a company needs to define a recovery strategy that encompasses their backup solution with an appropriate, tested recovery plan. This session outlines the various backup strategies and how to implement them in a recovery scenario to minimize data loss. This session will discuss various case studies of backup strategy implementations that neglected a strong recovery strategy and resulted in catastrophe for the company.

SessionID: 50520

Do Awesome Things with PowerShell in 5 minutes or Less

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Aaron Nelson

Title: Do Awesome Things with PowerShell in 5 minutes or Less

Abstract:

What if you could import 25 million rows of CSV data in less than 2 minutes? Or regain lost sysadmin access to your SQL Server in 20 seconds? Need to check which of your 200 servers has misconfigured max memory, calculate the proper memory and then set it? No problem, couple of minutes, tops.

PowerShell can do amazing things for database administrators. It can automate your complex, onerous tasks. It can also automate the boring yet vital tasks like testing backups, and it can do it faster than you think. Even better, it is easier to learn than you might expect.

Get Better, Faster, Stronger with PowerShell SQL Server.

SessionID: 51232

Automating SQL Server Administration Using SQLCMD

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: Automating SQL Server Administration Using SQLCMD

Abstract:

The sqlcmd utility is a powerful tool in every SQL Server administrator's toolbox. Simpler and easier to learn and implement than PowerShell, sqlcmd has all the power and flexibility you need to automate recurring tasks via T-SQL statements, system procedures and script files. After this session you will have a working knowledge of sqlcmd basics including:

• How to invoke commands interactively, through scripts, and in scheduled tasks, • Important command switches, • Examples of how to use sqlcmd to make your job easier and more productive

SessionID: 53558

Execution Plans for Mere Mortals

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45: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: 53721

Enabling Advanced Data Preparation Capabilities for Your Business

Back to calendar

Event Date: 20-08-2016 - Session time: 10:45:00 - Track: Analytics and Visualization

Speaker: Rafael Salas

Title: Enabling Advanced Data Preparation Capabilities for Your Business

Abstract:

Are your business and data analysts frustrated with the amount of time and effort that takes them to wrangle and massage the data they need for their analysis? Is your IT development team flooded with requests to integrate and deliver data?

Self-Service BI technologies have evolved to include data preparation capabilities and in that space Power BI comes with a rich set of features that often goes unnoticed or underused.

In this session we will explore how Power BI can be used to respond to more advanced data preparation scenarios while requiring no or minimal coding, making it an ideal tool for users such as data and business analysts. We will show how Power BI can be used to reduce time and cost of preparing the data used in analysis and reports, while keeping in check considerations and concerns that we, as IT stakeholders, have when adopting this type of technologies in our organizations.

SessionID: 49045

Introducing Azure ML

Back to calendar

Event Date: 20-08-2016 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Introducing Azure ML

Abstract:

Azure Machine Learning is a point-and-click Software-as-a-Service offering on the Microsoft Azure platform. It allows data scientists to manage, cleanse, and filter data; train, score, and evaluate models; and write custom components in R and Python. Once the data scientist's work is done, Azure ML then automatically generates a production-ready web service to implement the model, saving significant development effort. This talk will walk through the Azure ML offerings and discuss how they may integrate into a mature business platform.

SessionID: 49184

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 20-08-2016 - Session time: 13:15: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: 50519

Achieve More in Less Time by Using SQLPS

Back to calendar

Event Date: 20-08-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Aaron Nelson

Title: Achieve More in Less Time by Using SQLPS

Abstract:

Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati. Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell. I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren't a "DBA".

SessionID: 51233

SQL Server 2016 In-Memory OLTP for DBAs

Back to calendar

Event Date: 20-08-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: SQL Server 2016 In-Memory OLTP for DBAs

Abstract:

In-Memory OLTP in SQL Server 2016 has been reborn. Many limitations within the previous versions have been removed, making it a viable option for a variety of workloads. As DBAs responsible for ensuring data integrity, recoverability and performance of the databases under our care, we need to know how In-Memory tables impact our jobs and our environment.

In this session we will highlight critical issues in implementing and managing SQL Server 2016 instances and databases containing In-Memory tables. The bulk of this session will be spent walking through the process of identifying candidate In-Memory tables, migrating an on-disk table to an in-memory table and comparing performance.

SessionID: 53635

Extract, Tranform And Load - Using R

Back to calendar

Event Date: 20-08-2016 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Kiran Math

Title: Extract, Tranform And Load - Using R

Abstract:

In this session we will Learn R through an Example. We will Extracting Data from Multiple Excel sheets, transforming the data, Visualizing the data and Loading it into SQL Server Table.

SessionID: 48729

Disaster Recovery Where to Begin

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Strategy and Architecture

Speaker: Tracy Boggiano

Title: Disaster Recovery Where to Begin

Abstract:

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

SessionID: 48737

Partitioning Basics: Treating Your Tables Like Legos

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Brandon Leach

Title: Partitioning Basics: Treating Your Tables Like Legos

Abstract:

Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!

With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll also look at how partitioning affects things under the hood. Finally you'll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement.

SessionID: 48765

Using Powershell to Document SQL Server

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

SessionID: 51126

Encrypting Data within Sql Server

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Norman

Title: Encrypting Data within Sql Server

Abstract:

Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.

SessionID: 52558

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server

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

Designing highly flexible PowerShell Scripts

Back to calendar

Event Date: 20-08-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Eder

Title: Designing highly flexible PowerShell Scripts

Abstract:

A common practice when a script is needed for a particular task is to copy an existing script and modify it to meet a new need. At some point, a bugs are found and fixed in the script it was found in. After a while, there are many versions of the script, but the variations are numerous. This session provides one method to break this cycle by creating a script that is highly flexible to the kind of variations that will exist in an environment.

SessionID: 48738

Data Pages, Allocation Units, IAM chains... Oh My!

Back to calendar

Event Date: 20-08-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My!

Abstract:

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session, we'll explore various concepts in the storage engine and tell humorous stories along the way. We'll also look at why certain best practices exist and what they are really doing.

You'll hear how these concepts tie in to your work as a DBA or developer. You’ll get to see the concepts in action through demos and learn how you can use this knowledge to design better solutions. In addition you'll see some neat tools to help you dig in and learn further.

After this session you will understand:

• The three basic types of storage in SQL Server

• The physical structure of a row and how it affects performance

• Differences in how SQL Server works with heaps and clustered indexes

• How pages are allocated and tracked

• How to use various tools to continue your learning

SessionID: 48795

Small Scale Data Collection Using PowerShell - Going NSA Style!

Back to calendar

Event Date: 20-08-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Jana Sattainathan

Title: Small Scale Data Collection Using PowerShell - Going NSA Style!

Abstract:

While we are not the NSA, certain vital data needs to be collected – for example audit data, trace data, session information, performance data etc. – all to a central SQL Server repository, for analysis. In this session let us see how freely available PowerShell code can be used to collect data from multiple SQL Servers instances/databases. At the end of this session, you will have the knowledge and ability to collect pretty much any data to a central repository with just a couple of lines of code all in a manner that works specifically for you!

SessionID: 50215

Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Back to calendar

Event Date: 20-08-2016 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Silvia Doomra

Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Abstract:

Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB's elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.

SessionID: 52549

Policy Based Management - Beyond the Basics

Back to calendar

Event Date: 20-08-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Keisler

Title: Policy Based Management - Beyond the Basics

Abstract:

Policy Based Management is a great feature of SQL Server and easy to implement; however, for most organizations you need a way to customize it to your enterprise. Join me for this session as we take a deeper dive into PBM to see how you can customize polices, evaluate those polices across your entire enterprise environment, track those changes over time, and deliver reports to management showing your progress.

SessionID: 52559

Introduction to Artificial Intelligence

Back to calendar

Event Date: 20-08-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Paco Gonzalez

Title: Introduction to Artificial Intelligence

Abstract:

Artificial Intelligence (AI) is being out there for a long time. Now it is time to take advantage of it with our own data. There are many different terms that relate to AI: machine learning, data mining or data science. This session will introduce the concepts, techniques, and tools. We will explore different real scenarios: classification, basket analysis, clustering or forecasting. All different tools available will be shown: SQL Server Analysis Services Data Mining, Azure Machine Learning, HDInsight Mahout, or R. Join this session for an introduction that will position you to understand further concepts.

This site is open source. Improve this page.