A New Word: mcfeely
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are trite or obvious or being broadcast blindly to the masses. I get mcfeely all the...
2024-05-03
14 reads
Blog Posts
Check your regions people
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)
199 reads
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break into this field or climb the DBA career ladder, mastering SQL is absolutely crucial. Let's...
2024-05-03
375 reads
Using Git Prune–#SQLNewBlogger
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated a lot of branches. Even though I’m a solo developer, I decided to use branches,...
2024-05-03 (first published: 2024-04-17)
208 reads
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill.
To check my progress I needed to...
2024-05-02
203 reads
6 Best SQL Training Courses for Beginners (2024 Updated)
We all know that choosing the right basic SQL training is absolutely crucial if you want your SQL journey to be a success story, especially when you're starting from...
2024-05-01 (first published: 2024-04-30)
243 reads
SQL Database Administration: Not For Everyone (But Maybe It’s for You)
Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you...
2024-05-01 (first published: 2024-04-17)
700 reads
Test Data Management – 2024 is your year to do it
This blog post is about Test Data Management – or my take on it. I just saw that a video I did for my good mates at Redgate is...
2024-05-01 (first published: 2024-04-30)
85 reads
Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module
Full documentation on the Undercover Catalogue can be found HERE It’s been a while since the Undercover Catalogue last received an update but having had a few of those...
2024-05-01 (first published: 2024-04-16)
282 reads
Upcoming speaking events in May (Australia)
Are you looking to boost your skills and knowledge in Database DevOps, learn how to transition to the cloud, and work across multiple databases? Join me and fellow speakers/experts...
2024-05-01
17 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers