Building RESTful APIs using Node JS, Express JS, and MS SQL Server
This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server.
2018-07-30
20,617 reads
Node
Working with the BigInt Type in Node and SQL Server
Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the JavaScript TDS library called 'Tedious'. 'Tedious' is a mature product but it is still possible to get things wrong in converting SQL Server datatypes such as BigInt to native Javascript data.
2017-04-19
3,491 reads
Retrieve SQL Instance Connect Info
This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port
2013-04-11 (first published: 2013-03-24)
1,443 reads
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,845 reads
Side-by-side installation problems
I have SQL Server 2000 and I recently installed SQL Server 2005 Beta 2 as side-by-side installation. Now nothing seems to work. In SQL Server 2000, - Service Manager can't find the file specified. When I click on refresh services, I get "The system cannot find the specified file" - Enterprise Manager: When I start […]
2005-04-13
how to implement a “colourScheme”
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-01-29
RE: SP Problem With VB6
Have you noticed that when you write an ActiveX DLL, passing values ByRef is faster than ByVal, but when you write an ActiveX EXE the opposite is true?
2004-01-05
1 reads
RE: TempDB operations faster?
SQL doesn't has to recovery tempdb when restarted, so it doesn't need to log everything in the log file as much as in a user db. So write operations should be faster.
2003-12-30
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers