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)

16 comments

Posted in General

Tagged as live chat on sql server related issues with sujeet!

Comments

abhinandan November 8, 2011

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.

Sujeet November 26, 2011

Dear Abhinandan,
Thanks for putting up your question here. Let me rephrase your question - Two different people (or users) are using the same user ID and password to login to a SQL Server, assuming the logon credentials have been shared between both the users. If this is the case, SQL Server will allow both the users to login respectively.
Now, the second part is as a SQL DBA you want to allow logging only one user at a time. For this, you can check the user from the active users logged in (many ways - but one of the simplese way is to check with sp_who2 active command) and if the user is there, you can disconnect the second user.
I hope this answers your question else feel free to ask again.

Regards,
Sujeet

Farida December 1, 2011

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

wahab December 12, 2011

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

prodip December 26, 2011

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

Neha Sharma February 13, 2012

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.

Sujeet Kumar February 14, 2012

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

Neha Sharma February 15, 2012

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

Bikash Karmakar February 15, 2012

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
:)

Sujeet February 15, 2012

Hi Neha,
Answering to comment# 8, please check the "Articles" section in my website - www.SqlDbaGuru.com, which explains you how to setup and configure the database mirroring. Do let me know for any additional queries.

Here is an example for your while loop. I hope this solves your problem.

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

PRINT 'Too much for the market to bear';

Regards.

Sujeet February 15, 2012

Dear Bikas,
For answering comment# 10, thanks for your kind words and I am happy that you liked the articles and knowledge sharing in this website. For your certification, I would suggest you to go through the URL - http://sqldbaguru.com/dba-without-prior-experience in my website. Please feel free to have your any other related question.

Kind Regards,
Sujeet

Neha Sharma February 16, 2012

Hello,

This blog site is just awesome coz when you are in trouble related to SQL Server you must post your query here,its amazing u'll get reply with best solution for your query.
I am really very much thankful to Mr.sujeet Sir for his kind and motivative response he saved me to get my degree.

Thanks.

Neha Sharma February 17, 2012

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

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

Neha Sharma February 18, 2012

Hii Sir,

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

Thanks.

Sujeet February 19, 2012

Hi Neha,
Answering Comment#13, the command for taking a transaction log backup is as follows.

BACKUP LOG <>
TO DISK = 'C:\DatabaseName.TRN'
WITH STATS
GO

Please replace the <> with the actual database name for which you are taking the backup.

Regarding Comment #14, it seems that you have missed sending me the query for which you want to check the output. Can you please send it to me?

Kind Regards,
Sujeet.

Neha Sharma February 20, 2012

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

SQL DBA Guru

“Your issues, Our solutions”

Live Chat on SQL Server related issues with Sujeet!

Comments

Add comment

Get the Expert's Advice.