More in SQL Server

  • Jul 23, 2014
    Education

    Session 3: Advanced Catalog Customization  

    Running Time: 63 minutes | A deep dive into SSIS execution in the SSIS Catalog commensurate with a deeper look at the SSIS Catalog reporting solution built into SQL Server management Studio. Included is a discussion about security, roles, and the implications of both to the enterprise data integration life cycle....More
  • Jul 23, 2014
    Education

    Session 2: Catalog Features  

    Running Time: 70 minutes | An exploration of SSIS Catalog functionality applied to the modern data integration enterprise, featuring discussion and demonstrations of SSIS project and package parameters, SSIS project connection managers, and SSIS Catalog environments and references. Together, these features facilitate enterprise connections management – one of the most important functions of any data integration framework....More
  • Jul 23, 2014
    Education

    Session 1: Introduction to the SSIS Catalog  

    Running Time: 70 minutes | An introduction to SSIS Catalog installation, features, and operation that provides a solid foundation for data integration developers new to the SSIS Catalog and developers transitioning from SSIS 2005, 2008, or 2008 R2 to 2012 or 2014....More
  • Jul 23, 2014
    Education

    Session 3: Implementing Large Cubes  

    Running Time: 63 minutes | In this session, we teach you how best to manage cube processing when you need to load fresh data....More
  • Jul 23, 2014
    Education

    Session 2: Designing Large Cubes  

    Running Time: 60 minutes | In this session, you will learn specific techniques for designing dimensions and cubes to optimize the storage and retrieval of large data....More
  • Jul 23, 2014
    Education

    Session 1: Why is SSAS Multidimensional Still Important?  

    Running Time: 58 minutes | In this session, you learn why SSAS Multidimensional is not ready for retirement....More
  • Jul 17, 2014
    Education

    Session 3: Windowing Functions in SQL Server  

    Running Time: 66 minutes | In this session, we'll examine the windowing functions in SQL Server that allow you to efficiently query data in groups, or partitions, and answer complex questions such as running totals and ranking results into percentiles....More
  • Jul 17, 2014
    Education

    Session 2: Intermediate Queries  

    Running Time: 62 minutes | We'll examine a few intermediate techniques for efficient queries. We start with tally tables and calendar tables, showing practical uses of each. We will then look at pivoting data to display row data as column data and vice versa....More
  • Jul 17, 2014
    Education

    Session 1: Writing Cleaner Code  

    Running Time: 88 minutes | This session will examine ways to write better code by using CTEs to simplify queries, implement error handling to deal with problematic data, and show a few tips and tricks for writing code quicker and generating enough test data to properly evaluate your queries....More
  • Jun 26, 2014
    Education

    Session 3: Enhancing Reports with Interactive Features  

    Running Time: 59 minutes | For users who access and view reports online most of the time, you can add interactive features to make it easier for them to use your reports. In this session, you'll learn how to allow the user to change the sort order of data, add tooltips, or make it possible to expand and collapse sections of your report. You'll also learn how to employ navigation aids to help the user easily move to information located in the same report or to access information contained in a related report or web page. For users who regularly print or export reports as PDF documents, you'll learn how the structure of a page depends on rendering and how to use various report properties that influence the layout of items on a page and pagination....More
  • Jun 26, 2014
    Education

    Session 2: Visualizing Data  

    Running Time: 57 minutes | Reporting Services includes a wide variety of options for displaying information as a data visualization. This session begins by describing how to work with chart controls and how to apply basic formatting to charts. A key performance indicator is a special type of data visualization that you can add to a report to monitor progress to goals. This session shows you the many options available for using a gauge as a key performance indicator and also how to use the indicator report item. In addition, you'll learn about working with spatial data in general, how to use the map wizard to create a map, and how to fine-tune the appearance of a map by configuring properties for the map....More
  • Jun 26, 2014
    Education

    Session 1: Developing Reports  

    Running Time: 65 minutes | In this session, you'll learn a variety of report development techniques that take advantage of the rich set of features available in Reporting Services. You'll start by learning how to work with report server projects in SQL Server Data Tools and how to manage report server project files and properties. Then you'll learn all the data source types you can use to display data in your report, how to connect to these data source types by creating data sources, and how to design queries for these data source types to create datasets. Next, you'll learn how to work with each type of report item, how to configure properties to control appearance and behavior of each report item, and how to work with properties specific to the tablix. Last, you'll learn how to enhance reports by adding calculations and using expressions to change properties dynamically....More

Windows Forums

The Windows IT Pro forums are moving to myITforum.com! Get answers to questions, share tips, and engage with the IT professional community.

Sponsored Introduction Continue on to (or wait seconds) ×