Just What IS it That You Do?
This is a question that I get asked all the time. It’s fair enough, really. The most common assumption for people outside the field seems to be that that...
2019-05-06
Career Growth
How can we close the tech skills gap?
One of the most profound challenges faced by technology companies today is talent. According to the latest Harvey Nash survey, 65% of CIOs believe that a shortage of tech skills is affecting their ability to respond to change.
2019-05-03
The Space Between
Andy Leonard on finding the time to keep up with learning and avoiding time sinks.
2019-05-02
The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
2019-04-25
303 reads
How the Company-Startup Thing Worked Out For Me, Year 7
It’s time for my annual update on the wild ride. If you want to catch up, check out past posts in the Brent Ozar Unlimited tag. This post covers...
2019-04-09
You're not really that good at SQL Server
Steve reminds some people that there are reasons to continue to improve your skills.
2019-04-08
1,828 reads
2017-06-16
2,574 reads
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
127 reads
Beginner, Expert, or Both?
It can be easy to start learning about a topic, think you've mastered it, and become complacent. Steve Jones notes that an expert beginner might be what you are, but it's not necessarily what you want to be.
2013-10-07
413 reads
15 Quick Short Interview Questions Useful When Hiring SQL Developers
Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.)
2014-12-25 (first published: 2013-02-28)
15,676 reads
Blogs
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
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...
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