Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
Given in the form of a case study, this session will highlight a real-life implementation done of an interesting user request.  Using the functionality of SharePoint, SSIS, and SSAS attendees of this session will learn how to give analyists the ability to generate, define, and immediately use Custom Defined sets in an Analysis Services cube.

This session will highlight some of the power of SharePoint lists, third party SSIS providers, and many-to-many relationships in SSAS cubes.  Additionally, the flexibilty of this solution will be shown though the use of several different user reporting tools.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you!  John will be talk about things that he's seen in the trenches that every DBA should know and understand.  
Speaker:

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time parameter sniffing is helping performance on your servers. But sometimes, circumstances change and what was helping you is now hurting you, bad. In this session we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then, we’ll explore how parameter sniffing can go wrong and I’ll show you seven different ways you can deal with it when it does. You’ll bring back a wealth of knowledge so that you can identify and resolve bad parameter sniffing in your own environment. 
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online.  Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot!  Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases.  Learn the options with SQL server, what each choice will do for you and when to use each one.
Speaker:

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production. 
Speaker:

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a methodology for researching questions and resolving issues then you need to get one, and soon. Join Microsoft MVPs Jason Strate from Digineer and Thomas LaRock from Confio Software as they help guide you while YOU make the choices in this interactive performance tuning adventure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA / DEV

Level: Advanced

Session Code:

Date: January 07

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

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Chefs and cooks have a process called mise en place (MEEZ ohn plahs) which translates to "put in place". For cooks this means "organize and prepare" their stations. They have everything they need ready and in the right place. It also means to remove all distractions. 

In this session I will show how developers and DBAs can use this method to better organize their time and efforts to get more done with less rework.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you remember what it was like to fall in love? Wasn't it wonderful? 

Lately it hasn't been the same. There's no spark anymore. You've been stuck doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong, and you're even thinking about seeing other reporting products.

In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven't been listening), and show you some new -- and easy -- tricks you may not have known RS can do. You'll leave knowing more about troubleshooting with the execution log views, understanding how to design reports for high performance, how to deal with blank pages, and more.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is going to help create a dimensional Data Mart from the AdventoureWorks database that includes dimension tables and 2 example fact tables. The Kimball spreadsheet for documenting a Data Mart will be used to reenforce the need for Requirements and Functional specifications.  A brief review of ETL for Slowly Changing Dimension and population of the Fact will be deomstrated as well as a simple cube for reporting.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. 
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Is your table fat?  Do you need to manage a table that has billions of rows within it and are overwhelmed by index rebuilds that take more than 12 hours?  SQL Server's table partitioning gives the DBA the tools to manage this beast and support very large tables in a way where index management and data retrieval does not become unwieldy.  This presentation will take you step by step through choosing an appropriate partitioning key, setting up the partitioning on the table, and finally maintaining the partitions.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you confident that your application performs as expected on Leap Day?  Do you know how long it would take to run out of identity values in your major tables?  Can you support case-sensitive collations and non-standard sort orders?  If not, odds are good that you are not edge and corner testing your application.  In this session, learn how to define the edges of your application and start to stretch those boundaries by setting up challenging test and development environments.  For database administrators, learn what configurations in your environment may be a source of bugs in application code and what you can do about it.  Learn about edge cases that you can start hardening your code against on Monday morning!
Speaker:

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Companies store data in multiple diverse formats on multiple databases using multiple versions of software and none of it is designed to integrate of work together… until that it gets to the BI systems. In the BI system data suddenly must – as if by magic - become a fully integrated and logically coherent system to generate reports for executives.  This session will explore the Master Data Management (MDM) default system for many companies, their BI stack and how we can use the ETL process to get a single version of truth for corporate data.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Just starting or thinking of starting a data warehousing project but not sure where to begin.  Or still not sure if your organization needs a data warehouse.  This discussion is geared towards answering the what and why (or why not) of data warehousing.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Slow running packages? SSIS consuming all your resources? No idea what it's doing?
After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

Peanut Butter and Mayonnaise? No, Policy Based Management  What can it do for me?  Do I really need it?  How do I install and configure it?  How can it help me to pass audits?  Who is that masked man you got into my database. You mean each server can really be configured the same.  Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA / DEV

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

While a SQL Server consultant may encounter various one-off situations over the course of a career, there are also several patterns and scenarios which repeat themselves with only minor variations.  In this presentation Joe Sack will walk through common scenarios based on his experiences as a field engineer at Microsoft and also as a consultant with SQLskills.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

 Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: January 07

Time: 12:00 AM - 1:00 AM

Room: TBD

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