sqlsathistory

Nr: 767

SQLSaturday #767 - Lincoln 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Brian Hansen	Application Database Development	Remember Back When? Temporal Tables in SQL Server 2016 and 2017
08:30:00	Monica Rathbun	Enterprise Database Administration Deployment	How to Get SQL Server to Run Better on Crappy Hardware.
08:30:00	Dave Bland	Enterprise Database Administration Deployment	Statistics - Why are they there and what do I do with them
08:30:00	John Morehouse	Cloud Application Development Deployment	Azure Basics for the DBA
08:30:00	Rick Lowe	Enterprise Database Administration Deployment	Why should I care about ... the plan cache?
08:30:00	Ed Leighton-Dick	Application Database Development	Understanding SQL Server Always Encrypted
10:00:00	Kevin Feasel	Application Database Development	APPLY Yourself
10:00:00	Sean McCown	Enterprise Database Administration Deployment	Monster Text Manipulation: Regular Expressions for the DBA
10:00:00	Brett Powell	BI Information Delivery	Husker Power BI
10:00:00	Jennifer McCown	Enterprise Database Administration Deployment	Beginning Admin: The Care and Feeding of SQL Server
10:00:00	John Morehouse	Application Database Development	Temporal Tables – The New Hotness in Data Auditing
10:00:00	B.D. Softley	Professional Development	SELECT Tidbits FROM My.Experience WHERE NiceToKnow = 1 and date = DATEADD(D,-1,current_timestamp)
12:45:00	Marc Beacom	BI Platform Architecture, Development Administration	Implementing a Cloud Analytics Solution: Options, costs and more
12:45:00	Chris Lumnah	Enterprise Database Administration Deployment	Taking the pain out of database migrations
12:45:00	David Klee	Enterprise Database Administration Deployment	Zen and the Art of Baselines
12:45:00	Bill Fellows	Application Database Development	What's new for Developers - SQL Server 2014-2017
12:45:00	Ed Leighton-Dick	Enterprise Database Administration Deployment	How to Keep Your Databases Secure in Just Minutes a Day
12:45:00	Brett Powell	BI Platform Architecture, Development Administration	Processing Analysis Services Tabular Models
14:15:00	Tim Gorman	Enterprise Database Administration Deployment	Reducing The Surface Area Of Risk in Data Security
14:15:00	Kevin Feasel	Application Database Development	Using Kafka for Real-Time Data Ingestion with .NET
14:15:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell
14:15:00	Brian Hansen	Enterprise Database Administration Deployment	Let's Explore SQL Internals
14:15:00	Monica Rathbun	Professional Development	I'm It - Survival Techniques for the Lone DBA
14:15:00	Phillip Labry	Cloud Application Development Deployment	Analysis Services is in Azure? Seriously!? Let's build a model!
15:45:00	Ryan Casey	BI Platform Architecture, Development Administration	Shiny, SSAS Tabular Model Developed from a Star Schema
15:45:00	Andy Galbraith	Enterprise Database Administration Deployment	Getting Started with Extended Events
15:45:00	David Klee	Enterprise Database Administration Deployment	Level Up Your Cloud Skills
15:45:00	Jennifer McCown	Application Database Development	T-SQL's Hidden Support Feature
15:45:00	Rick Lowe	Cloud Application Development Deployment	SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
15:45:00	Wm Bruce Wray	Security	Data Breach 101 - Legal and IT Responses

SessionID: 85065

Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Brian Hansen

Title: Remember Back When? Temporal Tables in SQL Server 2016 and 2017

Abstract:

SQL Server 2016 and 2017 come with their own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work. And yes, this is a version 1 (and 2) product, so we'll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!

SessionID: 85278

How to Get SQL Server to Run Better on Crappy Hardware.

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: How to Get SQL Server to Run Better on Crappy Hardware.

Abstract:

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

SessionID: 85377

Statistics - Why are they there and what do I do with them

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Statistics - Why are they there and what do I do with them

Abstract:

In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly. We will discuss what on going maintenance should be done on statistics.

SessionID: 85408

Azure Basics for the DBA

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: John Morehouse

Title: Azure Basics for the DBA

Abstract:

It's not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session, we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.

SessionID: 85532

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

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30: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 often seem so frazzled. This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 85553

Understanding SQL Server Always Encrypted

Back to calendar

Event Date: 27-10-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server Always Encrypted

Abstract:

Always Encrypted is a highly-touted feature of SQL Server 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: 80810

APPLY Yourself

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 82974

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

SessionID: 84694

Husker Power BI

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Brett Powell

Title: Husker Power BI

Abstract:

In this session a sample database of athletic performance and wellness is leveraged to deliver insights and analytical capabilities via Power BI. A robust data model, advanced DAX metrics, rich data visualizations, and distribution capabilities in the Power BI web service such as data alerts and email subscriptions all contribute to the overall solution designed to answer top questions such as "Which athletes are making the greatest gains?" and to identify exceptions and trends.

SessionID: 85317

Beginning Admin: The Care and Feeding of SQL Server

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: Beginning Admin: The Care and Feeding of SQL Server

Abstract:

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we'll cover the basics of the big five administrator tasks:

Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
Index maintenance – Databases need regular upkeep so they'll continue to run well.
Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!

SessionID: 85410

Temporal Tables – The New Hotness in Data Auditing

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Application Database Development

Speaker: John Morehouse

Title: Temporal Tables – The New Hotness in Data Auditing

Abstract:

A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.

SessionID: 85420

SELECT Tidbits FROM My.Experience WHERE NiceToKnow = 1 and date = DATEADD(D,-1,current_timestamp)

Back to calendar

Event Date: 27-10-2018 - Session time: 10:00:00 - Track: Professional Development

Speaker: B.D. Softley

Title: SELECT Tidbits FROM My.Experience WHERE NiceToKnow = 1 and date = DATEADD(D,-1,current_timestamp)

Abstract:

This is not a class about how to pass a test, or make a pretty report. This is a guy with 20+ years of experience telling you some things that he wished he would have known when he was young.

SessionID: 77169

Implementing a Cloud Analytics Solution: Options, costs and more

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marc Beacom

Title: Implementing a Cloud Analytics Solution: Options, costs and more

Abstract:

If you’ve looked at the cloud, you’ve realized the large number of options you have to implement a complete cloud analytics solution. You have the ability to deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have to run Cloud Analytic Solutions from the three major cloud providers – AWS, Azure and Google Cloud Platform.

SessionID: 82709

Taking the pain out of database migrations

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Lumnah

Title: Taking the pain out of database migrations

Abstract:

Database migrations are scary. The migration of a database has many moving pieces and things to think about. Some of those things have nothing to do with the DBA and are outside of their control. However, if these items are not taken into account, it is the DBA that management will hold responsible for the failure.

This session will discuss what you need to take into account to ensure a successful pain free database migration. These steps can be used for a single database, multiple databases, or an entire server. By the end of the session, you will have a checklist of the items you need to consider for a database migration.

SessionID: 83384

Zen and the Art of Baselines

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Zen and the Art of Baselines

Abstract:

SessionID: 84478

What's new for Developers - SQL Server 2014-2017

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Bill Fellows

Title: What's new for Developers - SQL Server 2014-2017

Abstract:

Have you been too busy to explore the new developer features in 2014+? This session is for you! We're going to work through solving problems more effectively using the new capabilities built into SQL Server.

Topics covered will include JSON, string splitting and aggregation, data masking, row level security, graph processing, and too many "minor" features to mention.

SessionID: 85551

How to Keep Your Databases Secure in Just Minutes a Day

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Leighton-Dick

Title: How to Keep Your Databases Secure in Just Minutes a Day

Abstract:

You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.

SessionID: 86344

Processing Analysis Services Tabular Models

Back to calendar

Event Date: 27-10-2018 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brett Powell

Title: Processing Analysis Services Tabular Models

Abstract:

For large in-memory Analysis Services Tabular models, the design of table partitions and the scheduled refresh/processing operations has significant implications for query performance, resource utilization, processing duration, and database availability. This session will review the tabular model's processing operation types, design decisions such as parallelism and transactions, and provide examples of Tabular Model Scripting Language (TMSL) scripts and PowerShell scripts used to support the processing of Tabular models. Additionally, common Azure and on-premises job automation and orchestration tools used in the processing of Tabular models will be demonstrated including Azure Automation, SQL Server Agent, and SSIS.

SessionID: 77021

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

Data obfuscation, also known as data masking, is soon a legal requirement. Data masking is the best way to secure non-production systems (i.e. DEV, TEST, etc) to greatly reduce the surface area of risk for data breach in your organization. Masking isn't encryption, which is an appropriate solution for production applications. Masking also isn't just a SQL Server feature, it is a technique common across databases.

Data masking for data at-rest removes the value from the asset. This reduces your organizations "surface area of risk" overall, permitting your organization to prioritize security efforts where they are absolutely needed. There are other possible solutions, such as synthesizing data and redaction, which present other challenges.

Come learn about the right way to secure non-production data to limit exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.

SessionID: 80811

Using Kafka for Real-Time Data Ingestion with .NET

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Using Kafka for Real-Time Data Ingestion with .NET

Abstract:

SessionID: 82973

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 85064

Let's Explore SQL Internals

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Let's Explore SQL Internals

Abstract:

Have you ever wondered how SQL Server stores your data? With so many ways that it can be done, we couldn't possibly cover everything in this session, but we'll discuss the fundamental building blocks that SQL uses to organize data into usable units. We'll also see how we can peek under the covers to actually view some of the strutures involved. Why? Because understanding how the pieces fit together will help you to design better, more efficient databases and tables, as well as providing knowledge of a critical component of how the SQL optimizer comes up with query plans.

SessionID: 85277

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15: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: 86356

Analysis Services is in Azure? Seriously!? Let's build a model!

Back to calendar

Event Date: 27-10-2018 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Phillip Labry

Title: Analysis Services is in Azure? Seriously!? Let's build a model!

Abstract:

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in or currently using Power BI? Do you you have a need for Analysis Services but don't want to have to deal with the hassle of buying and installing a server? Are you dreading having to upgrade your hardware for your current SSAS Tabular instance? Is your organization using Office 365? If you answered yes to any of these questions, you might need Azure Analysis Services. The wait is over! Azure Analysis Services is the platform as a service version of the wildly popular Analysis Services Tabular product.

This demo heavy session will be focused on setting up Azure Analysis Services, deploying a model, loading the model with data and finally reporting from your Azure Analysis Services instance.

SessionID: 80243

Shiny, SSAS Tabular Model Developed from a Star Schema

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Casey

Title: Shiny, SSAS Tabular Model Developed from a Star Schema

Abstract:

A deep dive into a Tabular Model developed from a Star Schema. We review different levels of normalization versus de-normalization. We examine how all relationships require a M:1 cardinality that is joined on a pair of single columns. We will clarify that models cannot include model ambiguity.

“Live” Demos using Power Pivot and Power BI • Integrated workspace / server workspace • Data connections (impersonation) • Import tables into the tabular model • Date Dimension for Time Intelligence • Relationships between facts and dimensions • DAX to create measures and calculated tables • Ragged Hierarchies • Detail Rows Expression Property for Measures • Project deployment and processing • Best practices and what to avoid • Dimensions, facts, and reference tables (parameters) • Bridge table and M:M relationships • Bi-directional filtering versus cross-filtering • DAX Expanded Tables • Filter context and DAX

SessionID: 83193

Getting Started with Extended Events

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Galbraith

Title: Getting Started with Extended Events

Abstract:

Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!

SessionID: 83385

Level Up Your Cloud Skills

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Level Up Your Cloud Skills

Abstract:

SessionID: 85321

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.

SessionID: 85533

SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Rick Lowe

Title: SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Abstract:

Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.

SessionID: 86379

Data Breach 101 - Legal and IT Responses

Back to calendar

Event Date: 27-10-2018 - Session time: 15:45:00 - Track: Security

Speaker: Wm Bruce Wray

Title: Data Breach 101 - Legal and IT Responses

Abstract:

Data breaches are now a when, not an if. Yet despite years of reading about data breaches in the news, very few companies are ready to weather the storm. This course will provide a general primer on data breach incident response and the parallels between the IT and Legal response cycles. At the end of this course, you will have the baseline knowledge of data breach responses and legal aspects your company needs to know.

This site is open source. Improve this page.