Multimedia Library - Video http://demo.sqlmag.com/media/all/video en Session 3: Using Storage to Increase Database Performance http://demo.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://demo.sqlmag.com/sql-server/session-3-using-storage-increase-database-performance" target="_blank">read more</a></p> http://demo.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://demo.sqlmag.com Session 1: Writing Cleaner Code http://demo.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://demo.sqlmag.com/database-administration/session-1-writing-cleaner-code" target="_blank">read more</a></p> http://demo.sqlmag.com/database-administration/session-1-writing-cleaner-code#comments Database Administration Wed, 23 Jul 2014 17:12:00 +0000 21831 at http://demo.sqlmag.com Session 2: Power BI for Office 365 Administration http://demo.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://demo.sqlmag.com/power-bi/session-2-power-bi-office-365-administration" target="_blank">read more</a></p> http://demo.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://demo.sqlmag.com Session 3: Implementing Large Cubes http://demo.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://demo.sqlmag.com/sql-server/session-3-implementing-large-cubes" target="_blank">read more</a></p> http://demo.sqlmag.com/sql-server/session-3-implementing-large-cubes#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 21981 at http://demo.sqlmag.com Session 2: Data Internals Deep Dive http://demo.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://demo.sqlmag.com/backup-and-recovery/session-2-data-internals-deep-dive" target="_blank">read more</a></p> http://demo.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://demo.sqlmag.com Session 1: Building from a Solid Foundation http://demo.sqlmag.com/database-administration/session-1-building-solid-foundation <div class="node-body video-body"><p><strong>Running Time:</strong> 67 minutes | </p> <p>Without a solid foundation, it can be difficult or even impossible to scale a poorly-designed database to meet future demands. We'll cover some of the core fundamentals of the SQL Server instance and database that you need to be aware of to give the best chance of scalability and maintainability over time.</p></div> <div class="og_rss_groups"></div><p><a href="http://demo.sqlmag.com/database-administration/session-1-building-solid-foundation" target="_blank">read more</a></p> http://demo.sqlmag.com/database-administration/session-1-building-solid-foundation#comments Database Administration Wed, 23 Jul 2014 17:12:00 +0000 21291 at http://demo.sqlmag.com Session 2: Intermediate Queries http://demo.sqlmag.com/sql-server-2014/session-2-intermediate-queries <div class="node-body video-body"><p><strong>Running Time:</strong> 62 minutes | </p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://demo.sqlmag.com/sql-server-2014/session-2-intermediate-queries" target="_blank">read more</a></p> http://demo.sqlmag.com/sql-server-2014/session-2-intermediate-queries#comments SQL Server 2014 Wed, 23 Jul 2014 17:12:00 +0000 21841 at http://demo.sqlmag.com Session 3: Data Integration http://demo.sqlmag.com/power-bi/session-3-data-integration <div class="node-body video-body"><p><strong>Running Time:</strong> 80 minutes | </p> <p>Power BI for Office 365 can tap into both cloud and on premise data sources. We'll walk through the setup and configuration of the Data Management Gateway (used for on premise connectivity), review the role of the data steward, and discuss future integration capabilities.</p></div> <div class="og_rss_groups"></div><p><a href="http://demo.sqlmag.com/power-bi/session-3-data-integration" target="_blank">read more</a></p> http://demo.sqlmag.com/power-bi/session-3-data-integration#comments Power BI Wed, 23 Jul 2014 17:12:00 +0000 21891 at http://demo.sqlmag.com Session 2: Creating Synchronous, Asynchronous and Read-Only Replicas http://demo.sqlmag.com/high-availability/session-2-creating-synchronous-asynchronous-and-read-only-replicas <div class="node-body video-body"><p><strong>Running Time:</strong> 56 minutes | </p> <p>In this session, you'll see how you can create AlwaysOn Availability Groups that contain both synchronous and asynchronous replicas. You'll also see how you can offload reporting and backups to read-only replicas.</p></div> <div class="og_rss_groups"></div><p><a href="http://demo.sqlmag.com/high-availability/session-2-creating-synchronous-asynchronous-and-read-only-replicas" target="_blank">read more</a></p> http://demo.sqlmag.com/high-availability/session-2-creating-synchronous-asynchronous-and-read-only-replicas#comments High Availability Wed, 23 Jul 2014 17:12:00 +0000 23421 at http://demo.sqlmag.com Session 3: Indexing Internals http://demo.sqlmag.com/backup-and-recovery/session-3-indexing-internals <div class="node-body video-body"><p><strong>Running Time:</strong> 60 minutes | </p> <p>We will discuss how the application architecture of SQL Server works, and how to apply this logic to building the best indexes for your queries.</p></div> <div class="field-byline"> Presented by: Bradley Ball </div> <div class="og_rss_groups"></div><p><a href="http://demo.sqlmag.com/backup-and-recovery/session-3-indexing-internals" target="_blank">read more</a></p> http://demo.sqlmag.com/backup-and-recovery/session-3-indexing-internals#comments Backup and Recovery Wed, 23 Jul 2014 17:12:00 +0000 23621 at http://demo.sqlmag.com