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
5 database subjects I'm researching
08 February,2016 by Tom Collins
There is no excuse for not expanding the DBA knowledge base. Automation is massivley changing DBA work. The primary goals is still data integrity and access to data, but data sets are growing which requires a extension of skills
1.NoSQL. Over the last couple of years I've seen products introduced into companies with ONLY a NoSQL option. It used to be you'd get multiple RDBMS options. How will NoSQL proceed.Will NoSQL progress into ACID? There are applications which require a key-value representation . How does the DBA deal with NoSQL?
2.InMemory - OLTP - It's in it's infancy , but with the performance improvements I've seen , it's got massive potential. I initially became interested during TechEd 2013
3.Cloud - automation,auto install, patching , template builds. Bring it on! The less of these tasks you're manually completing , the better you are at your job. How can I utilise the Cloud , particuarly template builds to make my life easier? Spending more time on value - added tasks is the way to progress.
Cloud is not answer to all our problems . Database servers are unique - security, intensive processing , statefulfulness (failure will not be tolerated)
4.Columnstore indexes - Initially when I played around with Columnstore indexes in sql server 2012 - I saw it as a non clustered index sitting on top of a table. But since 2014 - I've seen the compression \ performance benefits. I'm starting to work on various projects with Columnstore index
5.We manage data , not Servers . A change in mindset . In practical terms more knowledge on : Retention, ETL,Datawarehouses,data analytics databases as a service, reporting.
Underlying these skills are still deep technical knowledge. for example, analytics may be underpinned by modelling and the modelling requires intensive processing . Data sets are getting bigger - which introduces it's own set of technical challenges.
What are your data needs? - SQL Server DBA - Sqlserver-dba.com
SQL Server – DBA Skills Growth Areas - Sqlserver-dba.com
How to go from New DBA to Advanced 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: |