Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 44
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Vendor Session

Level: Beginner

Session Code:

Date: April 14

Time: 1:15 PM - 2:15 PM

Room: Flowe 208

Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA "cannot change the code" but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience. 

In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Intermedia

Session Code:

Date: April 14

Time: 2:30 PM - 3:30 PM

Room: Flowe 222

"Alexa, make Song Quiz smarter and more fun." That command may not work (yet), but this session can give you the tools and knowledge to enhance Alexa's ability to do all kinds of fun and useful things. Alexa is fast growing to be the strongest of the three personal assistants.  Much of this growth has come from the fact that Amazon opened up 3rd party development through their Skills program. In this session, we’ll start with the Alexa ecosystem and terminology. We’ll then cover the infrastructure behind skills and development framework We’ll wrap things up with how to implement continuous improvement, by using data to drive it all!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Pressly 201

Both Hashbytes and Compress functions have some use cases that we should consider when designing and tuning databases.  These functions can be used to improve query performance, reduce storage, and enforce consistency.  We will walk through some examples where these functions have helped me and will hopefully help you in the future.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Scale

Level: Beginner

Session Code:

Date: April 14

Time: 11:00 AM - 12:00 PM

Room: Flowe 220

Power BI allows us to easily apply Row Level Security (RLS) to our published reports, streamlining report development for individuals or groups within your organization. This session shows you how to set up a report to apply RLS as well as how to model your data to support users dynamically.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analyze

Level: Beginner

Session Code:

Date: April 14

Time: 9:45 AM - 10:45 AM

Room: Pressly 101

This full-day session on Friday, April 13, 2018, will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. This session is approximately 70% demonstrations: we will create a data lake, populate it, organize it, query it, and integrate it with a relational database via logical constructs. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.

To register for this paid Pre-Con:
https://www.eventbrite.com/e/architecting-a-data-lake-with-melissa-coates-raleigh-sql-saturday-tickets-42691287791
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Design

Level: Intermedia

Session Code:

Date: April 13

Time: 8:30 AM - 9:30 AM

Room: 1

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: April 14

Time: 3:45 PM - 4:45 PM

Room: Flowe 208

Automating extract packages is trivial., you simply use INFORMATION_SCHEMA.  The problem is not all your data sources have easy to read metadata like SQL Server.  How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.  

With that schema, automatically generating your extract package is a matter of seconds!  Join me while I share my interrogator project with you and start saving hours at work today!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Intermedia

Session Code:

Date: April 14

Time: 2:30 PM - 3:30 PM

Room: Pressly 101

In today's world, technology is a pervasive part of our lives. We have "smart" appliances everywhere: from cars, thermostats, and even refrigerators contain built-in systems to collect, store, and transmit data. Small embedded devices can also be used for scientific purposes as well, offering new and exciting ways to collect data for studies or projects at home.

The High-Altitude SQL Server Project, or HASSP, is one such project.

The HASSP team has created a high-altitude balloon that uses sensors to collect various data points and store the results in an embedded version of SQL Server!

In this session, you'll hear about how this is possible: we'll discuss the hardware used, the custom device that we built, and the software used to make it all work together. Best of all, you'll see how to recreate (and hopefully improve!) the project on your own.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Design

Level: Intermedia

Session Code:

Date: April 14

Time: 3:45 PM - 4:45 PM

Room: Pressly 101

The ""Cloud" is here.  With it, there are many options for storing and processing data.  What does it mean?  Why should you be interested in this conversation?  How can a cloud solution compare to an "on-prem" solution?  We will discuss these questions and more. The focus of this session will be on the options available in Azure from Azure SQL DB to Azure SQL Data Lake, but we will also touch on AWS and Google Cloud options to put the options in context.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Evolve

Level: Beginner

Session Code:

Date: April 14

Time: 11:00 AM - 12:00 PM

Room: Pressly 201

You're looking to protect your SQL instance from a machine failure.  Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides.  Let's learn what a cluster is and why it might be the right thing for you.  We'll explore the system, network, storage and database administration sides of the equation.  And, when it's all said and done we'll even have built a SQL clustered instance!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: April 14

Time: 11:00 AM - 12:00 PM

Room: Flowe 208

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Intermedia

Session Code:

Date: April 14

Time: 3:45 PM - 4:45 PM

Room: Flowe 217

Why create a SQL Server Test premise environment in Azure cloud?  One of the first steps into moving to Azure cloud, is building an environment that looks a feels like premise but only in the cloud.  This session is an overview of getting started with basics of Azure environment, such as Accounts, virtual networks, Storage and creating virtual machines..  Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Intermedia

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Flowe 208

In this breakout session, you'll learn the basics of the DAX language, Power BI’s modeling language. Belinda will introduce you to the concept of calculated columns, measures and basic data modeling, with some practical examples. This introduction will cover basic calculations and an overview of all the scalar and table functions. This session has practical examples for business analytics and users.  To the Developer, DAX feels like a programming language; to the user, DAX feels like Excel formulas.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analyze

Level: Beginner

Session Code:

Date: April 14

Time: 1:15 PM - 2:15 PM

Room: Flowe 220

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: April 14

Time: 3:45 PM - 4:45 PM

Room: Flowe 111

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs. 

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Scale

Level: Intermedia

Session Code:

Date: April 14

Time: 11:00 AM - 12:00 PM

Room: Pressly 101

This session will highlight the core fundamentals of Power Query and how it can transform your efforts relating to Business Intelligence. Together we will talk about what it is, how it works, and how you can put it to good hard use in your organization.  Power Query is powerful tool that can help do the dirty work for you!  It’s easy to learn and get started!  Whether you want to use large complex datasets for Excel, Power BI or Power Pivot,  Power Query is definitely a tool to help get you where you want to be!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Build

Level: Beginner

Session Code:

Date: April 14

Time: 1:15 PM - 2:15 PM

Room: Pressly 101

Any changes to Non-Memory Optimized tables require a certain amount of logging to the transaction log in order to ensure the integrity of the operation and of course the data. Most of these are fully logged operations and can write a tremendous amount of data to the transaction log. As you probably already know this can lead to various performance and availability issues. However you may be able to minimize the effect of these with what is called a minimally logged operation. This session will outline how these can be used under the right conditions to save time, resources and potentially a lot of headaches. Various demos will hit home on just how much of an impact this can have on some every day operations.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Perform

Level: Beginner

Session Code:

Date: April 14

Time: 3:45 PM - 4:45 PM

Room: Flowe 222

Some people think of Azure HDInsight as Microsoft’s Hadoop in The Cloud. That thought is only partially correct. With storage separate from compute, HDInsight flexibility offers Hadoop with Pig and Hive options as well as HBase, Storm, Spark, R Server, and Kafka … all priced a la carte and on-demand. Join me as I explain what HDInsight is and is not along with some live demos of HDInsight’s capabilities.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Innovate

Level: Intermedia

Session Code:

Date: April 14

Time: 2:30 PM - 3:30 PM

Room: Flowe 111

It seems like web apps are getting all the love and at first glance it may be hard to identify a good way to use the database in containers.  This session will review the concept of containers and attempt to identify ways we might benefit from this new technology as we support our users.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Design

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Flowe 220

Sessions Found: 44
Back to Top cage-aids
cage-aids
cage-aids
cage-aids