[Comments] Certifications and learning

[chadbaldwin]

https://chadbaldwin.net/2021/01/31/certifications-and-learning.html

[MyKarpenko]

There is one more exam. Azure DP-300
https://docs.microsoft.com/en-us/learn/certifications/exams/dp-300

[dmilius]

Of all the topics that you recently learned about in this cert process, which topic do you think will benefit you the most in your day-to-day work?

[chadbaldwin]

@dmilius The two most beneficial things I've been able to apply so far are...

1. Index tuning...how to build and use indexes properly. I roughly knew how to use indexes, and how to make them...but not how to do it properly (column order, sort order, B-tree structure, key columns vs include columns).

2. Isolation levels...how each one works, their pros and cons, pessimistic vs optimistic locking, how to prevent locking and deadlocks. Really looking forward to playing with RCSI.

Just in the last month, I've significantly changed how I write stored procedure code, and my process in how I test and tune queries.

I think once I'm able to work around 2016+ servers that columnstore indexes and in-memory OLTP (with natively compiled stored procedures) could be a huge benefit.

[francesco1119]

I did the same and I was able to archive MCSA: SQL Server 2012/2014 before the 31 of January. I was so relieved.

[chadbaldwin]

@francesco1119 nice job!