sqlsathistory

Nr: 452

Back to Main list

SQLSaturday #452 - Charlotte 2015

Start Time (24h) Speaker Track Title
09:00:00 Vladimir Oselsky Application Database Development Crash course on becoming better SQL Developer.
09:00:00 Andy Leonard BI Platform Architecture, Development Administration SSIS 2014 Data Flow Tuning Tips and Tricks
09:00:00 Michael Wharton Enterprise Database Administration Deployment PowerShell Basics for SQLServer
09:00:00 Harsh Deep Singh Enterprise Database Administration Deployment SQL Clinic
09:00:00 Rick Heiges Enterprise Database Administration Deployment First Look at SQL Server 2016
09:00:00 John Welch BI Platform Architecture, Development Administration Getting Started with SSIS Script Tasks and Components
09:00:00 Kiran Math Analytics and Visualization Introduction To R For Sql Developers
09:00:00 Paco Gonzalez BI Information Delivery Tone Analysis with HDInsight and Azure Machine Learning
10:15:00 Andrew Kelly Enterprise Database Administration Deployment Getting the Skinny on Minimally Logged Operations
10:15:00 George Walkey Enterprise Database Administration Deployment Scripting out SQL Server for Documentation and Disaster Recovery
10:15:00 Lindsay Clark Enterprise Database Administration Deployment Beginners SQL Server Security the Low Hanging Fruit
10:15:00 Bill Anton BI Platform Architecture, Development Administration Analysis Services: Show Me Where It Hurts
10:15:00 Melissa Coates BI Platform Architecture, Development Administration Power BI: Architecture, Integration Points, Implementation Options
10:15:00 Allen White Application Database Development Scalable Application Design with Service Broker
10:15:00 Justin Ward BI Information Delivery Trust Your Data with Data Quality Services
10:15:00 Brian Carrig Other Planning for Virtualization
11:30:00 Jeff Reinhard Enterprise Database Administration Deployment Table Partitioning Intro and make that a sliding window too!
11:30:00 Kevin Feasel Other Much Ado About Hadoop
11:30:00 Denis McDowell Enterprise Database Administration Deployment Managing Complex Workloads Using the SQL Server 2014 Resource Governor
11:30:00 Slava Murygin Enterprise Database Administration Deployment Statistics are hidden treasure.
11:30:00 Jake Switzer Analytics and Visualization Introduction to R Programming
11:30:00 Kevin Hazzard BI Information Delivery From T4 to BimlScript
11:30:00 Jason Hall Cloud Application Development Deployment Managing a Production Azure SQL Database - True Story!
11:30:00 Jana Sattainathan Other Small Scale Data Collection Using PowerShell - Going NSA Style!
11:30:00 Mark Scott Analytics and Visualization Looking for the Power BI on-prem alternative?
13:00:00 Gene Webb Sponsored Session Profisee: Learn How To Build A Golden Record for Any Subject
13:00:00 Mark Scott Sponsored Session Pyramid Analytics: Looking for the Power BI on-prem alternative
13:00:00 Scott Fallen Sponsored Session Better Managed Services Through Monitoring with UpSearch and SQL Sentry
13:00:00 Vera Takakura Sponsored Session DELL SQL Server Solutions
13:45:00 Justin Randall Professional Development Building Your Yellow Brick Road: Directing Your Path to a Successful Career
13:45:00 Lori Clark Cloud Application Development Deployment Azure SQL Database - Is it right for my organization?
13:45:00 Meagan Longoria Professional Development There May Be No Free Lunch But You Can Have Free Training
13:45:00 Nate West Application Database Development What's in a Date? Avoiding confusion with Dates, Times, and Durations
13:45:00 Melvin Black BI Platform Architecture, Development Administration Creating a Performance Monitoring Solution for SQL Server BI Suite
13:45:00 Mark Hudson Other Making Predictions with Microsoft Data Mining Tools
13:45:00 Montrial Harrell BI Information Delivery Configuring and using PolyBase to interact with Hadoop
13:45:00 Tracy Boggiano Other Disaster Recovery Where to Begin
13:45:00 Thomas Chan Enterprise Database Administration Deployment Secure/Encrypt SQL Server Database With TDE
13:45:00 Rich Cargile Cloud Application Development Deployment SQL Server and Azure
15:00:00 Ryan Brickey Enterprise Database Administration Deployment Policy Based Management: Introduction and Implementation
15:00:00 Rob Volk Application Database Development Tame Your Unruly Data...With Constraints!
15:00:00 William E Pearson III Analytics and Visualization Introducing Forensic Analytics with PowerPivot for Excel
15:00:00 Leveat Ruse Professional Development Status of the Charlotte IT Marketplace
15:00:00 Stephen Muliokela Other Database Corruption
15:00:00 Patrick Keisler Enterprise Database Administration Deployment No Money for Performance Monitoring Tools? No Problem!
15:00:00 Scott Fallen Enterprise Database Administration Deployment Getting Started With Execution Plans
15:00:00 Thomas Norman Cloud Application Development Deployment Beginning Azure
15:00:00 Cornell Emile Analytics and Visualization Enhancing Data and Predictive Analytics with NoSQL

SessionID: 37624

Crash course on becoming better SQL Developer.

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash course on becoming better SQL Developer.

Abstract:

Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I write modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.

SessionID: 37632

SSIS 2014 Data Flow Tuning Tips and Tricks

Back to calendar

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

Speaker: Andy Leonard

Title: SSIS 2014 Data Flow Tuning Tips and Tricks

Abstract:

Do you want SSIS to go fast? This session is for you! Attend and learn techniques for developing, instrumenting, monitoring, and managing SSIS 2014 Data Flow performance in your data integration enterprise.

SessionID: 37862

PowerShell Basics for SQLServer

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Wharton

Title: PowerShell Basics for SQLServer

Abstract:

Overview of PowerShell and how to perform SQL scripts using PowerShell. In this session you will learn the basics on building scripts using PowerShell and then learn the basics of using PowerShell for SQL server administration.

SessionID: 38134

SQL Clinic

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Harsh Deep Singh

Title: SQL Clinic

Abstract:

If you do not have problems or questions you can just sit in and learn what kind of problems other people have in their environments.

SessionID: 38220

First Look at SQL Server 2016

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Heiges

Title: First Look at SQL Server 2016

Abstract:

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016. We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB. Row Level Security allows you to add another layer of security to your environment. StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.

SessionID: 39109

Getting Started with SSIS Script Tasks and Components

Back to calendar

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

Speaker: John Welch

Title: Getting Started with SSIS Script Tasks and Components

Abstract:

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session for an introduction to the scripting capabilities of SSIS.

Many data movement activities can be handled with SSIS using the built-in tasks and components. Eventually, though, you will run into a scenario that will be better handled by extending SSIS functionality with custom code. In this session, we will cover the basics of using scripts in SSIS control flows and data flows. We’ll talk about the pros and cons of scripts, review the development environment for scripts, cover some interesting and useful .NET classes, and walk through multiple examples of scripts that add useful functionality to SSIS.

SessionID: 39840

Introduction To R For Sql Developers

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Kiran Math

Title: Introduction To R For Sql Developers

Abstract:

In this session we will explore

  1. Installation of R and R Studio
  2. R basics
  3. Power of R
  4. Getting data from databases and other sources.
  5. Managing Data frame using Package dplyr
  6. Visualization of Data using Graphic Package ggplots2
  7. In-Database R in Sql Server 2016

SessionID: 40152

Tone Analysis with HDInsight and Azure Machine Learning

Back to calendar

Event Date: 17-10-2015 - Session time: 09:00:00 - Track: BI Information Delivery

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

Getting the Skinny on Minimally Logged Operations

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Kelly

Title: Getting the Skinny on Minimally Logged Operations

Abstract:

Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the database. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know these can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.

SessionID: 37638

Scripting out SQL Server for Documentation and Disaster Recovery

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Scripting out SQL Server for Documentation and Disaster Recovery

Abstract:

Most DBAs need to 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 exportable and 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 moving or recovering a SQL server instance 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, and Server Triggers

SessionID: 37828

Beginners SQL Server Security the Low Hanging Fruit

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Lindsay Clark

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract:

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.

SessionID: 38511

Analysis Services: Show Me Where It Hurts

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Anton

Title: Analysis Services: Show Me Where It Hurts

Abstract:

"Its.Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!")

What's slow? Since when? Compared to what?

Join this "something-everyone-should-be-doing-but-isn't" session, in which we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.

SessionID: 39370

Power BI: Architecture, Integration Points, Implementation Options

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Power BI: Architecture, Integration Points, Implementation Options

Abstract:

In this session we will review Power BI V2 architecture and integration points with corporate data sources, SaaS services, Azure, and third party apps. We will examine and demonstrate key capabilities in the Power BI web-based service, Power BI Desktop, Excel, and mobile apps. Implementation options for Power BI involving cloud, on-premises, and hybrid approaches will be explored. Finally, the concept of "Bimodal BI" will be introduced with use cases for how Power BI might be utilized for both self-service BI and certain corporate BI initiatives.

SessionID: 39794

Scalable Application Design with Service Broker

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Allen White

Title: Scalable Application Design with Service Broker

Abstract:

How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.

SessionID: 40077

Trust Your Data with Data Quality Services

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: BI Information Delivery

Speaker: Justin Ward

Title: Trust Your Data with Data Quality Services

Abstract:

This session will step through the fundamentals that go into assessing existing data quality issues as well as an introduction on how to use Microsoft's Data Quality Services to address those issues. The presentation will begin by discussing techniques to uncover pain points that may currently exists within your data. We will step through techniques for stakeholder discussions and things to look for when profiling your data. In the second half of the session, we will transition into a demo that introduces the capabilities of Data Quality Services. I will discuss the major functions of Data Quality Services such as, Knowledge Bases, domains, and matching. My goal at the end of the session is for each participant to have a good baseline understanding of what to look for when assessing quality within their data, as well as, how to begin solving the issues they find.

SessionID: 40193

Planning for Virtualization

Back to calendar

Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Other

Speaker: Brian Carrig

Title: Planning for Virtualization

Abstract:

This session will serve as a guide for database administrators who are considering virtualizing their SQL server instances (or are about to have that decision thrust upon them) and are unsure of the best approach. It will cover the basics of how to configure a virtualized environment for SQL server, make you aware of some of the common performance pitfalls and help to dispel some of the myths around managing database availability in a virtualized environment. At the end of the session you should have a good idea as to whether virtualization is the right choice for your database environment and a broad strategy for how to go about implementing it.

SessionID: 37636

Table Partitioning Intro and make that a sliding window too!

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Reinhard

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

Abstract:

A walk-through of creating a sliding window table partition on an AdventureWorks table.

SessionID: 37707

Much Ado About Hadoop

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Other

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

SessionID: 37829

Managing Complex Workloads Using the SQL Server 2014 Resource Governor

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Denis McDowell

Title: Managing Complex Workloads Using the SQL Server 2014 Resource Governor

Abstract:

The Resource Governor is a key SQL Server technology for managing competing workloads. New capabilities designed to provide greater flexibility in resource management have been added in SQL Server2012 and SQL Server 2014. As organizations consolidate their SQL architectures, effective management of compute and disk resources becomes more difficult. This session will detail Resource Governor functions as well as demos to illustrate advanced workload management using the SQL 2014 Resource Governor.

SessionID: 37875

Statistics are hidden treasure.

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Slava Murygin

Title: Statistics are hidden treasure.

Abstract:

What are statistics? Why do we need statistics? How we can use statistics for our advantage?

I'll show you the case, along with walking through statistics, execution plans, plan cache and query hints.

Also, will show how to use statistics in your day-to-day life and benefit from it.

SessionID: 38093

Introduction to R Programming

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: Jake Switzer

Title: Introduction to R Programming

Abstract:

SessionID: 39007

From T4 to BimlScript

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: BI Information Delivery

Speaker: Kevin Hazzard

Title: From T4 to BimlScript

Abstract:

This session is for database and application developers who know Microsoft's T4 (Text Template Transformation Toolkit) from Visual Studio but would like to make the transition to the powerful BimlScript language for generating SSIS and SSAS projects dynamically. Business Intelligence Markup Language (Biml) and BimlScript let you tap into the rich metadata of your SQL Server databases, multiplying your efficiency and accuracy many times over. During this highly-interactive session, we'll leverage your familiarity with template-based code generators like T4, comparing its features to BimlScript to tackle some difficult Business Intelligence tasks in a fraction of the time it would normally take. If you don't know T4, any prior experience with template-based code generators will prepare you well for this session. Moreover, if you've never done dynamic code generation before, you may still find this session fascinating and a quite useful addition to your toolbox.

SessionID: 39459

Managing a Production Azure SQL Database - True Story!

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Cloud Application Development Deployment

Speaker: Jason Hall

Title: Managing a Production Azure SQL Database - True Story!

Abstract:

I develop for and manage a small, but active, web application that lives completely inside of Azure from code to data. I've been involved with it since inception, and I've learned a few things about developing for, and managing data in this environment the hard way.

I'd like to share some of the lessons I've learned in hopes that it can save others some time.

SessionID: 40194

Small Scale Data Collection Using PowerShell - Going NSA Style!

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Other

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

Looking for the Power BI on-prem alternative?

Back to calendar

Event Date: 17-10-2015 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: Mark Scott

Title: Looking for the Power BI on-prem alternative?

Abstract:

Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!

Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.

SessionID: 41338

Profisee: Learn How To Build A Golden Record for Any Subject

Back to calendar

Event Date: 17-10-2015 - Session time: 13:00:00 - Track: Sponsored Session

Speaker: Gene Webb

Title: Profisee: Learn How To Build A Golden Record for Any Subject

Abstract:

Attend the lunch demo and see how you can use Master Data Services and Maestro to:

o Create a golden record for any subject area in a matter of minutes o Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment? o Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything? o Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting o Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise

SessionID: 41339

Pyramid Analytics: Looking for the Power BI on-prem alternative

Back to calendar

Event Date: 17-10-2015 - Session time: 13:00:00 - Track: Sponsored Session

Speaker: Mark Scott

Title: Pyramid Analytics: Looking for the Power BI on-prem alternative

Abstract:

Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. We will discuss architecture considerations; use cases; integration points with Power BI, SharePoint on-prem, and SSRS; Tabular Modeling on-the-fly; and even consumption of data from Azure ML!

Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and hear about how you can do all of this and more with Pyramid Analytics’ BI Office suite.

SessionID: 41342

Better Managed Services Through Monitoring with UpSearch and SQL Sentry

Back to calendar

Event Date: 17-10-2015 - Session time: 13:00:00 - Track: Sponsored Session

Speaker: Scott Fallen

Title: Better Managed Services Through Monitoring with UpSearch and SQL Sentry

Abstract:

In this presentation Brian Davis and Scott Fallen will demonstrate how SQL Sentry tools help UpSearch and their managed services customers monitor and tune their SQL Servers. Brian is a SQL Server Consultant for UpSearch, and Scott is a Sales Engineer for SQL Sentry. During the presentation, we will look at baselining, performance bottleneck identification, query tuning, alerting, and automated response with SQL Sentry in the context of how the team at UpSearch leverages these features. We will conclude with a demo of some of the powerful features of SQL Sentry Plan Explorer FREE.

SessionID: 41343

DELL SQL Server Solutions

Back to calendar

Event Date: 17-10-2015 - Session time: 13:00:00 - Track: Sponsored Session

Speaker: Vera Takakura

Title: DELL SQL Server Solutions

Abstract:

Your organization relies on SQL Server to support its applications, customers and employees. But to maintain productivity, control costs and protect data, your SQL Server environment must be up and running, effectively supported and secured. Come see how DELL SQL Server Solutions increase productivity, reduce costs and protect data in your SQL Server environment.

SessionID: 37672

Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Professional Development

Speaker: Justin Randall

Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Abstract:

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.

SessionID: 38487

Azure SQL Database - Is it right for my organization?

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Lori Clark

Title: Azure SQL Database - Is it right for my organization?

Abstract:

Azure SQL Database is now based on the same bits as SQL Server 2014, bringing great enterprise capabilities. We will discuss business continuity features such as geo restore, point-in-time recoveries, and how to recover a deleted database with only a few clicks. No more retrieving tapes from you off-site backup vault! Learn how easy it is to configure a geo-replicated solution which allows for both disaster recovery and readable secondaries. Use the built-in SQL Server Management Studio wizard to migrate your on-premises databases into Azure SQL Database.

SessionID: 38813

There May Be No Free Lunch But You Can Have Free Training

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Professional Development

Speaker: Meagan Longoria

Title: There May Be No Free Lunch But You Can Have Free Training

Abstract:

Did you know that you don't have to wait until the next PASS Summit or BA Conference to get more training? If your company can't send everyone to the big conferences every year, it definitely doesn't mean you have to go without keeping up your skills or increasing your knowledge. You've found your way to SQL Saturday, and that's a great first step. But there is so much more out there. I'll share with you free resources including blogs, user groups, PASS virtual chapters, Twitter, Linked In, online forums, and other websites. These resources will help you stay connected to the SQL/BI community year-round so you can continue to increase your skills without draining your company's training budget or your wallet.

SessionID: 39719

What's in a Date? Avoiding confusion with Dates, Times, and Durations

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Nate West

Title: What's in a Date? Avoiding confusion with Dates, Times, and Durations

Abstract:

Dates and Times can be very confusing. Julian Days, Fiscal Years Months, UTC, Atomic Time, Leap Seconds, ISO 8601, and more clutter up what, on the surface, appears to be a simple set of data types. This session will work to demystify dates and times, with a focus on SQL Server. It will cover the pros and cons of each of SQL Server's date/time data types, why you need a Calendar table in almost every database (and maybe a Time table too), various good methods of handling intervals and durations, how to use the IANA tzdata database to help with time zones daylight savings. As a bonus, if we have time, we'll also talk about SQL Server 2016's Temporal tables and what they mean for the current/history table pattern.

SessionID: 39824

Creating a Performance Monitoring Solution for SQL Server BI Suite

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melvin Black

Title: Creating a Performance Monitoring Solution for SQL Server BI Suite

Abstract:

These talks discuss using the native Windows performance tools System Monitor and WMI technology to create logs that track the overall performance of SSIS, SSAS, and SQL Server. This will be a deep dive into Windows Performance Monitoring and WMI tools that are native to all Windows Operating Systems and how they can be used to track and monitor your SQL applications. I will discuss memory utilization, counters, WMI classes, and threading that is collected during SQL operations within the Windows OS. I will also show you how to collect this data manually or via automated schedule and export it for later evaluation or logging

SessionID: 40008

Making Predictions with Microsoft Data Mining Tools

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Other

Speaker: Mark Hudson

Title: Making Predictions with Microsoft Data Mining Tools

Abstract:

Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.

SessionID: 40009

Configuring and using PolyBase to interact with Hadoop

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Montrial Harrell

Title: Configuring and using PolyBase to interact with Hadoop

Abstract:

In this session, we are going to connect to a fully deployed Hadoop Cluster using PolyBase and Power BI. We will go over the Pros vs Cons of using this solution and what use cases this architecture fits.

SessionID: 40024

Disaster Recovery Where to Begin

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Other

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

Secure/Encrypt SQL Server Database With TDE

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Secure/Encrypt SQL Server Database With TDE

Abstract:

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

SessionID: 41074

SQL Server and Azure

Back to calendar

Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Rich Cargile

Title: SQL Server and Azure

Abstract:

SQL Server 2014\2016 is on the edge of one of the larger revolutions in Database technologies in the recent past. The reason is that we have a new technology out there, and your may have heard of it, it’s called the cloud. Microsoft's version of cloud technologies is called Azure.

In this session, we will learn some details of using SQL Server 2014 with Azure, as well as Azure Database as a Service. In addition, we’ll explore some of the new, improved features available in SQL Server 2016. We’ll explore how SQL Server integrates with Azure, and how you can put one toe in the water and get started integrating the cloud into your organization.

SessionID: 37681

Policy Based Management: Introduction and Implementation

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00: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: 37691

Tame Your Unruly Data...With Constraints!

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data...With Constraints!

Abstract:

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

SessionID: 37727

Introducing Forensic Analytics with PowerPivot for Excel

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: William E Pearson III

Title: Introducing Forensic Analytics with PowerPivot for Excel

Abstract:

Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.

In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.

SessionID: 39141

Status of the Charlotte IT Marketplace

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Status of the Charlotte IT Marketplace

Abstract:

SessionID: 39157

Database Corruption

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Other

Speaker: Stephen Muliokela

Title: Database Corruption

Abstract:

Database corruption could happen to you. This could potentially be one of the worst nightmares you could experience in the database world. In this session I will be talking about what database corruption is. I will also give a lesson on how dbcc works and the limitation of it. I will give examples of database corruption and how to resolve them.

I will also give examples of how to verify integrity of backups. Backups are essentially the last resort for resolving database corruption.

SessionID: 39401

No Money for Performance Monitoring Tools? No Problem!

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Keisler

Title: No Money for Performance Monitoring Tools? No Problem!

Abstract:

So you like the idea of using one of the commercially available performance monitoring tools but can’t convince your boss to spend the money? Then join me as we explore some absolutely free tools born right out of Microsoft’s customer support teams: DiagManager and SQLNexus. We will see just how easy it is to use them to collect and analyze performance data from your SQL Servers. These tools can get you started quickly without having to deal with the red tape.

SessionID: 39608

Getting Started With Execution Plans

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Scott Fallen

Title: Getting Started With Execution Plans

Abstract:

Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

SessionID: 39959

Beginning Azure

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00: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: 40687

Enhancing Data and Predictive Analytics with NoSQL

Back to calendar

Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Cornell Emile

Title: Enhancing Data and Predictive Analytics with NoSQL

Abstract:

The pervasiveness of Big Data has created significant challenges for companies that have historically utilized relational database management systems to perform data analysis and predictive analytics. This presentation outlines the challenges that stem from Big Data as it relates to deriving value from data, the types of NoSQL data stores available and how NoSQL can serve as a data platform that enhances the data analysis and predictive analytics capabilities of companies.