SQL Utilization Tip Sharing

Simon Cho

Want to share overall MSSQL utilization tip and feature?

1. SQL can run http api call such as get, post using crl function.
One of Microsoft Engineer, Jovan Popovic, posted Curl extension to clr function.
It gives us lots of flexibility on MSSQL database.
MSSQL is very good to run Json data structure.
MSSQL can run API call.
MSSQL is good at scheduling job.

Therefore, MSSQL itself can do datasync from API provider to on-premise DB structure.
It can provide flexibility to provide on demand report as well.

2. Distributed AlwaysOn can do another AG top of AG in different domain.

3. Visual studio DB project to Database Deployment automation.

4. SQL Automatic tuning enable.

5. e.t.c.