A First Look at Redgate’s Subsetter
I have been a proponent of subsetting databases in dev/test for a long time. It took awhile, but as part of the Test Data Manager that Redgate launched at...
2024-03-11 (first published: 2024-02-28)
317 reads
Blog Posts
Azure SQL MI License free?
A common setup when leveraging the cloud is to use the cloud for Disaster recovery (DR) purposes, some say it becomes a logical extension of your on-prem / data...
2024-03-11 (first published: 2024-02-27)
444 reads
10 reasons why IT certifications are still important
As someone who has spent over 20 years in the Software/Data Engineering area and has obtained numerous certifications, I can confidently say that certifications are still a valuable asset...
2024-03-08 (first published: 2024-02-23)
446 reads
A New Word, err Phrase: loss of backing
loss of backing– n. an abrupt collapse of trust in yourself – having abandoned a resolution, surrendered to your demons, or squandered an opportunity you swore you’d take seriously...
2024-03-08
27 reads
SQLpassion Live Training about running SQL Server in Microsoft Azure
From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft...
2024-03-08 (first published: 2024-03-04)
325 reads
Book Review: My Effin Life
This is very off topic, but I’ve been a fan of Rush since I was about 12 years old. Their Moving Pictures This is a few thoughts on Geddy...
2024-03-06
141 reads
Foreign Keys in SQL Data Generator
A customer recently asked about using FKs in SQL Data Generator, and I decided to write a short post showing how these work. The Scenario I’ve got a copy...
2024-03-06 (first published: 2024-02-26)
327 reads
How Redgate’s Test Data Manager Can Enhance Automated Testing
A brief overview of the benefits and challenges of automated testing and how Redgate’s Test Data Manager can help. Automated testing uses software tools to execute predefined tests on...
2024-03-06 (first published: 2024-02-26)
160 reads
Adding Git LFS Support – #SQLNewBlogger
I got this message recently while committing some changes: This post shows my work in adding Git LFS support to GitHub. Another post for me that is simple and...
2024-03-04 (first published: 2024-02-21)
179 reads
Know Thy Platform
IT and data professionals, I implore you – know thy platform. All of it. Not just the layer your job is tasked with. Modern public cloud (or any infrastructure...
2024-03-04 (first published: 2024-02-22)
219 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