geohernandez - Journey of a Database Engineer and Data Engineer apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
ABOUT
CONTACT ME
WORK WITH GEO
    Data Specialist
    Speaker Events
    Resume
geohernandez - Journey of a Database Engineer and Data Engineer apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
Chronicles from the trenches•T-SQL

Dealing with errors for SQL_Variant datatype in MS SQL Server

September 15, 2018 by geohernandez 2 Comments

I have to confess; I have had traumatic experiences with variant data type in my beginning as a software developer, in fact, I always have believed that it is an anti-pattern, at least in the OOP world, on the other hand in the Database world it gains much relevance, Why? Because of every column inside a table is supposed to be a specific datatype, otherwise, it could create a great number of conflicts and uncomfortable situations.

Continue reading
Share:

Search for articles

Recent Posts

  • Python Lambda and Regex – A good team for replacing a string using dictionaries
  • Configuring a Cassandra cluster on Azure – Part III
  • Configuring a Cassandra cluster on Azure – Part II

Categories

  • Azure (3)
  • Azure DevOps (2)
  • Bash script (1)
  • Blog (1)
  • Cassandra (3)
  • Chronicles from the trenches (15)
  • Data Engineering (2)
  • DB optimization (2)
  • Events (2)
  • GIT (1)
  • Python (2)
  • SQL Saturday (1)
  • SSIS (2)
  • T-SQL (4)

Archives

  • December 2020 (1)
  • October 2020 (3)
  • September 2020 (1)
  • August 2020 (1)
  • January 2020 (1)
  • August 2019 (1)
  • July 2019 (1)
  • June 2019 (1)
  • May 2019 (1)
  • April 2019 (1)
  • March 2019 (1)
  • November 2018 (3)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)

© 2020 copyright Geo Hernandez // All rights reserved
Step by Step