Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 50
You know BI.  Right?  Well kids, traditional Business Intelligence is changing … you heard about the ambitious data analyst down the hall who created a mashup of data from the internal data warehouse + Excel + an Azure feed?  Empowering knowledge workers is Microsoft's vision of delivering "BI for the Masses."  In this session we will dismiss the hype & examine how this new world of "Managed Self-Service BI" complements Corporate BI in SQL Server 2012 and SharePoint 2010.  Goals: (1) Overview of each Self-Service component.  (2) Introduce Codename "Data Explorer" and Data As A Service.  (3) Techniques to monitor, manage, & secure the Self-Service BI environment.
Speaker:

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Recent changes in Business Intelligence have placed greater emphasis on on enabling end-user analytics. While compelling in theory, in practice there are many challenges when creating a foundation that supports end-users analytics. Many of these challenges revolve around making consistent reference (i.e. dimensional) data available to end users. This can be addressed using a Master Data Management solution.

This session session will explore ways that Master Data Services 2012 can be used to support the definition and management of master data used to support analytics (BI) solutions. It will start with a high level overview of MDM and MDS 2012, and finish with a demo of an analytical MDM solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 debuts a new Semantic Platform (commonly known as the applied task, Semantic Search). This text mining technology leverages the already established Full Text Index, and builds semantic indexes in a two-phase process. This presentation provides a science description and demo for the Enterprise implementation of Tag Index and Document Similarity Index. At present (RC0), the indexes work for 15 languages. Included are strategy tips for how to best leverage the technology along with already-existing Microsoft text mining and data mining.
Speaker:

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BEG

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, "Jack of all trades, master of none." The full saying is, "Jack of all trades, master of none, though often times better than master of one."
Speaker:

Session Type:
Regular Session

Track:
BEG

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Benchmarking, Baselines and Monitoring Storage
There are several steps in the life cycle of your storage systems. We have several tools to help us understand our storage systems from initial deployment through its useful life. 
We will cover:
SQLIO, a specific SQL Server benchmarking tool.
Iometer, a general IO benchmarking tool and simulator.
SQLIOSim a specific SQL Server base lining tool and simulator. 
TPC style testing focused on TPC-C, TPC-E and TPC-H.
Monitoring your system using WMI and virtual file stats.
Finally, what it all really means, how to read these results and compare them with each other.
With these tools you can plan, deploy and manage your storage for years to come!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA\DEV

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server backups can be burdensome to set up and maintain. All sorts of different problems can occur. This session targets the most common problems encountered while working with SQL Server backup and shows you how to identify these issues in your environment. In fact, I’ll walk you through how to prevent these common issues from ever cropping up within your systems in the first place. Be prepared for information you can take back to the office and put to work right away making your system backups more reliable. With backups running correctly all the time, you’ll be protecting your systems better, and feeling a lot less stress when it times to perform an emergency restore.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BEG

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Moore's law is not dead; it lives on as CPU manufacturers add more and more CPU cores to the same chip real estate.  In this session, we will look at the ways in which you can leverage concurrent processing in your PowerShell code to dramatically increase the efficiency of your code.  Speed up those ETL processes, execute code on multiple servers at the same time, and complete your maintenance tasks much faster using the techniques you will learn.
Speaker:

Session Type:
Regular Session

Track:
POW

Level: Advanced

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Reporting Services can be one of the easier tools to configure, once you understand how to use the configuration manager. In this session you'll explore the configuration settings available through the exploration of the Reporting Services Configuration Manager. You'll learn the different accounts Reporting Services will need in order to run, how to access Reporting Services via URLs, and the importance of encryption keys. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA\DEV

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Advanced

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Enterprise Information Management (EIM) is an industry term for managing your data for data integration, quality, and governance. This session revolves around a demo which brings together the EIM functionality in SQL Server, a key part of our Credible, Consistent Data story for the 2012 release. We will show you how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS) and other Microsoft technologies work together to provide a comprehensive EIM solution. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSAS\IS\RS

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA\DEV

Level: Advanced

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA\DEV

Level: Advanced

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples.  We will also show how bad performance can get when suboptimal joins are used.
Speaker:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

During this session we will be digging into the internals of SQL Server indexes.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Advanced

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries.  In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
Speaker:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduces the first significant enhancement to FILESTREAM: FileTables. FileTables use the underlying FILESTREAM storage, but expose the stored data using traditional Windows file I/O APIs. In addition, they also support hierarchical data storage (read "folders"). This session will show how to set up your SQL Server instance to support FileTables, how to create a FileTable and how to access it using standard Windows file APIs.
It may be valuable to attend the Introduction to FILESTREAM session also.
Speaker:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

With the new data security standards and legislation, encryption has become a necessity in today’s business world. This session will introduce SQL Server column-level encryption and show how it can easily be implemented as part of a comprehensive security initiative (even in SQL Server Express Edition!). The session will include slides and discussions to introduce concepts and will also have a live demo of a simple implementation of column-level encryption. This is intended for anyone who is interested in SQL Server encryption, or those who need to implement column-level security in their databases as part of their overall database information security strategy.

Speaker:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Beginner

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 
Speaker:

Session Type:
Regular Session

Track:
DBA\DEV

Level: Intermedia

Session Code:

Date: April 14

Time: 12:00 AM - 1:00 AM

Room: TBD

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