Название: SQL Server Metadata Succinctly
Автор: Joseph D. Booth
Издательство: Syncfusion, Inc.
Год: 2019
Язык: английский
Формат: pdf (true), rtf, epub
Размер: 10.1 MB

SQL Server is a very complex and powerful product, but it provides tremendous amounts of data about itself. You can use this metadata to improve your database design, increase performance, review security, and more. Joseph D. Booth will show readers sample scripts and queries using information schema views as well as SQL Server-specific views in SQL Server Metadata Succinctly.

Microsoft SQL Server (and other SQL systems) also provide a large amount of data about their servers, users, tables, and stored procedures. In this book, we are going to explore that metadata and provide example scripts and queries to learn a lot of information about your SQL environment.

In this book, we will start with the information schema views and provide some handy queries about the server's data tables. We will then explore some of the views that are unique to Microsoft and provide very useful information about SQL Server.

Table of contents:

Introduction
Information Schema
Server Information
Database Properties
Tables and Columns
Performance
Security