How to use a database to find nearby locations. The geography data type and associated SQL Server functions can be used to calculate distances and search for nearby locations.

Change tracking captures rows in a table that have been changed, but do not capture the data that was changed.

Microsoft SQL Server Compact Edition is an embedded database system that allows us to integrate it in our Web, Desktop and Mobile applications.

In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.

In SQL Server 2005 and later versions of it, database objects such as functions, Stored Procedures, etc. can be created which are already created in CLR.

In the article, I will cover how to use table variable techniques in order to simulate the autonomous transaction behavior of Oracle databases in Microsoft SQL Server.

In this article, I will explain steps need to send emails from SQL Server.

Extended Properties in SQL Server allows us to create additional customized properties to store additional information. Extended Properties are a way to create a self-documenting database.

This article explains how to convert one type of data into another then again repeat the procedure for converting that type of data into another form.

This article explains database tracking in SQL using TFS.

In this article, I describe Views in SQL Server. Views are database objects which are like virtual tables that have no physical storage and contains data from one table or multiple tables.

In this article you will learn how to make Equated Monthly Installments (EMIs) for a loan in SQL Server.

In this article I provide a quick overview of how to use the right and left functions in SQL Server.

This article demonstrates how to create SSRS report. This article begins with the SSRS Introduction, Use of SSRS and step by step creation of report.

In this post I would like to share something regarding Entity Framework, how we can implement CRUD operations using stored procedures in Entity Framework.

SQL REPLACE function inserts or replaces values of records in a database table. This article will teach you how to use a Replace in SQL.

SQL Server Compact Edition (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

In this article I will explain reading XML data from XML String \ XML File through SQL Stored Procedure.

Here I am going to discuss deleting files using SQL Job.

In this article, I will discuss some useful T-SQL query performance tips and tricks for SQL server developers.