A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2020-03-03 (first published: 2018-10-28)
3,193 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
Azure Enhancements – Time to take a look (and read the ebook.)
TweetG’day,
Recently I’ve become quite interested in the latest incarnation of Azure SQL Database.
For those that are unaware of some of...
2020-03-03 (first published: 2015-01-27)
6,535 reads
Following good practice saves wasted time down the line.
TweetG’day,
Sometimes I come across what I call unusual coding practices. Developers usually have pressure on them to deliver and this...
2020-03-03 (first published: 2012-09-10)
2,386 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2020-03-03 (first published: 2019-02-02)
2,552 reads
THE IIF statement – SQL has it at last.
TweetG’day All,
While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came...
2020-03-03 (first published: 2014-02-18)
13,689 reads
The SQL Elephant in my room
TweetG’day,
Are people familiar with the saying “If there’s an elphant in the room, introduce it“? – if not, then to sum...
2020-03-03 (first published: 2014-03-19)
5,436 reads
Data Events in Australia and New Zealand in early 2020
Over the course of the next few weeks there are some significant events taking place that reflect technologies on the Microsoft data platform and beyond. Thursday 13th and 14th...
2020-02-12
49 reads
2020-02-02
9 reads
Is NoSQL still a thing?
G’day, Looking back, perhaps one of the (many) mistakes that I’ve made in my career was to initially ignore the N0SQL movement. I’ve focused my career on Relational Database...
2020-01-27
20 reads
Moving to a Modern Microsoft Platform
Melbourne Event – Monday 17th June 2019 (Free – including lunch and prizes) PASS, in conjunction with Microsoft, Intel and community leaders are offering free training on Moving to...
2019-06-06
6 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