How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!)
Here's why you should NEVER use the FORMAT() function in SQL Server.
2022-08-05
20,168 reads
Datetime conversions
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
28,653 reads
Convert GMT/UTC to Local datetime
International Applications require timezone handling for different users Here is how to do this with SQL.
2009-05-06
3,604 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
DTEXEC Not working for my project: Cannot create a task from XML for task
I recently created an SSIS package and then converted it to a Package Deployment...
Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?
Hi all, So here's the situation. We migrated to a new server as our...
2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847
Tables have identical structure but different indexes (except) PK and different stats. all...