Notification for missing database backups

I got a question today about sending notifications from SQL Server when there are databases which have not been backed up in the past 24 hours.

The solution is simple – schedule an SQL Server Agent job which uses Database Mail to send emails if there are missing backups. All you have to do in the

Continue reading […] Notification for missing database backups […]

 

Where do you get your SQL Server knowledge?

Lately I have been wondering: if there is too much information everywhere, how do we know what to get, how to filter it and what to make out of it? (just imagine a chicken, swimming in a sea of all kinds of seeds – corn, sunflower, rye… how does the chicken choose?

Continue reading […] Where do you get your SQL Server knowledge? […]

 

Pave the shortcuts!

Here is a real life example of a great concept: great unpaved shortcuts in their glory.

Pave the shortcuts!

The reality is that if there is a well-stomped shortcut somewhere, then it should definitely be paved. After all, it is well-stomped because many have taken it. And if many have taken a shortcut, this means

Continue reading […] Pave the shortcuts! […]