Browse by Tags

All Tags » Best Practice (RSS)
22 November 2011 22:02

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
21 November 2011 20:12

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...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
26 April 2011 21:52

The Devs, The Bad and The Ugly – you choose!

How many times have you heard a DBA describing the teams they work with I wonder? Well here’s my proof.  
Posted by GrumpyOldDBA | with no comments
Filed under:
02 February 2011 19:05

Ghost in the machine

Well it does relate to ghosts, in this case dbGhost, http://dbghost.com/    which is what this post is about. Ghost creates databases on the fly, something I personally don’t like too much, which it then compares to a “base” database to produce...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
09 September 2010 22:25

Don’t add that column

This is the first of the topics from my presentation “ Gone in 60 nano seconds “   As a quick summary this is why additional columns can cause degraded performance. Background I put this brief list of points together after having a carefully tuned...
Posted by GrumpyOldDBA | with no comments
Filed under: ,
16 June 2010 20:15

So which null equals this null, that null? maybe this null, or is it this null?

Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude...
Posted by GrumpyOldDBA | with no comments
Filed under: , ,
03 June 2010 12:36

Now you know it's true !

Grumpy is good - official !! http://news.bbc.co.uk/1/hi/8339647.stm
Posted by GrumpyOldDBA | with no comments
Filed under: ,
17 May 2010 20:12

Just when you thought it was safe..........

One of my duties is to handle software releases to our Production system, as is my want I always run my eye down any schema changes, this new object stood out for a number of reasons. I may add this to my interview questions: SET ANSI_NULLS ON SET QUOTED_IDENTIFIER...
Posted by GrumpyOldDBA | 2 comment(s)
Filed under: ,
15 May 2010 12:20

Did I back that file up ?

As part of some diagnostics I was wishing to check if a particular file had been locked by a backup process whilst I was trying to copy it. So I put a request into the DataCentre for a list of files backed up and time when they were backed up, seems reasonable...
Posted by GrumpyOldDBA | 19 comment(s)
Filed under: ,
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: , ,
More Posts Next page »