Passed my Microsoft DA-100 exam. I will try to get certifications for #M365 and #OCI next time. #Azure #MCP

Design Point 1 [Public Cloud] Public clouds need to be designed on the assumption that they will stop (not 100% SLA). #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Design Point 2 [Public Cloud] For applications that connect to high-availability services such as databases, retry processing should be implemented to enable error handling. For retry logic, exponetial backoff is effective. #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Design Point 2-1 [Public Cloud] Exponential back off is a logic that gradually extends the retry interval. Recently, exponential back off + jitter may be popular. #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Design Point 2-2 [Public Cloud] jitter specifies a random time instead of extending the retry interval at equal intervals to prevent retry processing from many processes at the same time, thus balancing the load. #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Design Point 3 [Public Cloud] Consider implementing a circuit breaker. Add logic to treat subsequent requests as failures if number of retries are over threshold, thereby preventing the problem from spreading to normal processes. #cloud #CloudComputing #Azure #AWS #OCI #GCP

Design Point 4 [Public Cloud] Try to design a configuration using managed services (SaaS/PaaS) first. Replace those that do not meet your requirements/constraints with IaaS. #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Design Point 5 [Public Cloud] When migrating an existing system to the cloud, it's often the case that the cloud shift is made gradually from the cloud lift, but it's important to consider the future concept even before the cloud lift. (e.g., account integration/auth methods)

Design Point 6 [Public Cloud] Consider the SLA of the entire system. If you combine 99.99% + 99% of the services, the overall system uptime drops to 0.9899 = about 99%. #cloud #CloudComputing #business #Azure #AWS #OCI #GCP

Added "web" category to #Azure / #AWS / #GCP / #OCI service comparison chart. If there are any mistakes, I would be happy if you could point them out. nobtak.com/entry/sc01e

This blog summarizes how to resolve inconsistencies in #SQLServer database using the 'DBCC CHECKDB' command with REPAIR option. nobtak.com/entry/sqlb12en

This blog summarizes about memory management of #SQLServer. Please let me know if you have some questions. nobtak.com/entry/sqlb13en

#SQL Tuning Point 4 Do not use string functions or other functions in the search condition column of the conditional clause (WHERE) in the SELECT query. Anti-pattern : WHERE substring(YMD,1,4) = '2021' #dba #developer #SQLPerformance

#SQL Tuning Point 5 Do not specify local variables in the conditional clause (WHERE) of a SELECT query. (Rewrite them into parameterized query or stored Procedure.) Anti-patterns : declare Player1 int set Player1=10 select * from tab1 where c2=Player1 #dba #developer #SQLPerformance

#SQL Tuning Point 7 Ignore indexes on tables with small amounts of data, as they have no effect on performance even if the fragmentation rate is high. #dba #developer #SQLPerformance

#SQL Tuning Point 13 Consider specifying the recompile option for parameterized queries (stored procedures) when atypical parameters (values in a range not normally specified) are sometimes set, resulting in a suboptimal query execution plan. #dba #developer #SQLPerformance

#SQL Tuning Point 14 You should try to avoid using the 'NOT EXISTS' clause as much as possible, and consider whether you can be replaced by a 'JOIN' clause. #SQLPerformance

Added "Security" category to #Azure / #AWS / #GCP / #OCI service comparison chart. If there are any mistakes, I would be happy if you could point them out. nobtak.com/entry/sc01e #CloudComputing #MSCloud #Technology #cloud

I am pleased to receive the Microsoft MVP for Data Platform award this month. I will continue to post technical information. mvp.microsoft.com/en-us/PublicPr…