Multimedia Library - Video

Jun 25, 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 25, 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 25, 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
May 14, 2014
Education

Session 1: SQL Server 2014 New Features, Editions, and Licensing  

Running Time: 49 minutes This introductory session provides an overview of all of the major new features in SQL Server 2014. You’ll learn which features are included in which editions of SQL Server 2014. Finally, you’ll get a look at some of the common licensing scenarios for SQL Server 2014 with virtualization and AlwaysOn....More
May 14, 2014
Education

Session 2: Getting Started with In-Memory OLTP  

Running Time: 59 minutes In this session you'll learn how the new In-Memory OLTP engine works. You’ll see how to use the new AMR (Analyze, Migrate, Report) tool to analyze your tables and stored procedures and then migrate them to the new memory-optimized format. Finally, you’ll see how to track the performance of your memory-optimized databases....More
May 14, 2014
Education

Session 3: AlwaysOn and Backup Integration with Windows Azure  

Running Time: 56 minutes In this session you’ll learn about the new AlwaysOn Availability Groups and backup features in SQL Server 2014. You’ll see how to use the compression and encryption features in SQL Server 2014’s backup. Next, you’ll see how the new AlwaysOn Availability Groups can leverage on-premise replicas for high availability (HA) and Azure replicas for disaster recovery (DR)....More
Mar 20, 2014
Video

SQL Server Evolution

Michael Otey discusses the evolution of SQL Server, all the way to SQL Server 2014....More
Feb 19, 2014
video

Documenting Code

Michael Otey believes that as long as programmers still write code, there’s a need for code comments....More
Feb 14, 2014
video

Is the PC Dying?

Michael Otey opines that the PC will do just fine against the rising juggernaut of tablet and PC sales....More
Jan 6, 2014
Video
SQL Server Pro

Session 3: Handling Corruption  

Presented by: Robert Davis Running Time: 59 min Corruption can happen no matter how much care we take to prevent it. It’s inevitable, so the best course of action is to be ready for when it does happen. We will learn in the earlier sessions how to detect corruption, and now it’s time to learn what to do once you have identified it. We will explore the different types of corruption and the options for handling each type … without data loss....More
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Health check note on computer keyboard
Jul 28, 2014
Sponsored

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 6

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×