Quick & Easy way to get data from SQL to HTML using FOR JSON

In this video, I teach you how to use the FOR XML and FOR JSON functions inside SQL Server.

I then take it a step further and give you a demo of how to quickly and easily put this data onto an HTML page with Visual Studio.

Finally, there is also a simple hack to get around the way the JSON FOR AUTO will link the table relationships, saving having to learn the other JSON functions within SQL.

Here is a link to the source code so you can try it yourself.

https://stingrae.com.au/downloads/demojson.zip

How to use GUIDs in your marketing

If you spend $100 on advertising, how do you know it was money well spent? 

You need to know ... and the only way to know is to measure it. And that's where Globally Unique Identifiers can help. 

Watch this short video below where I explain what they are, and how we use them in our Martial Arts Software CRM. 

Thanks for watching ... and if you want to try Arnold for your gym, here is the link: 

https://gymdatabase.co 

Lock Escalation in SQL Server

 Have you heard the following database terms, and wondered what they meant? 

• Locking
• Blocking
• Deadlocking 

Well wonder no more, as in this video I explain what they are, and when a deadlock occurs, I show you one way of figuring out what caused it: 

Click here to open in new window