Browse by Tags

All Tags » Best Practice (RSS)
09 June 2008 18:54

Dates - especially when SQL Server can't be British!

Just like memory config dates never seem to go away and I've had some discussions with our BI team recently on why things were not working quite as expected, especially on the 13th of the month; and I noticed the same issue had arisen for a member...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
18 April 2008 12:53

Come to the UK SSUG

Support your local user group! If you missed out on attending the UK SSUG Meeting in London last night then you missed an excellent evening, OK if you can't get to London Victoria beacuse you're in Scotland fair enough, but with the close proximity...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: , ,
26 October 2007 10:09

Do you use the float datatype?

I thought I’d perhaps blog about this although I don’t truly think this is of any real significance unless you like to use the flat datatype, which I hope you don’t. I had restored a production backup onto a development box and the guys had run a couple...
Posted by GrumpyOldDBA | 11 comment(s)
Filed under: ,
26 June 2007 12:55

Not thinking it through – the post mortem

I just thought I’d round off my series of posts concerning my first experience of an outsourced data centre. http://sqlblogcasts.com/blogs/grumpyolddba/archive/2007/01/04/not-thinking-it-through-the-saga-continues.aspx It really got to the stage of almost...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
16 April 2007 22:18

Compliance, the DBA and the 4 W’s

Compliance is a word that can bring a chill to a Production DBA, especially in the financial sector. I was fortunate enough to be able to say a few words the other day about a product that can help the DBA in the quest for compliance. Now let's be very...
Posted by GrumpyOldDBA | with no comments
Filed under:
27 December 2006 11:06

NTFS Fragmentation - Bad for Databases ?

( Note: I had a couple of attempts to post this before I figured out how to publish pictures ) So what has this to do with the DBA you might say? Well I mostly make my living from tuning databases and applications. I always start with a hardware audit...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: ,
21 November 2006 16:46

Best Practice - Defaults on columns

I have an extensive document on Best Practices, from the DBA perspective, this is one which I don't think made it in. I'm working with some versioning and scripting tools and the definition of column defaults in table creation scripts is giving me some...
Posted by GrumpyOldDBA | 1 comment(s)
Filed under: