Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- 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.
- SQL Agent Last Modified explanation
- Sql certificate chain was issued by an authority that is not trusted
- sqlserver-dba.com switching from feedburner to follow.it
- Taking transaction log backup and full back at the same time
Simple Ideas to improve the life of a DBA
07 April,2017 by Tom Collins
It’s Friday afternoon , and I’m just preparing for a relaxed weekend. Hopefully. There’s always the possibility of a call-out but that’s the life I’ve chosen with a Career in DBA
There are big moves across organisations to handle bigger data and start justifying the costs of IT. “Why are we spending all this money and not making processes less expensive?”
Not all changes need to be monumental. In fact , some changes can be just a readjustment of focus . Here are some example of ideas that would make my life easier as a DBA.
- Make the developers more accountable for the code they are writing. Alerting should have a process to escalate straight to the developer. Very often a DBA is left with the responsibility of hacking code written by developers . Think of how to change alerting and escalation to developers
- Developers and DBAs should work closer. A DBA should understand the developer challenges and a Developer should become involved in the DBA responsibilities.
- Companies should invest more on DBA training. Data sets are getting bigger, deployments need to be more automated, self service, the list goes on.. All these requirements require a deeper set of skills while enhancing the classic DBA skills. Focus on the DBA basics with the 95 - 5 rule
- Consider Remote DBA services – Can be an effective and focused way of getting some temporary assistance – without the overhead of a full time DBA.Outsourcing DBA tasks to an Offshore IT company
5. Send DBAs to more labs, conferences etc. Expand the DBA mind. Here are some lessons I learnt at TecheEd 2013 - it's interesting how may of the ideas are now mainstream .TechEd Europe 2013 lessons learnt - SQL Server DBA
6. Recognise a DBA job is stressful and develop a culture of working productively . One habit to develop is to measure activity .It is far easier to argue for changes if you have statistics at your fingertips.
7. Reassess signal to nose ratio on alerts , are all the alerts useful?Does everything need to be alerted ? Consider differentiating between alerts and reporting Database server : Monitoring versus reporting
Read More
5 tricks to boost DBA productivity (SQL Server DBA)
Sushi , daily habit, productivity and DBA - SQL Server DBA
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: |