Nr: 497
SQLSaturday #497 - Huntington Beach 2016
SessionID: 42216
Habits of Highly Effective SQL Development Teams
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Other
Speaker: Ike Ellis
Title: Habits of Highly Effective SQL Development Teams
Abstract:
t its most fun, software development is a team sport. Think of an NFL team. Does the quarterback know where the running back or tight-end will be? Does he do his job in a vacuum or with coordination and support from his teammates?
However, if the teammate isn't doing what they're supposed to do, the play dissolves and leads not only to losing a game, but also individual dissatisfaction. Come to this session to learn how to coordinate and communicate as a team, improving individual and overall developer effectiveness. Learn how to overcome particular obstacles unique to SQL Developers.
SessionID: 43087
Mastering and Enhancing Company Data
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Rushabh Mehta
Title: Mastering and Enhancing Company Data
Abstract:
SessionID: 44701
3 Skills Every Junior DBA Must Know
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Kendra Little
Title: 3 Skills Every Junior DBA Must Know
Abstract:
You’re just getting started as a SQL Server Database Administrator -- or you’re trying to get there. You’re confused about exactly what you need to learn to master the basics of the job. Kendra Little has been there, and she can help! In this session she’ll explain three critical skills that every Junior DBA must master. You’ll leave this session with free scripts and an itemized, online training plan to achieve your goals.
SessionID: 45896
Mysteries of Data Masking Revealed - in Azure, SQL Server, and beyond.
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Application Database Development
Speaker: Yevgeniya Mushkatblat
Title: Mysteries of Data Masking Revealed - in Azure, SQL Server, and beyond.
Abstract:
Data Masking, or Data De-identification, is a technique allowing a database practitioner to hide data with "false" values. Done in response to the compliance regulations such as HIPAA, GLBA, PCI and other, it allows securing data in variable ways based on the user role in the organization. Data Masking is not encryption! The strategies and algorithms would differ whether you need to use it in production or non-production environment and whether you need to apply it enterprise -wide or in separate applications. Learn about data masking as a part of privacy - by -design strategy and how to decide what to use and where.
SessionID: 46470
Managing Hierarchial Data in a Relational Database
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Strategy and Architecture
Speaker: Robert Hatton
Title: Managing Hierarchial Data in a Relational Database
Abstract:
Managing hierarchical data (such as Budgets, Bills of Material, or Organization Charts) can be a real challenge in a relational database. This session will feature a design pattern that makes it seem almost simple. We'll see a database schema that is flexible and efficient. We'll also take some time to discuss common design mistakes. Finally we review a recursive CTE that will allow you to traverse large hierarchies with surprising speed!
SessionID: 46745
A NoSQL Primer for the SQL Server Developer
Event Date: 02-04-2016 - Session time: 08:30:00 - Track: Strategy and Architecture
Speaker: Andrew Karcher
Title: A NoSQL Primer for the SQL Server Developer
Abstract:
You have all probably heard about this "NoSQL" thing and wondered what is about, how does it differ from SQL Server and how will this affect me. You might want to just stick your head in the sand and ignore it, but as database professionals it is always good to know about what other technologies might be out there to compliment your existing solutions. We will not be going deep into any one solution, but by the end of this session, the goal will be that you understand the following:
- The different types of NoSQL databases
- Some use cases where they might be applicable
- Some of the major solutions out there for each one
SessionID: 42225
Data Modeling for Integration of RDBMS with NOSQL
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Strategy and Architecture
Speaker: Daniel Upton
Title: Data Modeling for Integration of RDBMS with NOSQL
Abstract:
Join us to explore how emerging data modeling methods and model notations help us define, and easily communicate, robust integration points between NOSQL data stores and emerging RDBMS 'Lean Data Warehouse' models that would otherwise be challenging to map across due to radical differences in normalization. Did you buy the pitch about how 'BigData and RDBMS Data Warehouses can remain in isolation'. Me neither! You will leave this sessions not only free from some rigid E/R modeling assumptions and diagramming standards, but also armed with an introduction to a practical method of logical data modeling in the new world of polyglot data storage.
SessionID: 44396
Production SQL Server 2016--Lessons from the Field
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Joseph D'Antoni
Title: Production SQL Server 2016--Lessons from the Field
Abstract:
SQL Server 2016 is almost here--there a ton of new features whether you are a business intelligence pro, a DBA or a developer. In this session you will learn practical lessons learned supporting 2016 in early production environments.
You will learn about:
--AlwaysOn Availability Groups and how they're better
--Columnstore Index changes
--What features are for you
--Backing up to Azure
--The joys of dealing with a rapid release cycle
This session will present a candid view of the 2016 process and why it will be ready for you to roll out on RTM day.
SessionID: 45508
Introduction to Azure Streaming Analytics
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Speaker: Warren Sifre
Title: Introduction to Azure Streaming Analytics
Abstract:
This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
SessionID: 45536
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Application Database Development
Speaker: Sean Werick
Abstract:
SessionID: 45971
How to successfully virtualize critical SQL servers
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Niran Even-Chen
Title: How to successfully virtualize critical SQL servers
Abstract:
Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications.
Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the same person writing the official SQL on VMware best practices guides.
SessionID: 46737
Data Migrations (using SSIS)
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Professional Development
Speaker: Eduardo Favio Angeles
Title: Data Migrations (using SSIS)
Abstract:
We will focus on important concepts, methodologies and do some demos if there is time at the end. If you would like to have an advanced sessions, please send me an email.
Agenda
- Infrastructure - What do you need to get started with SSIS?
- Methodology, Concepts, Best Practices
- If we have time, we may jump to some SSIS demos and share some tips.
SessionID: 46779
Microsoft Business Intelligence 2016 – More Love for Your Data
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: BI Information Delivery
Speaker: Tamera Clark
Title: Microsoft Business Intelligence 2016 – More Love for Your Data
Abstract:
Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.
SessionID: 46869
Are You Optimistic About Concurrency?
Event Date: 02-04-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Kalen Delaney
Title: Are You Optimistic About Concurrency?
Abstract:
What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012's SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency? In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
SessionID: 42233
SQL Injections and How to Stop Them
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Strategy and Architecture
Speaker: Jeff Prom
Title: SQL Injections and How to Stop Them
Abstract:
During the demo, we will take on a couple of different roles. As a hacker we will walk through steps a hacker might take to compromise a web application in order to retrieve sensitive data such as credit card information, usernames, passwords, and social security numbers. Assuming the role of a developer, we will then show various prevention techniques and their effectiveness in preventing SQL injections.
Attend this session to learn how SQL injections work, identify if you are being attacked, and how to stop them.
SessionID: 43042
How to Bully Your Query Execution Plans
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Kendra Little
Title: How to Bully Your Query Execution Plans
Abstract:
Sometimes bad execution plans happen to good queries. You may have heard that it's better to rewrite complex TSQL-- but is using a temporary table better than using query hints? In this session you'll learn the pros and cons of using hints, plan guides, and the new Query Store feature in SQL Server 2016 to manipulate your execution plans. You'll take away a checklist of things to do every time you decide to bully an execution plan.
SessionID: 45094
Effortless Backups with Minion Backup
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Jennifer McCown
Title: Effortless Backups with Minion Backup
Abstract:
Let's take the new, free backup tool out for a spin. We can hop through a quick installation, glance at the multi-install PowerShell script, and dance around the table-based schedules, for a start. Afterward we'll have a long, leisurely walk through some of the best things you can do with MB: backup ordering, pre- and postcode, live insight, striping and mirroring, and of course so much more. Feel free to download MB and follow along on your own laptop!
SessionID: 45104
The Power of Partitioning
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Strategy and Architecture
Speaker: Ranjay Singh
Title: The Power of Partitioning
Abstract:
Overview of Table Partitioning
-What is Partitioning?
- When to use it?
--ETL (Parallelism and Table Locking)
--Performance
-- Data Archiving
--Auditing and compliance
--Backup and Piecemeal Restore
-How to Plan and implement it?
-Demo
-Union Bank's Use case
SessionID: 45735
Building a PowerPivot BI Dashboard
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Analytics and Visualization
Speaker: Vazi Okhandiar
Title: Building a PowerPivot BI Dashboard
Abstract:
Demonstrate the steps to import raw data from text file, Access database and Excel file into Excel 2013, and then build a BI dashboard using PowerPivot and Power Map.
SessionID: 46334
Query Processing in In-Memory OLTP (Hekaton)
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Benjamin Nevarez
Title: Query Processing in In-Memory OLTP (Hekaton)
Abstract:
SessionID: 46445
Optimizing your data warehouse for OLAP Processing
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Konstantin Melamud
Title: Optimizing your data warehouse for OLAP Processing
Abstract:
SessionID: 46728
Introduction to SQL 2016 Temporal Tables
Event Date: 02-04-2016 - Session time: 11:00:00 - Track: Application Database Development
Speaker: Vicky Harp
Title: Introduction to SQL 2016 Temporal Tables
Abstract:
SQL Server 2016 introduces the concept of temporal tables, also called system-versioned tables. This new feature allows SQL Server to automatically keep track of the history of rows in any table for which it is enabled. In this session we'll cover the basics on how to create and work with temporal tables, including the new FOR SYSTEM_TIME query clause, and we'll discuss some of the ways that they may or may not fill a need in your environment.
SessionID: 46837
Cisco and Nimble Storage: Partners to Create a Next Gen SQL Server Solution
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Cho
Title: Cisco and Nimble Storage: Partners to Create a Next Gen SQL Server Solution
Abstract:
SessionID: 48368
New Capabilities on top of Microsoft SQL SSAS
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: BI Information Delivery
Speaker: Rony Ross
Title: New Capabilities on top of Microsoft SQL SSAS
Abstract:
We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL SSAS are a game changer for the BI market and specially for the Microsoft segment.
SessionID: 49115
DB "Time Machine" Never lose more than 1 second of transactions ever again!
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: Other
Speaker: Ken Smallwood
Title: DB "Time Machine" Never lose more than 1 second of transactions ever again!
Abstract:
If you're like the rest of us, don't miss the chance to learn how to forget about snapshots and consistency groups forever with Reduxio's database time machine at SQL Saturday.
Never lose more than 1 second of transactions ever again. Reduxio will showcase their breakthrough Backdating technology that obsoletes existing database backup technologies by providing the ability to instantly recover and clone from any second in the past with no upfront planning or data copy.
SessionID: 49277
SQL and VMware - more than just virtualization demos
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Niran Even-Chen
Title: SQL and VMware - more than just virtualization demos
Abstract:
SessionID: 49293
Flash Storage 101: How Flash Storage Modernizes Database Design
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: Strategy and Architecture
Speaker: Matt Henderson
Title: Flash Storage 101: How Flash Storage Modernizes Database Design
Abstract:
NAND flash storage is the new wave of technology hitting data centers and solutions design. With a new technology comes a new set of pros versus cons, new economics and changes in solutions architecture that highlight what it has to offer. This session will give an overview of how the technology works, what to look out for, how to properly POC/test each vendor’s solution and how to modernize your database architecture with this new technology.
SessionID: 49314
Keeping your SQL Objects Safe In Development
Event Date: 02-04-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Mickey Stuewe
Title: Keeping your SQL Objects Safe In Development
Abstract:
It has been a long established practice to keep maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer’s computer won’t turn on.
So, what about your SQL Objects?
Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.
SessionID: 42316
Building Your Way to Better Database Testing
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Application Database Development
Speaker: Phil Helmer
Title: Building Your Way to Better Database Testing
Abstract:
Test Data Builders. Ever heard of them? That's ok. Neither did I before I went looking for a convenient way to set up test data in SQL Server. I will show you what they are and how they work. More importantly, you will learn an easy way to get started and what you can do with them that could make your professional value grow and earn more money. I will also cover some of the design decisions you need to make so that they'll fit your needs.
SessionID: 44230
Rock Your Technical Interview (Part 1)
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Other
Speaker: David McCarter
Title: Rock Your Technical Interview (Part 1)
Abstract:
Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company you need to attend this session. Included are crazy and strange interview stories from engineers just like you! Learn tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer! Make sure you attend part 2!
SessionID: 44350
SQL Stretch Database
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Sapna Jeswani
Title: SQL Stretch Database
Abstract:
Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. Come find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!
SessionID: 45506
Introduction to Azure Machine Learning
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Advanced Analysis Techniques
Speaker: Warren Sifre
Title: Introduction to Azure Machine Learning
Abstract:
We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
SessionID: 45709
The Key to Keys
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Application Database Development
Speaker: Karen Lopez
Title: The Key to Keys
Abstract:
These concepts span data activities and it's important that your team understand each other and where they, their tools and approaches need to support these features.
We'll look at the generic and proprietary terms for these concepts, as well as where they fit in the database design process. We'll also look at implementation options in SQL Server and other DBMSs.
SessionID: 46444
VLDB: Partitioning in SQL Server Standard Edition.
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Konstantin Melamud
Title: VLDB: Partitioning in SQL Server Standard Edition.
Abstract:
Partitioning has long been one of the key feature sets utilized to improve performance or reduce contention within our large tables in SQL Server. However, table partitioning has been solely the prerogative of SQL Server Enterprise edition. You may be asking yourself, “Why is he talking about table partitioning? Didn’t we just establish it’s only available in Enterprise and not available to us Standard edition users?” Even though you’d be correct, there are techniques available to us in Standard edition which would accomplish the same result as table partitioning. Yes, I am talking about partitioned views.
In this session we will go through the steps needed to configure and use the partitioned views to achieve the same result as table partitioning. We will also configure the maintenance jobs to demonstrate the sliding window functionality, and for those of us who are lucky to have Enterprise edition, we will see how to be able to take advantage of combining the use of both partitio
SessionID: 46589
Power BI for the Enterprise
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Paul Turley
Title: Power BI for the Enterprise
Abstract:
Sure, Power BI is a terrific self-service data analysis tool but it's also an enterprise-class reporting and dashboard tool for serious business data. Learn how to build serious business solutions with on-premises data sources; SQL Server, Analysis Services and other business systems. You'll also see how you can architect solutions with security and user access control utilizing groups and content packs.
SessionID: 46860
Connecting Power BI to On-Prem Data with SSAS
Event Date: 02-04-2016 - Session time: 13:30:00 - Track: BI Information Delivery
Speaker: Kerry Tyler
Title: Connecting Power BI to On-Prem Data with SSAS
Abstract:
SessionID: 42295
Protecting your data in the Cloud
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Cloud Application Development Deployment
Speaker: Vijayakumar Thurupathan
Title: Protecting your data in the Cloud
Abstract:
The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server
SessionID: 44231
Rock Your Technical Interview (Part 2)
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Other
Speaker: David McCarter
Title: Rock Your Technical Interview (Part 2)
Abstract:
Have you ever not gotten a job because you weren’t prepared for the interview? Would you like a big raise? Do you need motivation to rock your career? I’ve interviewed 100’s of software developers and will share my knowledge on how to survive, what we look for and even divulge some of the secrets we use during the process. Whether you are looking for a new position within your company or at a new company you need to attend this session. Included are crazy and strange interview stories from engineers just like you! Learn tips to get you started, working with recruiters, getting prepared, the technical interview and more. You will also learn what is the #1 question you need to ask during an interview… it’s a game changer! Make sure you attend part 1!
SessionID: 44802
Be a Role Model for Women in Tech through Blogging
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Professional Development
Speaker: Mickey Stuewe
Title: Be a Role Model for Women in Tech through Blogging
Abstract:
Have you wanted to start giving back to our amazing SQL Community through writing, but are not sure how to start? Do you want to start blogging, but are anxious about criticisms? Are you unsure what to write about? I’ll walk through how to find topics to start writing about. I’ll go over tools to help you blog, and websites that you can start blogging about. We’ll discuss why it’s import to be a woman blogger, and I’ll share with you my experience over the last three years as a woman blogger in our community. Role models are needed for women in tech. They need to know that they are wanted in the community and that they have a voice. Be that role model through blogging.
SessionID: 45097
Monster Text Manipulation: Regular Expressions for the DBA
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Sean McCown
Title: Monster Text Manipulation: Regular Expressions for the DBA
Abstract:
• The most useful regular expression commands
• The appropriate times to use regular expressions
• How to use regular expressions to write code for you
• How to incorporate regular expressions into large tasks and combine them with other methods
SessionID: 45747
PolyBase in SQL Server 2016: Query Hadoop with ease
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Analytics and Visualization
Speaker: Sahaj Saini
Title: PolyBase in SQL Server 2016: Query Hadoop with ease
Abstract:
This session will cover the PolyBase fundamentals of what the feature is, how customers are using it and how it works under-the-covers. In addition, the session will include a Live Demonstration of how PolyBase can be used to bring relational and semi-structured data together using SQL skill sets.
SessionID: 46335
Understanding Parameter Sniffing
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Application Database Development
Speaker: Benjamin Nevarez
Title: Understanding Parameter Sniffing
Abstract:
SessionID: 46858
Managing Your Schema with Database Projects in Visual Studio
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Kerry Tyler
Title: Managing Your Schema with Database Projects in Visual Studio
Abstract:
SessionID: 46943
Better Report Development and Management Techniques
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration
Speaker: Ted Stathakis
Title: Better Report Development and Management Techniques
Abstract:
Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.
SessionID: 49332
Things You Should Never Do In Microsoft SQL Server
Event Date: 02-04-2016 - Session time: 14:45:00 - Track: Professional Development
Speaker: Denny Cherry
Title: Things You Should Never Do In Microsoft SQL Server
Abstract:
In this fun session we'll review a bunch of problem implementations that have been seen in the real world.
Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes again.
SessionID: 42218
How to Get Lightning Fast Answers with Power BI QA and Cortana
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: Analytics and Visualization
Speaker: Vishal Pawar
Title: How to Get Lightning Fast Answers with Power BI QA and Cortana
Abstract:
SessionID: 42305
Mastering Master Data Services
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jeff Prom
Title: Mastering Master Data Services
Abstract:
As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft provides the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you can ensure that your MDS data is always up-to-date and accurate.
In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.
SessionID: 45711
Panel: Will the DBA Job of the Future Still Involve DBAs?
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: Professional Development
Speaker: Karen Lopez
Title: Panel: Will the DBA Job of the Future Still Involve DBAs?
Abstract:
Our panel of SQL Server experts share their current experiences in the data profession.#160;They share what they believe you should be working towards now and in the future.
SessionID: 46469
Thinking in SQL
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Robert Hatton
Title: Thinking in SQL
Abstract:
SessionID: 46590
Reporting Services 2016 Solutions: The New Awesome
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: BI Information Delivery
Speaker: Paul Turley
Title: Reporting Services 2016 Solutions: The New Awesome
Abstract:
SessionID: 46660
Power BI Desktop – A BI developer’s view
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: BI Information Delivery
Speaker: Phil Robinson
Title: Power BI Desktop – A BI developer’s view
Abstract:
Power BI Desktop is the new self-service entry in the Microsoft BI development landscape but what does it offer the professional BI developer?
This session will explore Power BI Desktop features for data accusation and manipulation, sample some of the visualization provided and review the deployment options.
SessionID: 46726
Understanding and Monitoring Tempdb
Event Date: 02-04-2016 - Session time: 16:00:00 - Track: Application Database Development
Speaker: Vicky Harp
Title: Understanding and Monitoring Tempdb
Abstract:
Every SQL Server system that you work with has a tempdb database. In this session, learn how tempdb is structured, what it is used for, and what common performance problems are tied to this shared resource. Gain an understanding of tempdb contention and the snapshot isolation version store and how to detect problems with both. You will leave this session with a new confidence in what configuration and file settings may prevent problems in your environment.