Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type



Sessions Found: 42
One of the most highly anticipated new features in the SQL Server 2016 release is Query Store.  It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics.  If you've ever had to drop everything and try to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature.  In this session we'll explore the Query Store feature using the latest CTP of SQL Server 2016.  We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, and see how you can force SQL Server to use a specific plan for a query.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 8:30 AM - 9:30 AM

Room: Auditorium

Azure Data Factory is a json based data integration tool. It is not SSIS in the cloud, but like SSIS, its main purpose is moving data. This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 9:45 AM - 10:45 AM

Room: Training 2

After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic.  In this session, we will learn how to use  variables, expressions, and loops to do things like: extract data to a file with *today's* date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data.  For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 06

Time: 8:30 AM - 9:30 AM

Room: Training 1

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 06

Time: 8:30 AM - 9:30 AM

Room: Training 3

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 06

Time: 4:15 PM - 5:15 PM

Room: Training 2

Join several Hylanders for an overview and discussion of available database-related positions within the company.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: February 06

Time: 12:00 PM - 1:00 PM

Room: Training 3

Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious.  Your environment is running but you are wondering “now what” or “what’s next”.  In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQL Saturday.  So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 2:45 PM - 3:45 PM

Room: Training 2

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 06

Time: 2:45 PM - 3:45 PM

Room: Training 1

Microsoft rebranded and upgraded the high availability options for SQL Server 2012. This has caused a flurry of confusion around what features are used in what scenarios. Learn what the prerequisites are for running a Failover Cluster Instance or an Availability Group using AlwaysOn. We will also cover setting up an Availability Group then demonstrate both an automated and manual failover process. Finally, we wrap up with a discussion about using the Listener service and how that needs to be configured for your applications to continue to function on failover.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 1:30 PM - 2:30 PM

Room: Training 3

Memory problems in humans can be caused by injuries, traumatic events, or physical deficiencies. Interestingly enough, the same holds true for SQL Server. In this session, learn about common patterns and problems that affect SQL Server memory usage and how to solve them, based on real-world scenarios. We start with an overview of the SQLOS memory manager and the internals behind the memory components that are necessary to troubleshoot problems. We then move straight into sample scenarios. From incorrectly sized hardware for a specific workload to code and schema design challenges that tax SQL Server memory usage, this session gives you the practical tools necessary to tackle even the most challenging memory problems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 06

Time: 11:00 AM - 12:15 PM

Room: Auditorium

All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.
Speaker:

Session Type:
Sponsor Session (60 minutes)

Track:
Sponsor Session

Level: Beginner

Session Code:

Date: February 06

Time: 12:00 PM - 1:00 PM

Room: Training 5

Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these data type choices can be a real performance killer? 

Attend this session to learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! 

When you leave, you will be able to explain to your colleagues why data type choices matter, assess your own systems, and implement some best practices to mitigate these performance killers.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 06

Time: 2:45 PM - 3:45 PM

Room: Training 4

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. This course covers the bare bones basics: what an execution plan is, how to run them, how to read them, and additional features.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 06

Time: 11:00 AM - 12:00 PM

Room: Training 1

2016 welcomes the new R Services, which brings advanced analytics capabilities to SQL Server. You will learn how SQL Server R Services can enhance the work of a BI developer or analyst as well as impact a DBA. You will witness a few scenarios covering how to leverage R scripts in-database using T-SQL as well as how to use R in Reporting Services and Power BI. Finally, you will experience a gentle introduction to the installation and configuration of R Services. This session is targeted toward SQL professionals who have never used the R language.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 06

Time: 2:45 PM - 3:45 PM

Room: Auditorium

So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

•	Optimizing TempDB in an Azure VM
•	Reducing latency between application VMs and database VMs
•	Right sizing Azure VMs for performance and cost
•	Striping I/O across devices in Azure VMs
•	Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (75 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 11:00 AM - 12:15 PM

Room: Training 4

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data? 
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! 
We will then secure our database connections with a simple self-signed SSL certificate. 
Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. 
*Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 9:45 AM - 10:45 AM

Room: Training 5

There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will.  Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt.  And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 06

Time: 4:15 PM - 5:15 PM

Room: Training 5

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media forms in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 06

Time: 11:00 AM - 12:00 PM

Room: Training 2

Index for your entire server's performance instead of indexing for a single query, mostly by ensuring indexes are reusable by as many queries as reasonable.  Make the most of every index while limiting overhead of memory usage, I/O, disk, data modifications, and index maintenance.  Also look into tuning or rescheduling the queries that fall outside of typical data access patterns to keep index usage as efficient as possible.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: February 06

Time: 4:15 PM - 5:15 PM

Room: Training 3

SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side.  But when they don't, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.
It’s not that complicated once you understand how it all works. 
Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order.   In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options.  We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.
Speaker:

Session Type:
Extended Session (75 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 06

Time: 11:00 AM - 12:15 PM

Room: Training 5

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