Sql server

Hello guys in this tutorial , we will learn the first step of using sql server. We will see how we can create database and perform crud operation using sql queries.

Setting up database on plesk server

Database Backup .bak

1418 (HY000) at line 10185: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

There are two common objects in ADO.NET to read data, DataSet, and DataReader. C# DataSet and C# DataReader classes represent these objects. In this article, we'll learn about ADO.NET DataReader and how to use a DataReader in C#.

Hello guys, sometimes while working with sql server we often create tables with wrong columns names and we often need to rename those columns. So we will see how to rename table column in sql server.

Hello guys, sometimes while working with big databases in sql server we often need to find all tables where we have used specific columns. So we will see how to do that.

Hello guys, sometimes while working with big databases in sql server we often need to find all procedures where we have used a certain table.So we will see how to do that.

Converting commas or other delimiters to a Table or List in SQL Server

Multiple rows to one comma separated value in Sql Server

The GROUP_CONCAT() function was built specifically for the purpose of concatenating a query’s result set into a list separated by either a comma or a delimiter of your choice.

Hangfire is an open-source library to schedule and execute background jobs in .NET applications. You'll be able to create a simple background process inside the same application pool or thread without creating separate applications. Hangfire creates background jobs in persistence storage, like MS SQL Server, Redis, MongoDB, and others, that may prevent you from losing the job on recycling IIS pools or exception prevalence.

Hello guys, sometimes while working with sql server, we sometimes face the need of working with json data . For that purpose we have to be able to read json data in sql which is quite a difficult task, so we will see how to read json in sql server in simple steps.

Creating and displaying SSRS Report in ASP.NET MVC

Hello guys, in this article we will create script for creating database backups from sql database server. We will use powershell script batch file for this purpose.

In this tutorial we will tell you how to create crud operations in Entity Framework