Improving DevOps Automation
Steve notes that his employer is re-evaluating their build and release process, in a true DevOps fashion to improve the way they build software.
2021-07-14
135 reads
Editorials
Enterprise Software
Building software in an enterprise is hard, and often, large organizations don't quite know how to do it.
2021-07-12
477 reads
Do We Need to Learn Linux?
An announcement on Windows containers has Steve noting that Linux might be a more desired skill in the future for SQL Server professionals.
2021-07-10
204 reads
Fixing Report Visuals
Building reports and visualizations isn't as simple as we would like. Learning a bit about how to better design them is important.
2021-07-09
147 reads
How Do You Decide to Rollback?
One of the constant questions I get from Redgate customers is about rolling back database changes. We build software to help you deploy changes, but what about rollbacks? I think I've heard this in almost every conversation I've had on this topic in the last 5 years. It's one reason that Flyway has undo, though […]
2021-07-07
453 reads
The Second Half of 2021
July is starting, and with it we move to the second half of 2021, or H2 2021 for those of you that like the planning shorthand on roadmaps and project manager boards. The first half of 2021 has felt like a big of progress in the world, as we try to recover from the pandemic […]
2021-07-05
115 reads
Happy Birthday USA!
This is the Fourth of July weekend here in the US when we celebrate the birth of the country based on the publication of the Declaration of Independence. For those who don't know, this celebration mostly consists of fireworks and outdoor cookouts. However, at our house we've always tried to do a little bit more […]
2021-07-03
128 reads
Learning Intentionally with a List
We're coming up on the middle of the year, and I wonder if you are improving your career this year? Did you make plans and are you sticking to them? I've been tracking progress on my goals, and so far mediocre progress. It's tough to learn, but even tougher to learn when you don't have […]
2021-07-02
139 reads
Patching Challenges
Having a patching strategy for your systems is important, and Steve notes that you ought to be organized and allow for some flexibility when designing one.
2021-06-30
346 reads
Where Does NoSQL work well?
NoSQL was hyped as the way to replace your RDBMS and achieve incredible performance at scale. It does work well, but it hasn't replaced most RDBMSes. Steve has a few thoughts on this topic.
2021-06-28
243 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers