Multimedia Library - Video http://sqlmag.com/media/all/video en Session 3: DAX Expressions http://sqlmag.com/sql-server/session-3-dax-expressions <div class="node-body video-body"><p><strong>Running Time:</strong> 63 minutes | </p> <p>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.</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-3-dax-expressions" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-3-dax-expressions#comments SQL Server Mon, 01 Jun 2015 17:12:00 +0000 24841 at http://sqlmag.com Session 1: Loading Data into the Model http://sqlmag.com/sql-server/session-1-loading-data-model <div class="node-body video-body"><p><strong>Running Time:</strong> 68 minutes | </p> <p>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.</p> <p>During this session, we will discuss best practices for creating a model that is easy-to-use and that loads and delivers data efficiently.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-1-loading-data-model" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-1-loading-data-model#comments SQL Server Mon, 01 Jun 2015 17:12:00 +0000 24821 at http://sqlmag.com Session 2: Refining the Model http://sqlmag.com/sql-server/session-2-refining-model <div class="node-body video-body"><p><strong>Running Time:</strong> 59 minutes | </p> <p>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.</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-2-refining-model" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-2-refining-model#comments SQL Server Mon, 01 Jun 2015 17:12:00 +0000 24831 at http://sqlmag.com Session 3: Using Storage to Increase Database Performance http://sqlmag.com/sql-server/session-3-using-storage-increase-database-performance <div class="node-body video-body"><p><strong>Running Time:</strong> 60 minutes | </p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-3-using-storage-increase-database-performance" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-3-using-storage-increase-database-performance#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 19441 at http://sqlmag.com Session 1: Writing Cleaner Code http://sqlmag.com/database-administration/session-1-writing-cleaner-code <div class="node-body video-body"><p><strong>Running Time:</strong> 88 minutes | </p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/database-administration/session-1-writing-cleaner-code" target="_blank">read more</a></p> http://sqlmag.com/database-administration/session-1-writing-cleaner-code#comments Database Administration Wed, 23 Jul 2014 17:12:00 +0000 21831 at http://sqlmag.com Session 2: Power BI for Office 365 Administration http://sqlmag.com/power-bi/session-2-power-bi-office-365-administration <div class="node-body video-body"><p><strong>Running Time:</strong> 79 minutes | </p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/power-bi/session-2-power-bi-office-365-administration" target="_blank">read more</a></p> http://sqlmag.com/power-bi/session-2-power-bi-office-365-administration#comments Power BI Wed, 23 Jul 2014 17:12:00 +0000 21881 at http://sqlmag.com Session 3: Implementing Large Cubes http://sqlmag.com/sql-server/session-3-implementing-large-cubes <div class="node-body video-body"><p><strong>Running Time:</strong> 63 minutes | </p> <p>In this session, we teach you how best to manage cube processing when you need to load fresh data. </p></div> <div class="field-byline"> Presented by: Stacia Misner and Denny Lee </div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-3-implementing-large-cubes" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-3-implementing-large-cubes#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 21981 at http://sqlmag.com Session 2: Data Internals Deep Dive http://sqlmag.com/backup-and-recovery/session-2-data-internals-deep-dive <div class="node-body video-body"><p><strong>Running Time:</strong> 64 minutes | </p> <p>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.</p></div> <div class="field-byline"> Presented by: Bradley Ball </div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/backup-and-recovery/session-2-data-internals-deep-dive" target="_blank">read more</a></p> http://sqlmag.com/backup-and-recovery/session-2-data-internals-deep-dive#comments Backup and Recovery Wed, 23 Jul 2014 17:12:00 +0000 23611 at http://sqlmag.com Session 3: Advanced Catalog Customization http://sqlmag.com/sql-server/session-3-advanced-catalog-customization <div class="node-body video-body"><p><strong>Running Time:</strong> 63 minutes | </p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-3-advanced-catalog-customization" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-3-advanced-catalog-customization#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 23951 at http://sqlmag.com Session 1: Exploring the SSIS Catalog http://sqlmag.com/sql-server/session-1-exploring-ssis-catalog <div class="node-body video-body"><p><strong>Running Time:</strong> 62 minutes | </p> <p>In this session, we will walk through the SSIS catalog: its moving parts, the deployment story, and day-to-day management. We will examine how packages are stored in the catalog, how package configurations have changed (for the better!), and what takes place during a package execution. Much of this presentation will be demo-based, so you'll get to see all of these moving parts in action.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-1-exploring-ssis-catalog" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-1-exploring-ssis-catalog#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 24481 at http://sqlmag.com