SQL Server Archives - Page 2 of 3 - ASP.NET Hosting Tips & Guides

How to Schedule SQL Server Backup

March 20, 2023 Andriy Kravets

A disaster recovery approach must include a solid backup and restore plan. This piece will outline 3 distinct methods/solutions for setting up a scheduled backup

Entity Framework SQL Server

How to Execute SQL Query on a Different Database

October 28, 2022 Andriy Kravets

I had to deal with this issue a couple of times when developing a Web Application that was using Serilog, a neat third-party package that you

ASP.NET Tips Entity Framework MySQL SQL Server

How to Combine Database with Your ASP.NET Core Application

September 28, 2022 Javier Huthon

When building an ASP.NET Core application, you will probably need to use a database to store your data. This post will explore several possibilities to

SQL Server

How to Backup and Restore Without Using .BAK

May 25, 2022 Andriy Kravets

In previous tutorial, we have given tutorial about how to backup SQL database to local. In this tutorial, we will explain how to backup and

SQL Server

How to Backup Remote SQL Database to Local

May 20, 2022 Andriy Kravets

In this article, you’ll learn the key skills that you need to copy tables between SQL Server instances including both on-premises and cloud SQL databases.

ASP.NET Tips SQL Server

Steps to Use Database First in Entity Framework with a Class Library and SQL Server

March 4, 2022 Javier Huthon

The following is short tutorial about how to get my database first working in a Class Project (.NET Core), with a .NET Core Web App.

SQL Server

How to Fix ‘The certificate chain was issued by an authority that is not trusted’ SQL Server

July 9, 2021 Andriy Kravets

In previous article, we have written tutorial about how to restore specific table(s) from SQL server database. In this article, we will discuss about the