Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.

Nested Schemas

Creating schemas

Capture CREATE, DROP, ALTER from the default SQL trace file

Tracks and stores changes to database objects by reading from the default SQL server trace file using ::fn_trace_gettable()

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.

SQL Monitor Custom Metric: Schema Modified

This metric creates an alert that will be raised when something is added to the schema, or the existing schema is modified.

Default schema

Divide and Conquer

Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.

Schema & Renaming Fun

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database