geohernandez - Journey of a Database Engineer and Data Engineer apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
  • EnglishEnglish
    • EnglishEnglish
    • EspañolEspañol
ABOUT
CONTACT ME
WORK WITH GEO
    Data Specialist
    Speaker Events
    Resume
English
    English
    Español
geohernandez - Journey of a Database Engineer and Data Engineer apprentice
  • ABOUT
  • CONTACT ME
  • WORK WITH GEO
    • Data Specialist
    • Speaker Events
    • Resume
  • EnglishEnglish
    • EnglishEnglish
    • EspañolEspañol
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

  • Database Migration Service – We do not have sufficient capacity for the requested VM size in this region
  • Setting up an Azure SQL Managed Instance
  • Book Review – How to speak so people really listen

Categories

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

Archives

  • March 2022 (1)
  • September 2021 (1)
  • May 2021 (1)
  • March 2021 (1)
  • February 2021 (3)
  • 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)

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