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 ...

Figure 1. Get started by running SQL's version of PowerShell. Let's start off with looking at the SQL Server services running on a given machine. Use the Get-Service cmdlet to find out about services ...

Arthur Fuller responds to a reader who sent him a question recently asking how to display currency amounts in currency format. Check out the solution he offers for the reader's problem.