SQL SERVER – Standards Support, Protocol, Data Portability

I have been working with SQL Server for more than 8 years now continuously and I like to read a lot. Sometimes I read easy things and sometimes I read stuff that is not so easy.  Here is few recently released article which I referred and read. They are not easy to read but indeed very important read if you are the one who likes to read things which are more advanced. Let us read more about Standards Support, Protocol, Data Portability.

SQL Server Standards Support Documentation
The SQL Server standards support documentation provides detailed support information for certain standards that are implemented in Microsoft SQL Server.

Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.

Microsoft SQL Server Data Portability Documentation
The SQL Server data portability documentation explains various mechanisms by which user-created data in SQL Server can be extracted for use in other software products. These mechanisms include import/export functionality, documented APIs, industry-standard formats, or documented data structures/file formats.

Here are my few recent videos and I would like to know what is your feedback about them. You can subscribe to my youtube channel here.

• Find a Table in Execution Plan – SQL in Sixty Seconds #151
• Transactions and Variables – SQL in Sixty Seconds #150
• Count Table in Cache – SQL in Sixty Seconds #149
• List All Sessions – SQL in Sixty Seconds #148
• Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
• Slow Running Query – SQL in Sixty Seconds #146
• Change Database and Table Collation – SQL in Sixty Seconds #145
• Infinite Loop – SQL in Sixty Seconds #144
• Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
• SQL SERVER – 16 CPU vs 1 CPU : Performance Comparison – SQL in Sixty Seconds #142
• SQL SERVER – TOP and DISTINCT – Epic Confusion – SQL in Sixty Seconds #141

Reference: Pinal Dave (https://blog.sqlauthority.com)