Multimedia Library - Video

Aug 3, 2016
Sponsored

HPE and Microsoft Partner to Help the "Always On" Enterprise

VIDEO: See how SQL Server 2016 and Superdome X work together to deliver mission-critical availability anytime, anywhere....More
Jun 1, 2015
Education

Session 3: DAX Expressions  

Running Time: 63 minutes | This session will cover the creation of advanced measures and analytics within the model using DAX expressions. We will use the CALCULATE() function along with various filtering, date, and table functions to create time analytics, percent of total, and other common functionality. We will also look at KPIs and working with hierarchies. During this session, we will discuss how filtering works within a Tabular model to create an in-depth understanding of basic DAX functionality and provide a firm foundation for developing complex measures using DAX expressions....More
Jun 1, 2015
Education

Session 1: Loading Data into the Model  

Running Time: 68 minutes | This session will cover the process of loading data into the model. We will look at working with various types of data sources. We will pull whole tables, as well as use queries to pre-aggregate data as part of the load process. Once the data is in the model, we will begin to clean the model to make it as user friendly as possible. During this session, we will discuss best practices for creating a model that is easy-to-use and that loads and delivers data efficiently....More
Jun 1, 2015
Education

Session 2: Refining the Model  

Running Time: 59 minutes | This session will cover the process of refining the data in the model. This will include setting various attributes of the tables and the columns to improve functionality. We will also create relationships and hierarchies within the model. In addition, this session will cover the creation of calculated columns and basic measures within the model. During this session, we will discuss ways to get the most out of your model by completely defining the structure and content of the model....More
Jul 23, 2014
Education

Session 3: Using Storage to Increase Database Performance  

Running Time: 60 minutes | In the final session, we'll look at ways that your storage solution can be configured to increase database performance. Some of the things to consider when selecting the correct RAID level to use will be highlighted, along with a review of how to setup the cache in your storage array or DAS. We'll then look at some of the newer technologies like FLASH Cache to improve the caching abilities of the storage arrays. Finally, you'll learn some of the differences between iSCSI and Fibre Channel and how to use tiered storage from both a performance and finance perspective....More
Jul 23, 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
Jul 23, 2014
Education

Session 2: Power BI for Office 365 Administration  

Running Time: 79 minutes | We'll install and configure Office 365 on the desktop, then setup and configure a new Power BI for Office 365 tenant. This session will also cover the Power BI for Office 365 licensing and site provisioning requirements....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: Data Internals Deep Dive  

Running Time: 64 minutes | During this session, you will learn about byte swapping, bitmaps, and dive a little into decoding Hex and binary – working to give you a full understanding of database internals and how you use them every day....More
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

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Sep 15, 2016
Sponsored

Power BI Desktop “Publish to Pyramid Server” Button

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
Jul 6, 2016
Sponsored

Using BI Office Together with Microsoft Power BI Desktop to Unlock Business Insights

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
Jul 6, 2016
Sponsored

Why It’s Important to Unlock Business Insights Trapped on Individual Desktops

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More

Sponsored Introduction Continue on to (or wait seconds) ×