Halfway Through 2011
Steve Jones stops halfway through the year to look over the things that he ought to be doing to better manage systems as a DBA and reminds you to do the same.
2011-07-11
81 reads
Editorials
Lesson #6: What CIOs really care about
This editorial was originally published on Dec 30, 2005. Steve is traveling to the UK this week and we are reprinting editorials.
2011-07-11
121 reads
Self-aware Instances
For this Friday's poll, Steve Jones talks about a fundamental architectural decision for your software. Do you want central control or a series of distributed processes, each one self-aware, and able to act on its own.
2011-07-08
88 reads
Measurements
"If you cannot measure something, you cannot improve it." - Lord Kelvin. That quote and a blog about it inspired today's editorial.
2011-07-07
164 reads
We Need a DBA Boot Camp
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
2011-07-06
243 reads
How Much Is It Worth?
This editorial was originally published on Nov 21, 2005. It is being re-run today as Steve is on holiday. How much money is it worth to compromise your ethics? Steve Jones asks today as many companies around the world seem to be doing that.
2011-07-05
128 reads
Cloud Barriers
I'd like to hear the thoughts of DBAs out there on Windows and SQL Azure, and the prospects of moving applications and databases into the clouds. How many DBAs work for companies that have done it or are seriously considering it? What are the deepest concerns?
2011-07-04
92 reads
Independence Day 2011
A holiday in the US has most people away from work. Steve Jones leaves you a few thoughts and humor from his vacation.
2011-07-04
85 reads
Sabbaticals
This editorial was originally published on Oct 25, 2005. Steve Jones talks about the idea of a sabbatical from work and the problems that might ensue if you haven't properly planned it.
2011-07-01
95 reads
A Little Interviewing Advice
This editorial was originally published on October 20, 2005. It is being reprinted as Steve is on vacation. I know there was a great uproar over the interview piece at the beginning of this week and I received lots of opinions on various parts of the article, good and bad to go over. But one […]
2011-06-30
337 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers