Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 30
This session is an introduction to tuning backups.  Learn how to take those backup jobs to disk and change them from running for hours to running in minutes.  We’ll be discussing the advantages & disadvantages of using the following parameters: COMPRESSION, BUFFERCOUNT, MAXTRANSFERSIZE, & BLOCKSIZE.  We’ll also be covering the concept of striping database backups.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 1610

Do you consider yourself a beginner to T-SQL? This session will go over the basic T-SQL syntax for querying data. We'll break down the fundamental statements to look at the different parts to see how they work together. 

This session is designed for the junior DBA or developer who is looking for a better foundation of the basics. The goal is to feel more confident with how to write queries and understand how to build on that knowledge.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Starter Track

Level: Beginner

Session Code:

Date: March 24

Time: 9:40 AM - 10:40 AM

Room: 1455

Abstract:

You just found out that a client needs a SQL database to be designed from scratch.  However, you existing DBA has given two week notice.

This presentation is meant for the Accidental DBA that has little to no experience with creating Transaction SQL objects.

After this presentation, will be ready to meet that clients need.

Coverage:

1 - How is a view better than ad-hoc SQL?
2 - Abstracting underlying tables via a view.
3 - Avoiding DML updates to views.
4 - Using triggers to enforce business rules.
5 - Using triggers to prevent data modifications.
6 - What are the different types of functions?
7 - Simple use of each type.
8 - Using stored procedures as an application interface.
9 - Batch programming using stored procedures.
10 - How to schedule batch jobs.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Starter Track

Level: Beginner

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 1455

Big Data has become a corporate and household buzzword. But is it just that? You really need to start learning about it as soon as possible. Come learn about what happens to the tons of your personal data that you leave behind knowingly or unknowingly, like bread crumbs for various entities for the devil and the angel alike.
We'll also discuss various real life examples like detection and spread of Ebola virus, the 2016 elections, the traffic patterns in a third world country; all of this using Big Data.
You will also learn how Big Data is produced, processed(with cheap hardware using Hadoop like environments), reported and acted upon by producing meaningful and actionable reports/predictions.
Over and above, we'll also take a quick peek at some of the huge and successful installations of Hadoop ecosystems around the world; installations that affect our lives.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: March 24

Time: 1:30 PM - 2:30 PM

Room: 1610

The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developers who want to store their data in JSON because it is fast, standard, and flexible. DBAs cringe when they hear of long text strings being stored in their SQL databases; they cry with concern, “No data validation? No schema binding?”. Is there any hope for these two warring factions to see eye-to-eye?

This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016 and 2017. It will also usher in an era of peace between DBAs and developers…

… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud & On-Premises)

Level: Beginner

Session Code:

Date: March 24

Time: 3:50 PM - 4:50 PM

Room: 1455

More and more of our data is originating from or being moved to the cloud, but many of us are doing the same old ETL process with SSIS and other tools. In this session, we will compare a legacy SSIS package and show the process of building the same flow with the newly released Azure Data Factory v2
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 1435

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:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 3:50 PM - 4:50 PM

Room: 2400

Keeping up with technology can feel like a treadmill; you keep running but never get anywhere. We'll take a look at ways to keep up with technology without pulling your hair out. We'll balance cost versus benefit for the different types of learning. We will also talk about learning goals.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 8:30 AM - 9:30 AM

Room: 2400

Dynamic SQL can be a powerful tool that allows you to write fast & efficient queries when the specifics may not be known until run-time.  It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud & On-Premises)

Level: Intermedia

Session Code:

Date: March 24

Time: 3:50 PM - 4:50 PM

Room: 1445

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips & tricks that I have learned along the way. 

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 3:50 PM - 4:50 PM

Room: 1610

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:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 1455

If you work in an agile environment, design requirements often come to us as stories with the phrase: "As a type of user, I want to ..."

For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.

That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together. 

This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud & On-Premises)

Level: Intermedia

Session Code:

Date: March 24

Time: 3:50 PM - 4:50 PM

Room: 1435

Are you stuck in your existing job for years? Do you feel you need to get out, try either a new company or a new role; or even a new boss? This a very entertaining and highly interactive session is perfect for you. I promise, you'll walk out of it totally reassured and enlightened.

In this session I'll share my and other people's real stories and the techniques about keeping abreast the job market and finding new opportunities. 

We'll also talk about normal mistakes that people make when they are cozy in a job. 
But, what do we do once we get that rare opportunity to interview. 

We must take care of :
1. Overall appearance
2. Food habits on the eve of the interview
3. Postures
4. Arrival
5. During the interview
6, Closing
7. Follow up
8. Maintaining interview logs

Keep going at it. Never stop looking!!!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 9:40 AM - 10:40 AM

Room: 2400

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
9 - Which of these techniques apply to an Azure SQL database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development (Cloud & On-Premises)

Level: Intermedia

Session Code:

Date: March 24

Time: 10:50 AM - 11:50 AM

Room: 1445

In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, a SQL Server MVP, and then joined Microsoft.  Along the way I saw my yearly income triple.  Is it because I know some secret?  Is it because I am a genius?  No!  It is just about laying out your career path, setting goals, and doing the work.  

I'll cover tips I learned over my career on everything from interviewing to building your personal brand.  I'll discuss perm positions, consulting, contracting, working for Microsoft or partners, hot fields, in-demand skills, social media, networking, presenting, blogging, salary negotiating, dealing with recruiters, certifications, speaking at major conferences, resume tips, and keys to a high-paying career.

Your first step to enhancing your career will be to attend this session!  Let me be your career coach!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 2:40 PM - 3:40 PM

Room: 2400

More and more applications/reports require handling of geospatial data. You may need to store maps, calculate distances between points or look for the closest locations to your users. Don't pay fees to third party tools for geospatial functionality, SQL Server is here to help you.
In the first half, learn the spatial data types and common spatial functions in SQL Server, and in the second, use the new JSON functions and In-Memory tables to create/query spatial data in SQL Server. Here's your chance to learn how to handle spatial data in SQL Server using modern ways.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: March 24

Time: 1:30 PM - 2:30 PM

Room: 1455

More and more companies are starting to invest in multiple database platforms and DBAs are needing to develop a skillset to support a mixed-database environment.  Database concepts are often the same between platforms, however, the “how” can be very different (and sometimes not different at all!).  Starting with the basics and gradually moving into the more advanced; this session will show you how to perform the same task in SQL Server, Oracle, and Mongo.  Take a leap and start your journey in to the multi-platform world!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Starter Track

Level: Beginner

Session Code:

Date: March 24

Time: 2:40 PM - 3:40 PM

Room: 1455

You've just been told by HR that you are no longer a part of their organization.  You've been kicked to the curb.  You are now living in the no-man's land called unemployment.

Unemployment is a scary situation.  You're dealing with emotions and uncertainty.  You don't know if you'll be out of work for days, weeks, or months.

Fortunately, unemployment is survivable.  In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times.  We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time.  Hopefully, you'll land on your feet once again before long!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: March 24

Time: 1:30 PM - 2:30 PM

Room: 2400

When we talk about memory usage in SQL Server, we are often referring to the buffer cache.  This is an important part of SQL Server’s architecture, and is responsible for the ability to query frequently accessed data quickly.  Knowing how the buffer cache works will allow us to properly allocate memory in SQL Server, gauge accurately how databases are accessing data, and ensure that there are not inefficiencies in our code that cause excessive data to be cached.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: March 24

Time: 1:30 PM - 2:30 PM

Room: 1445

SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools.  Which enabled rapid enhancement to Execution Plan.  

Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows? 

In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan.  You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: March 24

Time: 2:40 PM - 3:40 PM

Room: 1445

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