Leadership
Steve Jones talks about the need for leadership and what managers should be looking to achieve in their efforts.
2010-05-03
166 reads
Editorial
Would You Like a Stay Interview?
For this Friday poll, Steve Jones talks about an interesting concept. The "stay interview."
2010-04-30
383 reads
Man in the MIddle
Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.
2010-04-29
290 reads
Regular Service
Steve Jones feels that we ought to get regular service packs from Microsoft to support SQL Server. Not everyone agrees. Do you?
2010-04-28
105 reads
Concrete Code
When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.
2010-04-27
192 reads
Minimal Meetings
Too many meetings happen in software teams. Steve Jones says that when scheduling meeting, you should be aware of the cost, and only include those people that need to be there.
2014-11-27 (first published: 2010-04-26)
211 reads
Financial Data in the Cloud?
Phil Factor believes that there will have to be further compromises between the pioneers of The Cloud and the regulators, before companies feel safe in entrusting their financial data to such an abstract service, seemingly 'remote from sand and iron'.
2010-04-26
356 reads
Spring Cleaning
For a Friday poll this week, Steve Jones is looking at those spring cleaning or annual maintenance activities that you might perform on your systems.
2010-04-23
154 reads
What Do We Want?
Today Steve Jones talks about the challenges of deciding what to include in that next software release. Something that likely isn't as easy as we might think it should be.
2010-04-22
92 reads
Speed Racer
Speed is critical. That's the theme for today's editorial, using the NYSE as an example.
2010-04-21
136 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