sqlsathistory

Nr: 545

SQLSaturday #545 - Pittsburgh 2016

Start Time (24h)	Speaker	Track	Title
08:45:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
08:45:00	Michael John	Enterprise Database Administration Deployment	What is a DBA?
08:45:00	Drew Furgiuele	Enterprise Database Administration Deployment	SQL Server Transactional Replication: A Deep Dive
08:45:00	Adam Belebczuk	Enterprise Database Administration Deployment	Availability Groups 101: An Introduction
08:45:00	Lance Tidwell	Enterprise Database Administration Deployment	SQL Server Agent: The life preserver for the drowning DBA
08:45:00	Jeremy Frye	BI Platform Architecture, Development Administration	Speed Up Your SSAS Cube#39;s Data Refresh With Dynamic Partition Processing
08:45:00	Jeff Moden	Application Database Development	The Secret to High Performance Code...The Devil’s in the Data
10:00:00	Kevin Feasel	Application Database Development	Peanut Butter Chocolate: Integrating Hadoop with SQL Server
10:00:00	Eugene Meidinger	BI Information Delivery	PowerBI Part 1: a business user#39;s perspective
10:00:00	Azhagappan Arunachalam	Cloud Application Development Deployment	Getting to know U-SQL
10:00:00	Slava Murygin	Enterprise Database Administration Deployment	What treasures are hidden in the Plan Cache?
10:00:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
10:00:00	Rick Heiges	Enterprise Database Administration Deployment	Winning with Columnstore - A Customer Story
10:00:00	Michael John	Professional Development	Basics of database design
11:15:00	Chris Bell	Enterprise Database Administration Deployment	Statistics Cardinality – How they work to find data efficiently
11:15:00	Andrew Loree	Enterprise Database Administration Deployment	Stretch Database and Managed Backups: Cloud Services for your SQL Servers
11:15:00	Mike Hillwig	Enterprise Database Administration Deployment	Leaving the Past Behind: Rewriting Your Checklist for SQL 2016
11:15:00	Eugene Meidinger	BI Information Delivery	PowerBI Part 2: PowerBI Internals
11:15:00	Pam Matthews	BI Platform Architecture, Development Administration	Master Data Management with SQL Master Data Services (MDS) and Ma
11:15:00	Brandi Dollar	Professional Development	Basics of querying
11:15:00	Brenda Bentz	Advanced Analysis Techniques	The Pros and Cons of Table Partitioning
12:55:00	Rick Heiges	Professional Development	SQL Games
12:55:00	Matt Nelson	Other	Plus Consulting sponsor session
12:55:00	Matt Nelson	Other	Teletracking sponsor session
12:55:00	Matt Nelson	Other	EMC sponsor session
12:55:00	Matt Nelson	Other	Profisee sponsor session
12:55:00	Matt Nelson	Other	Data Insights recruiting with Microsoft
13:30:00	Thomas Grohser	Enterprise Database Administration Deployment	Designing SQL Server HA/DR Infrastructure to meet the SLA
13:30:00	Timothy McAliley	Cloud Application Development Deployment	A Discussion on the Azure SQL Database Security for the Cloud Objectionist
13:30:00	Jonathan Stewart	BI Platform Architecture, Development Administration	An introduction to the magical world of BIML!
13:30:00	Kevin Kline	Enterprise Database Administration Deployment	Configuration Option and Trace Flag Secrets: Surprising Behavior at the Flick of a Switch
13:30:00	Allen White	Enterprise Database Administration Deployment	[#16
13:30:00	Sam Nasr	Application Database Development	Using Filetables
13:30:00	Cardell Washington	Professional Development	Basics of administration
14:40:00	Gigi Bell	Professional Development	Dealing With Difficult Managers
14:40:00	Robert Davis	Enterprise Database Administration Deployment	Exploiting SQL Server Security Holes
14:40:00	Carlos L Chacon	Other	SQL Data Partners Podcast Live QA session
14:40:00	Ben Galluzzo	BI Information Delivery	Working with SSRS Data-Driven Subscriptions
14:40:00	Michael Schulte	Analytics and Visualization	Extending SQL Server with Advanced Analytics and R
14:40:00	John Sterrett	Enterprise Database Administration Deployment	Synthetic vs Real-World Workloads: Benchmark Throwdown!
14:40:00	Kyle Walker	Advanced Analysis Techniques	Basics of BI/Data Warehousing
15:50:00	Ray Kim	Strategy and Architecture	Disaster Documents: The role of documentation in disaster recovery
15:50:00	Thomas Chan	Enterprise Database Administration Deployment	SQL Backup 102 - From basic to something more
15:50:00	Kevin Kline	Professional Development	The Most Important IT Person in the Room: Why Data Experts Own the Future
15:50:00	Steve Hood	Application Database Development	Buffer Pool Memory Management
15:50:00	Alex Grinberg	Application Database Development	How to build XML.
15:50:00	Sayed Saeed	BI Platform Architecture, Development Administration	The Business Intelligence Side of SQL Server
15:50:00	Michael John	Professional Development	Additional learning, getting hired, and wrap up

SessionID: 48751

New Instance, Now what?

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 48771

What is a DBA?

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael John

Title: What is a DBA?

Abstract:

What are the different kinds of DBA’s? What are the popular RDMS’s?

Presented by Michael John and Ed Wagner

SessionID: 48979

SQL Server Transactional Replication: A Deep Dive

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deep Dive

Abstract:

Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

SessionID: 49147

Availability Groups 101: An Introduction

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Belebczuk

Title: Availability Groups 101: An Introduction

Abstract:

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.

SessionID: 49619

SQL Server Agent: The life preserver for the drowning DBA

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Lance Tidwell

Title: SQL Server Agent: The life preserver for the drowning DBA

Abstract:

Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.

SessionID: 53548

Speed Up Your SSAS Cube#39;s Data Refresh With Dynamic Partition Processing

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: Speed Up Your SSAS Cube#39;s Data Refresh With Dynamic Partition Processing

Abstract:

Are you sometimes plagued with the unfortunate event of your SSAS cube refresh exceeding the scheduled maintenance window? Maybe you simply need to update recent data to reflect a critical change during business hours, but can’t afford several hours of downtime. I have a solution for you! In this session, we will focus on building an ETL framework while leveraging your cube’s logical partition design to dynamically process only the necessary data within your measure group. We will discuss audit logging, cube processing options, partition design and metadata access. These techniques and strategies will provide a faster data refresh process for your warehouse or data mart.

SessionID: 53934

The Secret to High Performance Code...The Devil’s in the Data

Back to calendar

Event Date: 01-10-2016 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Jeff Moden

Title: The Secret to High Performance Code...The Devil’s in the Data

Abstract:

You found code you need in a “Holy Grail” article complete with test data and tests across several methods “clearly” identifying the best one to use. Excited at your good fortune, you quickly download the code, rerun the tests on your Dev box . It “passes” with flying colors. You promote the code to production and go home on time for a change.

The next day, your boss and the DBA are waiting for you in your cube and, look, the DBA has a bat with your name on it because your code brought the server to its knees and the code failed. How is that possible? The answer is, “The Devil’s in the Data”. Whether you’re an SQL “Newbie” or seasoned veteran, this “Black Arts” session will teach you most of what you need to know to build large quantities of just about any test data you might imagine and more quickly than you ever dreamed. It’ll also show you how to avoid the pitfalls that lead to the DBA with the bat. ;

SessionID: 49052

Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract:

So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

SessionID: 49517

PowerBI Part 1: a business user#39;s perspective

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Eugene Meidinger

Title: PowerBI Part 1: a business user#39;s perspective

Abstract:

The Power BI Suite has been around for less than a year and is changing every week. However, the technology behind it has been around for years now. It can be confusing trying to understand PowerThis and PowerThat. In this session, we will cover the different parts of PowerBI and what it might be appealing. We do this from the perspective of a business user.

SessionID: 50802

Getting to know U-SQL

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Azhagappan Arunachalam

Title: Getting to know U-SQL

Abstract:

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

SessionID: 52326

What treasures are hidden in the Plan Cache?

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Slava Murygin

Title: What treasures are hidden in the Plan Cache?

Abstract:

Producing a query plan can be CPU costly process for a SQL Server. To avoid repeating these expensive steps, SQL Server Engine stores its query plans, in the plan cache where they can be reused as needed.

In this session, we’ll look at Plan Cache, what it is and what it contains, how query plans get into the Cache , how they are reused and how they get out.

SessionID: 52368

Crash Course on Better SQL Development

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

What does one need to know to become better SQL Developer? How can I write modular code to make it reusable? What about error handling? What is execution plan and how do I read it? Is there easier way to refactor code? All these questions and many others will be answered by writing some code, demo of free tools and showcasing SSDT.

SessionID: 52720

Winning with Columnstore - A Customer Story

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Heiges

Title: Winning with Columnstore - A Customer Story

Abstract:

This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

SessionID: 54460

Basics of database design

Back to calendar

Event Date: 01-10-2016 - Session time: 10:00:00 - Track: Professional Development

Speaker: Michael John

Title: Basics of database design

Abstract:

As part of the Wanna Be A DBA track

This session will dive into the design of databases. Including tables, views, normalization, cardinality, table relationships, foreign keys, and more.

SessionID: 49003

Statistics Cardinality – How they work to find data efficiently

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: Statistics Cardinality – How they work to find data efficiently

Abstract:

Are your statistics up to date?

Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

SessionID: 50165

Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Abstract:

Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.

SessionID: 50510

Leaving the Past Behind: Rewriting Your Checklist for SQL 2016

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: Leaving the Past Behind: Rewriting Your Checklist for SQL 2016

Abstract:

How big should the page file be for Windows Server 2016? How many data files should SQL Server 2016's TempDB contain? What trace flags should we use by default now?

These are questions you addressed long ago in your setup checklist. You've spent a lot of time with that checklist, and you're sure it's perfect. Or is it? When was the last time you visited that checklist? Does it make sense for SQL 2014? What about SQL 2016? Change is hard, and DBAs need to constantly challenge yesterday's best practices to ensure they meet today's business needs.

Join Microsoft MVP Mike Hillwig and his list of server administration best practices that need to be revisited for modern versions of SQL Server, especially SQL 2016.

SessionID: 53516

PowerBI Part 2: PowerBI Internals

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Eugene Meidinger

Title: PowerBI Part 2: PowerBI Internals

Abstract:

This session takes a deeper dive into PowerBI. We won#39;t be explaining the individual components, instead we will take time to go through the technology behind the scenes. We will discuss what is in a pbix file. We will cover how the Tabular data model works. Finally, we#39;ll review how the publishing and hosting infrastructure works.

SessionID: 54417

Master Data Management with SQL Master Data Services (MDS) and Ma

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Pam Matthews

Title: Master Data Management with SQL Master Data Services (MDS) and Ma

Abstract:

In this session, we will focus on how to formulate a Master Data Management (MDM) strategy and build a solution to find the single version of the truth, aka the Golden Record. While these techniques can apply to any data domain, we will demonstrate building a sample customer domain, showing how to leverage SQL Server Master Data Services (MDS) and other tools for data quality, matching, and de-duplication across multiple data sources.

SessionID: 54536

Basics of querying

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: Professional Development

Speaker: Brandi Dollar

Title: Basics of querying

Abstract:

We figured out what to put data into, we need to learn HOW to put it in, get it out, and modify data!

SessionID: 54537

The Pros and Cons of Table Partitioning

Back to calendar

Event Date: 01-10-2016 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Brenda Bentz

Title: The Pros and Cons of Table Partitioning

Abstract:

Have you considered implementing SQL Server partitioning? According to Wikipedia, “A partition is a division of a logical database or its constituent elements into distinct independent parts. Database partitioning is normally done for manageability, performance or availability reasons, as for load balancing”. Would you benefit from it or will it be a big headache for you? In a very straight forward approach, I will introduce what, when, why and how to create partition.

SessionID: 52721

SQL Games

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Professional Development

Speaker: Rick Heiges

Title: SQL Games

Abstract:

SessionID: 54388

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Abstract:

Attend this session to learn more about Plus Consulting

SessionID: 54389

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Abstract:

TeleTracking in the Cloud!

TeleTracking has been the industry leader in automated healthcare solutions for the past 25 years. From EVS to Transport, TeleTracking has automated solutions available to eliminate waste in healthcare. Come see our future solutions where we explain our products in the cloud using SaaS(Software as a Service), PaaS(Platform as a service), IaaS(Infrastructure as a service), and DBaaS(Database as a service).

SessionID: 54390

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Abstract:

Attend this session to learn more about EMC

SessionID: 54391

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Abstract:

Attend this session to learn more about Profisee

SessionID: 54686

Data Insights recruiting with Microsoft

Back to calendar

Event Date: 01-10-2016 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Title: Data Insights recruiting with Microsoft

Abstract:

Join Steve Tiano to learn more about working at Microsoft on the Data Insights PFE and consulting services team.

SessionID: 49413

Designing SQL Server HA/DR Infrastructure to meet the SLA

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Grohser

Title: Designing SQL Server HA/DR Infrastructure to meet the SLA

Abstract:

Once you agreed to an SLA for the databases you manage its time to deliver on this promise

This session will show how to select from the many HA/DR features you have in SQL Server to pick the ones that will help you meet the SLA and most important will tell you how you must combine them to be successful. For each one of the solutions we discuss we will define a series of failure modes and then check if the solution actually can fulfill the SLA as promised or if it needs more

SessionID: 51134

A Discussion on the Azure SQL Database Security for the Cloud Objectionist

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Timothy McAliley

Title: A Discussion on the Azure SQL Database Security for the Cloud Objectionist

Abstract:

SessionID: 53134

An introduction to the magical world of BIML!

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 53406

Configuration Option and Trace Flag Secrets: Surprising Behavior at the Flick of a Switch

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: Configuration Option and Trace Flag Secrets: Surprising Behavior at the Flick of a Switch

Abstract:

If you’ve been a SQL Server DBA or Dev for any length of time, you’ve probably heard of various options that you can set at the instance- or database-level that can impact performance. Do you know what they are, when to use them, or what they do? And what about all of those trace flags? There are so many of them and many are undocumented. What gives? In this session, you’ll learn about a variety of ways to speed up IO, adjust memory, change plan and buffer cache behavior, debug the SQL query optimizer, and how to punch SQL Server in the face!

SessionID: 53475

#16 | Maintain SQL Server Performance Baseline w/PowerShell

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: #16 | Maintain SQL Server Performance Baseline w/PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 53590

Using Filetables

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Sam Nasr

Title: Using Filetables

Abstract:

The FileStream feature allows BLOBs to be managed by the DB. FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system but with benefits only a database can offer, such as text searching and querying.

SessionID: 54534

Basics of administration

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Professional Development

Speaker: Cardell Washington

Title: Basics of administration

Abstract:

Covers the day to day administrative duties of a DBA, such as backups, high availability, disaster recovery, security, etc.

SessionID: 49007

Dealing With Difficult Managers

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Professional Development

Speaker: Gigi Bell

Title: Dealing With Difficult Managers

Abstract:

We have all encountered difficult managers that leave us stressed out. They can be micro-managers, bullies, too timid, or even just apathetic. In any case, you are currently stuck with this manager, and you need coping strategies!

Through case studies and open discussion, we will help you determine if you indeed have a difficult manager. We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her. In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.

SessionID: 52614

Exploiting SQL Server Security Holes

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Davis

Title: Exploiting SQL Server Security Holes

Abstract:

Most flaws in SQL Server can be avoided with proper security policies ... as long as those policies are followed. What can happen if they are not followed or security is very loose? A lot of people will tell you what not to do, but has anyone ever shown you what can happen if you do them anyway?

This demo heavy session will show you just what I could do in these situations if I was so inclined to exploit these lapses in security. You will learn how to prevent these security holes to ensure you are protected.

SessionID: 53231

SQL Data Partners Podcast Live QA session

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Other

Speaker: Carlos L Chacon

Title: SQL Data Partners Podcast Live QA session

Abstract:

Let's bring the 'hallway track' into a session! We'll have a panel of 3-4 speakers and discuss some items that on the minds of the attendees. It will be recorded and made available later in podcast format.

SessionID: 53560

Working with SSRS Data-Driven Subscriptions

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: BI Information Delivery

Speaker: Ben Galluzzo

Title: Working with SSRS Data-Driven Subscriptions

Abstract:

SSRS Subscriptions are one of the great things within SSRS to automate delivery of reports. However, one of the more powerful methods of further enhancing this automation is by use of data-driven subscriptions. Data-driven subscriptions allow us to determine at run time what subscribers and other parameters can be used for automating the generation of these reports.

We#39;ll begin with a quick overview of what the more familiar subscription functionality is and then quickly jump into what data-driven subscriptions provide for us. We#39;ll then demonstrate from beginning to end how to implement data-driven-subscriptions. Lastly, we#39;ll wrap up with any tips and tricks to enhance our process.

SessionID: 53570

Extending SQL Server with Advanced Analytics and R

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Analytics and Visualization

Speaker: Michael Schulte

Title: Extending SQL Server with Advanced Analytics and R

Abstract:

The Microsoft SQL Server stack provides an excellent set of tools for storing, visualizing, and analyzing data, but sometimes we want to do more. In this session, we’ll take a look at the various ways that we can apply advanced analytics by using the R programming language on top of SQL Server. We#39;ll consider the advantages and capabilities of SQL Server R Services and look at how to set up a development environment. Along the way, we will discuss the data science workflow and consider some examples of advanced analytics that are commonly used.

SessionID: 53707

Synthetic vs Real-World Workloads: Benchmark Throwdown!

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Synthetic vs Real-World Workloads: Benchmark Throwdown!

Abstract:

How much do you really understand how your workload changes based on the time of day, background processing, user load, or which application module is in use? There's no better way to understand your workload than to benchmark and replay it. This will help you mitigate risk in production before making changes, allow you to find and improve bottlenecks in your code or infrastructure. In this session, you will learn how to compare and replay your own workload and synthetic TPC-C workloads in your environment to make you look like a rockstar.

SessionID: 54535

Basics of BI/Data Warehousing

Back to calendar

Event Date: 01-10-2016 - Session time: 14:40:00 - Track: Advanced Analysis Techniques

Speaker: Kyle Walker

Title: Basics of BI/Data Warehousing

Abstract:

With more and more businesses entering the twenty-first century, they are finding themselves with more and more data. In this session, I will cover the basics of the Microsoft Business Intelligence stack and show how that data is leveraged to make informed business decisions.

SessionID: 48888

Disaster Documents: The role of documentation in disaster recovery

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Strategy and Architecture

Speaker: Ray Kim

Title: Disaster Documents: The role of documentation in disaster recovery

Abstract:

I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. Prior to that infamous date, I had written several departmental documents that ended up being critical to our recovery. In this presentation, I provide a narrative of what happened in the weeks following 9/11, and how documentation played a role in getting the organization back on its feet.

While other disaster recovery presentations talk about strategies, plans, and techniques, this presentation focuses on the documentation itself. We will discuss the documents we had and how they were used in our recovery. We will also discuss what documents we didn't have, and how they could have made the process better.

SessionID: 52789

SQL Backup 102 - From basic to something more

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: SQL Backup 102 - From basic to something more

Abstract:

We will start with the importance of backup for a database administrator.

The second part will cover backup/recovery strategy and the three backup types including a demo. The last part will cover the other techniques not considered as a normal backup process but can be used for it like attach/detach, import/export, replication and disaster recovery (log shipping).

SessionID: 53403

The Most Important IT Person in the Room: Why Data Experts Own the Future

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Professional Development

Speaker: Kevin Kline

Title: The Most Important IT Person in the Room: Why Data Experts Own the Future

Abstract:

SessionID: 53579

Buffer Pool Memory Management

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Application Database Development

Speaker: Steve Hood

Title: Buffer Pool Memory Management

Abstract:

Understand what#39;s in memory, why it#39;s there, and how to reduce the footprint if that#39;s reasonable. Find your large queries with several techniques, justify them, and tune them. Find indexes to drop, consolidate, or create. Finally, purge your data, because even our accounts hire pyromaniacs with scissors!

SessionID: 53937

How to build XML.

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Application Database Development

Speaker: Alex Grinberg

Title: How to build XML.

Abstract:

This session will cover process to create an XML as resultset from the table(s). Live demo samples will include and cover FOR XML clause, also RAW, ELEMENTS, AUTO, PATH, ROOT, and TYPE modes.

SessionID: 54138

The Business Intelligence Side of SQL Server

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sayed Saeed

Title: The Business Intelligence Side of SQL Server

Abstract:

This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft's top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

SessionID: 54461

Additional learning, getting hired, and wrap up

Back to calendar

Event Date: 01-10-2016 - Session time: 15:50:00 - Track: Professional Development

Speaker: Michael John

Title: Additional learning, getting hired, and wrap up

Abstract:

Closing out the day for Wanna Be A DBA, this session will pull everything together. What steps to take to get hired as a DBA. Additional learning opportunities to continue learning after today, Answering any questions that you may have.

This site is open source. Improve this page.