Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 36
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:
Room 321

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn 10 common T-SQL mistakes and how to avoid them.  Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.
Speaker:

Session Type:
Regular Session

Track:
Room 142B

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date & time functions, windowing functions, analytic functions and sequences.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 321

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Why am I here?  This is a question you might ask yourself each day at work.  Perhaps its mundane tasks, reactive troubleshooting, or just filling out TPS reports on a Friday afternoon.  This session is going to attack the mundane and show you some of the things Powershell can bring to the table for working with SQL Server.  From performance monitoring to writing tests, it promises to be entirely scripts and demos compiled from real work on a large OLTP SQL environment .  The theoretical will be ignored as well as any common decency towards mass produced beer.       

No SSIS or Powerpoint will be harmed during this presentation.  
Speaker:

Session Type:
Regular Session

Track:
Room 142A

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Window functions are an underused feature in T-SQL.  These functions can help you solve complex business problems such as running totals and ranking.  If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.
Speaker:

Session Type:
Regular Session

Track:
Room 142A

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

More often than not, a SQL DBA will also be requested (or required) to administer *other* applications in the SQL universe.  These applications are often the BI stack, SSIS, SSRS, and SSAS.  In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work.  At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.

This session will focus on the SSIS, SSRS, and SSAS engines in this session.  Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.
Speaker:

Session Type:
Regular Session

Track:
Room 142B

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will explore Service Broker, one of the lesser known features available since Microsoft SQL Server 2005. This technology provides a robust asynchronous programming model and can be reliably used to develop lightning fast applications that scale very well and can boost your application's throughput. We will look at a few examples of real world service broker implementations in OLTP as well as batch processing modes. We will also discuss some of the commonly used tools for troubleshooting a service broker set up, as well as few common pitfalls to avoid .
Speaker:

Session Type:
Regular Session

Track:
Room 336

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We  will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker:

Session Type:
Regular Session

Track:
Room 142A

Level: Intermedia

Session Code:

Date: April 21

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:
Room 322

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Data Tools (SSDT) formerly known as Project Juneau is the next iteration of Visual Studio for Database Professionals aka DataDude.  Let's chat about some of the great new features, and some of the features that aren't so great. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 322

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
Speaker:

Session Type:
Regular Session

Track:
Room 321

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

A demo-rich presentation of PowerPivot 2012
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 336

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Demystifying PowerPivot from the SharePoint Admin Perspective. PowerPivot can be a maddening undertaking to the SharePoint Admin. We'll walk through the basic architecture of PowerPivot within SharePoint. Then we'll setup an actual working PowerPivot and store it in SharePoint. We'll also walk through setting up the PowerPivot Refresh. Along the way David will share anecdotes, tips & hints, SharePoint war stories, and the occasional movie quote. 
Speaker:

Session Type:
Regular Session

Track:
Room 350

Level: Intermedia

Session Code:

Date: April 21

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 using the execution log, understanding how to design reports for high performance, how to deal with blank pages, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 350

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them.
Speaker:

Session Type:
Regular Session

Track:
Room 142A

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Having multiple database files and filegroups is one of many strategies to improve performance and make administration easier. What are filegroups, and how do you use them? In this session, I'll show you how to create filegroups, create objects in them or move objects to them, and discuss how they can help performance. I'll also cover Enterprise-level features like piecemeal restores. 
Speaker:

Session Type:
Regular Session

Track:
Room 321

Level: Intermedia

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

  Every SQL developer or DBA should have a fully stocked toolbox that they can turn to in times of need.  SQL Server enjoys a wide variety of support from 3rd party vendors that provide tools to help us peek under the hood and pinpoint issues.  Sometimes we either don't have the budget for everything we would like, or we need something for a one-off project.  In this session we will examine some of the free tools published by members of the SQL community and 3rd party vendors.
Speaker:

Session Type:
Regular Session

Track:
Room 142B

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The world of databases is constantly changing.  It used to be that we kept all of our servers and data locked up in big, expensive server rooms in the back of the building.  Now days, you hear about data existing in this cloud-thing.  So what happens when you come in on Monday morning and the latest database was deployed in the cloud.  In this session, we’ll look at what it means to be a DBA with SQL Azure and how the more things change the more they stay the same.
Speaker:

Session Type:
Regular Session

Track:
Room 321

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 336

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 350

Level: Beginner

Session Code:

Date: April 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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