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,192 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,534 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,383 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,550 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,688 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,435 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
47 reads
2020-02-02
8 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
19 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
5 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers