Live Chat on SQL Server related issues with Sujeet!

Posted September 7, 2011

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 related issues,) has been sharing many of the top-notch advices and scenario based solutions to all levels of SQL database professionals across the globe.

I would like to help you all on as many posts as possible, but due to time constraints, would request you to not to miss out on your chance to get an expert advice!

Logistics:

Days: Mondays and Thursdays

Duration: About 30 minutes.

Timings:

  • 7:30 AM GMT / 8:30 AM BST (London)/ 01:00 PM IST (New Delhi) / 01:30 AM EST (USA New York)
  • 5:30 PM GMT / 6:30 PM BST (London)/ 11:00 PM IST (New Delhi) / 12:30 PM EST (USA New York)

 If you have any issues accessing the chat room at all, please mail or call me, and we’ll get the issue resolved at the earliest.

Catch you there at gmail chat @ sujeetsaha@gmail.com!


Sujeet Kumar,

Database Architecture and DBA (SQL Server)

Comments

If my server received 2 requests to login with same user name and password (Here one who has registered has given his user name & password to some1), then as a DBA what precautions i shall take so that it will be allowed to only one person to log-in & deny the access to other. Using JSP or Servlets. Please do reply.

Need help in knowing the impact if SQL max memory is more than RAM capacity.

i want to take backup of database 3 months before . i am using sql 2000 server. please help me

i have 3 batabase with same tables struck.. now i want to show one report with marge 3 batabase..how do i get it?/

Need Help Urgent.....
Dear Sir,

I want to measure the values in to two databases(SQL Server 2008-R2 and SQL Server Lower versions/MySQL/Oracle whatever ll be easy can take it doesnt matter) so that i can proove that SQL Server 2008-R2 is more Secure in all respect such as No/minimum Dataloss, reliable to all other one.

Dear Neha,
Thanks for putting up your question at SqlDbaGuru.com and I am more than happy to answer your query. But can you explain a bit more on the question? Do you want to know how SQL Server 2008 R2 is more powerful and secure than SQL Server previous editions?
Do you want to know the high availability features of SQL Server R2 edition? If you can help me to understand, I may help you more on answering your queries.
Thanks again and feel free to have your queries put directly to me.

Regards,
Sujeet Kumar.
www.SqlDbaGuru.com
+91 88-26-648-648

Hi Sujeet,
I am working on a project named "SQL Server 2008-R2 Security features". I have completed the documentation part to describe the SQL Server 2008 R2 Security features in comparison to MySQL.

But now I have to implement something and have to show that SQL Server 2008 R2 is more secure, reliable, preventing dataloss in comparison to MySQL.

I have no idea about how and what should I implement for this, can you help me regarding this? Many

---------
Thanks and Regards
Neha Sharma

Hello Sujeet Sir,

I have gone through your blog and website - www.SqlDbaGuru.com and got your email ID from there.
First of all, thank you for being so selflessly giving person, you are one of those rare kind.

Now about me, I am a .NET developer with 4 yr of experience from kolkata, INDIA but willing to and have very much craze to become a DBA since the beginning of my career.
I have worked extensively as a developer with SQL Server and want to get deeper into it. The immediate step I want to take is to get certified in this field (as suggested by you in the log).
Can you please show me the way?
Only want to know which exam to go for in Microsoft certification.

Waiting for your revert and suggestions.

Bikash
:)

Please tell me in detail how to create a transaction log backup??

--------
Neha Sharma
http://tivlabs.in/

Hii Sir,

Can you please tell me what the above query is doing(Output).

Thanks.

USE <>;
GO

WHILE (SELECT AVG(ListPrice) FROM Production.Product) < 300
BEGIN
UPDATE Production.Product
SET ListPrice = ListPrice * 2

SELECT MAX(ListPrice) FROM Production.Product
IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
BREAK
ELSE
CONTINUE
END

I am talking ABOUT THIS QUERY.

------
Thanks
Neha Sharma
http://www.tivlabs.in/

Displaying all 16 comments

Add comment

Get the Expert's Advice.

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! 

Always reachable through:

  • - A Live Chat Session every Mondays and Thursdays.
  • - Call at  88-26-648-648  Dial 0091 before the number while calling from outside India.
  • - Mail me your questions at question@sqldbaguru.com