Nr: 480
SQLSaturday #480 - Nashville 2016
SessionID: 40742
Cleaning House: The Indexing Edition
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Database Administration
Speaker: Andy Yun
Title: Cleaning House: The Indexing Edition
Abstract:
SessionID: 40985
Turbo-Charged Transaction Logs
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Database Administration
Speaker: David Maxwell
Title: Turbo-Charged Transaction Logs
Abstract:
SessionID: 41293
The Next Dimension of Data
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: BI Analytics Visualization
Speaker: Dave Mattingly
Title: The Next Dimension of Data
Abstract:
Send your data on a journey through space and time, while engaging your audience’s senses to tell its story.
SQL Server’s geospatial datatype offers pinpoint accuracy and many advanced location-aware capabilities, such as shapes, overlaps, distances, and direction. The Power Map feature can turn your addresses and supporting figures into a movie.
Turn your facts and figures into a compelling story by entering geospace: the final frontier.
SessionID: 41536
Mastering and Enhancing Company Data
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: BI Analytics Visualization
Speaker: Rushabh Mehta
Title: Mastering and Enhancing Company Data
Abstract:
SessionID: 41567
Encrypting Data within Sql Server
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Thomas Norman
Title: Encrypting Data within Sql Server
Abstract:
Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.
SessionID: 41661
XML Without Xanax: How to Handle XML in SQL Server
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Adam Belebczuk
Title: XML Without Xanax: How to Handle XML in SQL Server
Abstract:
Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.
SessionID: 42206
Building Your Yellow Brick Road: Directing Your Path to a Successful Career
Event Date: 16-01-2016 - Session time: 08:30: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: 42215
Row-level Security in SSRS and SSAS
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: BI Architecture Management
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: 42227
Let Me Finish... Isolating Write Operations
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Louis Davidson
Title: Let Me Finish... Isolating Write Operations
Abstract:
SessionID: 42235
Powershell Jumpstart for SQL Server DBAs
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: PowerShell
Speaker: Michael Fal
Title: Powershell Jumpstart for SQL Server DBAs
Abstract:
SessionID: 42350
Show me whatcha workin' with: Big Data Edition
Event Date: 16-01-2016 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment
Speaker: Josh Luedeman
Title: Show me whatcha workin' with: Big Data Edition
Abstract:
SessionID: 40746
Beginners SQL Server Security the Low Hanging Fruit
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Administration
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: 40787
Looking for the Power BI on-prem alternative?
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: BI Analytics Visualization
Speaker: Mark Scott
Title: Looking for the Power BI on-prem alternative?
Abstract:
SessionID: 40939
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Jeff Foushee
Abstract:
SessionID: 41143
Tame the sibling rivalry of the Lock, Block, Deadlock sisters
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Application Development
Speaker: William Wolf
Title: Tame the sibling rivalry of the Lock, Block, Deadlock sisters
Abstract:
Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.
We will review locking, blocking and deadlocking. We will review isolation levels. When would be an appropriate time to use each. We will also review how to identify locks and deadlocks and how to lessen the family fighting.
SessionID: 41355
Version control with GIT for the DBA
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Other
Speaker: Justin Dearing
Title: Version control with GIT for the DBA
Abstract:
What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.
In my session. We'll cover:
What is version control?
How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN?
How do I setup git for internal use in my company?
How do I host public and private repositories on github.
How do pull requests work?
How do I fork a SVN repo to github?
We will be covering using git from both the command line and Visual Studio.
SessionID: 41703
Top 10 Wait Types Everyone Should Know
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Administration
Speaker: Janis Griffin
Title: Top 10 Wait Types Everyone Should Know
Abstract:
SessionID: 42064
Maintain SQL Server Performance Baseline w/PowerShell
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: PowerShell
Speaker: Allen White
Title: Maintain SQL Server Performance Baseline w/PowerShell
Abstract:
Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
SessionID: 42095
Use Biml to Automate SSIS Design Patterns
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: BI Architecture Management
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: 42210
Ten Query Tuning Techniques Every SQL Programmer Should Know
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Kevin Kline
Title: Ten Query Tuning Techniques Every SQL Programmer Should Know
Abstract:
SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.
Goal 1: Implement a reusable Transact-SQL test harness for reliable query results.
Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them.
Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.
SessionID: 42259
Using SQL Servers AlwaysOn Availability Groups
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Administration
Speaker: Denny Cherry
Title: Using SQL Servers AlwaysOn Availability Groups
Abstract:
In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the "AlwaysOn" features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.
SessionID: 42262
Social Networking Is Alive!!!
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Professional Development
Speaker: John Morehouse
Title: Social Networking Is Alive!!!
Abstract:
SessionID: 42264
A Quick Peek into the 4th Dimension with T-SQL
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Rodney Landrum
Title: A Quick Peek into the 4th Dimension with T-SQL
Abstract:
Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and Excel to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.
SessionID: 45075
Looking for the Power BI on-prem alternative?
Event Date: 16-01-2016 - Session time: 09:45:00 - Track: BI Analytics Visualization
Speaker: Jason Picker
Title: Looking for the Power BI on-prem alternative?
Abstract:
SessionID: 40734
Batches, Transactions, and Errors
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Database Application Development
Speaker: John Deardurff
Title: Batches, Transactions, and Errors
Abstract:
This session is an introduction into the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.
SessionID: 40737
Understanding SQL Server Backup and Restore
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Database Administration
Speaker: Tim Radney
Title: Understanding SQL Server Backup and Restore
Abstract:
SessionID: 40739
Keys to Successful SharePoint Administration for the DBA
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Other
Speaker: Daniel Glenn
Title: Keys to Successful SharePoint Administration for the DBA
Abstract:
SessionID: 41187
Execution Plans for Mere Mortals
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Database Application Development
Speaker: Mike Lawell
Title: Execution Plans for Mere Mortals
Abstract:
As a beginner database professional, execution plans are intimidating. In this session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.
You will understand how, why and when the execution plan will be created and saved to plan cache.
Reading the execution plan will be much less intimidating as we walk through the flow and process of a graphical execution plan.
After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance tuning opportunities.
Finally, you will be able to capture the execution plan, save it for analysis and comparison after modifications have occurred.
SessionID: 41221
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Database Application Development
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables – What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 41356
R with AzureML
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: BI Analytics Visualization
Speaker: Jake Switzer
Title: R with AzureML
Abstract:
SessionID: 41741
16 Enhancements for SQL Server 2016
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Database Administration
Speaker: Robert Verell
Title: 16 Enhancements for SQL Server 2016
Abstract:
Microsoft announced SQL Server 2016 on April 1, 2015 and it is no joke! In this session we'll examine 16 of the new enhancements that are coming in the latest version of SQL Server that is currently available in a technology preview. there are so many enhancements that I can't cover them all in one session! So we will examine some in high level reviews and more in-depth previews such as row level security, query store, and always encrypted.
SessionID: 41805
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Dave Fackler
Abstract:
SessionID: 41840
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment
Speaker: Joseph D'Antoni
Abstract:
• Optimizing TempDB in an Azure VM
• Reducing latency between application VMs and database VMs
• Right sizing Azure VMs for performance and cost
• Striping I/O across devices in Azure VMs
• Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.
SessionID: 41841
Introduction to SQL Server Integration Services
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Ed Watson
Title: Introduction to SQL Server Integration Services
Abstract:
Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!
SessionID: 42063
Get Near Realtime ETL with Service Broker
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Allen White
Title: Get Near Realtime ETL with Service Broker
Abstract:
SessionID: 42202
A Real, Live PowerShell Beginner's Tutorial
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Other
Speaker: Tim Warner
Title: A Real, Live PowerShell Beginner's Tutorial
Abstract:
This is for the PowerShell precon. The problem I've seen with most PowerShell "beginner's tutorials" is that they almost always go way beyond the basics. In this session, in which participants are expected to be utterly brand-new to the technology, we cover the true basics, focusing on only three commands: Get-Command, Get-Help, and Get-Member. I can do this in 60 or 90 minutes, although I'd prefer the latter.
SessionID: 42250
Understanding Windows Azure High Availability Options for SQL Server
Event Date: 16-01-2016 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment
Speaker: David Bermingham
Title: Understanding Windows Azure High Availability Options for SQL Server
Abstract:
Windows Azure provides an excellent IaaS platform for deploying SQL Server. Although Microsoft is managing the infrastructure, you still need to plan for high availability and disaster recovery. In this session, learn how to leverage Azure Fault Domains, Upgrade Domains, and Internal Load Balancers to ensure the high availability of SQL Server deployments within the Azure cloud. Learn the difference between Azure Classic and Azure Resource Manager and how both affect your SQL Server availability.
While Microsoft Azure offers SLA's of 99.95%, you have to know what to do to make sure your SQL Server deployment qualifies. Don't miss this session if you are moving or have moved your SQL Servers instances to Azure. This session assumes you have a basic knowledge of SQL Server AlwaysOn Failover Clustering as well as Availability Groups.
SessionID: 42648
Extended Time Slot
Event Date: 16-01-2016 - Session time: 12:00:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: Extended Time Slot
Abstract:
Extended time slot for Spotlight Sessions (90-min) listed above
SessionID: 42025
Perceptual Intelligence with Cortana Analytics
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: BI Analytics Visualization
Speaker: Dan Evans
Title: Perceptual Intelligence with Cortana Analytics
Abstract:
Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. Come learn more around how you can take action by going beyond looking in the rear-view mirror to predicting what’s next. Enhance your business applications with machine intelligence to evolve from simple descriptive analytics to prescriptive recommendations. See some of the new ways to infer intent with vision, face, speech, text and sentiment analysis to customize responses and drive appropriate actions in a secure, compliant and scalable way leveraging SQL Server, Azure and Power BI. Expect to leave the discussion understanding new trends in analytics and how you can apply value to your organization.
SessionID: 42574
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: Database Administration
Speaker: David Orlandi
Abstract:
Foglight Performance Investigator. You will learn about: Multidimensional SQL workload drilldowns. View dimensions of your data, including users, programs, SQL, and sessions. Historical lock analysis – Resolve SQL Server concurrency issues with historical reviews of blocking-lock scenarios built into the dimensional drilldown. Automated change tracking – Find out when changes to server, instance, database and schema environments occur. Compare utility – Efficiently identify root causes and symptoms of performance deviations in application environments. Find and analyze statement-level wait events.
SessionID: 42649
Case Study: Improving High Availability and Disaster Recovery
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: Case Study: Improving High Availability and Disaster Recovery
Abstract:
SessionID: 44866
The Benefits of Implementing SQL Server on Cisco Unified Computing System
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: Database Administration
Speaker: Frank Cicalese
Title: The Benefits of Implementing SQL Server on Cisco Unified Computing System
Abstract:
SessionID: 45058
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: Database Application Development
Speaker: Kevin Kline
Abstract:
- A little-known technique to create a tiny version of large production databases, yet deliver query execution behaviors as you would see in production.
- Sneaky DBCC commands which help you replicate a full production server on your workstation, as well as how to turn on and off specific query engine optimizations.
- Best practices in reading execution plans using the free tool, Plan Explorer.
- A variety of T-SQL techniques, including the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, and some weird situations where SQL Server doesn’t use cached plans when it should.
SessionID: 45180
WIT-Diversity Panel: Parenting Daughters in an IT world Why Its Important
Event Date: 16-01-2016 - Session time: 12:30:00 - Track: Other
Speaker: Rie Irish
Title: WIT-Diversity Panel: Parenting Daughters in an IT world Why Its Important
Abstract:
Join Justin Dearing, Patrick LeBlanc, Arlene Rose and Rie Irish to discuss raising daughters as a parent involved in IT. Parenting is hard. We all know that. Parenting girls is really hard. Adding to an already complicated job, is our technology based way of thinking problem solving. The IT field isn't very diverse, but we have the opportunity to change that in a generation: encouraging young females, calling out other biases in the field and coming up with positive solutions. Are we raising tech savvy daughters? Should we be?
SessionID: 40880
Balancing Work and Home to Create a Better You
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Professional Development
Speaker: Karlyn LeBlanc
Title: Balancing Work and Home to Create a Better You
Abstract:
If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.
SessionID: 41076
Navigating the Options for Data Redundancy
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Administration
Speaker: Wendy Pastrick
Title: Navigating the Options for Data Redundancy
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
SessionID: 41111
Introduction to the Power BI Desktop
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: BI Analytics Visualization
Speaker: Patrick LeBlanc
Title: Introduction to the Power BI Desktop
Abstract:
Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.
SessionID: 41861
PowerShell for the Reluctant Administrator
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: PowerShell
Speaker: Pat Phelan
Title: PowerShell for the Reluctant Administrator
Abstract:
You've heard many people claim that PowerShell is fabulous, but you've never really felt the need for it. What's all the fuss? What is PowerShell and why should you even care, much less learn it? How will this new toy make your work easier?
This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you'll see some simple but useful tools and ideas for how you can use those tools and make your own tools too.
This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.
SessionID: 42105
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: BI Architecture Management
Speaker: Hope Foley
Abstract:
SessionID: 42234
Automating Database Restores
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Andy Warren
Title: Automating Database Restores
Abstract:
Beginning DBA's think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn't hard, but what about when you get five or ten requests a day? It's not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable.
This presentation will show you the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I'll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it's a pattern you could solve using another language, even perhaps TSQL!
SessionID: 42258
SQL Server's In Memory Database Objects
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Denny Cherry
Title: SQL Server's In Memory Database Objects
Abstract:
SQL Server 2014 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project Hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
SessionID: 42260
Database Continuous Delivery Your Salvation!
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Application Development
Speaker: John Morehouse
Title: Database Continuous Delivery Your Salvation!
Abstract:
SessionID: 42267
Turning Requirements into a BI Prototype
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: BI Architecture Management
Speaker: Stacia Varga
Title: Turning Requirements into a BI Prototype
Abstract:
Your SQL Server system can support two types of Analysis Services models: multidimensional or tabular. But what if you’ve never implemented them and your company wants to start using BI? Are you wondering how to get started? Regardless of which type of SSAS model you want to use, the best first step is to determine what types of questions your BI solution should answer. Next, determine how to structure your data. Before you begin the physical restructuring of your data, though, you should validate your proposed design by creating a prototype that users can review with you. In this session you’ll learn how to translate the business questions to be answered by your solution into a functional prototype that can steer your development efforts in the right direction.
SessionID: 42274
TempDB Done Right
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Administration
Speaker: Eddie Wuerch
Title: TempDB Done Right
Abstract:
SessionID: 42348
Data Factory: Data Integration in the Cloud
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Cloud Database/Application Development Deployment
Speaker: Josh Luedeman
Title: Data Factory: Data Integration in the Cloud
Abstract:
SessionID: 44612
Surviving Your Peak Database Load
Event Date: 16-01-2016 - Session time: 13:30:00 - Track: Database Administration
Speaker: Ben DeBow
Title: Surviving Your Peak Database Load
Abstract:
SessionID: 40843
Getting Started with MDX
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: BI Architecture Management
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect, SSAS Maestro and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2012 and most previous versions. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
SessionID: 41112
Power BI: Data Refresh ad SSAS On-Premises Connectivity
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: BI Analytics Visualization
Speaker: Patrick LeBlanc
Title: Power BI: Data Refresh ad SSAS On-Premises Connectivity
Abstract:
Join me to go under the hood with a Power BI deep dive. Where I will discuss two Hybrid Scenarios for Power BI. I will explore the data refresh capabilities, allowing reports published to Power BI to connect to varying data sources for data refresh. I will also discuss exciting new capabilities that allows Power BI to connect directly to SQL Server Analysis Services on-premises and interactively query. Allowing customers to keep and manage data on-premises without the need to move their data to the cloud.
SessionID: 41347
Data Pages, Allocation Units, IAM chains... Oh My!
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Administration
Speaker: Brandon Leach
Title: Data Pages, Allocation Units, IAM chains... Oh My!
Abstract:
Understanding how SQL Server stores your data can seem like a daunting task. In this session You'll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.
We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
SessionID: 41562
Beginning Azure
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Cloud Database/Application Development Deployment
Speaker: Thomas Norman
Title: Beginning Azure
Abstract:
SessionID: 41860
Data Architecture 101
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Application Development
Speaker: Pat Phelan
Title: Data Architecture 101
Abstract:
This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
NOTE: Database Architecture 101 is like Calculus 101 or Bio-Chemistry 101. This is a very basic introduction to Database Architecture, but it is not intended for the inexperienced Database Administrator.
SessionID: 41878
Parameter Sniffing and the Query Store in SQL Server 2016
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Administration
Speaker: Sreeni Julakanti
Title: Parameter Sniffing and the Query Store in SQL Server 2016
Abstract:
SessionID: 41932
Overview of Security Investments in SQL Server 2016 and Azure SQL Database
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Application Development
Speaker: Jamey Johnston
Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database
Abstract:
Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.
SessionID: 42065
The Art and the Science of Designing a Mission Critical SQL Server Solution
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Application Development
Speaker: Maxwell Myrick
Title: The Art and the Science of Designing a Mission Critical SQL Server Solution
Abstract:
When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design. This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way you’ll hear best practices, tips, and real world advice for features like Availability Groups, clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. While you may not be able to revisit your current designs right away, what you learn will make you the hero of your next mission critical deployment.
SessionID: 42070
Tame Your Unruly Data...With Constraints!
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: Database Application 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: 42134
Hadoop for SQL Server Pros
Event Date: 16-01-2016 - Session time: 14:45:00 - Track: BI Architecture Management
Speaker: Jon Boulineau
Title: Hadoop for SQL Server Pros
Abstract:
What is Hadoop? Why is it getting so much attention? How will it impact my career? For many data professionals Hadoop remains a new technology that is often talked about, but rarely encountered. This demo-heavy session will demystify this high profile data platform by reviewing it's architecture, ecosystem of open source projects, and seeing it in action.