Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 44
In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided. 
Speaker:

Session Type:
Regular Session

Track:
Keller 3-115

Level: Beginner

Session Code:

Date: September 29

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:
Rapson 56

Level: Intermedia

Session Code:

Date: September 29

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:
Rapson 45

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Practical, real world implementation of advanced dimensional design concepts using SQL Server Analysis Services 2012.  Topics, examples and demos will include the appropriate use of Reference Dimensions, Fact Dimensions,and Many-To-Many Dimensions, to effectively architect and implement SSAS solutions that meet complex business requirements.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Keller 3-125

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter. 
Speaker:

Session Type:
Regular Session

Track:
Rapson 54

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment.
Speaker:

Session Type:
Regular Session

Track:
Rapson 54

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot of database professionals today  do not have a Computer-Science Degree  so they never attended a  “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific  join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Rapson 43

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will explore SQL Server Execution Plans.  Learn how the server is processing a query, see potential pain points, how to know if an index is needed.  This session is designed for intro level DBA's, designers, programmers or anyone who hasn't used Execution plans before
Speaker:

Session Type:
Regular Session

Track:
Rapson 43

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL.  This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks.  The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses.
Speaker:

Session Type:
Regular Session

Track:
Rapson 43

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Drill into Microsoft's Big Data solution and learn how to derive the most value from all your data, including previously untapped unstructured data. Microsoft’s Big Data solution offers breakthrough insights by enabling customers to combine the richness of relational data from databases with unstructured data from Hadoop.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Keller 3-180

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Tables getting big?  Not allowed to delete the data?  Consider table partitioning a great way to help manage large tables.  It is also useful for implementing a data retention and archiving strategy.
Speaker:

Session Type:
Regular Session

Track:
Rapson 56

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
Speaker:

Session Type:
Regular Session

Track:
Rapson 43

Level: Beginner

Session Code:

Date: September 29

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Rapson 56

Level: Intermedia

Session Code:

Date: September 29

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:
Keller 3-210: MVP-MCM

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Data modeling is often an abstract exercise involving a lot of talk and diagrams, but little hands-on experimentation.  This may still be viable in the world of transactional systems where a lack of source data prevents the modeler from quickly creating a prototype system, however in the world of dimensional modeling where source data is abundant there’s no longer a reason to treat data modeling as an academic exercise.  This session will cover how to use PowerPivot for Excel to quickly create prototypes of different dimensional models to try out and discard as necessary.  The features of PowerPivot which allow quick import of data from a variety of data sources will also be demonstrated.  
Speaker:

Session Type:
Regular Session

Track:
Keller 3-115

Level: Intermedia

Session Code:

Date: September 29

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:
Keller 3-125

Level: Intermedia

Session Code:

Date: September 29

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Rapson 56

Level: Intermedia

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre)
Speaker:

Session Type:
Regular Session

Track:
Rapson 45

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session explore the use of the SQL Server spatial data types.  We will see an example of the geography spatial data type used to represent data in a round-earth coordinate system.  Then the geometry spatial data type which represents data in a flat coordinate system will be demonstrated.  Both spatial types are CLR data types and provide a powerful way for businesses; such as; retailers to identify where their shoppers are concentrated, or for call centers to visualize the effect of top performers on others.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Keller 2-260

Level: Beginner

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

There's a lot that goes on under the covers of SQL Server with your indexes. But it's not as secretive as you might think. Most of this information is made available to you through DMVs. While this information is useful - you need a clear understanding of what is in the DMVs in order to understand what is going on. In this session we'll take a dive into sys.dm_index_operational_stats to find out what it does and what you can do with this information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Rapson 45

Level: Advanced

Session Code:

Date: September 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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