61 Comments on "Contact"
am vellikannan, am working as a database security admin.I would like to be a DBA.in our environment there is no repliation and clustering.kindly give me some notes to understand this both the concepts.
Thanks in Advance..
Dear vellikannan, appreciate your interest in DBA profile. you can check youtube for practical examples for replicaiton, mirroring an dother sql server concepts. There are lot of wonderful videos available.
Hi Sir please send some interview question AND ANSWER on REPLICATION ,MIRRORING ,LOG SHIPING
I need SQL DBA training in Delhi/NNCR, if your branch in available at Gurgaon, then let me know.
Boss I really impress to see your village and I would like to visit.
We should appreciate your interest in SQL DBA. We do not have any branches in Delhi,
Thanks for visiting. Happy Reading.
I am sandeep. I had done MCA in 2012. I am working as database analyst and some reporting work.
I have 3 years exp. in this field. but i want to be a ms sql server dba. I have good knowledge of sql queries from sql server 2008 r2. kinldy suggest me the path to be a sql server dba. and also let me know it would be better for me or not. I am confuse between developer and DBA track, which one is better.
Thanks sir, your information is much valuable. Could you please suggest me some content for sql developer for msbi track…
MSBI is totally a different track, you should have some basic knowledge on SSIS, SSRS and SSAS, should know about T-SQL, Data Analysis, VB / C# Scripting knowledge. These skills will help you in to excel in MSBI stack.
For MSBI interview questions and answers, you can have a look at below
Thank you very much Udayarumilli
Thanks Manjunadha !!!
i am sql server developer, i am having 3 years experience as sql developer, now i am attending interviews,
can you provide t-sql complex interview questions,so that it can helpful a lot for me
Thanks for visiting our site. We have been working on T-SQL interview questions. Will come back with the post.
your site is very very useful to every msbi jobsearching guys and There is no need to go any coaching centre to learn Msbi and Sql.
Do you have any real time scenarios on Msbi and Sql server with you?.If u have ,please share with me.
Subbu, Thank You So much for visiting our website. Will surely post production scenarios for MSBI and SQL Server.
I am Pavan, from L&T vishakapatnam. We want to develop application for our business process and looking for database architects. Can you take our project.
Firstly your blog is very useful and very informative..thanks for ur site
I am sql server developer, i am having 3+ years experience as sql developer, now i am attending interviews,
can you please provide t-sql complex interview questions,so that it can helpful a lot for me
Thanks for following our site.
For 3 years experienced, you just be strong on “Summary” that you mention in your profile:
Main topics you should be strong on:
1. Performance Tuning and Best Practices
3. Locking, blocking, Dead Locks
5. Application Support – What is connection pooling?
6. Differences : Delete – Truncate, Temp Table – Table Variable
1. Highest Salary – Nth highest
2. CUBE, ROLLUP, PIVOT
3. Update a table based on a Join (Join + Update)
4. Hierarchy Query- Write a query to get below output: In a given organization retrieve all employees and their manager details.
SLNO Employee_Name MGR_Name
Thanking you for very useful and very informative blog.., i am having 3+ years experience as sql server DBA, now i am looking for change,can you please provide DBA interview questions. In which things i would be strong for 3+ experience.
Thank you Sir.. ! For Very useful info..!!
I want know the brief informaton about diffrences between 2005, 2008, 2008 R2 and 2012 SQL servers..
Hi, We’ll surely work on these questions and will try to answer.
Thank U for very useful info..can u pls explain briefly diff b/w LOCK vs Block vs Deadlock..?
Really, thanks for your support..Please can you clarify this.
1) How can I find out if I have any uncommitted transactions? In real time, what is the solution to uncommitted transactions?
2) What is snapshot isolation level? How is it helpful..
Can you please post some couple of lines how to configuring Sql server 2 node cluster cluster in windows server 2012 environment.( Iscsi, San disk, Quorum) I just need step by step lines then i can understood, please post step by step process from beginning. it would be helpful me a lot.
Thank you in advance.
Thanks for visiting our site. http://www.sqlshack.com/sql-server-2014-install-clustered-instance-step-step-13/ http://theadminsguide.net/2014/05/20/sql-server-2012-failover-cluster-installation-step-by-step-guide-part-1/
Thank you So much Uday.
I want to prepare a document of my current organization Database backup and recovery policy. I dont know how to start and where to start it. And they dont have existing backup plan with document. So can you please help me in that & provide any model document So that i can start my documentation.
Thank you uday, Thank for ur support.
How to know the number of instances present in a machine with T-SQL query..?
I got a new issue like we have this one agent ID: firstname.lastname@example.org whose hours are not showing up in opearator login logout report
I am sure he was online on 11th, 12th I am still tentative ; however, his details do not show up in the operator login logout report for both 11th as well as 12th jan. And where i need check for this report and how can i solve this issue.
hi uday for 6 years of exp……….on which topics i have to cover kindly reply me ASAP…pls
Hi Ramesh, Thanks for the contact.
Can you tell me what is your core competency? (DBA, SQL Developer, BI, DB Modeling) based on this we can suggest you.
the Team SQL
sql server Dba
Thanks You Uday ……Thanks for your valuble information..and one small question in your website i am not fing high availability interview questions ….If you have kindly send me Please
hi Uday …..Pls can u share me the high availability interview questions
We have been working on High Availability questions and answers, we have been connecting with the experienced professionals for these interview questions. We’ll get back with the full list.
Thanks for visiting our blog.
The Team SQL
Do you have a Facebook page? Is it helping your business or just taking up space? More people decide on what to buy by asking their friends than by Google. So it’s vital that your social media pages have an impressive business connection. Make us one of your friends too, and we’ll use all our Search Engine Optimization skills to improve your sales. Details? Email us.
Hi uday for 6 years of MSBI exp……….on which topics i have to cover kindly reply me ASAP…pls
Thank you so much for sharing such a wonderful stuff related to SQL Server and I genuinely appreciate your efforts.
Could you please post an article related to Database documentations like SOP, Migration Checklist etc..
Thanks Mahesh for your kind words, it means a lot for us 🙂
We’ll surely try to cover the topic database documentation.
Hi Uday, what is backup device in SQL Server? How is it helpful.. please can you clearly explain..
In book sql the one, In sql Architecture it is TDS but you mention in protocol statement TDE please verify and confirm.
Thank you so much for reporting the issue. Appreciate your concern.
Unfortunately it was wrongly edited as TDE but it should be TDS (Tabular Data Stream).
We have already escalated it to publisher, we’ll make sure it’s got corrected.
Thanks again for your help
SQL THE ONE Team
I just started to read book SQL the ONE, In sql server architecture ,the protocol it is TDS but in statement you mention TDE.
I am Manish. I had done BE(CSE) in 2014. I am working as database developer.
I have 1.4 years of exp in this field. I have good knowledge of SQL queries ,now i want to switch from her . I request u to please help me to make my resume better because i have no idea about making experience resume for database developer.
I have created but that one is not good enough to get selected for interviews . so please i request u to help me to make my resume better .
The single biggest problem in communication is the illusion that it has taken place. The Thiruvannanamalai is blessed to welcome you.” When You Visit south india 3rd largest Temple? Arunachala vaibogam welcomes you To Reprogram your muscle memory and bio memory (Hinduism is Real,Experience it in thiruvannamalai) A visitor guide at thiruvannamalai temple. (THIRUVANNAMALAI HOLYDAYS ENRICH YOUR GENERATION) Abirami kumar 9042333482 8526197306 Thiruvannamalai temple guide
i finished engineering in 2011.but my situation i can’t get job it sector .as i am started self employee(tour guide at thiruvannamalai) .My friend (saidepet Chennai ) was buying books and preparing .he was left he job due to inconvenience work culture . now i am interested in digital marketing and he interested to work in sql domain.please guide me of both to get the job:
by the by what is your state of mined when your writing the book sql the one
Hi Uday, Appreciate your good work here. Do you recommend any institute / person for Sql Server Training for DBA / BI in Hyderabad. Thanks.
Sorry for the delayed response. Most of the institutes have a great masters whos is having real time experience in SQL DBA. I heard that SQL School and OptimizeSQL are good in teaching SQL DBA course.
All the very best.
SQL THE ONE Team
can you please give me 4 to 5 difficult task perform by a SQL DBA daily basis?
Thanks in advance