<

Getting Server / Database / Connection Information via T-SQL (SQL Server)

Posted on
3,923 Points
723 Views
2 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:18
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
2
Author:Steve Wales
1 Comment
LVL 69

Comment

by:Jim Horn
Nice job.  Voted Yes.
0

Suggested Videos

Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways. For this article, I'm going to demonstrate some of the popular ways of importing JSON data into MS SQL Server.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month