{"id":14039,"date":"2019-11-27T08:29:29","date_gmt":"2019-11-27T08:29:29","guid":{"rendered":"https:\/\/dbtut.com\/?p=14039"},"modified":"2019-11-27T11:13:46","modified_gmt":"2019-11-27T11:13:46","slug":"sql-server-database-administrators-roadmap","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/","title":{"rendered":"SQL Server Database Administrator&#8217;s Roadmap"},"content":{"rendered":"<p>In this article, I will describe the <strong>tasks<\/strong> and <strong>responsibilities<\/strong> of &#8220;<strong>SQL Server Database Administrator<\/strong>&#8220;.\u00a0 I will link to articles about how each item can be performed. In this way, I want this article to be <strong>a guide for new database administrators<\/strong>.<\/p>\n<p><strong>1)<\/strong>\u00a0 Operating System Logs and SQL Server logs must be checked daily and intervened if there is an unusual error. You can find details in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/13\/how-to-check-sql-server-error-logs-and-operations-system-logs\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Check SQL Server Logs and Operationg System Logs<\/a>&#8220;.<\/p>\n<p><strong>2)\u00a0<\/strong> It should be checked if the Scheduled jobs are working correctly. You should configure the jobs to send e-mail to database administrators when jobs failed. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/14\/how-to-send-an-email-after-failed-jobs\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Send Email After Failed Jobs<\/a>&#8220;.<\/p>\n<p><strong>3)<\/strong>\u00a0 You should check whether databases are successfully backed up and send it as an email to the dba team if there is a failed backup. To send email from SQL Server you must configure Database Mail. You may want to read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/07\/how-to-configure-database-mail-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Configure Database Mail On SQL Server<\/a>&#8220;<\/p>\n<p><strong>4)<\/strong>\u00a0 The databases must always be backed up to a different location. Because if the server becomes inaccessible, you should be able to access your backups from a different source and restore to a new environment.<\/p>\n<p><strong>5)\u00a0<\/strong> Once a month, you need to test that your backups can be restored. So, you can sure that your backups is healty. For more information about Backup and Restore, read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/22\/backup-restore-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Backup Restore On SQL Server<\/a>&#8220;.<\/p>\n<p><strong>6)<\/strong>\u00a0 You should check disk free space regulary so that the database can grow up in a healthy way. I recommend to create a SQL Server job to check disk free space regularly. This job may send a mail to the DBAs. You can also use a third party application for this.<\/p>\n<p><strong>7)<\/strong>\u00a0 You should monitor the system and check database performances throughout the day.(locks, deadlocks, long running queries, disk response times etc) You can use thirdparty dashboard tools for monitoring. There is many free monitoring dashboard tools on github.<\/p>\n<ul>\n<li>You can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/01\/data-collector-management-data-warehouse-perfmon\/\" target=\"_blank\" rel=\"noopener noreferrer\">Data Collector, Management Data Warehouse, Perfmon<\/a>&#8221; to monitor your system and create a baseline.<\/li>\n<li>You can also read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/22\/how-to-see-current-queries-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To See Current Queries On SQL Server<\/a>&#8221; in order to follow the current running queries.<\/li>\n<li>You can also read articles &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/13\/how-to-identify-long-running-queries-using-extended-events\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Identify Long Running Queries Using Extended Events<\/a>&#8221; or &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/12\/how-to-identify-long-running-queries-using-sql-server-profiler\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Identify Long Running Queries Using SQL Server Profiler<\/a>&#8221; to monitor long running queries in the database.<\/li>\n<li>You can read &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/30\/how-to-monitor-sql-server-with-utility-control-point\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Monitor SQL Server With Utility Control Point<\/a>&#8221; to monitor CPU and Disk Usage of SQL Server Databases.<\/li>\n<\/ul>\n<p><strong>8)<\/strong>\u00a0 Alerts should be created for potential problems and the system should be configured to send mail to database administrators. In order to create the necessary alerts, you can run the script that I specified in my article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/09\/sql-server-best-practices-and-configurations-that-need-to-be-made-after-installation\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Best Practices and Configurations that need to be made After Installation<\/a>&#8220;. In addition, if you write alerts in the Search section of our web site, you can also access other articles about alerts.<\/p>\n<p><strong>9)\u00a0<\/strong> Database should be created in accordance with the needs. Creating a database is not a right-click. I recommend reading &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/01\/how-to-create-a-database-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create a Database On SQL Server<\/a>&#8221; for the correct database design.<\/p>\n<p><strong>10)<\/strong> Before upgrading the production environment, you must test upgrade operation in the test environment. After the upgrade, you should make sure that the applications are working correctly. In addition you should use Database Migration Assistant to check whether the database is suitable for upgrade.<\/p>\n<p>I usually upgrade by installing a new instance. I transfer the databases one by one to the new instance I have installed and perform their tests first. In this way, if a problem occurs in tests, I quickly redirect applications to the database on the old instance. So I minimize the risks. Not everyone has that chance. If you don&#8217;t have such a chance, you should create a scenario for yourself\u00a0 and test it. For detailed information about the new installation, please refer to the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/09\/how-to-install-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Install SQL Server<\/a>&#8220;.<\/p>\n<p><strong>11)<\/strong> Database servers must be located in a physically secure environment. Some system engineer friends might be angry at what I said. But I had serious problems in virtual environments. Nowadays, technologies such as dockers, kubernetes are famous. But I still think that the database should be located in physical environments. :))<\/p>\n<p><strong>12)<\/strong> Be sure to use HA (High Availaiblity) solutions in your database systems. In this way, you can prevent unexpected server errors, disk errors. In addition, thanks to HA solutions, you can perform upgrade or maintainance operations without interruption. I prefer SQL Server Always On Failover Cluster as HA and SQL Server Always On Availability Groups as DR. For detailed information about HA (High Availaiblity), you can search related articles in our web site by typing High Availability in Search section.<\/p>\n<p>Especially, I recommend reading the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/11\/difference-between-always-on-failover-cluster-database-mirroring-always-on-availability-group-replication-and-log-shipping\/\" target=\"_blank\" rel=\"noopener noreferrer\">Difference Between Always On Failover Cluster, Database Mirroring, Always On Availability Group, Replication and Log Shipping<\/a>&#8220;.<\/p>\n<p><strong>13)<\/strong> Database servers and application servers should not be in the same vlan! If they are in the same Vlan, this means that you&#8217;ll be bypassing firewall. So it won&#8217;t be safe. There must be firewall between application servers and database servers and application servers must be able to access the database servers only from certain ports.<\/p>\n<p><strong>14)<\/strong> The number of sysadmin should be minimized.\u00a0 You can access the script that returns detailed results about authorizations from the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/15\/how-to-check-user-privileges-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Check User Privileges in SQL Server<\/a>&#8220;.<\/p>\n<p><strong>15)<\/strong> Users should be authorized only as much as they need. If the application only needs read, write, and execute privileges, the db_owner privilege should not be granted. This is because someone who is granted the db_owner privilege can also back up your database. The user who backs up can crash your system because he does not know how much space is available on which disk. You can read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/18\/how-to-deny-backup-to-database-owners-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Deny Backup to Database Owners in SQL Server<\/a>&#8220;.<\/p>\n<p><strong>16)<\/strong> For all database users, there must be strong password usage criteria. Strong passwords must be guaranteed with policies on Windows. You can find detailed information in my articles named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/08\/security-policy-for-sql-server-secpol-msc\/\" target=\"_blank\" rel=\"noopener noreferrer\">Security Policy for SQL Server(secpol.msc)<\/a>&#8220;, &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/09\/sql-server-password-policy\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Password Policy<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/17\/sql-server-account-lockout-policy\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Account Lockout Policy<\/a>&#8220;.<\/p>\n<p><strong>17)<\/strong> Users who have not logged in for a long time must be deleted in contact with the owner. Using Logon Trigger, you can create a job that will transfer users connecting to the sql server to a table. I explained in detail how to do this in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/02\/sql-server-trigger-types\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Trigger Types<\/a>&#8220;.<\/p>\n<p><strong>18)<\/strong> The database server must not be open to the Internet! This is the most basic safety principle.<\/p>\n<p><strong>19)<\/strong> A licensed virus program must be installed on the database server. An exception must be defined in the virus program for paths that contain database files. If you do not define an exception, the performance of your database will be slow and risky.<\/p>\n<p><strong>20)<\/strong> Maintenance should be done periodically. You can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/16\/sql-server-maintenance\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Maintenance<\/a>&#8220;. You can also access Maintenance-related articles by writing Maintenance Plan in the search section of our web site.<\/p>\n<p><strong>21)<\/strong> At regular intervals, queries that use the CPU and disk much should be identified and necessary improvements should be performed. You can access related queries from my article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/19\/how-to-find-most-expensive-queries-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Most Expensive Queries in SQL Server<\/a>&#8220;<\/p>\n<p><strong>22)<\/strong> Missing indexes in the system should be checked periodically and created if necessary. See the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/21\/how-to-find-missing-indexes-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Missing Indexes in SQL Server<\/a>&#8220;.<\/p>\n<p><strong>23)<\/strong> Unused indexes and tables should be removed in contact with the application developer. You can read the articles &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/23\/how-to-find-unused-indexes-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Unused Indexes in SQL Server<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/24\/how-to-find-unused-tables-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Unused Tables in SQL Server<\/a>&#8220;.<\/p>\n<p><strong>24)<\/strong> Creating Index is not always good. For example, there are 4 columns in the table and SQL Server recommends to create an index for 3 columns. This is already the same thing as recreating the table. Such an index should not be created. In addition, if too many indexes are created, inserts, updates and deletes may slow down. Before creating an index, I recommend reading &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/12\/index-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Concept and Performance Effect On SQL Server<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/13\/statistic-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Statistic Concept and Performance Effect On SQL Server<\/a>&#8220;.<\/p>\n<p><strong>25)<\/strong> A primary key should be defined in each table and this primary key should be on the most commonly used unique column. If possible it should be an integer colum. Tables without a Primary Key should be identified and reported to the application developer. You can benefit from the articles &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/14\/what-is-primary-key-and-foreign-key\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Primary Key and Foreign Key<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/16\/differences-between-primary-key-and-unique-constraint\/\" target=\"_blank\" rel=\"noopener noreferrer\">Differences Between Primary Key and Unique Constraint<\/a>&#8220;.<\/p>\n<p><strong>26)<\/strong> For queries with a high number of execution count, all columns in the Select, Where\u00a0 or Join can be defined on the index. In this way, the query will reach all the data from the index without accessing the actual data in the table.\u00a0 This reduce I \/ O and improves performance. This type of index is called covering index. You should also look at the columns in ORDER BY and GROUP BY. I recommend reading the following articles for details.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/06\/12\/index-concept-and-performance-effect-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Index Concept and Performance Effect On SQL Server<\/a>&#8220;<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/30\/create-index-on-the-order-by-columnascdesc\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create Index on the Order By Column(ASC,DESC)<\/a>&#8220;<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/01\/create-index-on-the-group-by-column\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create Index On the GROUP BY Column<\/a>&#8220;<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/29\/create-index-on-join-columns\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create Index On Join Columns<\/a>&#8220;<\/p>\n<p><strong>27)<\/strong> You should be careful while determining the size of the columns in the tables. If you create columns with unnecessary sizes, this will cause unnecessary I \/ O. Also, appropriate data types will prevent unnecessary growth of the table. See the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/13\/sql-server-data-typestsql\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Data Types<\/a>&#8220;.<\/p>\n<p><strong>28)<\/strong> Before you can use Query Hint, you need to make sure that the operation you are performing gives the result you want. Because, you force SQL Server to change its normal behavior by using query hint. The query hint can improve performance but also reduce it. Therefore, query hint should not be used without fully testing the results.<\/p>\n<p>Microsoft gives a warning for query hints:<\/p>\n<p><em>&#8220;Because SQL Server typically chooses the best execution plan, use query hints only as a last resort.&#8221;<\/em><\/p>\n<p>You can find examples of query hints in the following article.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/05\/10\/query-hints-in-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Query Hints in SQL Server<\/a>&#8220;<\/p>\n<p><strong>29)<\/strong> It is more useful to use Stored Procedure instead of adhoc query.<\/p>\n<p>You can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/18\/spstored-procedure-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sp(Stored Procedure) On SQL Server<\/a>&#8220;<\/p>\n<p>In some cases,\u00a0 if you are using stored procedures, parameter sniffing occurs. You can read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/20\/what-is-paramater-sniffing\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Parameter Sniffing<\/a>&#8221; for the solution.<\/p>\n<p><strong>30)<\/strong> When writing SQL code, comments about the content of the code should be written in the code. Thus, everyone can understand what this code do.<\/p>\n<p><strong>31)<\/strong> When using the UNION statement, you should look for duplicate records. Because UNION reduces duplicated lines to a single line. If there are duplicated records in the result set and the application does not need duplicated records, UNION can be used, otherwise UNION ALL will be required. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/14\/union-and-union-all-operators-in-sql-servertsql\/\" target=\"_blank\" rel=\"noopener noreferrer\">UNION and UNION ALL Operators in SQL Server(TSQL)<\/a>&#8221; for details and the use of UNION and UNION ALL.<\/p>\n<p><strong>32)<\/strong> When using the select statement, only the required columns should be selected. Some application developers select all columns(select * from) and this causes to unnecessary I \/ O and performance loss.<\/p>\n<p><strong>33)<\/strong> Where condition must be added to the Select statement as needed. When the filter is added, only the needed result set will be returned. This prevent unnecessary I \/ O. You can also improve the performance of the query by adding indexes on the columns in the where condition.<\/p>\n<p><strong>34)<\/strong> Negative expressions such as &#8220;&lt;&gt;&#8221;, &#8220;!=&#8221;, &#8220;!&gt;&#8221;, &#8220;!&lt;&#8220;, &#8220;NOT IN&#8221;, &#8220;NOT LIKE&#8221; should not be used if possible in your queries when using Where condition. Because a query written with these statements can cause table scan instead of using index. For example, you can use LEFT JOIN instead of NOT IN.<\/p>\n<p><strong>35)<\/strong> You must configure SQL Server after installation. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/09\/sql-server-best-practices-and-configurations-that-need-to-be-made-after-installation\/\" target=\"_blank\" rel=\"noopener noreferrer\">SQL Server Best Practices and Configurations that need to be made After Installation<\/a>&#8220;.<\/p>\n<p><strong>36)<\/strong> You can define application servers as login so that no password is specified within the application(webconfig). Thus, you can monitor the users other than the application user with audit. You can find the details in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/18\/create-server-logindo-not-type-a-password-in-web-config\/\" target=\"_blank\" rel=\"noopener noreferrer\">Create Server Login(Do not type a password in web config)<\/a>&#8220;.<\/p>\n<p><strong>37)<\/strong> You should definitely monitor the users other than the application user with the audit. You can find the details in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/11\/12\/how-to-create-sql-server-audit\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create SQL Server Audit<\/a>&#8220;.<\/p>\n<p><strong>38)<\/strong> Each database administrator must know how to connect to the database with a DAC when they cannot connect to SSMS or to the database server. You can find details in the article&#8221;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/24\/dacdedicated-administrator-connection-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">DAC(Dedicated Administrator Connection) On SQL Server<\/a>&#8220;.<\/p>\n<p><strong>39)<\/strong> Each database administrator must know how to connect to SQL Server from the cmd command line when necessary. You may be interested in the article&#8221;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/22\/how-to-connect-to-sql-server-from-cmd-command-line\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Connect To SQL Server From cmd command line<\/a>&#8220;.<\/p>\n<p><strong>40)<\/strong> If you are using Always On Availability Group, you must have an alert system. You may read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/06\/always-on-availability-group-alert-system\/\" target=\"_blank\" rel=\"noopener noreferrer\">Always On Availability Group Alert System<\/a>&#8221; to create an alert system for Always On Availability Group.<\/p>\n<p><strong>41)<\/strong> If you do not specify a path when creating a database, your database is created in the default paths that you specify in the installation. You may be interested in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/20\/how-to-change-default-paths-of-the-data-and-log-files\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Change Default Paths of the Data and Log Files<\/a>&#8220;.<\/p>\n<p><strong>42)<\/strong> The Recovery Model of the database plays a critical role in database management. You may want to read &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/26\/what-is-database-recovery-model\/\" target=\"_blank\" rel=\"noopener noreferrer\">What is Database Recovery Model<\/a>&#8221; and &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/05\/30\/how-to-change-the-database-recovery-model\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Change the Database Recovery Model<\/a>&#8220;<\/p>\n<p><strong>43)<\/strong> You must find the tables that need partition and create partitions if necessary. You may want to read below articles.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/10\/how-to-create-partition-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Create Partition On SQL Server<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/19\/sliding-window-switch-partition-split-range-merge-range\/\" target=\"_blank\" rel=\"noopener noreferrer\">Sliding Window-Switch Partition-Split Range-Merge Range<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/11\/how-to-find-partitioned-tables-in-the-database-on-sql-server\/\" target=\"_blank\" rel=\"noopener noreferrer\">How To Find Partitioned Tables In The Database On SQL Server<\/a>&#8220;<\/p>\n<p><strong>44)<\/strong> a good database administrator should also be a good sql developer. You can find many articles about TSQL in the link &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/category\/mssql\/tsql\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/dbtut.com\/index.php\/category\/mssql\/tsql\/<\/a>&#8220;<\/p>\n<p>Actually, these items are not enough to be a database administrator. But I thought it would be a good road map to start with. After reading the articles here, I recommend you to follow the articles on our web site in order. Almost all articles on our website consist of real scenarios.<\/p>\n<p>If you want to know about SQL Server History and comparison with Other Relational Database Management Systems you may want to read the below article.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/22\/about-sql-server-and-comparison-with-other-relational-database-management-systems\/\" target=\"_blank\" rel=\"noopener noreferrer\">About SQL Server and Comparison with Other Relational Database Management Systems<\/a>&#8220;<\/p>\n\n\n<div class=\"pvc_clear\"><\/div><p id=\"pvc_stats_14039\" class=\"pvc_stats all  \" data-element-id=\"14039\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p><div class=\"pvc_clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In this article, I will describe the tasks and responsibilities of &#8220;SQL Server Database Administrator&#8220;.\u00a0 I will link to articles about how each item can be performed. In this way, I want this article to be a guide for new database administrators. 1)\u00a0 Operating System Logs and SQL Server logs must be checked daily and &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14039\" class=\"pvc_stats all  \" data-element-id=\"14039\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14041,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[6242,6381,6342,6378,6383,6343,6366,6356,6373,6371,6345,6349,6377,6380,6341,6374,6376,6375,6346,6364,6348,6379,6354,6365,6360,6355,6362,6352,6369,6359,6372,6350,6347,6361,6363,6367,6358,6357,6344,6368,6351,6370,6353],"class_list":["post-14039","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-audit-dba-roles","tag-database-administrator-guide","tag-database-administrator-roadmap","tag-database-administrator-roles-and-responsibilities","tag-dba-guide","tag-dba-roadmap","tag-hat-is-dba-and-its-responsibilities","tag-how-can-i-become-a-database-administrator","tag-how-can-i-learn-sql-dba","tag-how-do-i-become-a-dba","tag-how-long-does-it-take-to-learn-database-administration","tag-key-responsibilities-of-database-administrators","tag-roles-and-responsibilities-of-sql-dba","tag-sql-dba-tasks","tag-sql-server-database-administrator-roadmap","tag-sql-server-dba-job-description","tag-sql-server-dba-responsibilities-and-roles","tag-the-key-responsibilities-of-a-database-administrator","tag-what-are-database-skills","tag-what-are-dba-tasks","tag-what-are-five-main-functions-of-a-database-administrator","tag-what-are-sql-server-dba-responsibilities","tag-what-are-the-daily-activities-of-sql-server-dba","tag-what-are-the-main-functions-of-dba","tag-what-are-the-responsibilities-of-database-designer","tag-what-are-the-responsibilities-of-dba-and-database-designers","tag-what-are-the-role-and-responsibilities-of-dba","tag-what-are-the-skills-required-for-database-administrator","tag-what-are-the-skills-required-for-sql-dba","tag-what-do-database-administrators-do","tag-what-do-you-mean-by-dba","tag-what-does-a-dba-do-all-day","tag-what-does-database-admin-do","tag-what-is-a-dba-what-kinds-of-responsibilities-does-a-dba-have-in-a-database-environment","tag-what-is-a-sql-dba","tag-what-is-dba-and-its-responsibilities","tag-what-is-sql-dba-role-and-responsibility","tag-what-is-sql-dba","tag-what-is-sql-server-database-administration","tag-what-should-a-dba-know","tag-what-skills-do-database-administrators-need","tag-what-skills-does-a-dba-need","tag-where-can-a-database-administrator-work"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Database Administrator&#039;s Roadmap - Database Tutorials<\/title>\n<meta name=\"description\" content=\"SQL Server Database Administrator&#039;s Roadmap\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Database Administrator&#039;s Roadmap - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"SQL Server Database Administrator&#039;s Roadmap\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-27T08:29:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-11-27T11:13:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png\" \/>\n\t<meta property=\"og:image:width\" content=\"557\" \/>\n\t<meta property=\"og:image:height\" content=\"366\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"SQL Server Database Administrator&#8217;s Roadmap\",\"datePublished\":\"2019-11-27T08:29:29+00:00\",\"dateModified\":\"2019-11-27T11:13:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\"},\"wordCount\":2398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png\",\"keywords\":[\"audit DBA Roles\",\"database administrator guide\",\"Database Administrator Roadmap\",\"Database Administrator Roles and Responsibilities\",\"dba guide\",\"DBA Roadmap\",\"hat is DBA and its responsibilities?\",\"How can I become a database administrator?\",\"How can I learn SQL DBA?\",\"How do I become a DBA?\",\"How long does it take to learn database administration?\",\"key responsibilities of database administrators\",\"roles and responsibilities of sql dba\",\"SQL DBA Tasks\",\"SQL Server Database Administrator Roadmap\",\"SQL Server DBA Job Description\",\"SQL Server DBA Responsibilities and Roles\",\"The Key Responsibilities of a Database Administrator\",\"What are database skills?\",\"What are DBA tasks?\",\"What are five main functions of a database administrator?\",\"What are SQL Server DBA Responsibilities?\",\"What are the daily activities of SQL Server DBA?\",\"What are the main functions of DBA?\",\"What are the responsibilities of database designer?\",\"What are the responsibilities of DBA and database designers?\",\"What are the role and responsibilities of DBA?\",\"What are the skills required for database administrator?\",\"What are the skills required for SQL DBA?\",\"What do database administrators do?\",\"What do you mean by DBA?\",\"What does a DBA do all day?\",\"What does database admin do?\",\"What is a DBA What kinds of responsibilities does a DBA have in a database environment?\",\"What is a SQL DBA?\",\"What is DBA and its responsibilities?\",\"What is SQL DBA role and responsibility?\",\"What is SQL DBA?\",\"What is SQL Server database administration?\",\"What should a DBA know?\",\"What skills do database administrators need?\",\"What skills does a DBA need?\",\"Where can a database administrator work?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\",\"name\":\"SQL Server Database Administrator's Roadmap - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png\",\"datePublished\":\"2019-11-27T08:29:29+00:00\",\"dateModified\":\"2019-11-27T11:13:46+00:00\",\"description\":\"SQL Server Database Administrator's Roadmap\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png\",\"width\":557,\"height\":366},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Database Administrator&#8217;s Roadmap\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Database Administrator's Roadmap - Database Tutorials","description":"SQL Server Database Administrator's Roadmap","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Database Administrator's Roadmap - Database Tutorials","og_description":"SQL Server Database Administrator's Roadmap","og_url":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/","og_site_name":"Database Tutorials","article_published_time":"2019-11-27T08:29:29+00:00","article_modified_time":"2019-11-27T11:13:46+00:00","og_image":[{"width":557,"height":366,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"SQL Server Database Administrator&#8217;s Roadmap","datePublished":"2019-11-27T08:29:29+00:00","dateModified":"2019-11-27T11:13:46+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/"},"wordCount":2398,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png","keywords":["audit DBA Roles","database administrator guide","Database Administrator Roadmap","Database Administrator Roles and Responsibilities","dba guide","DBA Roadmap","hat is DBA and its responsibilities?","How can I become a database administrator?","How can I learn SQL DBA?","How do I become a DBA?","How long does it take to learn database administration?","key responsibilities of database administrators","roles and responsibilities of sql dba","SQL DBA Tasks","SQL Server Database Administrator Roadmap","SQL Server DBA Job Description","SQL Server DBA Responsibilities and Roles","The Key Responsibilities of a Database Administrator","What are database skills?","What are DBA tasks?","What are five main functions of a database administrator?","What are SQL Server DBA Responsibilities?","What are the daily activities of SQL Server DBA?","What are the main functions of DBA?","What are the responsibilities of database designer?","What are the responsibilities of DBA and database designers?","What are the role and responsibilities of DBA?","What are the skills required for database administrator?","What are the skills required for SQL DBA?","What do database administrators do?","What do you mean by DBA?","What does a DBA do all day?","What does database admin do?","What is a DBA What kinds of responsibilities does a DBA have in a database environment?","What is a SQL DBA?","What is DBA and its responsibilities?","What is SQL DBA role and responsibility?","What is SQL DBA?","What is SQL Server database administration?","What should a DBA know?","What skills do database administrators need?","What skills does a DBA need?","Where can a database administrator work?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/","url":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/","name":"SQL Server Database Administrator's Roadmap - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png","datePublished":"2019-11-27T08:29:29+00:00","dateModified":"2019-11-27T11:13:46+00:00","description":"SQL Server Database Administrator's Roadmap","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-85.png","width":557,"height":366},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/11\/27\/sql-server-database-administrators-roadmap\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server Database Administrator&#8217;s Roadmap"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14039"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14039\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14041"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14039"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14039"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}