SQL Server DBA Tutorial 181-What are Synonyms & How to Create Synonyms in SQL Server Database

preview_player
Показать описание
This video will walk you through step by step process of creating Synonyms using SQL Server Management studio as well as using T-SQL Script. It also illustrates what is Synonyms in SQL Server and what are the best practices to create Synonyms in SQL Server database. It talks about couple scenarios where it would be good idea to create Synonyms. It also shows how to create Synonyms locally as well as remote Server Synonyms.

Blog post link:
  1. TechBrothersIT
  2. Database (Software Genre)
  3. Synonyms
  4. SQL
  5. Server
  6. Developer
Рекомендации по теме
SQL Server DBA 0:19:52

SQL Server DBA Tutorial 181-What are Synonyms & How to Create Synonyms in SQL Server Database

Tuning Query Cost 0:03:39

Tuning Query Cost 100% - SQL in Sixty Seconds 181

SQL Server DBA 0:18:54

SQL Server DBA Tutorial 183-How To Find out Who Deleted the Login from SQL Server

SQL Server DBA 0:17:50

SQL Server DBA Tutorial 184-How to Find out who has Modified or Created Object in SQL Server

SQL Server DBA 0:09:00

SQL Server DBA Tutorial 160-What are the Best Practices for SQL Server Deployment

Reading SQL: Create 0:00:31

Reading SQL: Create and Remove Synonyms: SQL Tutorial 120

Identify and Filter 0:01:37

Identify and Filter In-Memory Tables - SQL in Sixty Seconds #079

Synonyms in SQL 0:10:34

Synonyms in SQL Server

The Ins and 1:09:41

The Ins and Outs of SQL Server Data Compression - Bob Pusateri

SQL Server DBA 0:09:06

SQL Server DBA Tutorial 131-How to create ActiveX Script Proxy in SQL Server

GroupBy in Microsoft 0:09:35

GroupBy in Microsoft SQL Server and Handling Null Values

How to remove 0:07:53

How to remove key lookup in SQL Server ?

Databases: How to 0:02:43

Databases: How to create a synonym for a column in SQL Server? (2 Solutions!!)

Databases: SQL Server 0:02:26

Databases: SQL Server 2008 and extended properties (5 Solutions!!)

Some of your 0:01:54

Some of your external vendors can not connect to SQL server in intranet, what could be the cause

Error Functions inside 0:14:43

Error Functions inside SQL Server

SQL Server: sys.syscomments, 0:03:00

SQL Server: sys.syscomments, sys.sysobjects and findtext

indexes in sql 0:09:47

indexes in sql server|synonyms

SQL Tutorial 176-Patching/Updating 0:13:36

SQL Tutorial 176-Patching/Updating Availability Group with SQL Server Failover Cluster Instance P3

The complete sequence 0:14:58

The complete sequence for sql server

SQL Server DBA 0:06:15

SQL Server DBA Tutorial 60- How to Provide Explicit Permission to Specific Tables to a User

System Databases in 0:01:14

System Databases in Sql Server 2008R2 / 2012 / 2014 / 2016 /2017

How to Create 0:06:07

How to Create Custom Dashboards and Add Custom Counters in SQL Diagnostic Manager

What is new 0:06:23

What is new in SQL server 2012 that's not available in previous versions of SQL servers

Комментарии
Автор

Thank you so much it really helpful to me.

sag
Автор

whats old is new....

My company was making a big push for nosql/mongo five years ago, but we found that scaling to large complex datasets were very difficult. Some code from 15 years ago using SYNONYMS to handle complex scenarios where different data intakes can be accessed using SYNONYMS.

Just wow...a complex problem, we are talking about 4.3TB of binaries processed daily in under tight time timeframe, all this is complexity is solved by SYNONYMS, wtf?

onewizzard
visit shbcf.ru