SQL Server KBs and Blogs

Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news

Browse by Tags

Related Posts
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more
  • 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 ...read more