Jason Shadonix

Practical Uses for Synonyms in SQL Server

The concept of a synonym was introduced in SQL Server 2005. Synonyms are very simple database objects, but have the potential to save a lot of time and work if implemented with a little bit of thought. This article discusses what exactly a synonym is, and a few examples of how to use them.

4.06 (54)

2016-06-24 (first published: )

17,610 reads

Blogs

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

What's New in SQL 2019? at BRSSUG

By

Thanks to everyone who joined the BRSSUG for a night all about SQL Server...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3

By

This is the third post in a series about modern Data Lake Architecture where...

Read the latest Blogs

Forums

Using crypt_gen_random to generate unique Serial Numbers

By iviewtheworldthroughmylens

Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...

OPENQUERY is not inserting identical rows

By Johnny D

Hi, Thanks in advance for any help. I am trying to insert into a...

Azure file copy creating a directory to hold the renamed file

By Irish-Toon

Hi All, I'm pretty new to azure and am hitting the following problem. I've...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers