sqlsathistory

Nr: 564

Back to Main list

SQLSaturday #564 - Orlando 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	Michael Keleher	Enterprise Database Administration Deployment	Building Defense in Depth Using the Full Spectrum of SQL Server Encryption
09:00:00	Devin Knight	BI Information Delivery	Advanced Power BI: Solving the Hard Problems
09:00:00	Jeffrey Garbus	Professional Development	How to be a GREAT DBA
09:00:00	John Wang	Analytics and Visualization	Introduction to Fog Analytics
09:00:00	Dmitri Korotkevitch	Application Database Development	Data Partitioning for Database Architects and Mere Mortals
09:00:00	Jared Nielsen	Application Database Development	RESTful JSON API Microservices and SQL Server
09:00:00	Shannon Lowder	Analytics and Visualization	Cortana Intelligence Suite
09:00:00	Ernie Wise	BI Platform Architecture, Development Administration	Power BI Data Governance - Protecting Business Data
09:00:00	Bradley Ball	Enterprise Database Administration Deployment	SQL Internals , Recovery Models, Backups! OH MY
09:00:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell
10:15:00	miguel Cebollero	BI Information Delivery	Data Quality Services - Integrating your Data Steward
10:15:00	Valentin Iamandi	Enterprise Database Administration Deployment	Index Sql Server databases for high performance
10:15:00	Rob Volk	Enterprise Database Administration Deployment	Azure, PowerShell, and SQL Server Virtual Machines
10:15:00	Kevin Boles	Application Database Development	SQL Server 2014 Column Store Index vNEXT
10:15:00	Brian Knight	Professional Development	Real World Lessons from Starting a Software Company
10:15:00	Dmitry Pilugin	Enterprise Database Administration Deployment	Query Optimizer Changes in SQL Server 2016
10:15:00	Jennifer McCown	Enterprise Database Administration Deployment	Effortless Backups with Minion Backup
11:30:00	Anthony van Gemert	Application Database Development	MICROSOFT: SQL Server 2016 Stretch Database
11:30:00	Jeffrey Garbus	Application Database Development	Bad, less Bad, not Bad; rewriting bad SQL Code
11:30:00	Carlos Colon	Enterprise Database Administration Deployment	Planning and Executing a Successful SQL Server Database Migration
11:30:00	Tom Staab	Application Database Development	SQL Writing SQL
11:30:00	Rodney Landrum	Advanced Analytics Techniques	I See What You Did There - Automating Auditing in SQL Server
11:30:00	Paco Gonzalez	Advanced Analytics Techniques	Tone Analysis with HDInsight and Azure Machine Learning
11:30:00	Chris Hyde	BI Information Delivery	Row-level Security in SSRS and SSAS
12:45:00	Bradley Ball	Enterprise Database Administration Deployment	Plan Explorer 3.0 Webinar
12:45:00	Dominick DeQuarto	Enterprise Database Administration Deployment	SQL Server Performance Best Practices
14:00:00	Michael Antonovich	BI Information Delivery	Creating Reports and Dashboards with Power BI
14:00:00	Janis Griffin	Enterprise Database Administration Deployment	Does your performance tuning need a 12-step program?
14:00:00	Kevin Boles	Application Database Development	Unit Testing SQL Server
14:00:00	Eric Wisdahl	Enterprise Database Administration Deployment	Free tools from the SQL Server Community
14:00:00	Robert Biddle	Analytics and Visualization	Combining SQL Server and R
14:00:00	Pam Shaw	BI Platform Architecture, Development Administration	Tips and Tricks for Reporting Services
14:00:00	Jeff Taylor	Enterprise Database Administration Deployment	How To Tune A Multi-Terabyte Database For Optimum Performance.
14:00:00	Andy Leonard	BI Platform Architecture, Development Administration	Use Biml to Automate SSIS Design Patterns
15:15:00	Arvin Meyer	Application Database Development	Intelligent Indexing
15:15:00	Gareth Swanepoel	Enterprise Database Administration Deployment	What’s New in SQL Server 2016 ?
15:15:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
15:15:00	Jason Brugger	Analytics and Visualization	Hands-on with U-SQL and Azure Data Lake Analytics
15:15:00	Jonathon Moorman	Application Database Development	Database Projects: Advanced Topics
15:15:00	Andy Warren	Professional Development	The DBA Career Path - An Open Discussion
15:15:00	Amy Herold	Enterprise Database Administration Deployment	Hi, my name is Powershell, let's be friends! An Intro to PoSH
15:15:00	Kendal Van Dyke	Enterprise Database Administration Deployment	Making Database Development and Deployments Easier With SQL Server Data Too
15:15:00	Josh Luedeman	Advanced Analytics Techniques	Show me whatcha workin' with: Big Data Edition
16:30:00	Jeff Taylor	Application Database Development	What's New In SQL Server 2012/2014/2016 For The Developer
16:30:00	Ronald Dameron	Enterprise Database Administration Deployment	Monitoring and Alerting for an Azure PaaS application
16:30:00	Troy Gallant	Enterprise Database Administration Deployment	Supercharge Your Maintenance Plans!
16:30:00	Eric Wisdahl	Application Database Development	An Introductory Look at Execution Plans
16:30:00	Ryan Fonnett	BI Information Delivery	R Integration in Microsoft Solutions
16:30:00	Jennifer McCown	Application Database Development	Designing Stored Procedure Solutions
16:30:00	Rob Volk	Enterprise Database Administration Deployment	Revenge: The SQL!

SessionID: 50442

Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Keleher

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract:

As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can't decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

SessionID: 50616

Advanced Power BI: Solving the Hard Problems

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Devin Knight

Title: Advanced Power BI: Solving the Hard Problems

Abstract:

By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real world problems with Power BI.

SessionID: 50712

How to be a GREAT DBA

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Professional Development

Speaker: Jeffrey Garbus

Title: How to be a GREAT DBA

Abstract:

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

SessionID: 50828

Introduction to Fog Analytics

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: John Wang

Title: Introduction to Fog Analytics

Abstract:

This session will provide an overview of Fog Analytics and their frameworks: Azure IoT Suite and ConnectTheDots.io. Fog Analytics is applying analytics to the data generated by Internet of Things (IoT) devices in real-time.

SessionID: 52572

Data Partitioning for Database Architects and Mere Mortals

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Dmitri Korotkevitch

Title: Data Partitioning for Database Architects and Mere Mortals

Abstract:

Data partitioning is an essential technique that simplifies database administration tasks, improves system availability and reduces the cost of the solution. Contrary to popular belief, data partitioning is not limited to partitioned tables and the Enterprise Edition of SQL Server.

This session demonstrates the data partitioning techniques available in the various editions of SQL Server. It discusses benefits, downsides and the best use-cases for partition tables, local and distributed partitioned views and stretch databases. The session will also demonstrate how data partitioning helps boost performance of systems handling a mixed workload, improves cardinality estimations with large tables, and reduces the system’s storage cost.

Finally, the session provides a set of guidelines on how to split the data between relational and non-relational storages in OLTP and IoT systems hosted in the Cloud.

SessionID: 53019

RESTful JSON API Microservices and SQL Server

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Jared Nielsen

Title: RESTful JSON API Microservices and SQL Server

Abstract:

Transforming your enterprise or startup using micro services that rely on SQL Server data can be a challenge. There are so many options out there. I will introduce how you can jump into API driven develop with lightning fast frameworks that make your job easy and simple. Explore how we leverage Entity Framework to quick start your data models with code-first prototyping. Then we will explore how to transition back when you're ready for deployment. SQL Server offers native tools for JSON support in the newest 2016 release but if you don't have that luxury we'll explore legacy versions as well. API driven development can transform your software development lifecycle so join me as we get you going in the right direction with the latest frameworks and tools. Source code will be provided of a standard API framework with a real data model to accompany your efforts. We will also touch on OAuth 2.0, Unit Testing, and Continuous Integration (CI) for truly streamlined SQL powered apps.

SessionID: 54643

Cortana Intelligence Suite

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Shannon Lowder

Title: Cortana Intelligence Suite

Abstract:

The Cortana Intelligence suite is evolving every day. What began as data blob stores, no-sql providers, and SQL VMs, has grown into a full suite of offerings from Microsoft. Today you can build your entire data platform with ala carte purchases from Microsoft. In this session, I’d like to give you an overview of the services available as of the date of this presentation. I’ll also share with you some ways the different offerings have been used in products I’ve worked on in the past, as well as some insights into how it will be used in the future.

SessionID: 55024

Power BI Data Governance - Protecting Business Data

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ernie Wise

Title: Power BI Data Governance - Protecting Business Data

Abstract:

This session allows companies to think about the security and architecture of their Power BI deployment. Power BI is self service analytics. Users are quick to create a group work spaces without any thought. IT and organizations need to design a business friendly architecture that protects the business data without impacting the users ability to build their reports and dashboards. Users are also quick to change the data model or report without thinking of the negative impact. A strategy for delivering the changes needs to be put into place. This prevents presenting invalid reports or dashboards during the development or advancement stage of updating reports and dashboards.

SessionID: 55074

SQL Internals , Recovery Models, Backups! OH MY

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bradley Ball

Title: SQL Internals , Recovery Models, Backups! OH MY

Abstract:

The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? This is an introduction to these concepts. In this session you will learn about the internal Structure, Recovery Modes, and Backups and be better prepared to for Future Learning and Managing SQL!

SessionID: 56233

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 12-11-2016 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 50355

Data Quality Services - Integrating your Data Steward

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: miguel Cebollero

Title: Data Quality Services - Integrating your Data Steward

Abstract:

This session will take you through some of the basics of setting up DQS and how to get started. Beyond the technical work required to setup DQS, there is the Data Steward and their role in the day to day interactions with DQS. This session will explain how to integrate the Data Steward into the process to approve and correct data, in addition to how to integrated those corrections back into your data warehouse loads.

SessionID: 50769

Index Sql Server databases for high performance

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Valentin Iamandi

Title: Index Sql Server databases for high performance

Abstract:

1. Missing indexes for queries and sprocs

2. Rank missing indexes based on logical reads and/or execution time
3. Record missing indexes and query plans for later analysis
4. Verify indexing results
5. Stackoverflow big database used with examples

SessionID: 52860

Azure, PowerShell, and SQL Server Virtual Machines

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Azure, PowerShell, and SQL Server Virtual Machines

Abstract:

While the web portal makes it easy to deploy SQL Server on Azure Virtual Machines, there are a number of benefits to using PowerShell to do the job. This session will introduce Azure PowerShell command-lets and how to create a basic Azure infrastructure to support a SQL Server VM. We'll include the Azure Resource Manager, how to use ARM VM templates and Custom Script Extension, and how users can modify an existing Azure Gallery template. Desired State Configuration (DSC) will be covered to complete the Azure Powershell automation toolkit, allowing attendees to automate the deployment of dozens or more SQL Server virtual machines. Finally, we will configure Availability Groups and explain their eccentricities in the Azure environment as well as how to make them work effectively.

SessionID: 52880

SQL Server 2014 Column Store Index vNEXT

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: SQL Server 2014 Column Store Index vNEXT

Abstract:

The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it's underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.

SessionID: 53153

Real World Lessons from Starting a Software Company

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Professional Development

Speaker: Brian Knight

Title: Real World Lessons from Starting a Software Company

Abstract:

While starting Pragmatic Works and other companies, Brian (as with others) made a lot of na#239;ve mistakes. In this session, he will share with you the pitfalls he found when starting a business and managing a team of developers and consultants. Learn how to create a culture in your organization or team that will help you retain employees and help your team stand out. Learn some of the mistakes that most leaders make when starting a company. Finally, learn how to turn your idea into reality and grab your first customers.

SessionID: 54898

Query Optimizer Changes in SQL Server 2016

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitry Pilugin

Title: Query Optimizer Changes in SQL Server 2016

Abstract:

SQL Server 2016 brings us a lot of new and even revolutionary features, which is very exciting. However, the core components keep evolving too. One of these components is Query Optimizer, the most complicated, crucial and less understandable part of SQL Server.

The session will make a deep dive into the Query Optimizer internals and show some changes and new features of the SQL Server 2016. This will help you to understand how works the optimization process and certain features, and what changes you may came across in the query plans if you upgrade to SQL Server 2016.

SessionID: 55033

Effortless Backups with Minion Backup

Back to calendar

Event Date: 12-11-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: Effortless Backups with Minion Backup

Abstract:

Minion Backup is a stand-alone backup solution that can be deployed on any number of servers, for free. Once installed, Minion Backup (or just, MB) automatically backs up all online databases on the SQL Server instance, and will incorporate databases as they are added or removed.

While the solution is designed to be as simple as possible to get up and running, MB is deeply configurable for every backup scenario. In this session, attendees will learn about:

• Live Insight, which displays the status and progress of backups as they're running
• Backing up to Azure
• Striping, mirroring, copying, and/or moving backups to various destinations
• Flexible backup delete and archiving options
• Dynamic Backup Tuning, which changes tuning settings based on your custom thresholds
• Backing up certificates and passwords
• High Availability and Disaster Recovery features, including compatibility with Availability Groups
• Shrink log file on log backup, and some of the associated considerations

SessionID: 50352

MICROSOFT: SQL Server 2016 Stretch Database

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Anthony van Gemert

Title: MICROSOFT: SQL Server 2016 Stretch Database

Abstract:

Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant.

#160; There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. #160; Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!

SessionID: 50711

Bad, less Bad, not Bad; rewriting bad SQL Code

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Jeffrey Garbus

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract:

This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code "bad"

SessionID: 52856

Planning and Executing a Successful SQL Server Database Migration

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Carlos Colon

Title: Planning and Executing a Successful SQL Server Database Migration

Abstract:

Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing.

In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done about it), and pitfalls to avoid during the development, testing, and final implementation.

SessionID: 53135

SQL Writing SQL

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Tom Staab

Title: SQL Writing SQL

Abstract:

Have you ever had to move every object in a schema to a different schema? What about dropping and recreating a set of constraints to allow you to alter a dependent table? This session will demonstrate ways to use T-SQL and various catalog views to dynamically generate SQL statements that can save you time and effort in what would otherwise be tedious, manual tasks. I will provide a background followed by some examples and then open the floor to questions.

SessionID: 54860

I See What You Did There - Automating Auditing in SQL Server

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Advanced Analytics Techniques

Speaker: Rodney Landrum

Title: I See What You Did There - Automating Auditing in SQL Server

Abstract:

You are a DBA, not a psychic. If you want to know who is making changes, trying to access confidential data, or unsuccessfully attempting to login as the Web service account on any or all of the SQL Server instances you manage; you don’t need a crystal ball to gain the power of insight. However, if you follow along in this presentation you will be able to use the magic of SQL Server Audit to peer into the past with Power View and tell the professional future of the unwary soul who crossed your path. None shall PASS!

SessionID: 56391

Tone Analysis with HDInsight and Azure Machine Learning

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: Advanced Analytics Techniques

Speaker: Paco Gonzalez

Title: Tone Analysis with HDInsight and Azure Machine Learning

Abstract:

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning

SessionID: 56462

Row-level Security in SSRS and SSAS

Back to calendar

Event Date: 12-11-2016 - Session time: 11:30:00 - Track: BI Information Delivery

Speaker: Chris Hyde

Title: Row-level Security in SSRS and SSAS

Abstract:

It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we'll investigate a real-world solution to this common BI problem.

SessionID: 54797

Plan Explorer 3.0 Webinar

Back to calendar

Event Date: 12-11-2016 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bradley Ball

Title: Plan Explorer 3.0 Webinar

Abstract:

In this video, renowned query tuning expert and Microsoft Data Platform MVP Aaron Bertrand looks at the brand new release of SQL Sentry Plan Explorer, the industry’s most popular free query tuning tool. If you’ve ever struggled with performance troubleshooting SQL queries or had trouble figuring out what was happening behind the scenes with the query optimizer, this video is for you.

Learn about new features that will help you solve vexing execution plan problems, and see how Plan Explorer can take you from novice to expert in record time!

SessionID: 54804

SQL Server Performance Best Practices

Back to calendar

Event Date: 12-11-2016 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dominick DeQuarto

Title: SQL Server Performance Best Practices

Abstract:

2016 is the year of All-Flash for primary storage and DELL EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, DELL EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

SessionID: 50630

Creating Reports and Dashboards with Power BI

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Creating Reports and Dashboards with Power BI

Abstract:

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization. It will also touch a little on why you might choose Power BI over Power Pivot and why you might not. It will also look at how to create drill down detail screens to expose the details behind your visualizations. Finally, we will touch on how to publish your Power BI results for others in your organization to share. A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.

SessionID: 51143

Does your performance tuning need a 12-step program?

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Does your performance tuning need a 12-step program?

Abstract:

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

1. Quickly fine tune a SQL statement
2. Identify performance inhibitors to help avoid future performance issues
3. Recognize and understand how new SQL Server features can help improve query
   performance

SessionID: 52877

Unit Testing SQL Server

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Unit Testing SQL Server

Abstract:

In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

SessionID: 53076

Free tools from the SQL Server Community

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Wisdahl

Title: Free tools from the SQL Server Community

Abstract:

No budget? That's OK! Need Tools? We've get them! Don't know where to go? We'll show you! The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out. In this session we will show you several great tools, scripts, blogs and other resources to help you out. Best of all, it's all free! But wait, there's more. Order now and we'll include an extra two tips at no additional cost!

SessionID: 53147

Combining SQL Server and R

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Robert Biddle

Title: Combining SQL Server and R

Abstract:

SQL Server 2016 now includes a feature called SQL Server R Services. This feature allows for direct integration between database and the R statistical language. In this session we'll look at some of the R and SQL integration features, then we will build a machine learning model and then use that model for scoring and predictive analytics.

SessionID: 54798

Tips and Tricks for Reporting Services

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Pam Shaw

Title: Tips and Tricks for Reporting Services

Abstract:

Taking the Scare out of Monster Reports

Exploring new Frontiers with Power BI

SessionID: 54837

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

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00: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: 54907

Use Biml to Automate SSIS Design Patterns

Back to calendar

Event Date: 12-11-2016 - Session time: 14:00: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: 50364

Intelligent Indexing

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Arvin Meyer

Title: Intelligent Indexing

Abstract:

Using indexing to improve performance

SessionID: 50721

What’s New in SQL Server 2016 ?

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Gareth Swanepoel

Title: What’s New in SQL Server 2016 ?

Abstract:

SQL Server 2016 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always Encrypted, Enhancements to In-Memory OLTP tables and enhancements to AlwaysOn. If you are a SQL Server DBA or developer, an architect, or an IT professional who is excited about the new SQL Server 2016 features and are looking forward to learn more about them, this session is for you.

SessionID: 50816

R For the SQL Server Developer

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15: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: 51132

Hands-on with U-SQL and Azure Data Lake Analytics

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Jason Brugger

Title: Hands-on with U-SQL and Azure Data Lake Analytics

Abstract:

U-SQL is the query language for big data analytics on the Azure Data Lake platform. This session will explore the unification of SQL and C# in this new query language, examples of combining data from external sources such as Azure SQL Database and Blob storage with Azure Data Lake Store, creating and referencing assemblies, job submission and tools. The ADL platform will also be compared and contrasted to the HDInsight/Hadoop platform.

SessionID: 52655

Database Projects: Advanced Topics

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Jonathon Moorman

Title: Database Projects: Advanced Topics

Abstract:

A dive into database project details. This demo heavy presentation will look at configuring database projects, building and publishing, deployment scripts, using SqlCmd variables, and (time permitting) creating unit tests. This session will also look at composite projects to logically break apart a database solution.

SessionID: 54604

The DBA Career Path - An Open Discussion

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Professional Development

Speaker: Andy Warren

Title: The DBA Career Path - An Open Discussion

Abstract:

Join Andy Warren for an open discussion of the challenges and rewards of being a DBA and what the next step on the career path. Is it managing more and larger databases? Working on life critical systems? Moving into management? Or does our path take us more towards BI, or DevOps? No slides, just a lightly moderated discussion!

SessionID: 54607

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 54624

Making Database Development and Deployments Easier With SQL Server Data Too

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendal Van Dyke

Title: Making Database Development and Deployments Easier With SQL Server Data Too

Abstract:

Tooling for database development and deployment is often a cause for frustration. Developers don't like using Management Studio because it's an administrative tool that doesn't offer the full Visual Studio experience. DBAs want an automated, consistent, and reliable way to deploy changes without having to write custom scripts every time. Enter SQL Server Data Tools (SSDT), a free set of tools from Microsoft that spans all phases of the database lifecycle from development to deployment while relieving both Developer and DBA pain along the way. In this introductory level session you'll learn what SSDT it, how it works, and how to implement it in your environment.

SessionID: 55078

Show me whatcha workin' with: Big Data Edition

Back to calendar

Event Date: 12-11-2016 - Session time: 15:15:00 - Track: Advanced Analytics Techniques

Speaker: Josh Luedeman

Title: Show me whatcha workin' with: Big Data Edition

Abstract:

Congratulations. You've setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we're gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we'll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

SessionID: 50581

What's New In SQL Server 2012/2014/2016 For The Developer

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: What's New In SQL Server 2012/2014/2016 For The Developer

Abstract:

This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.

SessionID: 50922

Monitoring and Alerting for an Azure PaaS application

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ronald Dameron

Title: Monitoring and Alerting for an Azure PaaS application

Abstract:

The support of PaaS applications is a challenging task. These systems consist of multiple loosely coupled cloud services and components using a Service Oriented Architecture. You must monitor their availability and resource usage along with overall system health via custom End-to-End tests.

This session will show how to setup and configure monitoring and alerting on individual components in both the Azure portal and Application Insights including an operational dashboard that ensures the PaaS application remains healthy and available.

SessionID: 52673

Supercharge Your Maintenance Plans!

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30: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: 53077

An Introductory Look at Execution Plans

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Eric Wisdahl

Title: An Introductory Look at Execution Plans

Abstract:

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.

SessionID: 54623

R Integration in Microsoft Solutions

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: BI Information Delivery

Speaker: Ryan Fonnett

Title: R Integration in Microsoft Solutions

Abstract:

Session Abstract: R is a very powerful tool that is used for statistical computing and graphics. R has been adopted by many data scientists around the world and after Microsoft's Revolution Analytics R acquisition is integrated in Microsoft solutions. This introductory session will give a brief history on R and then explain how this popular statistical language is now baked into some of the Microsoft tools such as SQL Server, Power BI, and Azure ML. There will be live demoes that will explain how R can be utilized using each tool.

SessionID: 55035

Designing Stored Procedure Solutions

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 56564

Revenge: The SQL!

Back to calendar

Event Date: 12-11-2016 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

This site is open source. Improve this page.