Build Schedule

Advanced Filters:
  • Track

    clear all









  • Speaker


  • Level


  • Session Type

Sessions Found: 42
Text mining is projected to dominate data mining, and the reasons are evident:  we have more text available than numeric data.  Microsoft introduced a new technology to SQL Server 2012 called Semantic Search. This session's detailed description and demos give you important information for the enterprise implementation of Tag Index and Document Similarity Index. The demos include a web-based Silverlight application, and content documents from Wikipedia. We'll also look at strategy tips for how to best leverage the new semantic technology with existing Microsoft data mining.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SW5 - Room 1850

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

New marketplace is a great opportunity for developers to get rapid exposure on a growing platform. SharePoint 2013 introduces a new app model that brings the best of web development to SharePoint. This session will use a series of demos to walk through the developer getting started experience for apps for SharePoint and will highlight development tools such as Napa and Visual Studio. Whether you're a .NET developer or a SharePoint developer come learn how to build apps for SharePoint and submit them to Office marketplace.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1205

Level: Beginner

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is will help the SQL DBA or the SharePoint farm administrator understand what is required from the "other side" to get BI features up and running in SharePoint. We will outline the SharePoint farm and services architectures, and then walk through configuration scenarios that will get BI assets such as Reporting Services in SharePoint mode, PowerPivot for SharePoint, Power View, and PerformancePoint up and running.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1205

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Profiling data allows you to understand various aspects of new you receive. By profiling data you can make sure it meets your data quality standards. During this session we will be exploring the SSIS Data Profiling task to quickly analyze your data. Each of the eight different profiles available will be reviewed. A number of demos will be shown so you understand how to use and configure the different profiles. You will learn how to use the Data Profiling task output to control your SSIS data flow. Additionally you will be shown how to store the profiling output in SQL Server, so you can produce trend reports based on past profiling output information.
 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW5 - Room 1850

Level: Beginner

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

With the new Data Quality Services (DQS) Microsoft has an offering for Data
Quality Management. This session gives you insights how to use DQS efficiently.
In demos you will understand best practises in setting up a knowledge base,
correct matching rules and how to integrate DQS to your processes as DQS is
never an island solution. DQS performance aspects and how to report your
quality improvements will round up the session. The session assumes that you
have already tested DQS and want to get further with this toolset.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW5 - Room 1850

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about Microsoft’s Data Quality Services (DQS), what it is and how it works. We'll show you how DQS sets itself apart from conventional data cleansing routines that we’re used and go through examples on how to begin your own Data Quality Project. But what really makes DQS unique and powerful is its ability to access shared knowledge. In this presentation, we will also go through how to access and use that shared knowledge. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW5 - Room 1850

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Karen and Tom debate about options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys *NULL vs NOT NULL * Agile Database Design * Database Refactoring * How much does Size Matter? * 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 (60 minutes)

Track:
SW3 - Room 1710

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW3 - Room 1710

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

DBCC WritePage is an undocumented command that allows users to modify physical pages directly. It can only be useful for database repairing when there are extreme situations where nothing can help you recover your data. It makes troubles in most of the time. But it's a good tool for learning other stuff. More importantly, you need to know this when others have already known.

In this 500 level session, We will explore some internals, use this command or other ways to break the database integrity, and use this tool to recover it. I will also demonstrate you how to keep yourself safe from using this command. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1025

Level: Advanced

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

During query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will start with the basics of parallelism in SQL Server. Then lead you to understand what is under the hood of parallel query execution. How you can avoid or benefit from parallelism in OLTP or OLAP environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW3 - Room 1710

Level: Advanced

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes.  An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services.  In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena.

In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW5 - Room 1840

Level: Beginner

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

The word cluster is used a lot in the IT world, especially when it comes to SQL Server. We have clustered instances of SQL Server, availability groups that require Windows failover clustering ... but how does a DBA make sense of it all? Wonder no more! This session will explain all the forms of clustering as they relate to SQL Server (including how Windows fits into the picture) and give you some of the top keys to success whether you are using an older version of Windows and SQL Server, or you're looking to deploy the latest and greatest.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1025

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Do more with less… sound familiar? In this demo rich introduction to Policy Based Management presentation we will be going over what Policy Based Management is and how you can use Policy Based Management and a Central Management Server to evaluate your daily, weekly, and monthly checklists against your entire SQL Server environment.  We will be reviewing some of the “out of the box” policies as well as creating some custom policies that you might be interested in evaluating against all of your SQL Server instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW3 - Room 1750

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Never tried Entity Framework before? Or long term Entity Framework developer? Come learn how Entity Framework 5 makes it very simple to keep both your code and database in sync as you make changes using Code First and Migrations. Plus learn about many other enhancements including Designer improvements and support for new Enums and Spatial types.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1205

Level: Advanced

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 adds many new enhancements to TSQL. Learn how to use the windowing functionality of the OVER clause to create sliding aggregation. Find out about the new SEQUENCE object and when you should or should not use it to replace an IDENTITY.  Learn the IIF function and CHOOSE function to replace a common simple CASE functions.  OFFSET / FETCH will be covered to show you how to eliminate cursors or CTEs for data paging.  With CONCAT you have an easier time building strings in your TSQL statements independent of the data type, and without concern over nulls.  With these and other new TSQL enhancements you will be able to take full advantage of the power of TSQL in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW3 - Room 1710

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Contained Databases is a new feature introduced in SQL Server 2012. We will take a look at the security implications of contained databases and why it considered only “partially” contained. This technical dive into the feature will demonstrate how to implement contained databases, how to migrate a contained database, and
what “gotchas” to be aware of.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1205

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams. This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :) The practices shown in this session will allow to check the database design and identify some of the possible performance degradations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SW9 - Room 110

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Dude gone wild!!! Your final scripts deployed to the live database a few months ago and almost everything went perfectly. Since then you have heard there were few index patches needed maybe even a new column in one or the tables. The live database has drifted just a little from your deployed SQL scripts. How would you like to update your next baseline code to already resemble the current state of the production database? This is just one of the incredible features you can do with SSDT. Take the statefull nature of your database to create and test your code automatically and declaratively. Database developers can use the SQL Server Object Explorer in VS to easily. See how the new scripting and automation tools are used in SQL 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW9 - Room 110

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW1 - Room 1025

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn about the capabilities in Windows Server 2012 Hyper-V that allow you to take large-scale SQL Server workloads and migrate them to Microsoft’s Private Cloud.  You will find out how to configure the key resources – memory, CPU, network, and disk – to help enable the largest SQL Server implementations to perform well.  You will see how System Center 2012 SP1 helps you deal with performance and other issues allowing you to respond more quickly to elements that may impact the applications your users depend on.  Finally, we will demonstrate how implementing SQL Server on a Private Cloud helps to more easily deal with routine maintenance of both SQL Server and the infrastructure supporting it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SW9 - Room 110

Level: Intermedia

Session Code:

Date: February 16

Time: 12:00 AM - 1:00 AM

Room: TBD

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