If you just want to export all the tables in a SQL database in to separate CSV files, then this is a quick and easy way of doing it.
Execute below query which generates BCP commands
SELECT ‘bcp ‘ + st.NAME + ‘ out c:\Target\’ + st.NAME + ‘.csv -c -r -d ‘ + DB_NAME() + ‘ -U user@??????.database.windows.net -S tcp:?????.database.windows.net -P ?????? FROM sys.tables st
Paste the result set into text file. Make batch file and schedule it. (It can also be run in CMD manually)
A nice short video showing how to debug a web service in Microsoft Azure
I have tried a number of Git GUI’s and the best by far has to the Source Tree
Why? It’s just so easy to use and displays what you need when you need it.
It is important that when writing RESTful API’s that the correct HTTP status code is returned, the best and only source of reference has to be:
Continue reading HTTP Status Codes
You’ve been playing with Swagger and can now see the benefits, and you are planning to use a YAML file, now you would like to display it to the outside work, here is a short article explaining all that is required. This is based on you using Express within Node.js
Continue reading Swagger UI reading YAML file
Once you have installed swagger into your application, using this command:
npm install -g swagger
To edit you active YAML file just type to following:
swagger project edit
What is Swagger?
Swagger site we can find the definition of Swagger:
Swagger is the world’s largest framework of API developer tools for the OpenAPI Specification(OAS), enabling development across the entire API lifecycle, from design and documentation, to test and deployment.
Continue reading Swagger
no need for me to explain what to do when Microsoft already has a very good article on debugging within Visual Studio Code
Before we start let’s just ask a few questions:
Continue reading Node.js with Microsoft TypeScript
Here is a short article to provide a simple RESTful API using node.js.
Continue reading RESTfull API using node.js and express.js