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
31,123 reads
Calendar Table
Create Calendar Table Using Power Query M Language
Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.
2021-03-03
Time Slots - An Essential Extension to Calendar Tables
After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.
2015-05-05
7,291 reads
Blogs
SQL Saturday NYC Recap 2025
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
Why Data Silos Hurt Your Business Performance
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Forums
Problem creating a Linked Server to MS Access 97 database from SQL Server 2019
Hi there I need help on creating a Linked Server to an MS Access...
SSPI handshake failed error code 0x80090311
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Need query help - MAX record
Hello - I have attached a Word document here with details about my issue....
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers