Drive
What motivates people? What makes them happy at their jobs? Steve Jones talks about Drive, the book by Dan Pink, and the possibility that people actually like doing their jobs and are willing to work.
2011-02-24
213 reads
Editorial
Commuting Pain
Did you know that commuting can actually affect your health? Steve Jones talks about an IBM study on this and suggests you talk to your boss about telecommuting or remote work. The option to do so just might be beneficial for your long term health.
2011-02-23
232 reads
Archiving Little Used Data
How do you decide what to archive? Steve Jones says that you need to come up with a method as our data sizes grow larger and larger all the time.
2011-02-22
283 reads
What's Your Code Quality?
Today we have an editorial reprinted from Jan 3, 2006 as Steve is on vacation. What's the quality of your code? Do you measure it? And does it matter?
2011-02-21
274 reads
Getting Up To Speed on SQL Server Denali
Now that the Denali CTP has been out for several months, Brad asks how you're planning on getting up to speed on the latest version of SQL Server
2011-02-21
487 reads
2011-02-18
145 reads
The Stairway Series
Today we launch a new series of content aimed at providing basic knowledge to people new to a section of SQL Server. Steve Jones comments on the way this series came about.
2011-02-17
701 reads
What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
2011-02-16
178 reads
Data Quality
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
2011-02-15
265 reads
Careful Blogging
Today we have a reprint of an editorial from Sept 22, 2005. In this one, Steve Jones reminds you that blogging is a public event and you want to be careful about what you write.
2011-02-14
116 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