SQL Server

search by tag

Crafting paginated API with NodeJS and MSSQL

January 27, 2021 | 6 min read | 383 Views

Paging, sorting and filtering seems too much to handle for a single soul; but the soul of a programmer craves for such trouble. When you have tons of data to show in a grid/table provided with filtering and sorting options then there is no option left to leave these duties to your backend. In this article we will see NodeJS with MSSQL acting as backend and fabricate a paginated, sort and filter enabled API.

Calling Stored Procedure with NodeJS and MSSQL

December 31, 2020 | 6 min read | 1030 Views

Stored procedures, bringing bread and butter for many full stackers. They are the heavy lifters, holds up many business logics, handles input/outputs, returns multiple record sets and tons of more features. Why in this world, one will avoid the communication to happen between the super heroic NodeJS and MSSQL stored procs. In this article we will highlight most of the common scenarios we deal with while calling stored procs with NodeJS and MSSQL.

Teaming up with NodeJS and SQL Server

December 24, 2020 | 10 min read | 361 Views

It's always satisfying to watch our backend connecting to the database server in one go. Within this short life span we come across different weirdo errors and issues while making the simplest form of connection to a database server; teaming up NodeJS with MS SQL Server is no different. In this article will make a smooth connection between NodeJS and MSSQL, and perform the decade old tradition (CRUD).

Generate SQL script using beloved C#

November 27, 2020 | 3 min read | 658 Views

Generating SQL script is a pretty classy way to obtain queries for schema or data or schema and data which helps to get some sort of backup of your database or get build up queries to regenerate the database entirely. But what if we need to generate SQL scripts programmatically using hearty C#? The SqlManagementObjects (SMO) nuget package is here to help.