Nr: 581
SQLSaturday #581 - Nashville 2017
SessionID: 54091
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Andy Yun
Abstract:
Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.
SessionID: 54099
The PROCESS of Queries
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Application Development
Speaker: John Deardurff
Title: The PROCESS of Queries
Abstract:
This session is an introduction into the PROCESS of queries. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. Finally we introduce Execution Plans. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.
SessionID: 54114
The 20% of DAX That Gets You 80% of the Way There
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: BI Analytics and Visualization
Speaker: Austin Senseman
Title: The 20% of DAX That Gets You 80% of the Way There
Abstract:
SessionID: 54119
Word Up: Text Mining in SQL
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Other
Speaker: Dave Mattingly
Title: Word Up: Text Mining in SQL
Abstract:
Would a database by any other name smell as sweet?
Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.
Learn how to dig through your library of language to make your data better.
SessionID: 54168
How to successfully virtualize critical SQL servers
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Administration
Speaker: Niran Even-Chen
Title: How to successfully virtualize critical SQL servers
Abstract:
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: 54680
Many – to - Many: Multiple Calendars in a Single Analysis Services Multidimensional Cube
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: BI Architecture Management
Speaker: William E Pearson III
Title: Many – to - Many: Multiple Calendars in a Single Analysis Services Multidimensional Cube
Abstract:
Including the fiscal calendars of major customers within the date dimensions of their own cubes has great appeal to many organizations, including financial services firms and the like. After all, having customer calendars in their cubes' date dimension means sales and marketing managers can analyze - and report upon - data according to the fiscal calendar of the customer, as well as within the context of their own. In this session, Microsoft BI Architect, Data Platform (SQL Server and BI) MVP and SSAS Maestro Bill Pearson leads an examination into a way we can accomplish this by implementing a SQL Server Analysis Services "many-to-many" dimension scenario. This session applies, in most respects, equally to Analysis Services (MultiDimensional) 2008R2 and above.
SessionID: 56588
Very Large Databases in your future
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Administration
Speaker: Eric Peterson
Title: Very Large Databases in your future
Abstract:
Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned
from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout
decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re-
indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.
SessionID: 56663
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Administration
Speaker: Anthony Nocentino
Abstract:
SessionID: 56786
Enterprise Machine Learning with R and SQL Server
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: BI Analytics and Visualization
Speaker: Paco Gonzalez
Title: Enterprise Machine Learning with R and SQL Server
Abstract:
R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.
SessionID: 57137
Learn History from Temporal Tables
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Ameena Lalani
Title: Learn History from Temporal Tables
Abstract:
SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. They are basically history tables of the normal tables; that allow us to retrieve data from any point in time for every change such as updates and deletes . It does this all without any change to application code and without using any behind the scene triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. It will also cover some security concerns around theTemporal Tables.
SessionID: 57354
Registration for non-printed SPEEDPASS
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: Registration for non-printed SPEEDPASS
Abstract:
This room will be used for printing SPEEDPASS, cutting SPEEDPASSES and any other registration issues. This room will be ready when registration opens.
SessionID: 59399
Event Date: 14-01-2017 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Mike Byrd
Abstract:
Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables with and without columnstore indexes over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment.
After this session you will
- Understand what in-memory tables are and how to create and maintain them including their limitations
- Be able to identify performance gains over equivalent disk back tables
- Comprehend the new data monitoring needed for in-memory table
SessionID: 54141
Query Store Primer
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Tracy Boggiano
Title: Query Store Primer
Abstract:
SessionID: 54617
End-to-End Troubleshooting Checklist for SQL Server
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Kevin Kline
Title: End-to-End Troubleshooting Checklist for SQL Server
Abstract:
In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:
• XEvents, Profiler/Traces, and PerfMon
• Using Dynamic Management Views (DMVs)
• Advanced Diagnostics Using Wait Stats
• Reading SQL Server execution plan
Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.
SessionID: 55025
Power BI Data Governance - Protecting Business Data
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: BI Analytics and Visualization
Speaker: Ernie Wise
Title: Power BI Data Governance - Protecting Business Data
Abstract:
This session allows companies to think about the security and architecture of their Power BI deployment. Power BI is self service analytics. Users are quick to create a group work spaces without any thought. IT and organizations need to design a business friendly architecture that protects the business data without impacting the users ability to build their reports and dashboards. Users are also quick to change the data model or report without thinking of the negative impact. A strategy for delivering the changes needs to be put into place. This prevents presenting invalid reports or dashboards during the development or advancement stage of updating reports and dashboards.
SessionID: 56469
Let Me Finish... Isolating Write Operations
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Louis Davidson
Title: Let Me Finish... Isolating Write Operations
Abstract:
SessionID: 56556
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Janis Griffin
Abstract:
- Quickly fine tune a SQL statement
- Identify performance inhibitors to help avoid future performance issues
- Recognize and understand how new SQL Server features can help improve query
performance
SessionID: 56587
JSON and SQL 2016
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Eric Peterson
Title: JSON and SQL 2016
Abstract:
JSON: What it is, what it isn't and when to use it.
We'll look at native result sets vs JSON vs HTML along with JSON implementation as a built-in vs. native data type in SQL and shaping the JSON output.
SessionID: 56622
Introduction to SQL Server Integration Services
Event Date: 14-01-2017 - Session time: 09:45: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: 56669
Understanding and Handling Database Corruption
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: David Maxwell
Title: Understanding and Handling Database Corruption
Abstract:
Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption. In this session, we will discuss usage of related DBCC commands such as DBINFO, CHECKDB and PAGE. You'll learn how to monitor for corruption with SQL Agent Alerts and Jobs, and when it's time to restore instead of repair. After attending this session, you will be able to check for issues such as page corruption or data purity problems, and take the appropriate measures to deal with them.
SessionID: 56792
Self-Service ETL with Microsoft Power Query
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: BI Analytics and Visualization
Speaker: Damu Venkatesan
Title: Self-Service ETL with Microsoft Power Query
Abstract:
SessionID: 56799
Getting Started with SQL Server Replication
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Robert Verell
Title: Getting Started with SQL Server Replication
Abstract:
SessionID: 56861
SQL Server 2016: Why you should care.
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Administration
Speaker: Geoff Hiten
Title: SQL Server 2016: Why you should care.
Abstract:
Yet another SQL Version. Big deal? YES! BIG DEAL! SQL 2016 is loaded with new features that can help you right now, even if your company isn't ready to upgrade. More than just a laundry list of features, this session will discuss why this release will make your job better.
SessionID: 59338
A Key to Keys
Event Date: 14-01-2017 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Karen Lopez
Title: A Key to Keys
Abstract:
In this session we’ll look at the generic and proprietary terms for these concepts, as well as where they fit in the data modeling and database design process. We’ll also look at implementation options in SQL Server 2016 -- what works, what really doesn't work, and what mistakes are commonly made in implementing keys.
SessionID: 54142
Disaster Recovery Where to Begin
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
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: 54266
A Real, Live PowerShell Beginner's Tutorial
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: PowerShell
Speaker: Tim Warner
Title: A Real, Live PowerShell Beginner's Tutorial
Abstract:
The problem with most PowerShell "beginner's tutorials" is that they almost always go way beyond the basics. In this session we cover the true basics, focusing primarily on only three cmdlets: Get-Command, Get-Help, and Get-Member, in the context of SQL Server.
SessionID: 54330
Top 5 SQL Server Mistakes
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Kathi Kellenberger
Title: Top 5 SQL Server Mistakes
Abstract:
SessionID: 54714
Tips and Tricks for the SSIS Catalog
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Jonathan Buller
Title: Tips and Tricks for the SSIS Catalog
Abstract:
SessionID: 56457
I Installed SQL Server... Now What?
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Jared Karney
Title: I Installed SQL Server... Now What?
Abstract:
SessionID: 56493
Why NULL is not a value (and other SQL gotchas)
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Application Development
Speaker: Wendy Pastrick
Title: Why NULL is not a value (and other SQL gotchas)
Abstract:
Allowing NULL "values" in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.
SessionID: 56544
Visualize Your Transaction Log
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Brian Hansen
Title: Visualize Your Transaction Log
Abstract:
SessionID: 56631
Execution Plans for Mere Mortals
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Application Development
Speaker: Mike Lawell
Title: Execution Plans for Mere Mortals
Abstract:
For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.
Reading execution plans becomes 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 and save it for analysis and comparison after modifications.
SessionID: 56667
Re-Introducing Power BI
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: BI Analytics and Visualization
Speaker: Stacia Varga
Title: Re-Introducing Power BI
Abstract:
SessionID: 56841
ETL Architecture for Real-Time BI
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Jon Boulineau
Title: ETL Architecture for Real-Time BI
Abstract:
SessionID: 56863
Azure Automation Runbooks for the DBA
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment
Speaker: Brian Davis
Title: Azure Automation Runbooks for the DBA
Abstract:
With more and more data moving to the cloud it's time DBA's began learning how to automate their cloud environments. Many have already begun to do this using PowerShell and this is a great way to start but in this session we'll take it to the next level and learn about Azure Automation, Runbooks, and PowerShell Workflows. Whether you need to pause and resume Azure SQLDW on a schedule, load or re-load an Azure SQLDB, check and react to specific conditions, or even complete more advanced tasks, Azure Automation and Runbooks can help. In this session we'll cover the basics of Azure Automation and walk through creating a PowerShell Workflow or two. We'll also learn about variables, schedules, credentials and how they work with Azure Automation so that you can take full advantage of your Runbooks. Come learn how you can make your cloud life easier as well as save time and money using Azure Automation and Runbooks.
SessionID: 56866
SQL Server on Linux--Linux for the SQL DBA
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: Joseph D'Antoni
Title: SQL Server on Linux--Linux for the SQL DBA
Abstract:
In this session you will learn about the new release of SQL Server on Linux. You will learn about how to choose Windows versus Linux, the changes needed to make SQL Server run on Linux, and high availability and disaster recovery solutions.
SessionID: 57116
Backups Restores: You're Not In Kansas Anymore!
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: Database Administration
Speaker: John Morehouse
Title: Backups Restores: You're Not In Kansas Anymore!
Abstract:
There is no place like home, there is no place like home! When a database crashes and you have to recover it, this may be what you're saying to yourself over and over. It can feel like a house just landed on you if you're not prepared. Ok, not really, but recovering a database from an unexpected event is often just as terrifying! If you aren't prepared for it, it's really going to hurt. So what do you do? You prepare. You plan. You practice. We'll talk about how the backup restore process works in SQL Server and how it can help you prevent a Wizard of Oz situation!
SessionID: 57343
SQL Server 2012 2014 ColumnStore Indexes
Event Date: 14-01-2017 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Gareth Swanepoel
Title: SQL Server 2012 2014 ColumnStore Indexes
Abstract:
Come and learn how the new SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don'ts, restrictions, and more. I will have some insight into how CSI's have been updated in SQL Server 2014, as well.
If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.
SessionID: 57349
Extended Time Slot
Event Date: 14-01-2017 - Session time: 12:00:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: Extended Time Slot
Abstract:
Extended time slot for Spotlight Sessions (75-min) listed above
SessionID: 56461
Women in Technology: Identifying and Understanding Gender Bias Inequality
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Professional Development
Speaker: Rie Irish
Title: Women in Technology: Identifying and Understanding Gender Bias Inequality
Abstract:
Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women job responsibilities. We'll learn how to identify gender bias when we see it. We'll discuss why it's important, how it affects our work, decision making, hiring, etc. We'll discuss strategies for how both men and women can combat this at work in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.
SessionID: 56735
Discuss Your Career (Panel)
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Professional Development
Speaker: Louis Davidson
Title: Discuss Your Career (Panel)
Abstract:
As a database professional, you have plenty of choice in your career path. Should you stay at the same company for 20 years, or change every few years? Much depends on what matters most to you. Do you want higher income, regular work hours, training, vacation time, group insurance, job security, lots of travel, telecommuting, or the possibility to advance to management? The panel will give their observations and experience over decades of experience. Discussion will include at least one person who has spent over 19 years with the same employer, one person who has changed careers very recently, and everyone in attendance who is willing to give an opinion.
SessionID: 56817
Perceptual Intelligence with Cortana Analytics
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Cloud Database/Application Development Deployment
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: 57551
SQL Server and Pure Storage: Redefining Database Engineering
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Database Administration
Speaker: Argenis Fernandez
Title: SQL Server and Pure Storage: Redefining Database Engineering
Abstract:
Please join SQL Server MVP and MCM Argenis Fernandez for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.
SessionID: 59302
SQL and VMware - more than just virtualization demos
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Database Administration
Speaker: Niran Even-Chen
Title: SQL and VMware - more than just virtualization demos
Abstract:
SessionID: 59535
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Other
Speaker: Ben Boise
Abstract:
SessionID: 59569
Ten Query Tuning Techniques Every SQL Programmer Should Know
Event Date: 14-01-2017 - Session time: 12:20:00 - Track: Database Application Development
Speaker: Justin Randall
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.
SessionID: 54095
Use Biml to Automate SSIS Design Patterns
Event Date: 14-01-2017 - Session time: 13:30: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: 54100
The Basics of Manipulating Data
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Application Development
Speaker: John Deardurff
Title: The Basics of Manipulating Data
Abstract:
This session is an introduction into writing INSERT, UPDATE, and DELETE statements. We will also discuss how to work with IDENTITY columns, the OUTPUT clause, and what is the difference between DELETE, DROP, and TRUNCATE. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.
SessionID: 54603
In-Memory Indexes: The rest of the story!
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Mike Byrd
Title: In-Memory Indexes: The rest of the story!
Abstract:
This session is a continuation of my in-memory table presentation given at 8 SQL Saturdays in 2016 only now concentrating on in-memory indexes. This session will do an in-depth dive into hash, range, and columnstore indexes in the in-memory environment. It will be about 30% presentation and 70% demos with emphasis on when and how to apply in-memory indexes for stated environments/scenarios.
After this session you will
- Understand the three in-memory index types, how to create, and when to apply them for selected scenarios
- Be able to identify performance gains over equivalent disk back tables/indexes
- Comprehend the new data monitoring needed for in-memory tables/indexes
SessionID: 54988
Power BI SharePoint - A Marriage Made in Redmond
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: BI Architecture Management
Speaker: Daniel Glenn
Title: Power BI SharePoint - A Marriage Made in Redmond
Abstract:
We will explore the relationship between SharePoint and Excel, how Power BI swooped SharePoint off her feet, and the current Business Intelligence soap opera that stars all three. Using live demos, we will look at data interaction between SharePoint, Excel, Power BI (including the iOS app), and the intriguing new next door neighbor - Microsoft Flow.
SessionID: 56370
Data Visualization: How to truly tell a great story!
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: BI Analytics and Visualization
Speaker: Jonathan Stewart
Title: Data Visualization: How to truly tell a great story!
Abstract:
We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
SessionID: 56621
Database Security in SQL Server 2016 and beyond
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Denny Cherry
Title: Database Security in SQL Server 2016 and beyond
Abstract:
In this session we will review the new enhancements to SQL Server security available in SQL Server 2016 and Azure SQL DB, including Always Encrypted, Row-Level Security, and Dynamic Data Masking, as well as whatever else Microsoft has released since this abstract was written. We'll look at how to set these features up, how to use them, and most importantly, when to use them.
SessionID: 56791
The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: Justin Randall
Title: The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags
Abstract:
SessionID: 56801
Understanding Transaction Isolation Levels
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 56828
Autonomous Transaction Logging in SQL Server
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Rob Volk
Title: Autonomous Transaction Logging in SQL Server
Abstract:
Autonomous/nested transactions are available in other database products, but are not natively supported in SQL Server. Fortunately there are several methods available to provide this functionality.
We'll cover the standard table variable techniques to preserve data outside of transaction scope, and how the new in-memory table type can improve their performance. Other techniques like user-defined events, CLR procedures, linked servers will also be demonstrated, and how they can enhance functionality.
We'll review minimal techniques like RAISERROR and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management.
SessionID: 56830
Building a Data Warehouse for the DBA
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: Pat Phelan
Title: Building a Data Warehouse for the DBA
Abstract:
Users want Data Warehouses built, but no one ever builds one for the DBA. Let#39;s fix that!
Get information from Active Directory, your Windows Servers, SQL Servers and other sources that mean something and will help you to keep the databases running smoothly. Be able to see which disks/machines are low on disk, what databases are on which SQL Servers, when backups happened and if any jobs failed.
This is targeted at the DBA who is responsible for multiple SQL Servers, in multiple places, and doesn#39;t have time to quot;point and clickquot; their way to a comfortable understanding of the moving pieces on all of the systems that they need to monitor!
NOTE: This session covers how to BUILD the warehouse, how to collect information and store it in relational tables in a way that makes sense as a warehouse. I#39;m developing a follow on session that presents the collected data using BI tools.
SessionID: 57114
SQL Server Databaseology: A Deep Dive Into Database Internals
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: John Morehouse
Title: SQL Server Databaseology: A Deep Dive Into Database Internals
Abstract:
Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.
SessionID: 57390
Distributed Replay, using it to plan for the future.
Event Date: 14-01-2017 - Session time: 13:30:00 - Track: Database Administration
Speaker: Paul Popovich Jr
Title: Distributed Replay, using it to plan for the future.
Abstract:
Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade. Right? Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.
SessionID: 54097
Enterprise Row Level Security in SQL Server 2016 and Azure SQL DB
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
Speaker: Jamey Johnston
Title: Enterprise Row Level Security in SQL Server 2016 and Azure SQL DB
Abstract:
The need for organizations to provide Row Level Security (RLS) in their applications is increasing every day, often in existing applications where code changes are not easy. Microsoft has addressed this need in SQL Server 2016/Azure SQL DB with predicate based RLS.
This session will show how organizational asset hierarchies are leveraged together to provide predicate-based RLS on tables in SQL Server 2016/Azure SQL Database without application changes. This session will go beyond the basic RLS setups and show a real-world production setup of RLS using a small number of security records to secure large and small organizations.
Attendees will leave with a complete working demo they can take to their work and begin to use immediately. The demo will walk completely through creating the database, creating the application tables and security related tables, loading demo and security data, setting up the RLS and testing the RLS using Power BI as a test application.
SessionID: 54128
The Decoder Ring for Data Warehousing / Business Intelligence with SQL Server
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Other
Speaker: Robert Cain
Title: The Decoder Ring for Data Warehousing / Business Intelligence with SQL Server
Abstract:
Business Intelligence is one of the hottest job skills in the IT field. DBAs and Database Developers are being asked to implement databases with non-traditional design, and are having a lot of new vocabulary thrown their way. In this talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean.
SessionID: 54917
Working Effectively With Legacy SQL
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Application Development
Speaker: Kevin Feasel
Title: Working Effectively With Legacy SQL
Abstract:
A legacy code base can be a frightening thing. Between strict deadlines, ever-evolving requirements, differing skill levels of contributors over time, and historical circumstances, keeping database code clean and concise is difficult at best. This example- and demo-driven talk will help you build out a mental framework to prune those gnarled code bases. Much of this talk will be familiar to software developers who know of the "clean code" philosophy, but no knowledge of the topic is necessary. If you shudder whenever you look at your SQL code base, this talk may be for you.
SessionID: 54926
25 SSMS Tips and Tricks to boost your Productivity
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Application Development
Speaker: Samir Behara
Title: 25 SSMS Tips and Tricks to boost your Productivity
Abstract:
Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.
By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.
SessionID: 54987
Save code changes on your SQL Servers with Event Notifications
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
Speaker: Michael Bourgon
Title: Save code changes on your SQL Servers with Event Notifications
Abstract:
Additionally, with it you gain other abilities, like real-time monitoring of deadlocks, warnings from SQL Server's errorlog, failed login attempts, datafile growth and more. You can automatically provide change reports to your auditors, even add the changes to source control. Get ahead of the technical curve and go from reactive to proactive!
SessionID: 56574
Managing Availability Groups with PowerShell
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: PowerShell
Speaker: Ben Miller
Title: Managing Availability Groups with PowerShell
Abstract:
SQL Server Always On Availability Groups are all the craze. When you have a need to failover or modify a configuration there are some things that you can only do with PowerShell. Aside from these items, PowerShell can completely manage an AG. Join me for a demo filled session where we will create an Always On Availability Group from scratch to management with PowerShell, including the Windows Server Failover Cluster. From changing parameters to failover, we will have a blast using PowerShell with ease of use to make your life better. Let’s work smarter and not harder when managing this great feature of SQL Server.
SessionID: 56819
Partitioning for Perf and Mgmt of Large Tables
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 56831
Data Architecture 101
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
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!
This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
SessionID: 57107
Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
Speaker: William Wolf
Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Abstract:
Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.
To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.
By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.
SessionID: 57549
Storage Testing for Database Professionals
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: Database Administration
Speaker: Argenis Fernandez
Title: Storage Testing for Database Professionals
Abstract:
SessionID: 57818
Azure Automation using PowerShell
Event Date: 14-01-2017 - Session time: 14:50:00 - Track: PowerShell
Speaker: Josh Luedeman
Title: Azure Automation using PowerShell
Abstract:
SessionID: 59339
Panel: Will the DBA Job of the Future Still Involve DBAs?
Event Date: 14-01-2017 - Session time: 14:50: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.