Nr: 452
SQLSaturday #452 - Charlotte 2015
SessionID: 37624
Crash course on becoming better SQL Developer.
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:
SessionID: 37632
SSIS 2014 Data Flow Tuning Tips and Tricks
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:
SessionID: 37862
PowerShell Basics for SQLServer
Event Date: 17-10-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Michael Wharton
Title: PowerShell Basics for SQLServer
Abstract:
SessionID: 38134
SQL Clinic
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
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
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
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
- Installation of R and R Studio
- R basics
- Power of R
- Getting data from databases and other sources.
- Managing Data frame using Package dplyr
- Visualization of Data using Graphic Package ggplots2
- In-Database R in Sql Server 2016
SessionID: 40152
Tone Analysis with HDInsight and Azure Machine Learning
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
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:
SessionID: 37638
Scripting out SQL Server for Documentation and Disaster Recovery
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:
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
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
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
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
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:
SessionID: 40077
Trust Your Data with Data Quality Services
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
Event Date: 17-10-2015 - Session time: 10:15:00 - Track: Other
Speaker: Brian Carrig
Title: Planning for Virtualization
Abstract:
SessionID: 37636
Table Partitioning Intro and make that a sliding window too!
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
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
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.
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
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
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!
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!
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:
SessionID: 40879
Looking for the Power BI on-prem alternative?
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
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
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
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
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
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?
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:
SessionID: 38813
There May Be No Free Lunch But You Can Have Free Training
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
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
Event Date: 17-10-2015 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Melvin Black
Abstract:
SessionID: 40008
Event Date: 17-10-2015 - Session time: 13:45:00 - Track: Other
Speaker: Mark Hudson
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
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
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
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:
SessionID: 41074
SQL Server and Azure
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
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!
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
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
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
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
Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Patrick Keisler
Abstract:
SessionID: 39608
Getting Started With Execution Plans
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
Event Date: 17-10-2015 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
Speaker: Thomas Norman
Title: Beginning Azure
Abstract:
SessionID: 40687
Enhancing Data and Predictive Analytics with NoSQL
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: