Browse by Tags

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 of the UK SSUG - Anyway rather than spend time writing...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-09-2008
Why use BACKUP...WITH COPY_ONLY?

New in SQL Server 2005 - this BACKUP option doesn’t appear especially interesting from the description in Books Online - however could be really handy in some scenarios. The benefit of using the COPY_ONLY option is that it doesn't break the backup chain - so won't disrupt the restore routine...

Posted to Justin Langford (Weblog) by JustinL on 06-03-2008
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 to Victoria station and underground it's...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-18-2008
New version of SQL Server 2005 Best Practices Analyzer (January 2008)

The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment. A new version of the Best...

Posted to The Premiers (Weblog) by ThePremiers on 01-23-2008
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 of checks and found a sum of the data returned...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 10-26-2007
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 disbelief which is why it ended. From the previous...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 06-26-2007
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 clear about this now, compliance is more than just...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 04-16-2007
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 as it makes little sense to spend lots of money on...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 12-27-2006
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 pain. If you use the method below, each time the...

Posted to Grumpy Old DBA (Weblog) by GrumpyOldDBA on 11-21-2006

Page 1 of 1 (9 items)