Dealing with the Bits of a Binary Value in SQL ...
How you used to do it For example, say you want to find all the read-write database […]
T-SQL Programming
Converting Data Across Time Zones: An In-Depth Primer
If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t […]
The Basics of Deleting Data from a SQL Server Table
Greg Larsen’s series on Learning T-SQL so far: The basic T-SQL Select Statement Ordering a result set […]
The Basics of Updating Data in a SQL Server Table
Entry in Greg Larsen’s series on Learning T-SQL. The series so far: The basic T-SQL Select Statement […]
Summarizing data using GROUP BY and HAVING clauses
SQL Server provides the GROUP BY clause as a means to take a set of detailed values […]
What is interpolation?
Interpolation is a mathematical technique which was popular before we had a lot of cheap computing power. […]
Dynamic Data Unmasking
Dynamic data masking is a SQL Server 2016 feature to mask sensitive data at the column level […]