SQL Window Functions Series: LAG() and LEAD()
Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.
2023-12-11
6,775 reads
DateDiff
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
2022-07-13
29,192 reads
2021-02-04
724 reads
2020-02-27
23,014 reads
Work around for calculating age using the SQL Server DateDiff function
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
2012-05-23
4,752 reads
Blogs
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Forums
Counting Bits
Comments posted to this topic are about the item Counting Bits
Can You Become a More Productive Engineer?
Comments posted to this topic are about the item Can You Become a More...
Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL
Comments posted to this topic are about the item Boosting Data Accuracy: Resolving Common...
Question of the Day
Counting Bits
What does the BIT_COUNT function do in SQL Server?
See possible answers