Nr: 491
SQLSaturday #491 - Pensacola 2016
SessionID: 41800
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Application Database 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. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. 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 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: 46412
Beginning SQL Server Investigation and Troubleshooting
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Eric Wisdahl
Title: Beginning SQL Server Investigation and Troubleshooting
Abstract:
You have just been handed the keys to the kingdom - unfortunately, you've also been handed all of the responsibility to ensure that everything is running as expected. In this session we will take a high level look at topics which will be necessary for properly ensuring that your servers are running as flawlessly as possible. We will discuss what SQL Server is telling us through its' dynamic management objects, some great tools from the community on how to interpret these signals as well as how to set up maintenance, and finally how we will diagnose what is going on when your server is having issues.
SessionID: 46687
Parent, Child development Using SSIS Framework
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: BI Information Delivery
Speaker: Jorge Novo
Title: Parent, Child development Using SSIS Framework
Abstract:
Learn how to extend and reuse SSIS development using package controllers and drivers. Extend parallel process and view the different options for SSIS package configurations and become the GURU on ETL development for your organization
SessionID: 46702
Only You Can Prevent Database Fires!
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: John Morehouse
Title: Only You Can Prevent Database Fires!
Abstract:
Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!
SessionID: 46835
End to End Protection with Always Encrypted in SQL Server 2016
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Application Database Development
Speaker: Steve Jones
Title: End to End Protection with Always Encrypted in SQL Server 2016
Abstract:
Protecting our data from unauthorized access becomes more and more important all the time, however it has been difficult to ensure sensitive data is encrypted in SQL Server. The new Always Encrypted feature in SQL Server 2016 makes this much simpler for developers and DBAs with a framework for protecting data from the client, across networks, and inside of the database. This new feature allows for limiting access to the data, even from the DBAs and sysadmins that may control the database instance itself. Learn how to implement and use Always Encrypted in your applications.
SessionID: 46988
Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Event Date: 04-06-2016 - Session time: 08:30:00 - Track: Cloud Application Development Deployment
Speaker: Julie Smith
Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.
Abstract:
Azure Data Factory is a json based data integration tool. It is not SSIS in the cloud, but like SSIS, its main purpose is moving data. This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.
SessionID: 41866
Beginners SQL Server Security the Low Hanging Fruit
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Lindsay Clark
Title: Beginners SQL Server Security the Low Hanging Fruit
Abstract:
Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.
SessionID: 42182
Introduction to SQL Server Integration Services
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: BI Information Delivery
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: 43037
Introducing Forensic Analytics with Power BI
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: Analytics and Visualization
Speaker: William E Pearson III
Title: Introducing Forensic Analytics with Power BI
Abstract:
Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents. Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected. We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ Power BI to drive Forensic Analytics via various tests and reviews.
SessionID: 44323
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Anthony Nocentino
Abstract:
SessionID: 49918
SQL 2012 2014 Extended Events
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Gareth Swanepoel
Title: SQL 2012 2014 Extended Events
Abstract:
SessionID: 50794
Giving Feedback: How to Effectively Communicate to your Employees
Event Date: 04-06-2016 - Session time: 10:15:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Giving Feedback: How to Effectively Communicate to your Employees
Abstract:
SessionID: 41727
Understanding SQL Server Backup and Restore
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Radney
Title: Understanding SQL Server Backup and Restore
Abstract:
SessionID: 41731
SQL Admin Best Practices with DMVs
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Speaker: William Assaf
Title: SQL Admin Best Practices with DMVs
Abstract:
In this practical and script-focused session, we'll discuss many best practices regarding SQL Server administration, maintenance, optimizations and monitoring using Dynamic Management Views. DMV's are essential tools for the SQL administrator, but have a wide range of applications by developers, network engineers and DBAs. We will delve into best practices for server maintenance, index fragmentation, XEvents, wait type analysis and future features. This session will be informative and eye-opening to anyone from a junior DBA on up.
SessionID: 41737
Getting started with Tabular Analysis Services
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Thomas LeBlanc
Title: Getting started with Tabular Analysis Services
Abstract:
This session will give the basics of starting a tabular model with Analysis Services 2014 and PowerView from Excel 2013. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in PowerView from Excel 2013.
SessionID: 41934
Overview of Security Investments in SQL Server 2016 and Azure SQL Database
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
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: 45624
Mastering and Enhancing Company Data
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: BI Information Delivery
Speaker: Rushabh Mehta
Title: Mastering and Enhancing Company Data
Abstract:
SessionID: 50861
Women in Technology: Identifying, Understanding and Combating Gen
Event Date: 04-06-2016 - Session time: 11:30:00 - Track: Professional Development
Speaker: Rie Irish
Title: Women in Technology: Identifying, Understanding and Combating Gen
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 about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some 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: 50477
RedGate - Automatically Tracking Deploying Database Changes in Order
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Steve Jones
Title: RedGate - Automatically Tracking Deploying Database Changes in Order
Abstract:
Managing individual database scripts is often seen as slow, old-fashioned and error-prone. But how times have changed. With more teams automating deployments, script-based change processes (sometimes called “Migrations”) are undergoing a renaissance. When the SQL code is visible up-front, an exact change can be rehearsed through progressively more realistic test environments, so that deployment contains no surprises.
Come see how easy it can be to track all your database changes in Visual Studio and deploy those changes to a test and production environments reliably.
SessionID: 50478
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Janis Griffin
Abstract:
SessionID: 50479
SQL and VMWare - More than just virtualization demos
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
Speaker: Rodney Landrum
Title: SQL and VMWare - More than just virtualization demos
Abstract:
SessionID: 50795
Cisco UCS for the Data Professional
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Tim Radney
Title: Cisco UCS for the Data Professional
Abstract:
Tim Radney will share his experience with working with clients from all over the world that utilize Cisco UCS for the underlying infrastructure as well as how he helped a client migrate thousands of databases with over 100 instances to Cisco's UCS.
SessionID: 50860
SIOS - Clusters Your Way
Event Date: 04-06-2016 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
Speaker: Brandon Leach
Title: SIOS - Clusters Your Way
Abstract:
SAN and SANless clusters for physical, virtual, and cloud environments
SessionID: 41858
Execution Plans for Mere Mortals
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Application Database 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: 42036
Azure SQL Database: Deployment and Development of Your First DB
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
Speaker: Sven Aelterman
Title: Azure SQL Database: Deployment and Development of Your First DB
Abstract:
SessionID: 42841
Managing a Production Azure SQL Database - True Story!
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
Speaker: Jason Hall
Title: Managing a Production Azure SQL Database - True Story!
Abstract:
I develop for and manage a small, but active, web application that lives completely inside of Azure from code to data. I've been involved with it since inception, and I've learned a few things about developing for, and managing data in this environment the hard way.
I'd like to share some of the lessons I've learned in hopes that it can save others some time.
SessionID: 47318
Why Should I Care About ... Partitioned Views?
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Rick Lowe
Title: Why Should I Care About ... Partitioned Views?
Abstract:
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And we don't just talking about standard edition - they are also great for special indexing needs, multidimensional partitioning for starters. Come hear why this is still an important topic long after cargo pants and trucker hats went away.
SessionID: 47567
NEW FEATURES WITH SQL SERVER 2016 REPORTING SERVICES
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: BI Information Delivery
Speaker: David Pless
Title: NEW FEATURES WITH SQL SERVER 2016 REPORTING SERVICES
Abstract:
1). NEW FEATURES WITH SQL SERVER 2016 REPORTING SERVICES (75 minutes) (Level 200)
ABSTRACT:
In this session we will outline the new features of SQL Server 2016 Reporting Services that puts the power of data in the hands of everyone. In this session we will cover the alignment of Microsoft’s cloud and on-premises reporting solutions. We will cover how existing SSRS and PowerBI expertise will transfer across these deployment modalities so you can easily mix and match on-premises and cloud components. We will cover paginated, interactive, and mobile reporting, dashboards, and analytical report and charts.
We will focus on the new capabilities of mobile reporting and web based reporting which allows for greater consumption of your report capabilities across the board.
We will cover the new visualizations and Power BI integration dashboard. This further allows you to leverage your existing reporting investments in SQL Server Reporting Services.
SessionID: 49925
Power BI – Exploring New Frontiers
Event Date: 04-06-2016 - Session time: 13:45:00 - Track: Analytics and Visualization
Speaker: Pam Shaw
Title: Power BI – Exploring New Frontiers
Abstract:
SessionID: 42124
I'm It - Survival Techniques for the Lone DBA
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Professional Development
Speaker: Monica Rathbun
Title: I'm It - Survival Techniques for the Lone DBA
Abstract:
Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.
SessionID: 42238
Tuning SQL Server for SharePoint
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Other
Speaker: Daniel Glenn
Title: Tuning SQL Server for SharePoint
Abstract:
Some of the topics covered will include: the configuration steps and settings needed for SQL Server to properly host SharePoint databases, database size considerations, the SQL permissions your SharePoint administrators REALLY need, and why SharePoint databases have a GUID in their name (and how to avoid them!).
SessionID: 45179
Crash Course on Better SQL Development
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Application Database Development
Speaker: Vladimir Oselsky
Title: Crash Course on Better SQL Development
Abstract:
SessionID: 46620
Top 10 Wait Types Everyone Should Know
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Janis Griffin
Title: Top 10 Wait Types Everyone Should Know
Abstract:
SessionID: 46947
PowerShell Desired State Configuration from the Trenches
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: Other
Speaker: Mike Robbins
Title: PowerShell Desired State Configuration from the Trenches
Abstract:
SessionID: 51036
A SQL Developer’s Guide to MDX Basics
Event Date: 04-06-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Shabnam Watson
Title: A SQL Developer’s Guide to MDX Basics
Abstract:
You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.
In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.
SessionID: 41729
Fundamentals of Disaster Planning Recovery
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: Strategy and Architecture
Speaker: Michael Viron
Title: Fundamentals of Disaster Planning Recovery
Abstract:
In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.
SessionID: 44752
Tame Your Unruly Data...With Constraints!
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: Application Database Development
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 45542
Data Pages, Allocation Units, IAM chains... Oh My!
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Brandon Leach
Title: Data Pages, Allocation Units, IAM chains... Oh My!
Abstract:
Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the 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. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.
SessionID: 47474
Tone Analysis with HDInsight and Azure Machine Learning
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: BI Information Delivery
Speaker: Paco Gonzalez
Title: Tone Analysis with HDInsight and Azure Machine Learning
Abstract:
People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
SessionID: 48382
Let Me Finish... Isolating Write Operations
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: Application Database Development
Speaker: Louis Davidson
Title: Let Me Finish... Isolating Write Operations
Abstract:
SessionID: 50793
Hostile Takeover
Event Date: 04-06-2016 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Robert Bishop
Title: Hostile Takeover
Abstract:
In the spirit of Tim Ford's year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the "health" of the server.