Build a Secure Node.js App with SQL Server Step-by-Step

Related articles and resources:

---------------------------

Okta is a developer API service that stores user accounts for your web apps, mobile apps, and APIs.

[rauldeandrade]

I didn't start the tutorial yet and I already gave a thumbs up for that majestic beard. You sir, are awesome. I'm looking forward for the tutorial

[MatthewBlewittWeb]

Nice to see raw SQL examples, so many node tuts use ORMs!

[jaxparrow]

David, from the bottom of my heart, a BIG thank you!

[mrnikom]

Your voice is so loud & clear, Thanks

[Bobby-wqbn]

Also guys, if you start having the connectionError problem when opening localhost:8080/api/events - open Sql Server Configuration Manager - > profotols for MSSQLSERVER -> right click on TCP/IP and enable.

[moutonguerrier]

Thanks for the tutorial, explanations, pro-tips and a little guitar! I really appreciate the work put into this video.

[aabhassao]

Thanks for this tutorial, loved it. Didn't find content like this anywhere else.

[mustaphamouloua]

Great tutorial, you took your time and went trough the process nice and easy, very helpfull for me as a beginner, thanks a lot!

[gkramer]

Awesome content !!!! It’s so amazing and should have billions of views, congrats for the content

[genesdada]

Hello! love the guitar!.. really enjoying your tutorials. Asante Sana.

[LarryWEitel]

I thoroughly enjoyed your video! I picked up quite a few valuable ‘pro’ tips. THANK YOU!

[nilshomeier]

Great tutorial. Thank you for that! I was wondering if you could advise how to change the config so that it works with a SQL DB with windows authentication? I dont really get where to put the connection string.

[jasirakk]

Could you share with us what iterm theme are you using?

[ShadowBlackzZ]

How are you, thank you very much for such a good tutorial, but I have one doubt. Why the need to create a file for each query? This does not decrease performance? This is not entirely clear to me.

[kite]

1:28:00 im getting the following error when running "node ." even tho my directories are set up exactly as in the video (up to this point)
startup error [Error: ENOENT: no such file or directory, scandir '/Users/khalil/demos/src/ events '] {
errno: -2,
code: 'ENOENT',
syscall: 'scandir',
path: '/Users/khalil/demos/src/ events '
}

any ideas please? the events folder is inside the data folder, and if you look at the path:, there is a blank space. how can i edit the path so that the space is the data folder?
thank you

[amaanmuhammad]

got a question. Will i be able to store data on different accounts or is it just one account i can save it on?

[Krahkarq]

Thank you so much for this great tutorial!

[Ackrozinski]

Hi, nicely done video!

I did run into the following issue. when I try to run the sql server, it stops shortly after. Inspection of the log file reveals the master.mdf database file and the master log file master.ldf, are being loaded from C:\templatedata\master.mdf and C:\templatedata\master.ldf respectively. Is the reference to the C:\ drive and path part of the image/container that's used? I'm confused because I'm running on a Mac and there is no C:\ drive. Also note, no such destination exists on my system either. Is the destination also part of the container?

Part of the log file:

2020-11-03 02:02:25.78 Server Setup step is copying system data file 'C:\templatedata\master.mdf' to

2020-11-03 02:02:25.89 Server Did not find an existing master data file /var/opt/mssql/data/master.mdf, copying the missing default master and other system database files. If you have moved the database location, but not moved the database files, startup may fail. To repair: shutdown SQL Server, move the master database to configured location, and restart.

Thanks!

[TisDeKenny]

Idk how others managed to follow this for 3 hours but I quit 1:20:00 in. I was just copying and copying and copying code. Never stopped to pause and see what we just wrote (running our program to check the server running message for example). I just got lost after a while because VSCode didn't recognize app.config() and I couldn't figure out why because it could've happened anywhere in the past hour.

Also the "we'll install this and that and that" without any information about what it all exactly does is also a reason why I stopped.

[marcozambello]

Hi! I had problem with nodejs and mssql with await query. Why do you use hapi?