Browse by Tags

Environmental Pollution

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 it hadn’t worked. As you would expect there...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Jan 10 2017
Oh the irony of it all !!

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 .. well today I discovered that for some reason...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Sep 21 2016
How's your email today ? No Alerts ?

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 to the ongoing success of the company. I was...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Sep 13 2016
Benchmarking Hardware and Environments

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 I have tended to become more cynical and distrustful...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Fri, Sep 2 2016
Community is Great

I have a great respect for so many who contribute to the community, without them I would often struggle in my role for sure. When "strange events" happen in a busy production environment it can be quite daunting when it seems everyone around is expecting you to have the answer/solution at your...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Aug 20 2013
Performance issues due to Inactive Terminal Server Ports

This is an interesting post and although I don't have any direct issues of performance with any of my Servers I can see the build up in the registry as described. If you make extensive use of DPR / TS sessions you might want to check this out http://blogs.technet.com/b/askperf/archive/2012/03/06...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, Mar 12 2012
A follow up to yesterday

As I have been asked, here to tidy up yesterdays post is the procedure my startup procedure calls along with the logging table deployed in the DBA database. Just to muddy the water further I have routines for remotely calling the DBAMessages table through a remote server to send out email from...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, Nov 22 2011
Hello it’s your server calling

This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be used...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Mon, Nov 21 2011
Scheduled Jobs on strike ??

I had an interesting situation with agent jobs stopping running without failure. I don't want to go into attempting to describe our infrastructure but siffice it say we had a few issues. None of my SQL Servers went down but there were problems and when the system picked up I had some interesting...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Tue, May 17 2011
An interesting annecdote

A while ago I blogged about using the dmvs to identify lookups and scans on tables http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/19/analysing-indexes-reducing-scans.aspx Well continuing on from this I had discovered that two of the top scanning tables don't actually contain any data...

Posted to The original Grumpy Old DBA - Beware the darkside ! (Weblog) by GrumpyOldDBA on Wed, Jul 28 2010

Page 1 of 6 (56 items) 1 2 3 4 5 Next > ... Last »