Adding images to and removing them from a SQL Server database is straightforward using simple drag-and-drop procedures.

Take advantage of the open source library Serilog to log your ASP.NET Core application’s data to SQL Server or another database target.

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.

Applications that use the Jakarta Persistence API shouldn’t embed too much raw SQL in their code. However, when you need an SQL query for performance reasons or to access the database in a way that ...

SQL Server guru Denny Cherry uses 'horrible' stories about SQL Server disasters in a positive way: to teach others what not to do -- and what to do in case they do things they shouldn't have done.