2024-08-02
470 reads
Date Functions
2024-07-08
434 reads
2024-07-03
119 reads
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,562 reads
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
2021-09-22
3,344 reads
2021-06-28
708 reads
Blogs
Creating a GitHub Actions Self-Hosted Runner
By Steve Jones
I had to demo the Flyway Autopilot system recently and created a GitHub Actions...
Migrating from Azure PG Single Server to Flex with Azure VM and pg_dump/restore
This is more complicated than using the Azure Migration method, but because it’s maxed...
PowerShell (and T-SQL) and Elastic Jobs
I’ve covered how to create Elastic Jobs in the portal (this one is important...
Forums
Contracting DBA - Permissions for initial analysis
Accidental DBA here. After looking at all the work that needs to be done,...
How to convert run_date and run_time columns to datetime from SQL Agent systable
Hello SSC, Hope you are all having a great Monday! I am trying to...
SQL Server Reporting Services 2022 Permissions Issue
I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report...
Question of the Day
AG Rules for Databases
Which of these is not a requirement for a database to be added to an Availability Group (AG)?
See possible answers