Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.

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.

How to Open a Microsoft SQL Server .Bak File. You can save a backup of your MS SQL databases to a single file on your hard drive. These backup files have names ending with the ".bak" file ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

Microsoft today released the 2022 version of its SQL Server database, which features a number of built-in connections to its Azure cloud.

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

Microsoft's SQL Server 2014 has built-in in-memory technologies, so users don't need expensive additional software or hardware. Plus, it's fast.

Microsoft introduced a new service into its 'intelligent edge' portfolio at the recent Build conference. Here's how Azure SQL Database Edge will fit into the company's broader vision for a more ...