Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 19
This is an introduction session of MCM/MCA certification on behave of MCM program for senior SQL professionals. I will talk about current MCM status, new advanced certificates, and preparation of MCM from my past experience. Bring all your questions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The VertiPaq storage engine has moved out of PowerPivot and out to standalone AS instances. Learn how to build and develop tabular models for these corporate scenarios. You will learn basic modeling techniques, partitions, security, and administration. 
Speaker:

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Trent will discuss everything you need to know about baselines: why they’re important, how to use them and ways to create them using native SQL Server tools. He will also introduce you to Quest’s tools that can make all of this so much easier!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Create a highly-visual reporting experience in SharePoint with SQL Server Reporting Services integrated with SharePoint 2010. See how to use BI report design elements like sparklines, KPI indicators, gauges and maps to make important business information jump off the screen and get users’ attention. Create highly-interactive reports with dynamic drill-down, drill-through and super reports that morph as users interact with the data. Build an interactive dashboard using PerformancePoint/Insights and Reporting Services together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile! 
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

We all complete a full design document prior to coding, don’t we?  What elements should be included in the design document?  This session will explore a number of techniques for producing a solid design document and obtaining buy-in from the end users.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve heard of the term “ETL” before, but you’re not quite sure what it really is and how to do it. In this session we’ll demystify this so-called ETL.  Don’t worry, no previous experience required. We’ll work our way from getting your data from your sources, to cleaning and reformatting them, and loading them to your data warehouse. We will also look at some standards and conventions you should consider when doing ETL to simplify your process, and save you some headaches in the future. 

Of course, our go-to ETL tool is SSIS.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to walk through major topics of T-SQL programming, from simple select statement, joins, transaction controls to the coding of TSQL modules, caveats, and best practices.
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Raffle Draws
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Reserved for Microsoft
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Development

Level: Beginner

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wanted to create a recursive query, but didn't see how to do it.  With the Common Table Expressions class you will learn everything needed to start using CTE's for recursive queries, as a temporary views, and to use the result set multiple times in the same query.  Learn how simplify query syntax using CTE's.  One of the most overlooked features of SQL Server is the CTE which no only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server.  This presentation is targeted for database programmers and administrators who are familiar with TRANSACT SQL, Subqueries, and advanced join techniques.
Speaker:

Session Type:
Regular Session

Track:
Development

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Tabular models use DirectQuery to connect to data sources and fetch data in real time. Learn how DirectQuery works, see how to build DirectQuery models, and learn security and troubleshooting techniques.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

Assessing the health of your SQL Server with Several SQL Server Report Server reports designed for DBA’s and database developers to diagnose, and locate common pitfalls of SQL Server.  This includes reports for Duplicate Indexes, Index Fragmentation, Big Indexes, Backup Status - backup log, Big One Time Use Queries, Queries Needing Parameters and more.
Speaker:

Session Type:
Regular Session

Track:
Administration

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerShell is cool. And powerful. Don’t believe me? See it for yourself. Come to this session, and I will show you cool things we can do with PowerShell – ranging from backing up your servers, working with BLOBs and XML, to automating SSRS report deployments and downloads, and even integrating with SSIS. We’ll work with different facets of SQL Server from a PowerShell perspective. 
Speaker:

Session Type:
Regular Session

Track:
Expanded Horizons

Level: Intermedia

Session Code:

Date: March 17

Time: 12:00 AM - 1:00 AM

Room: TBD

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