Monday, January 1, 2018

DevOps for Databases

Today is the first day of 2018 in which I was expecting edx.org to release a set of Microsoft courses mostly in DevOps and SQL servers. Microsoft created the database DevOps course in collaboration with its partner RedGate and the course seems to have a very high quality.


I started a new job in mid 2017. My new job requires working with the Microsoft Stack and specifically SQL Server. I have been looking for a solution to increase my team's efficiency and quality in the past six months.


It has been particularly challenging because our main software is a large set of interconnected stored procedures that are not appropriately documented. Changes are committed to production which make it risky to develop and release features quickly. My team inherited this environment from at start-up within the company and the original team's focus had been primarily on fast growth.


I intend to finish the database DevOps course from Microsoft and apply its concepts to my workplace. I will post here more often as I go through this journey.


Following is an incomplete set of newly released Microsoft courses I have bookmarked:

  1. Machine Learning
    1. Reinforced Learning
    2. Professional Program in Big Data
  2. DevOps
    1. Professional Program in DevOps
  3. SQL Server
    1. SQL Server Database Development
    2. Data Cleansing with Data Quality Services (DQS)
    3. SQL Server Database Administration
      1. Managing SQL Server Operations
      2. & Others
    4. Implementing ETL with SQL Server Integration Services (SSIS)
    5. Querying Data with Transact-SQL
  4. Ethics &  Law in Data Analytics
  5. Programming
    1. Data Access in C# and .NET Core

DevOps for Databases

Today is the first day of 2018 in which I was expecting edx.org to release a set of Microsoft courses mostly in DevOps and SQL servers. Mic...