SQL Posts

Blog card feature

Connecting to a SQL Server Database via NodeJs

Every full-stack application in production today probably connects to a database of some variety, whether that be a NoSQL database like…

Blog card feature

SQL Server Insert or Update Query with T-SQL & Merge

Need to run a SQL command that will either update an existing row of data in a table or insert a new one if the data doesn't exist? It's a…

Blog card feature

What is a SQL Index?

What is a SQL Index? In short, a SQL Index is an ordered list of a specific column (or columns) from a SQL table. Suppose you have a table…