Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 53
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you just starting out in the DB world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to either of those questions, then this is the session for you! John will be talk about things from both an administration side a well as developmental that he's seen in the wild that every DBA should know and understand. We'll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy.
After attending this demo rich session you will be able to
-	Explain the differences between SQL Servers 9 "index" types
-	Identify the layout of SQL Server data on disk
-	Decide which index types are the right ones to use for a given query
-	Assess the impact of the Key on access speed
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Powershell

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me.   In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing.  We will evaluate the usefulness of  CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012.  The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents.  We will look at why you should start working with Extended Events, when you should start, and how to start.  What you will learn:

1.  How to investigate XEvents objects using the DMV's
2.  How to create an XEvents Session
3.  How to transition an existing Trace to an XEvents Session.

What you should know coming in:

1.  Basic use of SSMS  
2.  Familiarity with Trace/Profiler
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will look at some introductory execution plans, both estimated and actual, to help determine what the query optimizer will do, or has done, with the query presented. It should be noted that this session is not intended to be an in depth look at performance tuning, but rather a cornerstone in learning to use a tool appropriate for tuning.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 3

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination.  Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again.  BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy.  In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
Speaker:

Session Type:
Regular Session

Track:
Powershell

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy! 
Speaker:

Session Type:
Regular Session

Track:
DBA Admin

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This fun and informative session covers best practices for data visualization and even infographics using Microsoft BI: Excel, Power View, the Office 2013 Web Apps Framework, Reporting Services, Visio and other open source and third-party data visualizations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps.  You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including:  

* A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls. 

* A user experience that scale

* Getting data locally or thru Azure
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Dev/Cloud/Misc

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker:

Session Type:
Regular Session

Track:
Prof Dev/Cloud/Misc

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Databases are growing.  The way we use data is changing and growing.  When you have a lot of change, it has to be managed, or bad things happen to your data and your job!  A common problem with database change management is... database change management.  This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy.  There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be.  Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker:

Session Type:
Regular Session

Track:
DBA Admin 3

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will cover what is a SSIS Framework, why you need a SSIS Framework, and how to implement it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how to use the Separation of Duties Framework and a Privileged Identity Management suite to minimize the permissions needed by DBAs to do routine work. I'll review the Separation of Duties Framework and an easy to implement, low hassle solution that provides DBAs the minimum necessary access required to maintain the server but not be able to view user data.  I will prove that sysadmin is not always required more often than most DBAs think. Also, attendees will learn how to define a permission set with a single script that allows your company’s DBAs to do routine work and how to elevate DBA permissions quickly to respond to production emergencies.  
Speaker:

Session Type:
Regular Session

Track:
DBA Admin

Level: Intermedia

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot of report development today is done through T-SQL using a lot of temp tables and aggregate functions. The reason for this is because a lot of database developers were scared of Analysis Services MDX and its complexity. Until SQL Server 2012 there was no other option in the Microsoft stack for a corporate BI solution until SQL Server 2012 and the BISM Tabular Model. BISM Tabular's query language is an Excel like language called Data Analysis Expressions (DAX). This session will cover some basic concepts of the DAX language and how powerful it is and why the T-SQL developer should consider it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI & Big Data

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”.     As much as it frustrated me, he was right.  There is a core set of knowledge that DBA.  Correct  SQL installation and configuration, how’s and whys of backups,  how to make your role proactive, and many other things fall under that heading.  This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA Admin 3

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
Speaker:

Session Type:
Regular Session

Track:
Powershell

Level: Advanced

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?

You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.


Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: September 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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