Microsoft Tools

Dynamic Management Views (DMVs) allow you to inspect SQL Server internals. These views exist in the SYS schema. Here are some examples of ...

A transaction is a group of database statements that are all done as a single atomic unit. Or they might all be invalidated (rolled back)....

SQL Server allows you to create temporal tables. This functionality is new as of SQL Server 2016. These tables store the latest version of...

If you want to extract a single value out of a JSON string, you can use the JSON_VALUE() function. Note that parameters passed to it are c...

JSON stands for JavaScript Object Notification. It is a text format for object. It is similar and simpler than XML. It is also shorter. It...

Sometimes you need to Extract/Transform/Load data en masse. In these scenarios, you will be doing bulk operations for performance. There i...

XML is an expandable/extendable syntax. You need to meet certain rules to qualify as being well formed XML. Elements are placed between na...