Making Your Career Go Further
Steve Jones comments on a few things that can help you, and are worth keeping in mind as you interact with people.
2010-06-21
251 reads
Editorial
2010-06-18
265 reads
Selling Used Cars
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
212 reads
Archive Backups
The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.
2010-06-16
248 reads
Google FUD
A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.
2010-06-15
232 reads
A new IDE for SQL Server?
Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
2010-06-14
373 reads
Finding the Context
Will computers become better at finding context in situations and environments? Steve Jones comments.
2010-06-14
88 reads
Bad Database Design
A guest editorial from Andy Warren looks at a bad database design he recently ran across.
2010-06-11
1,299 reads
Is the MVP Worth It?
The MVP award is coveted by many people and there are constant questions about how to get it. Is it worth it? Steve Jones talks about that today.
2010-06-09
306 reads
2010-06-08
90 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