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
Career Growth
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,824 reads
2017-06-16
2,565 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
126 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
411 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,659 reads
Interviewing Tips for a Database Position
Interviewing for a database position is a careful game of give and take. Knowing what to expect and how to prepare for your interview is important, but it's only half the battle. You'll also need to ask questions to see if the job, and the company, is a good fit for you.
2013-02-08
5,440 reads
Free eBook: SQL Server Tacklebox
Get a free ebook from Rodney Landrum and Red Gate Software that helps you prepare to deal with the various crisis situations you might encounter with SQL Server.
2013-01-11
4,793 reads
The Technical Nuances of Technical Writing
A helpful guide to writing technical papers by focusing on the non-technical elements.
2012-10-18
5,400 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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