Скачать или смотреть Object Dependencies in SQL Server 2008

Get our course - Essential SQL Server Administration Tips (with discount) - https://www.sqlnethub.com/go/course-e...

learn everything you need to get started with SQL Server. Via a 2.5-hour journey with a combination of lectures, live demonstrations, quizzes and a practice test, you will get started with one of the world’s leading RDBMSs, that is SQL Server.

The online course containts the below sections and lectures/demos:

Basic Database Principles
-- Relational Database Management Systems
-- Databases, Tables, Queries and Programmability Objects
-- T-SQL vs SQL: What’s the Difference?

SQL Server Data Platform
-- What can you do with SQL Server?
-- Main SQL Server Services
-- Supported Operating Systems
-- Installing SQL Server

SQL Server Management Studio
-- What is SQL Server Management Studio?
-- Downloading and Installing SQL Server Management Studio
-- Connecting to the Database Engine and Navigating Through Database Objects
-- Creating a Database and Other Objects
-- Running Queries and Scripting to T-SQL
-- Importing and Exporting Data

SQL Server Security
-- Logins and Database Users
-- Surface Area Configuration

Azure Data Studio
-- What is Azure Data Studio?
-- Downloading and Installing Azure Data Studio
-- Working with SQL Server using Azure Data Studio

Special Topics
-- About Special Topics
-- Special Topic: Create Sample Database for Special Topics Demos
-- Special Topic: Import Data Using the OPENROWSET Function
-- Special Topic: Import & Export Data Using SQL Server Integration Services (SSIS)
-- Benefits of Primary Keys in Database Tables
-- The Importance of Database Indexes
-- Difference Between SQL and SQL Server

Wrap-Up
-- What we've Learned in this Course

Get our course - Essential SQL Server Administration Tips (with discount) - https://www.sqlnethub.com/go/course-e...

--
SQL Server 2008 introduced among other new features and enhancements for accurately tracking Object Dependencies.

This is very useful especially in cases where the user wishes to programmatically modify database objects having dependencies and therefore, he/she needs to resolve these dependencies before being able to proceed with the database object modification.

For efficiently tracking dependencies in SQL Server 2008, a new System View (sys.sql_expression_dependencies) and two Dynamic Management Functions (DMFs - sys.dm_sql_referenced_entities, sys.dm_sql_referencing_entities) are introduced.

© 2008-2019 Artemakis Artemiou, SQLNetHub
All rights reserved.