Posts

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

Presented By: - Sakthivel Chidambaram,SE,Microsoft...

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...

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

Presented By: - Niraj...

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

Presented By: - Niraj...

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...

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...

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 database

5. Effect...

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 are MSI's/MSP's

2. Location of Setup logs and log file names

3. Fixing missing MSI's and MSP's...

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 check out our...

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

Presented By : - Niraj P Mehta,SSE,Microsoft GTSC