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.
Dear Sandeep, There are their own paths and benefits for both SQL Developer and DBA. It all depends on your interest. Since you said you are interested in DBA and already into SQL development / Reporting you can learn DBA concepts and try for a DBA position in application support environment so that you can get 40 – 50 percent DBA work and there after you can ask for production DBA role. 1. Coming to salary it’s all depends on your experience and knowledge. 2. Onsite opportunities, usually developers can get more onsite opportunities. 3. Work flexibility again a developer… Read more »
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.
Hi, Thanks for following us. For 3 years experienced SQL DBA, Usually from 3 years experienced candidate is expected to aware of the concepts. Example you need not answer a typical questions like “How do you know when last CHECKPOINT issued?” But atleast you should aware of wht is checkpoint and what happens when checkpoint issued. However these are the basic concepts you should aware: 1. SQL Server DBA basics: Installations and Configurations Any idea about Summary.txt and where the file is located? What are the different error logs available? What are the components installed while installing SQL Server? How… Read more »
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 sir, Please spend your valuable time for these questions… 1. The downtime less how u migrate d/b within down time? 2. How do u rebuild master when it is corrupted? 3. What are the user permissions you give to user who want to create job? 4. Tell me your approach if your server is slow? 5. My query ran properly till yesterday and today it is taking much time then how do you troubleshoot? 6. If msdb crashes then what happened, How do u resolved? 7. What is Primary key Violation? Thank you in Advance.
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..?
Hi Ratnakar, Sorry for the delayed response. Here I am giving basic details about Locking; there is a lot to learn about locking. Remember I am not talking about ISOLATION LEVELS. Below examples considers the default ISOLATION level “READ COMMITTED” Locking: Lock: Basically when we talk about relational database, data is stored in tables. Internally a Table is represented using Pages. A lock is a memory structure which is issued by a transaction / session on a resource. Here the resource might be a Table / Page / Row / Index etc. There are basically 3 types of locks that… Read more »
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.
Hi Jagan, i have a document which i have prepared for one of the enterprise environment and i am not supposed to share. But you can get plenty of templetes , seek on google. Make sure the document should be able to answer below questions: 1. Purpose 2. POC: point of contact if backup failed if backup required from archieve 3. Full bkp policy : What is backup retention policy 4. Sla: Service Level Agreement 5. Backup Type 6. Storage Type 7. Backup Procedure 8. Backup validation / Backup check periodic 9. Sripts code and location 10. Max and min… Read more »
Thank you uday, Thank for ur support.
How to know the number of instances present in a machine with T-SQL query..?
Hi Ratnakar, I am really not sure how to get number of instances from T-SQL. We can do it using SQLCMD or from T-SQL XP_CMDSHELL. But we are not supposed to do that as it’s a security concern. There are 3 ways that we can get the instance details 1. SQLCMD – L or OSQL -L will give you all sql instances in your network. 2. Powershell script 3. Registry values But remember these might be different for different kind of instances (32 bit and 64 bit). Earlier we had a situation to prepare a server and database inventory and… Read more »
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
Ramesh, Usually for 6 years experienced candidate is expected to aware of all DBA concepts and must be expert in one or two areas. When you apply for SQL DBA position below are the top areas you should concentrate on: 1. SQL DBA Basic issues: (How to find and Resolve) Connectivity issues: Ex: Port number issues, Browser Service, Cross Domain issues etc Log Full issues Tempdb full issues Blocking / Deadlocks How to troubleshoot a failed job Different types of error logs Installation Failures Migration Types – Side by Side 2. High-Availability Issues and Resolution: Always-On Clustering Replication Log shipping… Read more »
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
Dear Jagadeesh, For 6+ years of experience on MSBI, please be prepared for below topics: 1. SSIS basic architecture theoretical questions 2. Components in SSIS engine 3. New features added in 2012 / 2014 4. Differences between SSIS components 5. Scenario Based Questions Ex 1: How do you design a SSIS package to read data from an excel file and while loading first 5 lines should be skipped. Ex 2: How do you design a SSIS package to read data from a web service and do an incremental load into database, the package should support N number of web URL… Read more »
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 .
Hi Manish, You didn’t mention why you need a switch from the current position. If it’s not mandatory to jump from the current place then I would strongly suggest to continue with the current position at least for the next one year. There are reasons behind that when you observe the corporate world then most of the MNC’s consider people with 2 years experience as a trainee and there will be no much difference between a fresher and trainee. Or if it’s a mandate situation that you need a move now then try to build a proper resume. There is… Read more »
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
DBA’s role has been changing from day to day, in early days DBA used to be responsible for taking ownership of a specific RDBMS (SQL Server / Oracle / DB2 / MySQL etc.) and handling all database administrative activities but now a DBA should be able to drive the show, he / she should be expertise in database administration and should know something about everything. Let me clarify the statement, let’s say you are working as a DBA and supporting an application stack which involves a lot of sub applications, web-services, multiple RDBMS, different layers of data processing and all… Read more »
While practising i try to set up back up job from SQ Agent .
and i am getting the following message . i am new persn. can u help
Job ‘Full BackUp of AdvWorks’ : Step 1, ‘Full BKP’ : Began Executing 2018-04-03 17:03:00
Msg 916, Sev 14, State 1, Line 1 : The server principal “WinLogin” is not able to access the database “AdventureWorks”
under the current security context. [SQLSTATE 08004]
Apologizing for the delayed response, hope the problem got resolved. if not you can reach me on my email.