• Blog Post: Why to look at "Wait Statistics" to troubleshoot SQL Performance

    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 4. Types of Waits. 5. Where to see waits in SQL Server 6. Demo To watch the video...
  • Blog Post: SQL server 2008 Filestream

    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 BLOB data with database transactional consistency, integrated management, security and excellent streaming...
  • Blog Post: Troubleshooting SQL server High CPU : Part 2

    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:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • Blog Post: Troubleshooting SQL server High CPU : Part 1

    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:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch...
  • Blog Post: Product Update Feature in SQL Server 2012

    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 search for the latest or applicable updates in Microsoft Update,Windows Server Update Services (WSUS), a local folder...
  • Blog Post: Introduction to Sparse Columns

    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 values. It reduces the space requirements for null values at the cost of more overhead to retrieve non...
  • Blog Post: High Availability for SQL Server Replication using Database Mirroring

    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. Database Mirroring Overview 3. Replication with Database Mirroring. 4. Mirroring the Publication...
  • Blog Post: SQL Server Replication

    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 we should use Replication? What is replication Model? Replication Types And much more, also...
  • Blog Post: Table partitioning concepts with sliding window example

    Highlights of this video blog :- 1. What are Partitioned tables & benefits 2. Building Blocks of Partitioning 3. Partitioned Table Operations 4. Demo 5. Best Practices To watch the video in better quality please check the link: - http://channel9.msdn.com/Admin/Entries/89c3b162-4dd2-4d88-8abf-9ff800b59e05...
  • Blog Post: SSL Encryption for SQL Server

    Highlights of this video blog :- 1. What is SSL Encryption 2. Why is it needed 3. Configuring SSL Encryption for SQL Server 4. Demo To watch the video in better quality, please check the link: - http://channel9.msdn.com/posts/SSL-Encryption-for-SQL-Server Presented By: Azad Raosaheb Sale...
  • Blog Post: What's Data Collector

    Highlights of this video blog :- 1. What is Data collector 2. Architecture 3. MDW(Management data warehouse) setup 4. System Data Collection Presented By: - Manish Upadhyay,SE,Microsoft GTSC Reviewed By: - Karthick Krishnamurthy,TL,Microsoft GTSC
  • Blog Post: Policy Based Management

    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 cover: What is Policy Based Management? What is facets? How we can create policies in SQL server ? What are the evaluation...
  • Blog Post: Procedure Cache-Part II

    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 query plans and allow its reuse and thus minimize the compile time and improve the performance. This blog will...
  • Blog Post: Procedure cache - Part I

    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 query plans and allow its reuse and thus minimize the compile time and improve the performance. This blog will...
  • Blog Post: Troubleshooting Kerberos Delegation Using DelegConfig

    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 step by step guidelines as to how to use this tool in resolving Kerberos Delegation. Highlights of the blog...
  • Blog Post: What's execution log in Reporting services?

    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 execution log? Where to check for execution log? Information provided by Execution Log How to Manage Execution...
  • Blog Post: Transparent Data Encryption (TDE)

    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 database 6. Migrating the encrypted database For better quality please check the link:- http...
  • Blog Post: Demystifying SQL server memory concepts video

    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 Space 2. SQL Server 32 bit Memory Architecture 3. AWE 4. Managing SQL Server Memory 5. Limitations of 32 bit SQL Servers ...
  • Blog Post: Multiserver administration

    In this video presentation you will learn in depth about Multiserver administration For better quality/download please check the link: - http://channel9.msdn.com/posts/Multi-server-Administration Presented by: Phani Raj,SE,Microsoft GTSC Reviewed by: Akbar Farishta,TL,Microsoft GTSC
  • Blog Post: DDL Triggers

    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
  • Blog Post: What's Performance Dashboard and how it can help in troublehsooting SQL issues.

    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 For better quality please check the link:- http://channel9.msdn.com/posts/Whats-performance-Dashboard-and...
  • Blog Post: What are SQL server audits - a new feature in SQL server 2008

    In this presentation, you will learn about the complete description of the SQL audits , their benefits along with brief demos. For watching the video in better quality please check the link: - http://channel9.msdn.com/posts/What-are-SQL-server-audits-a-new-feature-in-SQL-server-2008 Presented...
  • Blog Post: What are plan guides and how it could help in managing performance of the queries

    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 To see the video in better quality please click on the link: - http://channel9.msdn.com/posts/What-are-plan-guides...
  • Blog Post: Managing SQL resources using resource governer

    In this presentation, you will learn about how you could manage SQL resources using resource governer. To view the video in better quality please click on the link: - http://channel9.msdn.com/posts/Managin-SQL-resources-using-resource-governer Presented by Balmukund Lakhani
  • Blog Post: Whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup

    In this video we will see whats the backup compression in SQL server 2008 and how it can help to optimize the speed/size of the backup To see the video in better quality, please check the link :- http://channel9.msdn.com/posts/Backup-Compression-in-SQL-2008 Presented By: Devashish Salgaonkar
Page 1 of 2 (34 items) 12