Submit
Ask
Start Free Trial
Log In
Submit
Start Free Trial
Log In
Ask
Start Free Trial
Featured
Programming
DevOps
Virtualization
Databases
Security
OS
Microsoft
Networking
Web Dev
Cloud
Mobile
Multimedia
Productivity
...
We help IT Professionals succeed at work.
GET ACCESS
SEE HOW IT WORKS
Experts Exchange
>
Videos
> Getting Server / Database / Connection Information via T-SQL (SQL Server)
Facebook
Twitter
LinkedIn
Link
URL copied to clipboard
<
Getting Server / Database / Connection Information via T-SQL (SQL Server)
Posted on
2014-08-14
Microsoft SQL Server
3,923 Points
1 Comment
723 Views
2 Endorsements
Last Modified:
2014-08-26
Published
Experience Level: Beginner
Your browser does not support the video element.
5:18
Steve Wales
Follow
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
2
Author:
Steve Wales
1 Participant
Jim Horn
LVL 69
Microsoft SQL Server
42
1 Comment
LVL 69
Overall:
Level
69
Microsoft SQL Server
42
Message
Active today
Comment
by:
Jim Horn
2015-07-31
Nice job. Voted Yes.
0
Suggested Videos
Title
Views
Activity
Query data with no SQL code (1)
47
2024-01-11
Query data with no SQL code (4)
27
2023-12-28
Query data with no SQL code (5)
20
2023-06-21
Query data with no SQL code (6)
24
2023-06-21
Unpivotting by CROSS APPLY and VALUES
Article by:
PortletPaul
Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
Microsoft SQL Server
How to load JSON's data into SQL Server in different ways
Article by:
Ryan Chong
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.
Node.js
Powershell
Java
C#
PHP
Microsoft SQL Server, Python, JSON, Golang, SSIS
Other videos by this author
Basic Housekeeping for SQL Server
(5:10)
Query Current Session Information via SQL
(5:00)
How to Extract Information from the Oracle Data Dictionary Views
(5:19)
Suggested Courses
Network+ Exam N10-006
Microsoft SQL Server and Database Concepts
Practical Implementation of How to Filter routes from the Routers
Next Video:
SQL - Creating a Table
Keep in touch with Experts Exchange
Tech news and trends delivered to your inbox every month