Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 39
Are you a Business Intelligence developer? Have you built a SQL Server Reporting Services, Analysis Services or Integration Services solution? Have you deployed to a test server and are wondering "Now what?" Or are you a production SQL Server DBA who's been informed that since SSAS, SSIS or SSRS have "SQL" in their name, you have to take over the day-to-day management of a SQL BI project? This fast-paced session will look at what it takes to manage and administer projects created with the SQL Server BI products. We'll look at the management tools, deployment lifecycles, security capabilities and disaster recovery processes for these products. We'll see why, if you're a developer, you might still need your DBA, or if you're a DBA, you might 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Too busy to read BOL to figure out what they've added?  This purely demo based presentation will give you a taste of what new language features are available to make your life easier.  Sure, you might know about CTEs and windowing functions, but what about the new data types (geospatial, xml, etc), DMOs and query hints.  Stop in and see if I can rattle off a feature a minute.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

One of my clients, the Department of Human Services, wants to predict which children that leave foster care will have to return to foster care at later date.  Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data.  This presentation will demonstrate how to develop a data mining model using Analysis Services from conception to deployment using internal and external data, and you will see how to get and display results.  Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.  
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client.  In this session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate largely upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and SQL Server databases are moving in that direction as well.  This presentation will explore the fundamentals of running SQL Server in a VMWare environment. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks and cover best practices for maintaining optimum performance in a SQL Server / VMWare environment.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 1
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 2
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 3
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 4
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 5
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Break 6
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business.  Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks.  
This Library will also allow you to simply document your systems for your and others knowledge.  
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Don't let this happen to you! This session covers current and upcoming hardware from both Intel and AMD.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Most ‘accidental DBAs’ start their foray in to database administration in a similar way.  You start with little knowledge of SQL server and maybe even little knowledge of system administration basics at all.  I will share some tips and tricks that I have picked up over the years to help you get on your feet as a DBA, by showing you how to find out where your instances of SQL are, what business processes depend on them, what their current states are and how to learn the skills you need to keep your databases safe and available.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Lunch\Meet the experts\WIT
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Lunch\Meet the experts\WIT 2
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Lunch\Meet the experts\WIT 3
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Designing a fast, elegant report for Reporting Services can be challenging.  In this session, we'll cover design methods you can start using right away to create faster reports with fewer headaches and in less time.  We'll also look at how to deal with potentially frustrating aspects of report appearances like border behavior, multi-column layouts, and unwanted blank pages.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduced with SQL Server 2008 R2 and Visual Studio 2010, Data Tier Applications (DACs) help to simplify the development lifecycle of SQL Server database applications. DACs can be integrated into larger Visual Studio application projects and make for a very integration application development lifecycle. In this session, you will learn about DACs and how to use Visual Studio to build SQL Server Data Tier Applications. This session will also discuss creating DACs from existing database structures and will demonstrate how to integrate existing databases into Visual Studio application solutions.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

Networking 10
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 12

Time: 12:00 AM - 1:00 AM

Room: TBD

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