Find SQL Server Integer Columns to Make Skinnier

Find SQL Server Integer Columns to Make Skinnier

In this tip, you'll see the metadata queries that will make it possible to discover which integer-based columns could be made smaller (without any loss of data).

Simplify Date Period Calculations in SQL Server

Simplify Date Period Calculations in SQL Server

See how you can use new functions like DATEFROMPARTS to simplify otherwise really cryptic methods to obtain key dates (like the first day of the current month).

PASS Summit : I'm One of the Official Bloggers!

PASS Summit : I'm One of the Official Bloggers!

Aaron Bertrand announces that he is among the handful of community members in the inaugural group of official bloggers at PASS Summit 2019.