How to map SQL Server JSON columns using JPA and Hibernate

Introduction In this article, we are going to see how easy it is to map an SQL Server JSON column when using the Hibernate Types project. Not only that the hibernate-types project supports JSON column types for PostgreSQL and MySQL and Oracle, but, as you will see in this article, the JsonStringType works just fine when using Microsoft SQL Server. SQL Server JSON storage When using SQL Server, you can use the NVARCHAR column type to persist JSON objects. The advantage of storing JSON in an NVARCHAR column is that…

Read More

How to get the query execution plan on SQL Server

Introduction In this article, we are going to see how we can get the query execution plan when using the SQL Server relational database system. The execution plan allows you to understand the operations done by the database engine when executing a specific SQL query. SQL execution plan The steps involved in executing a given SQL query can be visualized in the following diagram. The first step is to parse the SQL query into an AST (Abstract Syntax Tree). During parsing, the database validates the SQL query syntax and the…

Read More
Scripts code 

Web Scripting Explained for Beginners

http://www.build-your-website.co.uk/Starting-scripting/- In this video tutorial we look at the different types of scripting languages that you will encounter on the web when building websites e.g JavaScript, PHP scripts. When are scripts used, and what you need to run them ,and common applications that use them.

Read More
Scripts code 

Scripting language – Server side scripting vs client side scripting

Hack facebook: https://www.youtube.com/watch?v=4QgqLxhB-L8 Android 8.0 Oreo: https://youtu.be/0qyVFZzMNJI Track mobile [PRACTICAL]: https://www.youtube.com/watch?v=6Q_EriLACak Social engineering: https://youtu.be/Gc47W6rHPAg Hack password: https://www.youtube.com/watch?v=BWKYmb2CHJc Hide IP Address: https://www.youtube.com/watch?v=SEeQ9tlIrOE 9 Top android apps for hacker: https://www.youtube.com/watch?v=ajO0k2r-i5o In this video I discuss about two types of scripting language. I tell you whats are the different between server side scripting and client side scripting, also I have tell you how both of two work. I hope you enjoyed the video. If so then please like this video and for more video related this Subscribe this channel now. Subscribe our Youtube…

Read More