2020-06-05 (first published: 2016-04-29)
215 reads
Editorials
Do You Think About CheckDB?
Running checkdb is part of ensuring your database health and data integrity. Steve notes that you might want to review that you have the best strategy for your organization.
2020-06-04
163 reads
2020-06-03
114 reads
2020-06-02
154 reads
Sabotage at Work
Some of the work habits that might sabotage an organization appear to have been adopted by some of Steve's former employers.
2020-06-01
264 reads
2020-05-30
215 reads
Crack that Encrypted Data
Ransomware is becoming an issue. Steve Jones notes DBAs need to be ready to deal with these issues.
2020-05-29 (first published: 2016-04-19)
253 reads
The Challenges of Working Under Quarantine
It's been nearly two months since the Redgate Software offices closed. I am not normally in the office, but I did cancel a trip that I normally would have taken to touch base with a number of teams. That's a minor change for me, but a still a change. It's much less than the disruption that […]
2020-05-28
129 reads
Jumping Air Gaps
There are all sorts of viruses, worms, and malware out in the world, and some of us have had to deal with them at different points in our career. SQL Slammer was particularly memorable for me, but there were plenty of non data related virus issues I've had to work on at various employers. To […]
2020-05-27
218 reads
Enriching Your Life
As I was looking to build career goals for the new year, I think mostly about technical topics. That makes sense, given my focus and job, but I ran across an interesting thread on Hacker News that asked about skills to work on in 2020, and not necessarily technical ones. I did find it interesting […]
2020-05-26
104 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