Security Disclosure
Did your company lose data last year? It can be hard to know, especially when even laws designed to ensure breaches are reported have loopholes. Steve Jones thinks this is a bad idea.
2010-08-09
77 reads
Editorial
Inception
Inspired by the movie with the same name, Steve Jones has a Friday poll about inspiration and ideas.
2015-02-06 (first published: 2010-08-06)
206 reads
Counting Servers
Which big tech company has the most servers? It doesn't matter, but how you show the data can matter. Steve Jones talks about a skill data professionals should develop.
2010-08-04
225 reads
Keeping Fresh
Today Steve Jones talks about how you might be able to help keep your employees excited and happy with their jobs.
2010-08-03
165 reads
Houston, we have a problem
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
2010-08-02
225 reads
Snoops
A survey shows the majority of IT administrators have snooped for data on their networks. Steve Jones reminds us to be professionals, each and every day.
2010-08-02
146 reads
2010-07-30
1,152 reads
Feedback for IT
Steve Jones thinks we should be building feedback loops into all our systems. Not just for customer service, but also for bugs.
2010-07-29
125 reads
Prevent Outsourcing
Outsourcing is a fact of life, but with the economic issues worldwide, it has also slowed. That will change eventually and Steve Jones has some thoughts about what you can do to prevent it for your job.
2010-07-28
289 reads
High End or Low End
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
2010-07-27
166 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