How come the Hourglass? Why database applications slow down

A new article of mine is out!

This time I write about the meaning of “my database is slow” and what hidden secrets database contain. I.e. databases are never a single player in the game of performance.

Here is the article: How come the Hourglass? Why database applications slow down.

 

How to find SQL Server agent jobs related to a database

When migrating a database to a new SQL Server instance, there are numerous steps to be taken, as I mention here.

One of the considerations is to move all Agent Jobs related to the database to the new instance.

How do we find which jobs to move, though?

 

A new beginning: migrating database systems to new environments

The rule of thumb in IT is that ’hardware used in production becomes obsolete every 3 years and needs to be replaced and upgraded’.

So far so good. The boss approves, the financial department approves, the IT department writes the specs and the vendor eventually delivers the hardware and installs it.

Now what?

The old ‘obsolete’ hardware is

Continue reading […] A new beginning: migrating database systems to new environments […]