Why to look at "Wait Statistics" to troubleshoot SQL Performance
[MP4] [0:18:56] [2012/06/18]Here we will discuss on Waits in the context of SQL Server: Highlights of this video blog :- 1. What is wait and why we need to focus on wait? 2. Lifecycle of a session 3. Analogy to explain waits…
SQL server 2008 Filestream
[MP4] [0:32:25] [2012/06/18]Filestream is a new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system. It provides an easy way of handling…
Troubleshooting SQL server High CPU : Part 2
[MP4] [0:16:36] [2012/06/11]In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:-…
Troubleshooting SQL server High CPU : Part 1
[MP4] [0:30:24] [2012/06/11]In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:-…
Sparse Columns
[MP4] [0:14:53] [2012/06/11]In this video blog we would walk you through a feature introduced from SQL server 2008 i.e. Sparse Columns. Sparse columns are just an ordinary columns that have an optimized storage for null…
Product Update Feature in SQL Server 2012
[MP4] [0:12:54] [2012/06/11]A new feature introduced in SQL Server 2012 setup is "Product Update". Product Update searches for the latest product updates and integrates it with the main product installation.It can…
High Availability for SQL Server Replication using Database Mirroring
[MP4] [0:26:22] [2012/06/08]Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring : Highlights of this video blog :- 1. Transactional Replication Overview. 2.…
Missing MSI's/MSP's error during SQL Server Patching
[MP4] [0:40:11] [2012/05/08]In this video blog, we would walk you through some tips and methods to troubleshoot Missing MSI's/MSP's error during SQL Server Patching or installation. Highlights of this video blog :- 1. What…
SQL Server Replication
[MP4] [0:18:44] [2012/03/23]Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the "Replication in SQL server". Highlights of the blog:- What is replication?Why…
Table partitioning concepts with sliding window example
[MP4] [0:41:39] [2012/02/25]Highlights of this video blog :- 1. What are Partitioned tables & benefits2. Building Blocks of Partitioning3. Partitioned Table Operations4. Demo5. Best Practices Presented By : - Niraj P…
What's Data Collector
[MP4] [0:16:17] [2012/02/22]Highlights of this video blog :- 1. What is Data collector2. Architecture3. MDW(Management data warehouse) setup4. System Data Collection Presented By: - Manish Upadhyay
SSL Encryption for SQL Server
[MP4] [0:16:52] [2012/02/22]Highlights of this video blog :- 1. What is SSL Encryption2. Why is it needed3. Configuring SSL Encryption for SQL Server4. Demo Presented By:Azad Raosaheb Sale
Policy based management
[MP4] [0:22:33] [2012/01/19]Check our video blog, and get answers to your queries related to "Policy Based Management" in SQL server. This feature is helpful to ensure compliance at SQL server end. This blog will…
Procedure Cache-Part II
[MP4] [0:45:49] [2011/12/13]Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache, main goal is to cache the…
Procedure cache - Part I
[MP4] [0:25:17] [2011/12/13]Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache, main goal is to cache the…
Troubleshooting Kerberos Delegation Using DelegConfig
[MP4] [0:05:49] [2011/12/10]Gain an expertise in solving the "Kerberos Delegation" issues using one of the useful troubleshooting tool for Kerberos i.e. DelegConfig. Refer to our video blog, that will provide you a…
What's execution log in Reporting services
[MP4] [0:17:31] [2011/12/08]Check out our video blog to gain in depth knowledge about importance of "Execution Log" in reporting services. In this blog you will get to know more about the following :- What is…
Transparent Data Encryption (TDE)
[MP4] [0:25:34] [2011/11/17]Leverage our video blog to empower your knowledge on TDE. Highlights of this video blog :- 1. Introduction to TDE 2. How to implement TDE. 3. Advantages of TDE 4. Changing DEK 5. Removing Encrypted…
Demystifying SQL server memory concepts 
[MP4] [0:23:58] [2011/11/16]Leverage our video blog to empower your knowledge on "SQL Memory".This video will help you to gain in depth expertise to following topics :- 1. More about Process Address Space2. SQL Server…
Multi server Administration
[MP4] [0:13:40] [2011/10/31]In this video we are presenting about Multi Server administration in SQL 2008
DDL Triggers
[MP4] [0:22:52] [2011/10/11]Hello Everyone, In this presentation, you will learn about what are DDL triggers and how they could help you in day to day DBA activities. Presented by: Niraj Mehta
SQL 2008 Clustering using Hyper-V
[MP4] [0:28:54] [2011/08/30] In this video post we are discussing about how to configure clustering on a Hyper V machine
What's Performance Dashboard and how it can help in troublehsooting SQL issues.
[MP4] [0:14:16] [2011/07/08] In this presentation you learn about: 1. How to install performance dashboard 2. How to use performance dashboard 3. Demos of performance dashboard usage in bad performance scenarios Presented By:…
What are SQL server audits - a new feature in SQL server 2008
[MP4] [0:24:42] [2011/07/06] In this presentation, you will learn about the complete description of the SQL audits , their benefits along with brief demos. Presented By Aravind Lakshminarayanan
What are plan guides and how it could help in managing performance of the queries
[MP4] [0:23:08] [2011/06/17] In this presentation, you will learn about what are the plan guides and how they could help the DBAs to manage the performance of the queries when change in the application is not feasible Presented…
Managing SQL resources using resource governer
[MP4] [1:07:03] [2011/06/16] In this presentation, you will learn about how you could manage SQL resources using resource governer. Presented by Balmukund Lakhani
Backup Compression in SQL 2008
[MP4] [0:18:25] [2011/06/16] In this video post we will discuss on Backup compression in SQL 2008. Presented By: - Devashish Salgaonkar
what are Virtual log files - VLF in SQL server - video
[MP4] [0:14:56] [2011/06/03] In this presentation you will learn : 1. Very basics of transaction logs internal structure i.e. VLFs. 2. Best practices for the log files. 3. Impacts of too many VLFs Presented By:- Sakthivel…
Implicit conversions and their implications on the SQL query execution
[MP4] [0:18:27] [2011/06/01] In this presentation , you will learn about what are implicit conversions. What can be their implications in the SQL query executions. Presented by: Rahul Digwasia
Service Broker Basics
[MP4] [0:14:33] [2011/05/03] We would be discussing about the basics of Service Broker and it's basic troubleshooting steps. Presented by: Vijay Rodrigues
Logshipping configuration and monitoring Video
[MP4] [0:16:06] [2011/04/15] In this presentation Anmol Bhasin(SQL server support engineer) has described briefly about: How to configure log shipping How to monitor log shipping Kind regards Harsh Chawla
SQL Server 2008: Declarative Management Framework 
[MP4] [0:11:57] [2011/02/26] Declarative Management Framework is a policy-based system for managing one or more instances of SQL Server 2008. In this presentation Bryan has discussed about working of Declarative Management…
SQL 2008 : Extended Events
[MP4] [0:14:46] [2011/02/26] SQL Server Extended Events (Extended Events) is a general event-handling system for server systems. In this video we are going to discuss about the working of extended events with a demo.
Change Data Capture (CDC) - Video
[MP4] [0:06:21] [2011/02/24] In this video we are going to present a brief demo of how CDC works and it's functionality. This video is presented by Bryan Von Axelson.
SSIS troubleshooting - Demo
[MP4] [0:16:18] [2011/01/07] In this video you will learn basic troubleshooting for SSIS e.g. SSIS connectivity, running SSIS packages via SQL agent jobs,SSIS troubleshooting(traversing through SSIS logs) and protection levels…