Avoiding the transaction

Database Modeling - Relationships

A proper relationship between two people, places or things improves the communication between them. In every real-world based application, this logic holds and a database is no different. This article discusses the different relationship types possible between database objects. The designing of these relationships between them is called modeling, and the three types of relationships […]

Compare Artificial Intelligence Models Built with T-SQL

This tip looks at using artificial intelligence models with SQL Server to predict outcomes.

The Binary Cast

Getting Subtotals

SSIS Variable and Parameter Analysis

Use T-SQL to analyse the usage of all variables and parameters in an SSIS project, including the identification of any unused variables and parameters.

The Last Sequence

Banker’s Rounding. What is it good for?

An in depth look at the implications of using Banker's Rounding.

Getting the default Datefirst

The Order of Operations