Why you would use Common Table Expressions
Simple way to get comma delimited values from a field by using SQL for XML clauses
SQL table dependency with entity framework in WPF
In this article, we will see in detail how to display role-based dynamic menu after a user logs in. For this, we will create a Menu Master table and insert a few records to display the menu and link the URL to the menu based on the logged in user's role.
In this post we are going to create a Single Page Application (SPA) with AngularJS and ASP.Net Core. We will use Angular-UI-Router for our application routing instead of MVC routing.
Additional logging and data collection
Prevent brute-force login attacks on a remotely accessible SQL Server database using T-SQL
An Entity Framework log printer that converts SQL commands to executable T-SQL statement
A simple program for compare table data from two sources – SQL databases, Excel, CSV or XML-files.
AngularJS and REST API Tutorial
A show case of a dockerized postgres to improve the coupling between versioned codebase and database schema
PostgreSQL notifications Windows Forms application
Strange behaviour converting NVARCHAR(MAX) to BINARY
Continue with learning indexes in MongoDB
This article explains the value of a multi-cloud computing architecture and the considerations that should factor into your strategy for building one.
In this post we are going to secure our NodeJS API’s with customized security token generated by logged user and HTTP actions.
This is the continuation of exploring the Mongo shells, we will be performing some commands on the Mongo shells.
How to build dynamic SQL in a stored procedure
After finishing the server part, we are continuing on to the client side, by utilizing one of the most popular frameworks out there, Angular 4.
Application of SocketPro onto various databases for continuous inline request/result batching and real-time stream processing with bi-directional asynchronous data transferring
Create and run jobs kinda like SQL Server Enterprise – Users Guide
Manage broken batch packages re-run start point.
This article explains how to tell if a relationship in a database should be many-to-one or one-to-many.
A complete event calendar, using trucking/shipping as an example, built with Visual Studio Community 2015, C# MVC and jQuery.Fullcalendar
SQL unit testing with SQL Server data tools (SSDT)
Snapshot Isolation Level in SQL Server
In this article, we are going to learn how to create a secure Web API in ASP.NET Core MVC.
This article describes how to implement a meeting room booking system in an ASP.NET MVC project with dhtmlxScheduler.
ADO.NET Micro-ORM to SQL Server
How to troubleshoot SQL code using comments