sqlsathistory

Nr: 678

SQLSaturday #678 - Orlando 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Troy Gallant	Enterprise Database Administration Deployment	Supercharge Your Maintenance Plans!
09:00:00	Patrick Keisler	Enterprise Database Administration Deployment	SQL Audit - Evidence Never Lies
09:00:00	Thomas LeBlanc	BI Platform Architecture, Development Administration	What’s new for SQL Server Analysis Services?
09:00:00	Shawn Meyers	Enterprise Database Administration Deployment	Monitoring and Alerting of Availability Groups
09:00:00	Rick Heiges	Enterprise Database Administration Deployment	Winning with Columnstore - A Customer Story
09:00:00	Amy Herold	Enterprise Database Administration Deployment	Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
09:00:00	Geoff Hiten	Cloud Application Development Deployment	ARMed for Azure
09:00:00	Rob Volk	Application Database Development	Logging Messages in SQL Server
10:30:00	Arvin Meyer	Application Database Development	Database Creation Process
10:30:00	Christopher Sims	BI Platform Architecture, Development Administration	Getting graphy with CosmosDB Graph API with Gremlin
10:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Query Store Primer
10:30:00	Ronald Dameron	Enterprise Database Administration Deployment	Uptight Database Security
10:30:00	Michael Antonovich	BI Information Delivery	Creating Reports and Dashboards with Power BI
10:30:00	Herve Roggero	Strategy and Architecture	Replicating data from SharePoint Online to SQL Server
10:30:00	Dmitri Korotkevitch	Enterprise Database Administration Deployment	Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
12:00:00	Shawn Meyers	Enterprise Database Administration Deployment	vNUMA, pNUMA, save your SQL Servers from certain DoomA
12:00:00	Diane Schuster	BI Platform Architecture, Development Administration	Excel and SSIS: Better Together
12:00:00	Rick Heiges	Professional Development	Getting Noticed: Strategies for Your Resume and LinkedIn
12:00:00	Andy Warren	Enterprise Database Administration Deployment	Database Continuous Delivery
12:00:00	Andy Warren	Advanced Analysis Techniques	The Path to #GetModern by Dell EMC
13:15:00	Jeff Taylor	Enterprise Database Administration Deployment	How To Tune A Multi-Terabyte Database For Optimum Performance.
13:15:00	Michael Corey	Cloud Application Development Deployment	Monster VM's (Database Virtualization) with vSphere 6.5 Doing IT Right
13:15:00	Hector Villafuerte	BI Platform Architecture, Development Administration	Data Security with Power BI, SSAS, SQL Server and Active Directory
13:15:00	Thomas LeBlanc	Application Database Development	Execution Plan Basics - Beginners
13:15:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
13:15:00	Elizabeth Noble	Application Database Development	Introduction to unit and integration testing with tSQLt
13:15:00	Jonathon Moorman	Strategy and Architecture	Azure Sql PAAS: Lessons from the Real World
13:15:00	Bradley Ball	Advanced Analysis Techniques	Baseball Analytics: SQL Server 2016 In-Database R
14:30:00	Daniel Janik	Advanced Analysis Techniques	A DBA's guide to whole stack performance troubleshooting
14:30:00	Kevin Feasel	Analytics and Visualization	Data Cleansing With SQL And R
14:30:00	Maximo Trinidad	Application Database Development	Working with SQL Server for Linux Cross-Platform
14:30:00	Sam Mesel	Other	InMemory Improvements on SQL 2016
14:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Tips on Managing Lots of SQL Servers
14:30:00	Tom Hanley	BI Platform Architecture, Development Administration	SQL Server Data Partitioning
14:30:00	Sean Forgatch	BI Platform Architecture, Development Administration	Processing Big Data with Azure Data Lake Analytics
14:30:00	Jeffrey Garbus	Enterprise Database Administration Deployment	Indexing for performance

SessionID: 66455

Supercharge Your Maintenance Plans!

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Supercharge Your Maintenance Plans!

Abstract:

Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

SessionID: 66489

SQL Audit - Evidence Never Lies

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Keisler

Title: SQL Audit - Evidence Never Lies

Abstract:

We've all heard about massive data breaches from big name companies. As a DBA, you should consider your company's data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we'll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.

SessionID: 66718

What’s new for SQL Server Analysis Services?

Back to calendar

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

Speaker: Thomas LeBlanc

Title: What’s new for SQL Server Analysis Services?

Abstract:

So, do we stick with the Cube or move to Tabular? Has DAX functionality improved enough to rely on performance with DirectQuery in a Tabular Model? Will we be porting Analysis Service (SSAS) databases to Azure? How do we know what level or pricing model is adequate for an Azure SSAS database?

When an SSAS database gets created, and users start to report against, it is very hard not to continue to expand the model. Anxiety is released when a new release of SSAS comes along adding functionality to replace the hooks created to satisfy user requirements. With 2016 and 2017, Microsoft is moving to update Tabular Models with more features, improved performance and better security. The Cube additions are mainly with Data Sources and better T-SQL generated to access source databases like Oracle and Teradata. So, let us examine the pros and cons together and get a consensus of the path forward with SSAS. You are definitely not going to want to stop using this tool.

SessionID: 67074

Monitoring and Alerting of Availability Groups

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Monitoring and Alerting of Availability Groups

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night?

This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises. We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action. Demo: Show AG dashboard and cause AG failures and excessive delay and show how alerts are sent Goals:
Teach what to monitor in AGs for proper health Alert on events when they occur which the DBA should know about Demonstrate alerts and notifications when failures or delays occur in your environment

SessionID: 67449

Winning with Columnstore - A Customer Story

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Heiges

Title: Winning with Columnstore - A Customer Story

Abstract:

This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

SessionID: 68198

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 68367

ARMed for Azure

Back to calendar

Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Geoff Hiten

Title: ARMed for Azure

Abstract:

The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments. Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems. In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.

SessionID: 68479

Logging Messages in SQL Server

Back to calendar

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

Speaker: Rob Volk

Title: Logging Messages in SQL Server

Abstract:

Logging messages in your database is a common request, and there are a million ways to do it. This presentation will cover basic methods and progress through more advanced ones. We'll also show how autonomous transactions (available in some database products, but not natively supported in SQL Server) can be accommodated with some interesting techniques.

We'll examine user-defined events, linked servers and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management, and cover their best use cases.

SessionID: 66450

Database Creation Process

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Arvin Meyer

Title: Database Creation Process

Abstract:

How to set up a Requirements Analysis to develop successful databases

SessionID: 66456

Getting graphy with CosmosDB Graph API with Gremlin

Back to calendar

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

Speaker: Christopher Sims

Title: Getting graphy with CosmosDB Graph API with Gremlin

Abstract:

CosmosDB was announced at Build 2017 as an extension to Microsoft's DocumentDB offering and is positioned to be a key component of the Microsoft Data Platform. In this session, we will explore CosmosDB's graph API that is built using Apache's TinkerPop and Gremlin projects. Graph databases allow you to build a powerful data model that explores connections and paths between data. At the end of this session, attendees will have a solid understanding of what a graph database is and how you can use Gremlin and the .NET API to interact with a graph database.

SessionID: 66841

Query Store Primer

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30: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 new features in 2017.

SessionID: 67343

Uptight Database Security

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ronald Dameron

Title: Uptight Database Security

Abstract:

Do you work for an institution that fears it’s DBAs could go rogue on their production databases?

Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you have concerns that the DBA team is querying sensitive databases? Then, you need Uptight Database Security. Come to this session to learn how to deploy a configurable permission model that provides on-demand access to SQL Server databases. This model allows DBAs to do routine work without sysadmin, elevate permissions to sysadmin only during production emergencies or disaster recovery scenarios. Attendees will leave this session with the fundamental knowledge and scripts to implement a low hassle solution that provides DBAs the minimum necessary access required to maintain a production database server.

SessionID: 67597

Creating Reports and Dashboards with Power BI

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Creating Reports and Dashboards with Power BI

Abstract:

SessionID: 68406

Replicating data from SharePoint Online to SQL Server

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Herve Roggero

Title: Replicating data from SharePoint Online to SQL Server

Abstract:

Ever wanted to query SharePoint Online Lists from SQL Server directly, or even create a replica of your SharePoint data in a SQL Server database for offline reporting? In this session, I will show you a new technology that allows you to access your SharePoint environment through simple SQL queries, in real-time, and how to replicate your SharePoint lists for offline reporting with just a few clicks.

SessionID: 68516

Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Back to calendar

Event Date: 07-10-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching

Abstract:

SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.

In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.

SessionID: 67075

vNUMA, pNUMA, save your SQL Servers from certain DoomA

Back to calendar

Event Date: 07-10-2017 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: vNUMA, pNUMA, save your SQL Servers from certain DoomA

Abstract:

When presented with large SQL Server workloads in a virtual environment, which cross NUMA boundaries, it is very important to understand how the hypervisor presents vNUMA to the SQL Server virtual machine. When there is a NUMA imbalance, it can have as much as a 40% impact on performance, causing a significant effect on your virtual environment. In this session attendees will learn ways to optimize vNUMA including:

• How vNUMA works across different processors; and the ways that Intel and AMD are different • Methods for determining if a NUMA imbalance exists • Which settings at the hypervisor, or virtual machine level, should be changed to ensure the best performance

SessionID: 67095

Excel and SSIS: Better Together

Back to calendar

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

Speaker: Diane Schuster

Title: Excel and SSIS: Better Together

Abstract:

If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are some limitations. Cozyroc’s Excel Source Plus and Excel Destination Plus components remove those limitations. In addition, Cozyroc’s Excel Task enables editing of Excel files from SSIS packages. In this session, I’ll talk about the capabilities of the Cozyroc components and demonstrate how easy it is use use these components with SSIS.

SessionID: 67446

Getting Noticed: Strategies for Your Resume and LinkedIn

Back to calendar

Event Date: 07-10-2017 - Session time: 12:00:00 - Track: Professional Development

Speaker: Rick Heiges

Title: Getting Noticed: Strategies for Your Resume and LinkedIn

Abstract:

You know you are well qualified for the jobs that you search for on any major job site. You know that if you just get to that next step that they will see it for themselves. This lightning talk focuses on strategies for your resume and LinkedIn profile to help get you noticed and reach that next step. Interaction with the audience is encouraged throughout the discussion.

SessionID: 69670

Database Continuous Delivery

Back to calendar

Event Date: 07-10-2017 - Session time: 12:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Warren

Title: Database Continuous Delivery

Abstract:

Automating your deployments should not be limited to applications. In this session, learn how to create an automated deployment pipeline that includes your application and database using Redgate’s DLM Automation tools. You will get instant feedback on your code changes, get the exact script you need for release automation and, when you’re ready, you can deploy to production in confidence. We will use Visual Studio, Visual Studio Team Services to create a build and release pipeline to deploy your changes to dev, staging, and production environments. [Presenter will be Esteban Garcia]

SessionID: 69894

The Path to #GetModern by Dell EMC

Back to calendar

Event Date: 07-10-2017 - Session time: 12:00:00 - Track: Advanced Analysis Techniques

Speaker: Andy Warren

Title: The Path to #GetModern by Dell EMC

Abstract:

To succeed in this new digital world, companies will require an IT Transformation. Dell EMC has announced a wave of innovations to help customers on their path towards a modern infrastructure and business agility. Join us to learn how to innovate faster, create competitive advantage, improve IT operations, reduce costs and ultimately #GetModern. The speaker for this session is Dominick Dequarto.

SessionID: 66460

How To Tune A Multi-Terabyte Database For Optimum Performance.

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Taylor

Title: How To Tune A Multi-Terabyte Database For Optimum Performance.

Abstract:

This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.

SessionID: 66470

Monster VM's (Database Virtualization) with vSphere 6.5 Doing IT Right

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Michael Corey

Title: Monster VM's (Database Virtualization) with vSphere 6.5 Doing IT Right

Abstract:

vSphere 6.5 has made a lot of changes to enhance the performance of Monster VM’s. Databases by their very nature are the classic Monster VM’s. If Monster VM’s are not virtualized properly they will never perform well and can negatively performance of other VM’s on the hosts. In this presentation, we will teach you how to properly virtualize Monster VM/Databases with vSphere 6.5. We will discuss why you virtualize, installation issues, how to Architect for performance discussing vSphere 6.5 specifics, the storage layer, the processor, Memory considerations, the network layer. Topics include NUMA, Memory reservations, how to avoid common mistakes. Lesson learned here help you optimize any workload you are virtualizing. With Special emphasis on Monster VM’s on Vsphere 6.5

SessionID: 66680

Data Security with Power BI, SSAS, SQL Server and Active Directory

Back to calendar

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

Speaker: Hector Villafuerte

Title: Data Security with Power BI, SSAS, SQL Server and Active Directory

Abstract:

Today's Business Intelligence Tools allow to secure the data for a variety of business scenarios. Learn How Row Level Security and other security data technologies can be implemented in Power BI, SSAS, and SQL Server and can change the design of corporate Apps using Active Directory.

In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design and architecture of data security using different tools: Power BI, SSAS, SQL Server, Web Apps and explain when to use them, their differences and their limitations. Throughout the session, we explore and demo various ways to secure the data and witness how to implement the security in each.

SessionID: 66719

Execution Plan Basics - Beginners

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Thomas LeBlanc

Title: Execution Plan Basics - Beginners

Abstract:

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?

SessionID: 66807

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15: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: 67599

Introduction to unit and integration testing with tSQLt

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Introduction to unit and integration testing with tSQLt

Abstract:

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

SessionID: 69468

Azure Sql PAAS: Lessons from the Real World

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Strategy and Architecture

Speaker: Jonathon Moorman

Title: Azure Sql PAAS: Lessons from the Real World

Abstract:

So you're using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What's a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore...? We'll go over these questions and any others that you may have.

SessionID: 69847

Baseball Analytics: SQL Server 2016 In-Database R

Back to calendar

Event Date: 07-10-2017 - Session time: 13:15:00 - Track: Advanced Analysis Techniques

Speaker: Bradley Ball

Title: Baseball Analytics: SQL Server 2016 In-Database R

Abstract:

This session is meant to dive into the world of R using awesome data to make learning memorable. We will discuss a brief overview of the syntax, how to write an In-Database R query, and then dive into a data set using the Lahman database data from Retrosheets.org to examine baseball games from 1990 – 2016 to answer the following questions: If I want to see my team win a game should I go to a double header? What is the best day of the week to see my team play? What is the best day if they are above .500 or below? What if they have home vs. away games? Then we will display the results in Power BI or and Excel Dashboard. Come for the Science stay for the data!

SessionID: 66517

A DBA's guide to whole stack performance troubleshooting

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Janik

Title: A DBA's guide to whole stack performance troubleshooting

Abstract:

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.

SessionID: 66664

Data Cleansing With SQL And R

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Data Cleansing With SQL And R

Abstract:

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

SessionID: 66679

Working with SQL Server for Linux Cross-Platform

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Maximo Trinidad

Title: Working with SQL Server for Linux Cross-Platform

Abstract:

I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session

SessionID: 66721

InMemory Improvements on SQL 2016

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Other

Speaker: Sam Mesel

Title: InMemory Improvements on SQL 2016

Abstract:

SQL Server 2016 lifted several limitations from its initial implementation.

This session will cover how to implement InMemory objects, new capabilities (Defaults, Checks, FK validation, Triggers); performance gains; and an introduction to monitoring these objects.

SessionID: 66844

Tips on Managing Lots of SQL Servers

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Tips on Managing Lots of SQL Servers

Abstract:

When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly? How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

SessionID: 67052

SQL Server Data Partitioning

Back to calendar

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

Speaker: Tom Hanley

Title: SQL Server Data Partitioning

Abstract:

Data partitioning allows for the efficient loading, storage, retrieval, and shedding of data in an RDBMS platform. This session will focus on its use in MS SQL Server and how table partitioning can improve performance, manageability, and decrease concerns over concurrency. Especially if you are working with a data warehouse, you want to be sure to understand these concepts and how/when you might leverage them.

SessionID: 67397

Processing Big Data with Azure Data Lake Analytics

Back to calendar

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

Speaker: Sean Forgatch

Title: Processing Big Data with Azure Data Lake Analytics

Abstract:

In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft's new Big Data language, U-SQL.

SessionID: 69206

Indexing for performance

Back to calendar

Event Date: 07-10-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

This site is open source. Improve this page.