Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type


Sessions Found: 45
Dynamic Management Views are a beautiful gift from Microsoft.  With them you can gather immense amounts of information about your SQL environment, optimize performance issues, and solve problems you didn't even know you had!
We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: May 16

Time: 1:30 PM - 2:30 PM

Room: Room 2400

Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect.  It becomes more challenging when we find nothing is wrong with the way SQL Server is running.  In this session we review common mistakes to the configuration of network settings.  We’ll also show how to troubleshoot the SQL Server Browser.  We’ll cover how to test for firewall issues.  Finally we’ll discuss why SQL Server is blamed for dropping its connections.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 16

Time: 9:45 AM - 10:45 AM

Room: Room 1455

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 16

Time: 11:00 AM - 12:00 PM

Room: Room 1520

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

Track:
Track 7

Level: Intermedia

Session Code:

Date: May 16

Time: 8:30 AM - 9:30 AM

Room: Room 2400

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 a database from the group up. 


     Topics are focused on data storage structures, security, and integrity. 
     After this presentation, will be ready to meet that clients need.


Coverage: 
    1 - Files & File Groups 
    2 - Logins & Users 
    3 - Security using schemas 
    4 - Database roles for access. 
    5 - Table design via SSMS or TSQL. 
    6 - Default, Check, and NULL constraints 
    7 - Handling table relationships (PK vs FK). 
    8 - To index or not to index? 
    9 - Testing database integrity using DML.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: May 16

Time: 1:30 PM - 2:30 PM

Room: Auditorium

SQL Server 2014 is all about in-memory. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: columnar storage, in-memory tables and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 16

Time: 1:30 PM - 2:30 PM

Room: Room 1435

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

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 16

Time: 4:00 PM - 5:00 PM

Room: Room 1455

When loading a large amount of data, e.g. into your data warehouse, you want 
the data inserted into the table as fast as possible. You know you have to use bulk 
load, but what do you need to do to ensure that data is loaded as fast as possible? 

In this session, you will learn about the different methods for bulk loading data 
into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is 
happening behind the scene of minimal logged inserts, why they are so 
important when doing bulk load, and what is required to achieve a minimal 
footprint on the transaction log. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: May 16

Time: 1:30 PM - 2:30 PM

Room: Room 1445

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: May 16

Time: 4:00 PM - 5:00 PM

Room: Room 1445

Join Thomas in an almost Powerpoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate it into multiple database projects with a few mouse clicks.
He will also share Tips and Tricks for using Visual Studio more effective.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 16

Time: 11:00 AM - 12:00 PM

Room: Room 1435

You've been hearing about Windows PowerShell, but you're wondering if it's something you should be working with. Or maybe you’re just looking for a way to make those boring, repetetive chores take care of themselves. In this introductory session, we'll talk about what PowerShell is, how to use it, and where it’s going. Whether you're a junior DBA or seasoned veteran, you'll find ways that PowerShell can make your life easier.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 16

Time: 8:30 AM - 9:30 AM

Room: Room 1435

In SQL Server 2008, Microsoft finally introduced a first-class auditing tool for monitoring what's going on in your databases.  Unfortunately, that's an Enterprise Edition feature.  What about those of us running Standard Edition?  In this demo-heavy session, we'll learn about auditing methods for the masses, including triggers, event notifications, SQL Trace, extended events, and even SQL Audit.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: May 16

Time: 9:45 AM - 10:45 AM

Room: Room 1520

Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 16

Time: 8:30 AM - 9:30 AM

Room: Room 1455

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: May 16

Time: 9:45 AM - 10:45 AM

Room: Room 1610

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.   This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: May 16

Time: 11:00 AM - 12:00 PM

Room: Room 2400

Integration services is a powerful tool for visualizing and handling most of your SQL Server ETL needs. But Business Intelligence Development Studio (BIDS) can be a confusing tool the first time that you start the application. There's a LOT going on, and for the first time developer, it's not very clear how to get started. This session will help get you on your feet developing SSIS packages. We will look at some common scenarios and live demo creating your first SSIS packages to copy data from one server to another, extract data to a flat file, and learn how to solve some common errors. Feel free to bring your questions on getting started with BIDS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: May 16

Time: 2:45 PM - 3:45 PM

Room: Auditorium

Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server,  and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 16

Time: 11:00 AM - 12:00 PM

Room: Room 1445

So you got a handle on what Big Data is and how you can use it to find business value in your data.  Now you need an understanding of the Microsoft products that can be used to create a Big Data solution.  Microsoft has many pieces of the puzzle and in this presentation I will show how they fit together.  How does Microsoft enhance and add value to Big Data?  From collecting data, transforming it, storing it, to visualizing it, I will show you Microsoft’s solutions for every step of the way.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: May 16

Time: 4:00 PM - 5:00 PM

Room: Room 2400

SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. 

This session will teach you how to avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world. 
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 16

Time: 2:45 PM - 3:45 PM

Room: Room 1435

As part of Microsoft's aggressive cloud strategy, the SQL Database as a service has been getting new releases and new features at a rapid pace.

The biggest change so far has been the introduction of three service tiers: Basic, Standard and Premium.

Gone is the pay for database size system and it has been replaced by a system where we also pay for the performance characteristics and recovery features of our database.

Come learn the differences between the tiers, measuring performance and how to optimize the use of your cloud SQL power.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: May 16

Time: 9:45 AM - 10:45 AM

Room: Room 1445

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