SQL DBA Guru

“Your issues, Our solutions”

header photo

Got a query?

Ask a question related to SQL Server here:

Need an expert advice or help? Having SQL Server performance problems? Be assured to get the best solution to help improving performance of your database. Feel free to put up all your queries here.

Do’s & Don’ts for a good career…

Posted October 27, 2011

I have seen many people who have secured very good percentage in their educational exams, got a fancy job at a multi-national company and then few years later their career just tanked! And, that’s because a career isn’t built only by a fancy degree or the first job. I would like to make here some points that could ruin your career:

Changing jobs for money alone
It’s more important to look for work you enjoy and which helps you to grow. Good money does not guarantee a good job. It’s very necessary that you should be passionate about your work.

Jumping careers too often
While it’s obvious to want to move to a better or more satisfying job but changing jobs too often may be perceived as indecisive and unstable.

Accepting status quo
There is no harm in trying your best. If you feel your current job is not adding value to you, talk to your boss before it causes anxiety, frustration and even depression.

Working without a long-term career strategy
A long-term plan will give you a clearer idea about what kind of jobs you should seek and which organisations will benefit you most.  But if you go with the flow for too long, it can get you lost and may lead to frustration.

Working due to some pressure
If you work that is not compatible with your aptitude, it will downgrade your work quality as well as your mental and physical health. So, don’t let your parents or friends influence your career decisions, especially if you are uncertain of what you want to do. If needed, seek a professional’s help like a career counsellor.

Short / No notice before quitting
Serving the notice period always help to both the parties. It gives your employer enough time to find a replacement without upsetting work whereas it will keep your boss happy, who will give a good testimonial when a future employer calls.

Not Networking
Try to develop a better work reference for yourself by meeting new people and making new friends. You don’t know when you will need these contacts and who will help you!

SQL Server Service Pack Upgradation.

Posted October 27, 2011

Dear Sir,

 In my current environment, I have SQL Server 2005 Ent. Edition with SP2 and planning to upgrade to higher Service Pack 3 or 4.  

For this I want to know : 

1.) What are the pre-requisites I need to take care?

2.) May I directly upgrade to SP4 or need to first upgrade to SP3 and then SP4 ?

 Regards,

Ajay Miglani

New Delhi.

Optimum Backup and Maintenance Plan

Posted September 27, 2011

Hi Sujeet,

                 I am looking for some information on an optimum backup / maintenance plan to be followed in a small to mid-sized organization. Also explain when this to be scheduled and how to apply this on multiple SQL Servers. If you can also let me know what each step of the maintenance plan does, it will greatly help to understand their impact and why the steps are being used in the maintenance plan.

 Thanks,

Bindhiya.

SQL Server Daily Issues

Posted September 27, 2011

Hi Sujeet,

     Can you help me to know what sort of issues a general DBA faces in his day to day activities and what are the solutions and workarounds are there to those problems? Thanks in advance for helping me and other freshers know about these details. This will greatly help me and other freshers to understand and prepare ourselves accordingly.

Thanks,

Bindhiya.

SCOM and SQL Server

Posted September 26, 2011

Hi Sujeet,

      I have heard about SCOM as a monitoring tool for SQL Server. Can you please help me more on this?

 

Thanks,

Bindhiya.

Good Books on SQL Server.

Posted September 21, 2011

Dear Sujeet,

I have a little bit idea about SQL Server and have done some DBA activities too on SQL Server.  Please suggest me some good SQL Server books to read.

          One another question is if you can tell me that can SQL Server is enough to handle large enterprise database like Oracle? 

Regards,

Nilanjan Chakraborty

Kolkata, India.

 

Need Help on SQL Server MSDE 2000 Desktop Engine.

Posted September 21, 2011

Hi Sujeet,

How are you ? Your website looks very impressive and keep up your good work.

I just need some solution from you for one SQL server related issue. One of our application is running on MSDE 2000 Desktop Engine which has a limit of 2 GB DB size. Now this size has reached the upper limit and hence the application is failing often. I found that sysjobhistory table of MSDB database has 33 lakhs rows.

So will truncating all those rows reduce the size of table? How to do that.....?

But still some of my constraints are as follows:

1. I don't have SQL server enterprise manager installed on the local server. When I try to connect from remote server and try to delete the rows, it was failing due to timeout issue.

2. I also try to install SQL editor in my desktop and try to connect to the DB but i failed because of firewall issues.

So I need a method or command to truncate the data to be executed in the local server. I tried with OSQL command prompt, but I was not able to succeed in that also...!!

So please help me to get rid of this issue....thanks a lot.

Regards,
Raghunath.S.D
System Administrator
Kingdom of Bahrain

SQL Server or Oracle?

Posted September 18, 2011

Hello sir,

I am working as a software developer since 1+ year but I am interested for DBA profile. I am also unable to found
a job here in Pune for the same profile. Can you please suggest and as per current market which one is better SQL Server or Oracle?

Thanks,

Rohan Sarnobat

SQL DBA Certification

Posted September 18, 2011

Dear Mr. Sujeet,

I am a SQL Server DBA with 3+yrs of experience and did not write any certification exam till now. So should  I write 70-432 or 70-450? Please let me know.

Thanks in advance,
S.M.Patel

Beginner level challenges as a SQL DBA

Posted September 17, 2011

Hi Sujeet,

I am a beginner level SQL DBA and my question is on clustered servers, with active-passive node on SQL Server 2005. I need to configure and set up the servers from scratch. I am not sure where to start, what to set up and how to make them as an organized servers. Please tell me how to proceed one by one in detail along with how to do health check on the servers, what processes to set up, etc.

I would appreciate your immediate help.

Thanks,

Sanjana B.

Interview Questions for Freshers.

Posted September 17, 2011

Hi Sujeet,
I am a fresher and want these information from interview point of view:

1. What is the overall size of a SQL Server in any mid sized company?

2. How many SQL Servers a DBA has to work with?

3. How many instances and for what purpose they are used?

3. How many databases and the size of each database?

4. Each database consists of how many tables?

5. Hardware specs (CPU’s, memory, Storage)

I think, Interviewer's mainly focus on these points, that is the previous large scale company experience. Please let me know the answers for these questions.

Thanks,
Bindhiya

Performance Tuning in SQL Server 2008 R2

Posted September 16, 2011

Hi Sujeet,

Can you provide me with some guidelines on how to fine tune and improve performance in SQL Server 2008 R2?

Thank You.

Salim

Need Career Guidance

Posted September 16, 2011

Hi Sujeet,

Hope you are doing well. I am working as an ATL (DBA) and needed some suggestions from you regarding building up my career.

Will it be helpful if a person has experience in both software development and with Database Administration? I was looking to stabilize my career as a SQL DBA and would need your valuable suggestions, please. Kindly guide me how should I proceed with my career?

Waiting for your valuable suggestions.

Thanks and Regards,
Amulya

Question:

Posted September 8, 2011

SQL Server 2008 Training They are the Best Trainers and Best Place to Work in Indian Training Industry www.Koenig-Solutions.com