JSON vs CLR UDT – performance comparison

Ability to create custom user defined types in CLR and use them in SQL Server is introduced in SQL Server 2005. In SQL Server 2016 is added JSON support that might be alternative for storing complex objects. Since JSON is stored as NVARCHAR and CLR is a type, it is questionable what would be better…


Release notes – October 29

On Sunday, October 29, 2017, we began to deploy a regular service update. We upgrade production services in batches, and it takes about a week for the update to complete. Below is the list of improvements, and bug fixes in this release. New functionality Azure Managed Service Identity: ability to create an identity associated with APIM with…


C# 7 Series, Part 5: Private Protected

C# has several accessibility modifiers, public, internal, internal protected, and private. Public: The member declared with this accessibility can be visible within the assembly containing this member, or any other assembly that references the containing assembly. i.e., access is not limited. Internal: The member declared with this accessibility can be visible within the assembly containing…

9