sqlsathistory

Nr: 574

Back to Main list

SQLSaturday #574 - Washington DC 2016

Start Time (24h) Speaker Track Title
08:20:00 Jamie Wick Enterprise Database Administration Deployment Automated SQL Server installation and configuration using PowerShell
08:20:00 David Dye BI Information Delivery Location Location Location Preparing and Presenting Geographic Data
08:20:00 David Klee Professional Development The Many Paths of Consulting
08:20:00 Timothy McAliley Enterprise Database Administration Deployment A Discussion on Azure SQL Database Security Features for the Cloud Objectionist
08:20:00 Eugene Meidinger BI Information Delivery PowerBI Internals
08:20:00 Andy Mallon Enterprise Database Administration Deployment Demystifying Data Compression
08:20:00 Adam Machanic Intermediate Dev Don't Let History Be a Mystery! Temporal Data in SQL Server 2016
08:20:00 Rick Lowe Enterprise Database Administration Deployment Why Should I Care About ... Partitioned Views?
09:45:00 David Patrick Analytics and Visualization Using Excel Web Services to Create Dashboards in SharePoint
09:45:00 Kevin Feasel Analytics and Visualization R For the SQL Server Developer
09:45:00 James Serra Professional Development Enhancing your career: Building your personal brand
09:45:00 George Govantes Professional Development Getting to 99.99% Uptime Delivering Operational Excellence
09:45:00 Allan Hirt Enterprise Database Administration Deployment Top 10 Dos and Don’ts for Clustered SQL Server Implementations
09:45:00 Slava Murygin Intermediate DBA SQL Server on Windows Core. Installation and Configuration.
09:45:00 Kendra Little Intro DBA Troubleshooting Blocking for Beginners
09:45:00 Ed Leighton-Dick Application Database Development Understanding SQL Server 2016 Always Encrypted
11:10:00 David Dye BI Platform Architecture, Development Administration Creating Dynamic Packages
11:10:00 Andrew Kelly Intermediate DBA The Art of War with Bad Code
11:10:00 Jessica Moss BI Information Delivery Introduction to SQL Server Reporting Services 2016
11:10:00 Monica Rathbun Professional Development I’m It – Survival Techniques for the Lone DBA
11:10:00 William Wolf Application Database Development Blue Collar SQL Tricks - Make Standard Edition Work for you.
11:10:00 Rie Irish Professional Development WIT: Identifying, Understanding and Combating Gender Bias
11:10:00 John Morehouse Enterprise Database Administration Deployment SQL Server Databaseology: A Deep Dive Into Database Internals
11:10:00 Rick Lowe Enterprise Database Administration Deployment Why should I care about ... the plan cache?
13:40:00 Alex Grinberg Intermediate DBA CONVERT_IMPLICIT is a hidden danger
13:40:00 Ayman El-Ghazali Other PolyBase: I now pronounce you SQL and Hadoop
13:40:00 Mindy Curnutt Professional Development Imposter Syndrome: Are You Faking It Will they Find Out?
13:40:00 Niran Even-Chen Enterprise Database Administration Deployment SQL and VMware - more than just virtualization demos
13:40:00 Wayne Sheffield Enterprise Database Administration Deployment SQL Server 2016: Temporal Tables and Dynamic Data Masking
13:40:00 Mike Hillwig Enterprise Database Administration Deployment Rewriting Your Checklist for SQL 2016
13:40:00 Jessica Moss BI Platform Architecture, Development Administration Introduction to SQL Server Integration Services 2016
13:40:00 Sebastian Meine Application Database Development Unit-Testing in SQL Server - An Introduction
15:05:00 Thomas Grohser Application Database Development Security 101
15:05:00 Andrew Kelly Intermediate DBA Query Store – What is it all about?
15:05:00 Mark Hudson Intermediate BI Introducing Azure Machine Learning
15:05:00 Mindy Curnutt Application Database Development Fun with SQL Server Spatial Data
15:05:00 Stephen Frost Application Database Development Introduction to PostgreSQL
15:05:00 Amy Herold Enterprise Database Administration Deployment Hi, my name is Powershell, let's be friends! An Intro to PoSH
15:05:00 Sebastian Meine Professional Development The Phenomenal IT Consultant
15:05:00 Brad McKuhen Intermediate BI Extending the SSIS Framework to be region aware

SessionID: 53371

Automated SQL Server installation and configuration using PowerShell

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Jamie Wick

Title: Automated SQL Server installation and configuration using PowerShell

Abstract:

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.

SessionID: 53449

Location Location Location Preparing and Presenting Geographic Data

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: BI Information Delivery

Speaker: David Dye

Title: Location Location Location Preparing and Presenting Geographic Data

Abstract:

This session will begin with the tasks necessary to model a dimensional data structure to maintain and present geographic data. We will discuss various requirements that can affect a data model such as granularity, surrogate keys, slowly changing dimensions. Real life examples and solutions will provided to give better context to each step in the process.

After the data structure has been created we will focus on how to best “clean” and validate the geographic data. We will focus on using SSIS to obtain latitude and longitude and then how this can be converted SQL Server spatial types. Finally we will cover presenting this data using SSRS and Power Map and how to create dynamic and aesthetically pleasing graphical reports. This portion of the session concentrates on presenting reports using the geographic data type that answer specific questions such as: Events that occurred at a specific address, zip code, and even block range and events within a mile radius.

SessionID: 53753

The Many Paths of Consulting

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Professional Development

Speaker: David Klee

Title: The Many Paths of Consulting

Abstract:

People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

SessionID: 53797

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

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Timothy McAliley

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

Abstract:

SessionID: 54784

PowerBI Internals

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: BI Information Delivery

Speaker: Eugene Meidinger

Title: PowerBI Internals

Abstract:

This session takes a deeper dive into PowerBI. We won't be explaining the individual components, instead we will take time to go through the technology behind the scenes. We will dig into the Vertipaq engine and how it affects performance. We will look into how customer visuals are made. Finally, we will quickly cover the architecture of the Power BI Service.

SessionID: 54901

Demystifying Data Compression

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

High-end storage is expensive, and SQL Server data compression can make your database smaller. So compress all the tables!

No--unfortunately, it's not that easy. We'll talk about how data compression actually works, and the differences between ROW and PAGE compression. As part of this, we'll look at the costs and benefits associated with each type of compression. By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 55151

Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20:00 - Track: Intermediate Dev

Speaker: Adam Machanic

Title: Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Abstract:

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.

SessionID: 55169

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 03-12-2016 - Session time: 08:20: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 not necessarily just for standard edition. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away.

SessionID: 53345

Using Excel Web Services to Create Dashboards in SharePoint

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: David Patrick

Title: Using Excel Web Services to Create Dashboards in SharePoint

Abstract:

In this session, we'll do a deep dive into Excel Web Services, a feature of SharePoint, that allows us to use Excel to create custom dashboards. Dashboards are pages served up by SharePoint and we'll look at how to create these pages, add Excel Web Services web parts to these pages, and arrange these web parts and "connect" these parts to communicate with each other, to create interactive, updating dashboards for our users.

SessionID: 53424

R For the SQL Server Developer

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 53784

Enhancing your career: Building your personal brand

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Professional Development

Speaker: James Serra

Title: Enhancing your career: Building your personal brand

Abstract:

SessionID: 54020

Getting to 99.99% Uptime Delivering Operational Excellence

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Professional Development

Speaker: George Govantes

Title: Getting to 99.99% Uptime Delivering Operational Excellence

Abstract:

How does one take advice from the top leadership experts and translate into action? As one's responsibilities grow many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some will argue this is out of my scope of responsibilities why should I care about the building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.

SessionID: 54148

Top 10 Dos and Don’ts for Clustered SQL Server Implementations

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: Top 10 Dos and Don’ts for Clustered SQL Server Implementations

Abstract:

Whether you are a new DBA or a seasoned veteran, clustered implementations of SQL Server can still vex many in one way or another. Physical, virtual, and cloud-based architectures all have different subtle complexities when it comes to deploying either clustered instances of SQL Server (FCIs) or availability groups (AGs) regardless if you are using an older version or SQL Server 2016. Storage, networking, Active Directory, quorum, the overall underlying Windows Server failover cluster, and more are topics that come up quite often. This session will cut to the chase and concentrate nearly 20 years of experience down into the most relevant aspects of planning, deployment, and administration of clustered implementations that every DBA should know. The ten dos and don’ts presented could not only mean the difference between success and failure, but whether your systems are up or down.

SessionID: 54314

SQL Server on Windows Core. Installation and Configuration.

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Intermediate DBA

Speaker: Slava Murygin

Title: SQL Server on Windows Core. Installation and Configuration.

Abstract:

Would you consider building your next SQL Server in Windows Core Environment?

Do you have enough knowledge? In this session we will go step by step through an installation, remote configuration and administration of SQL Server using PowerShell scripts.

SessionID: 55138

Troubleshooting Blocking for Beginners

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Intro DBA

Speaker: Kendra Little

Title: Troubleshooting Blocking for Beginners

Abstract:

Your SQL Server is slow, and you suspect blocking. You need to set up simple, lightweight monitoring using free tools to document who’s holding locks, who’s stuck waiting, and which queries are causing deadlocks. In this session we will work through three common scenarios where blocking problems steal your performance -- and sometimes even kill your queries! You'll learn how to cut through the confusion with free scripts that reveal why queries are slowing down your SQL Server.

SessionID: 55156

Understanding SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 03-12-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server 2016 Always Encrypted

Abstract:

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

SessionID: 53447

Creating Dynamic Packages

Back to calendar

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

Speaker: David Dye

Title: Creating Dynamic Packages

Abstract:

In a perfect world an ETL solution would only have to import data from a single file that always had the same name deliver it to a single already existing table. Unfortunately this case is the exception rather than the rule. How can you use SSIS to:

  1. Iterate through all files in a folder and import their content into SQL
  2. Dynamically create and name table based on a data source
  3. Dynamically create a T-SQL statement at runtime based on run time conditions This session focuses on how to create SSIS packages that can change to meet runtime events dynamically based on the environment. Each attendee will leave with the knowledge and toolset necessary to:
  4.  Use expressions within SSIS packages
    
  5.  Use variables to dynamically create SQL statements
    
  6.  Configure custom dynamic logging
    
  7.  Use package configurations and parameters and environments to make packages more portable at execution
    
  8. Replace dynamic SQL using expressions in SSIS

SessionID: 53943

The Art of War with Bad Code

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Intermediate DBA

Speaker: Andrew Kelly

Title: The Art of War with Bad Code

Abstract:

Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.

SessionID: 54689

Introduction to SQL Server Reporting Services 2016

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: BI Information Delivery

Speaker: Jessica Moss

Title: Introduction to SQL Server Reporting Services 2016

Abstract:

Reports, dashboards, and indicators are an essential part of your job as a report analyst. SQL Server Reporting Services (SSRS) 2016 gives you the ability to create these items to share with coworkers and management. This session will walk you through how to design, develop, deploy, and maintain reports within your environment. As a bonus, we will cover mobile reports, introduced in SSRS 2016!

SessionID: 54829

I’m It – Survival Techniques for the Lone DBA

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10: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: 54909

Blue Collar SQL Tricks - Make Standard Edition Work for you.

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Application Database Development

Speaker: William Wolf

Title: Blue Collar SQL Tricks - Make Standard Edition Work for you.

Abstract:

You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just the Standard version we have to dig into our “Blue Collar” roots, we need to become more creative and squeeze every penny it has to offer out of it.

In this session, we will review some of the limitations that Standard has. Then review items such as basic normalization and High Availability options available to Standard. You will also learn Blue Collar techniques to implement partitioning using techniques like as indexed views and partitioned views.

Let’s dig in and learn to make use of all we have until we beg our bosses enough to get Enterprise Edition!

SessionID: 54956

WIT: Identifying, Understanding and Combating Gender Bias

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Professional Development

Speaker: Rie Irish

Title: WIT: Identifying, Understanding and Combating Gender Bias

Abstract:

Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women and 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 and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

SessionID: 55002

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

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: 55167

Why should I care about ... the plan cache?

Back to calendar

Event Date: 03-12-2016 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 53551

CONVERT_IMPLICIT is a hidden danger

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Intermediate DBA

Speaker: Alex Grinberg

Title: CONVERT_IMPLICIT is a hidden danger

Abstract:

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

SessionID: 53669

PolyBase: I now pronounce you SQL and Hadoop

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Other

Speaker: Ayman El-Ghazali

Title: PolyBase: I now pronounce you SQL and Hadoop

Abstract:

If you thought the Royal wedding of 2011 was a big deal, then you#39;re about to be blown away! This is a match made in Data Heaven. You#39;re all invited, no need to RSVP, there is plenty of food for thought in this session. There will be some background talk and a demo for querying and creating data on HDFS (using Azure Blobs). As a special gift to the happy couple, we will also have a special demo with JSON documents. This will be the greatest coming together of 2016! See you there!

SessionID: 54299

Imposter Syndrome: Are You Faking It Will they Find Out?

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Professional Development

Speaker: Mindy Curnutt

Title: Imposter Syndrome: Are You Faking It Will they Find Out?

Abstract:

Have you ever thought to yourself “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

SessionID: 54519

SQL and VMware - more than just virtualization demos

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Niran Even-Chen

Title: SQL and VMware - more than just virtualization demos

Abstract:

The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. As a true platform of virtualized hardware, vSphere should be considered the premier platform on which to implement SQL Server. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.”

SessionID: 54568

SQL Server 2016: Temporal Tables and Dynamic Data Masking

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Wayne Sheffield

Title: SQL Server 2016: Temporal Tables and Dynamic Data Masking

Abstract:

SQL Server 2016 introduces many new features and enhancements. This session will look into two of those: Temporal Tables and Dynamic Data Masking. Temporal Tables simplifies the task of building a history table to track all data changes so that you can see how the data looked at a specific point in time, while Dynamic Data Masking is used to obfuscate data from users (for example, show just the last 4 characters of your SSN). This session is >90% demos!

SessionID: 54598

Rewriting Your Checklist for SQL 2016

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Hillwig

Title: 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 veteran DBA 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: 54688

Introduction to SQL Server Integration Services 2016

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jessica Moss

Title: Introduction to SQL Server Integration Services 2016

Abstract:

SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data. Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information. Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.

SessionID: 55161

Unit-Testing in SQL Server - An Introduction

Back to calendar

Event Date: 03-12-2016 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Sebastian Meine

Title: Unit-Testing in SQL Server - An Introduction

Abstract:

It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.

SessionID: 53533

Security 101

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development

Speaker: Thomas Grohser

Title: Security 101

Abstract:

Integrating security into your database design. Learn how to use roles, schemas and encryption to secure the data. A very demo rich session that will introduce you to security on the database level. We start with understanding GRANT, REVOKE and DENY while working our way through the object hierarchy till we end up at the column level when we have a lock at encryption. This session will also cover new SQL 2016 security features and how to use them correctly.

SessionID: 53942

Query Store – What is it all about?

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate DBA

Speaker: Andrew Kelly

Title: Query Store – What is it all about?

Abstract:

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.

SessionID: 53994

Introducing Azure Machine Learning

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate BI

Speaker: Mark Hudson

Title: Introducing Azure Machine Learning

Abstract:

Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AML experiment. Join me to see how AML might meet your advanced data analysis needs.

SessionID: 54298

Fun with SQL Server Spatial Data

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: Fun with SQL Server Spatial Data

Abstract:

SessionID: 54658

Introduction to PostgreSQL

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Application Database Development

Speaker: Stephen Frost

Title: Introduction to PostgreSQL

Abstract:

PostgreSQL is a powerful, open source object-relational database system with decades of continuous active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows, is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages).

This talk will provide an introduction to PostgreSQL by one of the project's committers, including the overall architecture, major features, data types, and capabilities.

SessionID: 54959

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 55162

The Phenomenal IT Consultant

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Professional Development

Speaker: Sebastian Meine

Title: The Phenomenal IT Consultant

Abstract:

Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone.

In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

SessionID: 55170

Extending the SSIS Framework to be region aware

Back to calendar

Event Date: 03-12-2016 - Session time: 15:05:00 - Track: Intermediate BI

Speaker: Brad McKuhen

Title: Extending the SSIS Framework to be region aware

Abstract:

In this demo-heavy session, we will extend the EntDNA SSIS Framework Community Edition to become region aware, tackling the problem of running groups of packages around the world on multiple servers, and get the results back to the calling server, all using a centralized, coordinated schedule.