Archives: April 2011
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
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
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
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
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
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
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
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