Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 54
In a customer service based business world the newest feature being offered to clients in many industries is access to their data for ad hoc analytics.  Agile players in many industries are stealing away market share because of this additional feature they can offer and in turn is forcing big players in every industry to just keep up to hold their ground.  SQL Server 2012 will be in the middle of this battle and will give us the ability to deliver this feature without building the entire system from scratch.  This feature is brought to us by using the new Power View and Business Intelligence Semantic Model all surfaced using SharePoint 2010. 

*** This session will be co-presented by Jacob Wilson who is a SharePoint MCM ***
Speaker:

Session Type:
Regular Session

Track:
BI Delivery

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Head starting to explode from all the technical information you’re absorbing?  Come spend a session with us while we play games with Reporting Services…literally!  Come watch and cheer as SQL Server MVP Stacia Misner is challenged by her progeny and protégé Erika Bakse to an hour of word play, all wrapped up in SQL Server Reporting Services.  They’ll push the limits with what can be built in SSRS and have a stupid amount of fun while doing it.  Swag, trash talk, board games and SQL…who could ask for more?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Delivery

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Understanding Transactions
Transactions are essential to maintaining data integrity. Getting transactions right means understanding both how they work and the business rules that govern your data. This session will explain the fundamentals of transactions and how they behave in SQL Server. It will delve into ACID properties, isolation levels and nested transactions. The session will also review how to structure transactions to satisfy business rules and ensure efficient performance.
Speaker:

Session Type:
Regular Session

Track:
App Dev / DBA

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

You know how to create a connection manager, and you can extract data to a flat file.  So how do you get past basic package creation?  This presentation will cover 5 high-level techniques you can use to become the "go-to" person for SSIS in your organization.  This session will be packed with demos of packages you can use to achieve SSIS Awesomeness!
Speaker:

Session Type:
Regular Session

Track:
SSIS

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Being a database professional can be a thankless job. No one thinks about the database when it works well.  So how do you get the proper recognition when performance review time rolls around?  How do you distinguish yourselves among your peers?  This session will cover 6 things you can focus on to ace your next performance review!
Speaker:

Session Type:
Regular Session

Track:
Professional Development / Azure

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a demo intensive deep dive showing a variety of SSIS methods that you can use to load unstructured text files, gigabyte size files, images, XML, Excel, email, and binary files. I will share techniques that allow files to be loaded in real time with a queue system to load small files separate from large files, file merging for fast loading, and parallel file loading using master/child packages and custom SSIS objects. Finally, I will share useful C# code for parsing complex strings, data manipulation and file archival.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Advanced

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn how to integrate Azure Marketplace data and other Odata feeds into your Semantic Model to provide rich and robust modeling and reporting without the need to create complex workflows or copy and paste formulas every time you manually integrate external data. You will also learn how to publish your data to the marketplace and the roadmap for Microsoft’s private data hubs – bringing the power of the Azure Marketplace to your datacenter.
Speaker:

Session Type:
Regular Session

Track:
Professional Development / Azure

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you finding your mornings filled with busy work?  Trying to manage a large and growing number of SQL servers and feeling a bit overwhelmed?  We'll take a look at tools that can help such as the SQL Server Tacklebox and a monitoring tool with a funny name - Zabbix.  http://data.samgreene.com for more info.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: April 28

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

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In today's enterprise environments, it is becoming increasingly necessary to integrate data from a variety of sources. As SQL Server continues its march into the enterprise, the days of focusing 100% on one platform are over. At a bare minimum, we need to be able to communicate with DBA's for other platforms. Terminology as simple as Instance and Database mean very different things in Oracle than they do in SQL Server. In this session, we will compare and contrast the two platforms in terms of features and terminology. We will also discuss some of the best practices and pitfalls when integrating the two. 
Speaker:

Session Type:
Regular Session

Track:
App Dev / DBA

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server on VMware???  Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Architecture

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot took end users a long way towards creating some amazing self-service data models that we are starting to find are very valuable to the business.  Now how do we take these models to the next level and truly allow enterprise access to something that may have just lived in a team site previously?  This is where the new features of Business Intelligence Semantic Models (BISM) come into play.  We will take a BISM model from its baseline roots of a PowerPivot and drive it to the enterprise level showcasing partitioning, security, and hierarchies while explaining how these will come into play in a real world business scenario.
Speaker:

Session Type:
Regular Session

Track:
BI Architecture

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
Professional Development / Azure

Level: Beginner

Session Code:

Date: April 28

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:
App Dev

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Got data that is a mess that you have been asked to clean up before loading into your data warehouse? Come learn from this demo packed session the various components and techniques in SSIS for cleaning messy data including removing duplicates, removing unwanted characters and words. Become less "fuzzy" about the cleansing powers of fuzzy grouping and fuzzy lookups. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you  now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
Speaker:

Session Type:
Regular Session

Track:
BI Delivery

Level: Beginner

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Professional Development / Azure

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Facts and Dimensions are the essence of any Data Warehouse, but there are many other components required to make the environment scalable, flexible and fully automated. 

There are lots of decisions to be made: Should you have a separate database for staging or not? How do you fully automate the ETL sub-system and parameterize it?

In this session we will discuss a practical approach to designing the Data Warehouse back-end, based on personal experience.
Speaker:

Session Type:
Regular Session

Track:
BI Architecture

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Dynamic MDX can be a great way to reuse, reduce, and recycle .rdls and simplify report maintenance. Have a lot of reports that are practically the same, minus a few pesky exceptions? Dynamic MDX could be the answer! In this session we’ll walk through how to create a basic .rdl that can support a variety of MDX queries that will be generated dynamically. We will also discuss the pros and cons of this approach so that you can make an informed decision of when and if Dynamic MDX is the solution for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Delivery

Level: Intermedia

Session Code:

Date: April 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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