Retrieving SQL Server Metadata with Help of T-SQL

Retrieving SQL Server Metadata with Help of T-SQL
4 (80%) 3 votes

This article contains a list of scripts that mine the SQL Server metadata in the various system functions, stored procedures, tables, and catalog views. Metadata queries are really helpful in discovering information for a given database schema. You can copy all the T-SQL scripts that are listed in this article and use for your own purposes. However, please do some tests before apply to a production database.

Read More

Active Directory vs Azure Active Directory

Active Directory vs Azure Active Directory
4 (80%) 3 votes

Active Directory traditionally used to manage elements of a domain-based network. But companies increasingly implement various cloud services that require its own user accounts. A tool for creating and managing user accounts, that are used by different Microsoft cloud services, which a company acquires, is Azure Active Directory. Read More