Create Employee Table- If you want to test in your local database then you can use the following SQL query to create an Employee table...

And this is the reason why I decided to write a little dictionary of terms that you will hear often during this series of tutorial about...

In this part of this article’s series, we are going to install and set up all the necessary programs to make things work with MongoDB in...

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is designed to manage and store large amounts of...

SQL Server Window Functions calculate an aggregate value based on a group of rows and return multiple rows for each group....

The following SQL Server string functions process on an input string and return a string or numeric value: Function Description...

This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data effectively. Returning the...

An aggregate function performs a calculation one or more values and returns a single value. The aggregate function is often used with the...

.NET Sql Authorization Manager is an authorization manager for .NET  Framework 2.0 developed applications (smart-client/web). The...

Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a...