Lost Data
Steve Jones talks about the loss of data, and how it can impact your life. And why you want to be sure that your restores are ready in the event of a disaster.
2010-07-01
148 reads
Editorial
On Being the 2009 Exceptional DBA
A guest editorial from Josef Richberg, winner of the Exceptional DBA contests in 2009.
2010-06-30
264 reads
The Breakfast Plan Goes Awry
A simple motivational plan goes sideways in this guest editorial from Andy Warren.
2010-06-29
198 reads
Kudos to the Community
Steve Jones takes a day to thank everyone that donates their time to help others in the community.
2010-06-28
81 reads
The Great Forum Debate
Phil discusses the pros and cons of the traditional versus stack overflow-style model for forum debate, and wonders whether there is a database model that would support all these different forms of discussion, or cooperative work, so that we can simply fit the 'visualization' to the nature of the particular discussion.
2010-06-28
99 reads
The Phantom DBA
This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?
2010-06-25
312 reads
Dinosaur Databases
Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.
2010-06-24
420 reads
We Still Need Human Judgment
Computers aren't necessarily more infallible than humans, and they aren't necessarily even going to make better decisions. We still need humans in the decision process.
2014-12-08 (first published: 2010-06-23)
196 reads
The Schema Debate
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
2010-06-22
640 reads
Moving to the Cloud
There has been a lot of talk about moving to cloud based computing, and cloud based services. Steve Jones comments on what this might mean today.
2010-06-21
314 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Daily aggregation of Azure Blob Storage by tier (created/tier-change/deleted)
Hello all, I’m looking for advice on how to derive a daily snapshot table...
SQL 2017 to SQL 2025. Good to Go ?
We need to replace our Windows server running SQL 2017. Any reason not to...
Question of the Day
Using OPENJSON
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers