Posts - GauravSrivastava


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…


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…