Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


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

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: 603

This session is for the those who have security objections related to moving to the cloud or are interested in the security features of the of the Azure SQL Database, a relational database Platform as a Service offering in Microsoft Azure.  There certainly are Azure SQL Database features which have parity with SQL Server engine features (Always Encrypted, TDE, RLS, etc.).  But this session will take a look at security features focused on the Azure SQL Database; server firewall settings, Auditing & Threat detection,  Alert Rules, Role-based Access Control and configuring Azure AD Authentication.  If time permits, we will step through Dynamic Data Making via the Azure portal.  Hopefully the main take away will be a warm and fuzzy (and more secure) feeling about planning for cloud workloads.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 1:30 PM - 3:00 PM

Room: 605

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 3:50 PM - 4:50 PM

Room: 604C (Wanna Be A DBA?)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: 613

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

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 8:45 AM - 9:45 AM

Room: 613

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: 604C (Wanna Be A DBA?)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 01

Time: 2:40 PM - 3:40 PM

Room: 604C (Wanna Be A DBA?)

As part of the Wanna Be A DBA track
This session will dive into the design of databases.  Including tables, views, normalization, cardinality, table relationships, foreign keys, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 10:00 AM - 11:00 AM

Room: 604C (Wanna Be A DBA?)

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 11:15 AM - 12:15 PM

Room: 604C (Wanna Be A DBA?)

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 01

Time: 3:50 PM - 4:50 PM

Room: 501

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

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 1:30 PM - 2:30 PM

Room: Gallery

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

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 01

Time: 10:00 AM - 11:00 AM

Room: 501

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 01

Time: 12:55 PM - 1:55 PM

Room: 501

We have all encountered difficult managers that leave us stressed out.  They can be micro-managers, bullies, too timid, or even just apathetic.  In any case, you are currently stuck with this manager, and you need coping strategies!
Through case studies and open discussion, we will help you determine if you indeed have a difficult manager.  We will identify and categorize behavior patterns of managers so that you can determine the best strategies to deal with him or her.  In addition, we will also explore the consequences of these actions, and how they can help you to succeed in furthering your career.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: October 01

Time: 2:40 PM - 3:40 PM

Room: 602

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

Session Type:
Extended Session (90 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 01

Time: 1:30 PM - 3:00 PM

Room: 501

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

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

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: October 01

Time: 3:50 PM - 4:50 PM

Room: 603

Attend this session to learn more about EMC
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: October 01

Time: 12:55 PM - 1:55 PM

Room: 613

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

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

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: October 01

Time: 2:40 PM - 3:40 PM

Room: 501

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

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: October 01

Time: 2:40 PM - 3:40 PM

Room: 613

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

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 01

Time: 10:00 AM - 11:00 AM

Room: 605

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