The Challenges of Resetting Databases
The challenges of state in databases can impact our development efforts.
2020-08-31
98 reads
Editorials
Learning Isn’t Easy, But It’s Vital
This week Grant notes that we need to work on our learning skills, especially as the world continues to drive forward.
2020-08-29
203 reads
Delivering in a Day
This week Steve wonders if you're want to tackle an exciting project for a day or a week.
2020-08-28
95 reads
Microservices
Steve doesn't think microservices work with relational databases, but maybe you can convince him otherwise.
2020-08-27
273 reads
Better Government Security Through DevOps
DevOps can help provide better security for your databases.
2020-08-26
85 reads
Data Analysis Without a Server
The ability to analyze lots of data on a workstation can be a way to test things without overloading server systems until you are sure your code works.
2020-08-25
133 reads
Looking Back at Software Development Trends
Steve looks at some of the software development trends from last year, and if they apply today.
2020-08-24
202 reads
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
2020-08-22
370 reads
What's the Bus Factor?
Today Steve asks about the people that might be critical in your organization.
2020-08-21
159 reads
Admin Challenges Across Scale and Time
The challenges of large scale administration can be complex, but the more we share, the more we help others learn and better manage systems.
2020-08-20
85 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