Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2011

Confessions of a DBA – Part 4

This is the last part of my confession series since this is showing me only in negative light. I wish there were positives that I could blog about but I guess there are not many. I must be doing OK since I am still employed here and have been promoted… Read more

4 comments, 561 reads

Posted in RumblingDBA on 19 April 2011

Confessions of a DBA – Part 3

After reading this confession, I am sure almost every DBA is going feel a churn in their stomach. They are all going to say “How could he do that? Does he not know that it is not right? Why does he keep doing that still?".

My confession is that we… Read more

15 comments, 1,112 reads

Posted in RumblingDBA on 14 April 2011

Confessions of a DBA – Part 2

How I caused a fifteen minutes of blocking.

This particular incident happened when I joined this company. I joined this company as a network administrator/programmer/third party software expert. My boss used to call me Jack of all trades. This was my third project and I was feeling quite comfortable with… Read more

4 comments, 626 reads

Posted in RumblingDBA on 12 April 2011

Confessions of a DBA - Part 1

Couple of year's back I brought the SQL Server down to its pathetic knees by using a HINT. Yes, with just one hint on a stored proc. Before I give specify what the HINT was, let me provide the details of why I thought of even giving a hint.

Our… Read more

4 comments, 706 reads

Posted in RumblingDBA on 8 April 2011

Should a DBA be involved in the physical set up of a Database Server? Part 3

This series of blog is to give a general idea what you could look at when setting up a new database server. First part of this blog talked about what could happen when you have a badly configured DB server while the second part listed what all steps can be… Read more

0 comments, 683 reads

Posted in RumblingDBA on 7 April 2011

Should a DBA be involved in the physical set up of a Database server? Part 2

Part 1 of this blog talked about the bad experience we had with a badly configured SQL Server. The second part of this blog will be talking about all the steps we took to configure a high performance SQL server. It has been more than two years since we did… Read more

3 comments, 844 reads

Posted in RumblingDBA on 6 April 2011

Should a DBA be involved in the physical set up of a Database server? Part1

There is always some disconnect between the network admins and the DBA’s regarding hardware set up of a SQL Server. If you ask a Network admin to build a SQL Server without specifications, they will install the server just like they install any application server. To be honest, fifty percent… Read more

6 comments, 738 reads

Posted in RumblingDBA on 5 April 2011

The one bright spot in an otherwise bad day.

April 1st is a fun day for almost everyone. Playing tricks or just enjoying the tricks played by others. For me personally it is a sad day. It is a day I lost someone very dear to me two years backs.

This year to rub salt to the injury, I… Read more

1 comments, 548 reads

Posted in RumblingDBA on 4 April 2011