2016-10-13
1,245 reads
T-SQL
Bones of SQL - Practical Calendar Queries
After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.
2020-05-15 (first published: 2016-10-13)
8,161 reads
2016-10-11
1,381 reads
Calculate two internships
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2019-10-04 (first published: 2016-10-03)
487 reads
2019-10-04 (first published: 2016-10-03)
851 reads
2016-09-28
1,330 reads
2016-09-22
1,320 reads
SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
23,918 reads
2016-10-04 (first published: 2016-09-19)
440 reads
2016-09-15
1,232 reads
Blogs
Friday Flyway Tips: Chaining Commands for State-based Deployments
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Forums
I need help accessing my local SQLExpress
My PC has been causing me problems for months. I've told my desktop support...
MDX SSAS Calculated measure for last totals + turnovers
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers