The linked article is long but well worth reading.  A lot of it dovetails with my experiences.

It's one thing to hire a great DBA, data engineer but you really need...

From what I have seen the people I would regard as being at the top of their profession have certain traits.

• Competence with confidence
• Natural teachers.  If feels like you...

Adventureworks is a publicly available DB designed to show off SQL Server.  As such it has sensible naming standards and PK/FKs.

Is there a capability that would work against DBs that...

Kris Kovacs has kept his original NOSQL comparison article up-to-date.  I refer back to it at intervals.

All DBs represent a compromise to achieve a set of functionality. ...

I was fortunate in that my company put all of us through Helen Tupper's "Squiggly Careers" programme.  I can recommend both of her books.  https://www.amazingif.com/books/.  I've bought Squiggly Careers for...

SQL Server still has sp_procoption so having a proc whose duty is to pre-warm the buffer cache is possible.  What would be useful to preload into the buffer cache...

In my experience people solve the wrong problem or follow a path that would mirrors the line "Something must be done!  This is something, therefore it must be done"!

The cloud...

Rod, I've found that solutions to human behaviour, such as finding reasons to want to bypass a CI/CD pipeline, are not permanent.

The danger with any process is that it is...

I was shocked to find a DB deployment pipeline that was written using the Talend ETL tool.  The tool attempted to be a SQL parser dictating what SQL could and...

Over the course of my career I have noticed a few things about the world of work that can be used to help fulfil your goals.

Some of the greatest restrictions...

I was out with a group of 4 friends at the weekend.  All are significantly higher ranking than I am in tech.

One told a story of using AI to analyse...

I've had to spend a lot of time with auditors.  Migrations can be useful artefacts for the auditors.

My experience has been that auditors want to see proof that you have...

Spent the day washing things.  Next day, finger print scanner couldn't recognise my fingerprints. Started working again about 24 hours later.

At the start of my career the breadth of technology was narrow.  There were 2 certifications for SQL Server and it was possible to be highly proficient at all areas...

Before COVID I went to quite a few MeetUp events.  The women at these events are often in the minority.  Going to these events when you know you will be...

• This reply was modified 1 year, 10 months ago by David.Poole.