I recently started full time learning of Amazon Web Services (AWS). I found that AWS's Relational Database Service
(RDS) is really user-friendly. RDS simplifies many of the
complicated aspects of...
2024-05-06 (first published: 2024-04-20)
50 reads
If you've ever wrestled with complex SQL code, you know the drill. Hours spent on a single query, eyes glazing over at the endless lines of commands, that sinking...
2024-05-06 (first published: 2024-04-19)
337 reads
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft Learn Docs article at the recommendation of my colleague Randolph West, who guessed (accurately) I...
2024-05-04 (first published: 2024-05-03)
15 reads
As a SQL DBA, what do you do when a vendor application has performance problems that are code related? Server settings don’t generally seem to be an issue. Queries...
2024-05-03 (first published: 2024-05-02)
17 reads
I posted on Terraform and Azure SQL last year but wanted to see what Bicep could do this year. I’m going to test Bicep out with Elastic Jobs. TL;DR—My...
2024-05-03 (first published: 2024-05-02)
6 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came up. I mentioned an F2 is only around €250 a month, but a colleague...
2024-05-03 (first published: 2024-04-17)
149 reads
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You get an option to load sample data when you create a new pipeline in...
2024-05-03 (first published: 2024-05-02)
26 reads