What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

The method you'll use to identify the slowly running queries will depend on the version of SQL Server you're using. If you're using SQL Server 2008 R2 through SQL Server 2014, you have the option ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

Is it possible to use linked services in MSSQL Server and execute queries if the Distributed Transaction Coordinator is not enabled?Maybe this should be in the NT forum, but I thought writing ...

When SQL Server 2014 debuted, you didn't have a lot of options for how to fix the queries that slowed down under the new CE -- you had the big hammer of not using it, or hinting queries to try to ...