• 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
  • 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
  • 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
  • INF: You may not be able to change the Design of a Table (Insert or Delete a Column) using GUI.

    We recently worked on an issue where modifying a Table from the GUI was not allowed even though the account had read – write permissions.  So, we are sharing our findings below: Let’s say you have a SQL account ‘ Account_1’ with following Database ...read more
  • Use Microsoft Linux ODBC Driver and Linked Server to access OLEDB Data sources on Remote Systems

    By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our customers when he indicated it would be great if the Microsoft Linux ODBC driver could be used to access his other database systems - in addition to Microsoft ...read more