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, 1 month ago by  David.Poole.

My wife's Skoda has a touch screen display that says "Loading user profile".  Until it has done so none of the other features are available such as Sat Nav, Audio...

We experimented with otter.ai for meeting transcripts.  Nothing wrong with the functionality but we are nervous about the same things as Redgate.

We are also interested in Codium.ai as we are...

I would quite like to experiment with a 3D printer.  One of my hobbies is building model railways and after trying to scratch build the Victorian bridge at Millers...

Entity Framework and various ORMs get a bad rap from DBAs.  In my experience this is down to them being used as an out-of-the-box install with bare minimum configuration.

Many of...

One of the reasons we have SQLFluff in pre-commit hooks and GitHub CICD pipelines is so that standards are enforced for everyone mechanically.  People come and go so mechanical enforcement...