Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULLImage taken from 9gag.com

According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...

MSSQLTips.com Rookie of the year 2018

You need a lot of hard work for success!2018 was a good year for me in a lot of areas...

MSSQLTips.com Rookie of the year 2018

You need a lot of hard work for success!
2018 was a good year for me in a lot of areas of my life both personal and professional (the birth...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easily

Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...

Enable Machine Learning Services on SQL Server

R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform...

Enable Machine Learning Services on SQL Server

R Services (SQL Server 2016) or Machine Learning Services (2017 and 2019 CTP) provide you with the ability to perform data analysis from the database itself using T-SQL.You can...