Samuel Vanga

Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at

Blog Post

Standardize Table Aliases

What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT    a.[BusinessEntityID]    , b.[FirstName]    , b.[LastName]FROM[HumanResources].[Employee] a    INNER JOIN [Person].[Person] b    ON...


772 reads

Blog Post

Standardize Table Aliases

What’s wrong with the following code?
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...


886 reads


Azure Cosmos DB introduction


Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...

Display dates between two input dates using SQL DATEDIFF function in SQL Server


SQL Server has a very useful function called DATEDIFF. This function is used to...

Checking if a database has a master key–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs


Static data masking is not showing in 18.0 above

By sqlfriend

I read this article trying to understand the feature of data masking in SQL...

QQ regarding DB_ID()

By YSLGuru

What actions aside from deleting and restoring from backup, would cause the value of...

Restore autmomation

By ramyours2003

i need to  create sql job  which perform automate restore of the databases  with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers