Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- How to get SQL Server Explicit Permssions for a Server Principal
- How to use Extended Events to report Query errors
- The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
- How to find privilege changes with SQL Server Default Trace
- sys.dm_server_services - How to check if SQL Server service is running or not?
- Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
- Can we restore a database to an older version in SQL Server?
- How do I save all SQL Agent Jobs
- How to view SQL Server mount point space without access to server
- DBCC SHRINKFILE: page could not be moved because it is a work table page.
Interview with Author on essential SQL
23 December,2014 by Tom Collins
Kris Wenzel is a SQL geek. He’s written some excellent guides to learning SQL . The guides are notable for the plain English used.
Kris started a series of interviews on his site. He interviews individuals who are involved in the SQL community. He asked me the following five questions.
Questions during the SQL Server DBA Interview
- What is some advice you would give someone that wanted to become a DBA?
- I noticed that you like to optimize databases. What are some tools and techniques a junior DBA can use to troubleshoot a poorly performing database? As a follow-on, are the any books or online resources you recommend they can use to learn more about optimization?
- SQLServer has added many new features over the years. Do you feel these newer features, some which make it easier to write SQL, are less efficient that doing it the long way? For instance, would you use the INTERSECT operator for convenience over the INNER JOIN method for speed?
- What is one of the biggest frustrations you see junior DBA have with SQLServer? Do you have any suggestions to help them overcome these?
- Do you have any advice for people that want to start a career as a DBA? For instance, are certifications a must?
It was a pleasure answering the questions . Read the answers on essential SQL – http://www.essentialsql.com/interview-with-jack-vamvas/
Read More on how to grow as a DBA
Top 10 DBA Tips to develop your competitive edge
DBA Ignorance , complacency and arrogance experiment
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |