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 http://SamuelVanga.com.

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...

2013-03-05

784 reads

Blog Post

Standardize Table Aliases

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

2013-03-05

898 reads

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

By

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

Free Webinar about Columnstore Indexes

By

I’m doing a small series on indexing basics for SQL Server, and on May...

Read the latest Blogs

Forums

BCA KCU MUARA KARANG TLP/WA 08216366654

By ASAPRoofing

Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450

BCA KCP Central Park TLP/WA 08218573837

By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV

Ruko GSA Blok Beufort 08 CB CC CD, RT.9/RW.5, South Tanjung Duren, Grogol petamburan,...

BCA KCU KEDOYA PERMAI TLP/WA 08218573837

By Quay thu XSMN hôm nay - quay thu MN - KETQUA.TV

Ruko Taman Kedoya Permai, Blok A 1A, No No.4-5, RT.11/RW.5, Kb. Jeruk, Kec. Kb....

Visit the forum

Question of the Day

SSoL Support on the OS

On which Linux versions is SQL Server 2025 on Linux supported?

See possible answers