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…

4

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 performance. It basically maintains transactional consistency between the…

2

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 the video in better…

1

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 the video in better…

1

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 or a network share. Product Update can pull in…

0

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 null values….

0

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 database 5. Effect of the Mirroring state on the Replication Log Reader agent. 6. Mirroring…

3

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 check out our upcoming series on replication for some in-depth knowledge. For…

1

Table partitioning concepts with sliding window example

Highlights of this video blog :- 1. What are Partitioned tables & benefits2. Building Blocks of Partitioning3. Partitioned Table Operations4. Demo5. Best Practices To watch the video in better quality please check the link: – https://channel9.msdn.com/Admin/Entries/89c3b162-4dd2-4d88-8abf-9ff800b59e05   Presented By : – Niraj P Mehta,SSE,Microsoft GTSCReviewed By: – Sumit Sarabhai,TL,Microsoft GTSC

1

SSL Encryption for SQL Server

Highlights of this video blog :- 1. What is SSL Encryption2. Why is it needed3. Configuring SSL Encryption for SQL Server4. Demo To watch the video in better quality, please check the link: – https://channel9.msdn.com/posts/SSL-Encryption-for-SQL-Server  Presented By: Azad Raosaheb Sale,SE,Microsoft GTSCReviewed By: Karthick Krishnamurthy,TL,Microsoft GTSC

2