Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

While Dapper provides excellent support for performing CRUD (create, read, update, delete) operations efficiently, it does not have built-in support for bulk operations (i.e., bulk insert, bulk update ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

NoSQL databases arose in response to the limitations of using SQL (Structured Query Language) for database queries. NoSQL databases store and manage data in ways that enable high operational speed and ...

Several years ago I documented Windows updates that needed additional registry keys to be set before you are fully patched. These updates can be hard to keep track of. Microsoft recently released ...

This paper aims to establish a relative study between a relational Microsoft SQL Server database and a non-relational MongoDB database within the unstructured representation of data in JSON format.

Development hiring managers and potential interviewees may find these open-ended SQL Server proficiency interview Q&As useful. The first installment of this TechRepublic series focused on C# developer ...

Theft of private information is a significant problem for online applications. For example, a recent investigation found that at least eight million people’s medical records were stolen as a result of ...

Use the Microsoft Sync Framework to synchronize data changes between SQL Server 2008 Standard, SQL Server 2008 Express and SQL Server Compact Edition 3.5. Despite the availability of wireless and ...