Browse by Tags

All Tags » Things I hate (RSS)
01 September 2011 16:31

Things you overhear !!

"You can't get better than 90% can you?" " we need to disaggregate down the data"
Posted by GrumpyOldDBA | with no comments
Filed under: ,
16 July 2011 23:31

A New Record ( How many noughts ????????? )

I have to say I thought I’d seen it all but this last week brought an event of such magnitude I may be contacting the Guinness Book of Records. OK that’s not true, but I’d like to! One of our production systems has to support a certain element of real...
Posted by GrumpyOldDBA | with no comments
Filed under: , , , ,
11 April 2011 20:41

Windows doesn't like Squirrels ?

Strange goings on when setting a sevrice account password ^^ I was setting a service account for a dev SQL server and wished to change the account password from that which it had been created with. I can list all of this as I'm not giving away server...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
30 September 2010 22:05

Rowversion vs Timestamp !! what’s the word then microsoft?

I like to promote all things SQL Server whenever I can and when the subject of allocating some time to maintenance of our applications was raised I was quick to suggest we could replace the numerous Timestamp columns with Rowversion so that we future...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
13 April 2010 14:13

Would you expect this then ?

I've just been working through a database looking for log tables which can have data aged out, or deleted if you like. I was using SSMS for this and used the default right click select top 1000 rows as a quick view of the data. Establishing that I...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: ,
22 February 2010 11:47

Don't always believe your system procs - they may lie !

It's sometimes interesting how a simple thing can catch you out! I have a set of routines which handle the process of restoring copies of databases on other servers, it also supports full blown log shipping but has various other functionality. Generally...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
17 April 2008 12:26

Disappointing Review.

It's not very often I'm provoked into making a criticism of a respected publication, however there's nothing like being grumpy! I've published a number of posts about baselines, trending and performance analysis and I've been quick...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
29 February 2008 19:57

Only once every four years thank goodness!

I never cease to be amazed by what I discover within IT, mostly these days I'm more disappointed than anything else, I'm not a lover of the let's bash Microsoft about security patches or we should all use Linux / Open source as in the latter I'm sure...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
19 June 2007 14:03

SQL Community is good to be part of.

It’s interesting to sometimes compare the flow of information about SQL Server to that available for other products. I’m currently working on an application which runs on SQL Server but by default / was developed with an ISAM back end. This particular...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
24 August 2006 14:35

sysmaint.exe failed

I just love this message! I never willingly use the built in maintenance wizards or maintenance plans, however the database backups are all through maintenance plans at my current site. Today I had a failure of a backup job for no apparent reason, examination...
Posted by GrumpyOldDBA | with no comments
Filed under: