Dear Sujeet,
Hi Sir,
I am having a doubt regarding one of the issues in SQL Server. Can you help me to find out the root cause? While trying to connect to a remote sever, I am getting the following error.
Error: A network-related or instance-specific error occurred while establishing a connect…
Hi Sujeet,
I am Srinu working as a DBA and recently I got one problem during upgradation.
In our Reproting Server (Standby) SQL Server 2005 SP4 (Version:9.0.5000) is installed, at present we want to upgrade to SQL Server 2005 Enterprise edition RTM (no Service packs, Version:9.0.1399). When I was…
Explore your career path to become a DBA and furthermore. Just choose your current job title to see what you might be doing in future @ http://www.sqldbaguru.com/career-path.
Dear Friends,
Due to my time unavailabity, the timings for live chat has been altered. Now, its only available for 30 minutes biweekly - Mondays and Thursdays at 7:30 AM GMT / 8:30 AM BST (London)/ 01:00 PM IST (New Delhi) / 01:30 AM EST (USA New York).
Thanks ag…
Now here you go! If you are looking for what you are worth for, here is the tool to calculate the payscale based on the market survey. So, why not to try it? It provides key salary data based on your requirements. There are millions of unique salary profles to compare with. So, visit the home page o…
Dear Sujeet,
Can you please suggest how to find the fragmentation level by using command prompt? Thanksin advance for your help.
Regards,
Kolla Srikanth
Sujeet Shares his experience with Koenig - Solutions at http://www.koenig-solutions.com/training/FeaturedStudent.aspx?syear=2010&sid=585#anchorfs. Something more there...
Hello everybody,
I feel very happy and excited as well as a pleasure to invite you all to the bi-weekly Live Chat sessions on the SQL Server Database administration and maintenance issues! My website, www.SqlDbaGuru.com, (born with a thought to help others struggling on the day to day database relat…
Question: I am a fresher and want to become a SQL Server DBA. I would like to know about the SQL Server environment and how SQL Server is deployed practically in small scale firms? Could you please help me to have more insight on this?
Solution: Good question. This is a very basic but a very valid…
Dear Friend,
If you are a SQL Server person, then just count that how many industry leaders and SQL techies know about you? Get yourself noticed globally by sharing your experience as an interviewer / interviewee for SQL DBA position helping others to learn from your mistakes or suggesti…
I am a DBA and I have got a request to add an user and grant him read access to all databases in a SQL server. Now, the problem is there are more than 60 databases hosted in the server and I do not wan to do it on all databases manually one by one. I…
Going for an Interview?
Now better be prepared before speaking up in an interview for the SQL Server DBA position and grab the opportunity. You can call at 88-26-648-648 or mail at sujeetsaha@gmail.com to fix up an appointment for a mock interview!
Please Dial 0091 before the number if callin…
Dear Friends,
On your constant requests for information on licensing models in SQL Server, you can now refer to my page - http://www.sqldbaguru.com/licensing. This applies almost same for SQL Server 2008 and 2005 but do let me know for further details if required.
Regards,
Suj…
Don't wait until you have got problems. Get the expert's advice, optimize your SQL Server and relax.
Contact for a SQL Sever Health Checkup Guidance today!
Mail me your questions at question@sqldbaguru.com