It's easy to set up. A standby database is easy to maintain and troubleshoot. It can be used for reporting purposes and configured for log shipping in one or more servers, for instance.

To synchronize the database Sql Server the log shipping is used. It is easy to set up, maintain and troubleshoot. It is the process of backing up your database and restoring these backups to anothe...

Views are very important and useful features of SQL Server. Let's learn what views are exactly and how to use them in SQL.

This article demonstrates how to use a full-text catalog and full-text search in SQL Server.

In this article, we have a look at how to enable line numbers in the SQL Server Query Window.

This article shows how we can determine the size of an entire database using C# and the size of each and every table in the database using a single SQL command.

In the last article I showed how we can implement CRUD operations using Entity Framework using SQL database, now I would like to show you how we can implement the same using MySql database.

In this article, you will learn how to use a SQL Between statement in SQL

In this article, you will learn how to use Cast and Convert statement in SQL.

This article will help you to learn about SELECT statements in SQL.

Before comparing the performance of SQLCLR and TSQL, just have a quick at the definition of SQLCLR.

In this article, I will explain how to merge multiple rows into a single row using SQL 2005.

In this article, we will discuss Service Master Key, backup, restore and alter Service Master Key.

SQL Server 2008 introduced Filtered Index. It is nothing but an optimized non-clustered index.

Learn about the SQL SELECT DISTINCT statement and its uses for retrieving unique data in SQL. Get expert insights on how to implement select distinct SQL queries

In this article, we will learn how to validate a numeric parameter value. In the previous article, you saw how to validate a date parameter SSRS parameter validation using custom code.

In this article I'll show you how to search a column value in all the referencing tables.

In this article, you will learn some basics about Compound Operators of SQL Server.

In this article you will learn about Join statements of SQL server.

In this article, I am explaining, with a sample demo, storing Session State in a local or remote SQL Server.