Reading Time: 9 minutes If you want to get into the fields of database development, database administration or data science, there is one skill you should have that will give you an advantage and make it easier to learn the tools necessary to do your job. This is a skill most database professionals already Continue Reading
Data Types
CAST and CONVERT: A How-To Guide
Reading Time: 9 minutes Two of the most common system functions you will see as a database developer are the CAST and CONVERT functions. These two functions perform in a similar way, with only slight differences between the two. The one you use will depend on your needs at the time. CAST and CONVERT Continue Reading
SQL Server NULL: Are you making these 7 mistakes?
Reading Time: 11 minutes A proper understanding of NULL is absolutely essential for writing accurate queries that return accurate results. When you are first starting out with SQL Server, you might have these assumptions about NULL that are not quite right, or maybe flat out WRONG. If you misunderstand how SQL treats NULL, you Continue Reading
SQL Server character data types (and the differences between them)
Reading Time: 8 minutes When I was first learning how to query and develop databases using T-SQL, I would find myself confused between the different character (aka string) data types available to us. I would ask myself questions like: “What’s the difference between CHAR and VARCHAR?“ Or maybe: “What’s the difference between CHAR and Continue Reading