Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
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

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Integration Services (SSIS) 2012 added full support for Change Data Capture (CDC) on databases. In this session we will cover the basics of CDC in SQL Server 2012 and then how to build SSIS 2012 packages that make using CDC to load your Data Warehouses easier than they were before. No previous knowledge of CDC is required for this session, but some knowledge of any version of SSIS will make it easier to understand.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover in how to properly research companies, interview, properly resign and how to brand yourself. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Personal Dev & Azure

Level: Beginner

Session Code:

Date: April 27

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, protected HIPAA information, and MY social security number.  Because of that, Peggy will be bankrupting my credit report. In this session you will learn: what is a recovery strategy,
creating your recovery point and recovery time objectives, selecting the proper backup type and recovery model, and then we will be putting it all together into a winning strategy!
Speaker:

Session Type:
Regular Session

Track:
DBA (Auditorium 2)

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will present 16 (free) tools that are available...when, where, why, and how to use them and include some demo's.
Speaker:

Session Type:
Regular Session

Track:
Personal Dev & Azure

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot has been said about ETL Frameworks and it's an important topic considering these frameworks are the cornerstone of any data warehouse implementation. This session will discuss building a robust enterprise ETL Framework while leveraging the architectural enhancements available in SQL Server 2012. Topics include auditing, logging, designing for fault tolerance and recoverability, handling orchestration, parallelism and finally scheduling.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 27

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

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View lets you create eye-popping visualizations and provides intuitive ad-hoc reporting that a variety of business users can use to make critical decisions. But before you can begin building these incredible reports, you must have your data properly prepared. This session will give you a beginning-to-end view of what is needed to create Power View reports, from organizing a PowerPivot model source to preparing the actual Power View report.
Speaker:

Session Type:
Regular Session

Track:
BI (Auditorium 1)

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Compare and contrast how each Microsoft BI tool satisfies requirements for visualization, interactivity, data sources, formatting, printing, and exporting.  We'll explore the strengths and limitations of each tool for creating dashboards & scorecards with PerformancePoint, Reporting Services, Excel, and Power View.  This session will help you with things to consider when selecting one tool in the Microsoft BI stack versus another.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Database projects have come a long way since the first fumbling attempts.  The newest incarnation is SSDT (Sql Server Development Tools) and it has left behind the false errors and obtuse directory hierarchy of database projects past.  Database projects have finally evolved to where they can be integrated into your daily build cycle!  I know, I know, I was skeptical too; and I don't mean to disillusion you into thinking it will all work fine right out of the box -- no, we're not close to there yet! Come to this session and let me introduce you to the strengths, weaknesses, caveats, and workarounds of database projects.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

A Requirements Analysis defines the system in terms of the operations and/or events that must be performed in order to meet the goals of the software. The goal of the requirements analysis is to assist in defining and allocating actions for the people that are to use the system that are best suited to their capabilities and limitations
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Mining Extensions (DMX) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services. You can use DMX to create the structure of new data mining models, to train these models, and to browse, manage, and predict against them. We will work through clustering and forecast examples and populate a relational table using SSIS.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

On this session you will learn how to find patterns and generic processes to create an ETL framework to automate the most common task within your organization using SSIS, from metadata driven package execution to ETL tracking of file loading processes. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server.  Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

In this age of big data, location matters more than many people imagine. Almost every set of data has some geographic information tied to it, and it is all the more pertinent to understand and unravel the patterns and trends behind them. This session will start by explaining why GeoSpatial analytics is important in today's world and then continue by exploring how we can share, analyze, and visualize data using the comprehensive Microsoft BI toolset, including Power View, GeoFlow, SQL Server Reporting Services, and more. The session will also feature practical demos for each of these tools, during which we will work on some of the publicly available datasets to uncover some interesting facts.
Speaker:

Session Type:
Regular Session

Track:
BI (Auditorium 1)

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on the differences in address format and structure around the world and how that can place in the effective storage of "useful" address data within the Enterprise. In addition, we’ll discuss how address data is "mangled" to be stored and how it can impact the overall quality level of any tool used for address validation and correction internationally. With 240+ countries and territories around the world, this is not a small consideration.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA (Auditorium 2)

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL Server 2012, Microsoft has killed the ever popular debate of 'Where should we deploy our packages?'. The new deployment model, with the use of environments, adds many new benefits and possibilities for different deployment scenarios. Learn the basics of the new deployment model and how to setup environments in this demo intensive session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Ever wonder how sports announcers can spout off statistics that seem like the logic to determine them is very complex? What if you could provide an equally detailed analysis of your business data? SQL Server Analysis Services is a tool that can help you do just that; get new a new and exciting look at your data in a way that wasn't possible before. Brad will show you the basics of SSAS to get you started. He will walk you through creating your first SSAS cube and show that it isn't as scary as people make it seem. Get ready for a demo filled session and end up ready to go tackle your own cube!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI (Auditorium 1)

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Come watch two titans of tech showcase their "talents" while they compete in building BI solutions using two different methods. One will use Self-Service BI techniques while the other uses traditional methods of building BI solutions. This continuing saga proves to be epic as usual!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI (Auditorium 1)

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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