Your database may get damaged due to several reasons. A backup will help you to restore the database lost in case of disasters and problems, like hardware failure, virus attack, or others. How To ...

Prerequisites SQL Server 2005 or later Visual Studio 2013 If using SQL Server 2014, make sure you have applied the SSDT updates. These can be found in Visual Studio’s Updates and Extensions menu.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Untangle SQL Server connection strings Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools.

In SQL Server 2014, Microsoft is introducing the In-Memory OLTP database engine which essentially performs the entire I/O operation set against selected tables straight from memory.