Multimedia Library - Video http://sqlmag.com/media/all/video en 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: How to Decide if your Database is a Good Candidate for Virtualization http://sqlmag.com/sql-server/session-1-how-decide-if-your-database-good-candidate-virtualization <div class="node-body video-body"><p><strong>Running Time:</strong> 56 minutes | </p> <p>You'll learn about the pros and cons of moving SQL Servers into a virtual server environment. Like all problems in the database world, there are no hard set answers on whether virtualization is a good idea, but there are some times when virtualizing a SQL Server is the best option and can save money. And then there are times when you'll be shooting yourself in the foot and shouldn't virtualize. By the end of this session, you'll know how to make this decision and how to gather the metrics you need to move forward with virtualization.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-1-how-decide-if-your-database-good-candidate-virtualization" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-1-how-decide-if-your-database-good-candidate-virtualization#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 19421 at http://sqlmag.com Session 2: Optimizing SQL Server Performance in a Virtual Environment http://sqlmag.com/sql-server/session-2-optimizing-sql-server-performance-virtual-environment <div class="node-body video-body"><p><strong>Running Time:</strong> 60 minutes | </p> <p>In this session, we'll look over what you should look at within your virtual environment to ensure you are getting proper performance. This will include how to look for CPU performance issues at the host level. We'll also discuss the Memory Balloon drivers – what they do, how you should configure them, and why. We'll discuss memory sharing technologies, which are built into vSphere and Hyper-V, and how they relate to SQL Server. Then we'll will finish with some storage configuration options.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-2-optimizing-sql-server-performance-virtual-environment" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-2-optimizing-sql-server-performance-virtual-environment#comments SQL Server Wed, 23 Jul 2014 17:12:00 +0000 19431 at http://sqlmag.com Session 2: Visualizing Data http://sqlmag.com/sql-server/session-2-visualizing-data <div class="node-body video-body"><p><strong>Running Time:</strong> 57 minutes | </p> <p>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.</p> <p>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&#39;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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-2-visualizing-data" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-2-visualizing-data#comments SQL Server Wed, 25 Jun 2014 17:12:00 +0000 19211 at http://sqlmag.com Session 3: Enhancing Reports with Interactive Features http://sqlmag.com/sql-server/session-3-enhancing-reports-interactive-features <div class="node-body video-body"><p><strong>Running Time:</strong> 59 minutes | </p> <p>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.</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-3-enhancing-reports-interactive-features" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-3-enhancing-reports-interactive-features#comments SQL Server Wed, 25 Jun 2014 17:12:00 +0000 19221 at http://sqlmag.com Session 1: Developing Reports http://sqlmag.com/sql-server/session-1-developing-reports <div class="node-body video-body"><p><strong>Running Time:</strong> 65 minutes | </p> <p>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.</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/session-1-developing-reports" target="_blank">read more</a></p> http://sqlmag.com/sql-server/session-1-developing-reports#comments SQL Server Wed, 25 Jun 2014 17:12:00 +0000 19201 at http://sqlmag.com Session 1: SQL Server 2014 New Features, Editions, and Licensing http://sqlmag.com/sql-server-2014/session-1-sql-server-2014-new-features-editions-and-licensing <div class="node-body video-body"><p><strong>Running Time:</strong> 49 minutes</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server-2014/session-1-sql-server-2014-new-features-editions-and-licensing" target="_blank">read more</a></p> http://sqlmag.com/sql-server-2014/session-1-sql-server-2014-new-features-editions-and-licensing#comments SQL Server 2014 Wed, 14 May 2014 17:12:00 +0000 18181 at http://sqlmag.com Session 2: Getting Started with In-Memory OLTP http://sqlmag.com/sql-server-2014/session-2-getting-started-memory-oltp <div class="node-body video-body"><p><strong>Running Time:</strong> 59 minutes</p> <p>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.</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server-2014/session-2-getting-started-memory-oltp" target="_blank">read more</a></p> http://sqlmag.com/sql-server-2014/session-2-getting-started-memory-oltp#comments SQL Server 2014 Wed, 14 May 2014 17:12:00 +0000 18191 at http://sqlmag.com Session 3: AlwaysOn and Backup Integration with Windows Azure http://sqlmag.com/sql-server-2014/session-3-alwayson-and-backup-integration-windows-azure <div class="node-body video-body"><p><strong>Running Time:</strong> 56 minutes</p> <p>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).</p></div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server-2014/session-3-alwayson-and-backup-integration-windows-azure" target="_blank">read more</a></p> http://sqlmag.com/sql-server-2014/session-3-alwayson-and-backup-integration-windows-azure#comments SQL Server 2014 Wed, 14 May 2014 17:12:00 +0000 18201 at http://sqlmag.com SQL Server Evolution http://sqlmag.com/sql-server/sql-server-evolution <div class="node-body video-body">Michael Otey discusses the evolution of SQL Server, all the way to SQL Server 2014.</div> <div class="og_rss_groups"></div><p><a href="http://sqlmag.com/sql-server/sql-server-evolution" target="_blank">read more</a></p> http://sqlmag.com/sql-server/sql-server-evolution#comments SQL Server Thu, 20 Mar 2014 04:00:00 +0000 16811 at http://sqlmag.com