I did a number of posts under the heading “You couldn’t write it”  but in this case it had been so a different subject was required. We’d been looking at an issue which had allegedly been fixed but the testing seemed to present some problems indicating...(read more)

https://sqlblogcasts.com:443/blogs/grumpyolddba/archive/2017/01/10/environmental-pollution.aspx

I did a number of posts under the heading “You couldn’t write it”  but in this case it had been so a different subject was required. We’d been looking at an issue which had allegedly been fixed but the testing seemed to present some problems indicating...(read more)

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2017/01/10/environmental-pollution.aspx

Let me say that I like log shipping, for me as a DBA it ensures I have a set of backups in a different location, hopefully a different site to my main data centre. Mostly I like log shipping because all of my backups get restored as soon as after being...(read more)

https://sqlblogcasts.com:443/blogs/grumpyolddba/archive/2016/11/15/when-it-s-gone-it-s-gone.aspx

In my previous post I mentioned what I see as a fatal flaw with the “Alert on Error” scenario, well no sooner posted than to quote Shakespeare “hoisted by my own petard” HA!  I have a log shipped setup where the server communicates alerts using smtp...(read more)

https://sqlblogcasts.com:443/blogs/grumpyolddba/archive/2016/09/21/oh-the-irony-of-it-all.aspx

When I first started as a SQL Server DBA / Developer in 1995 working with SQL Server 6.x one of the key steps was to set up alerting and monitoring. I was working for a very rapidly growing mortgage provider and DR, monitoring and performance were critical...(read more)

https://sqlblogcasts.com:443/blogs/grumpyolddba/archive/2016/09/13/how-s-your-email-today-no-alerts.aspx

I suppose it would be fair to say I didn’t pick up the Grumpy Old DBA for no reason, as well as the usual paranoia of a Production DBA , distrust of almost anyone who wants to go near a database and possibly over protective nature regarding databases...(read more)

https://sqlblogcasts.com:443/blogs/grumpyolddba/archive/2016/09/02/benchmarking-hardware-and-environments.aspx