Tekoälystä on tullut osa arkeamme ja jokaiselle tärkeä kansalaistaito

 
Microsoft, Elisa ja Sulava tuovat yhdessä korkeakoulujen kanssa tekoälyosaamisen jokaisen suomalaisen ulottuville. 
 
Nyt jokaisella on mahdollisuus valjastaa tekoäly keventämään rutiineja, tukemaan oppimista ja vapauttamaan aikaa luo… Continue reading Tekoälystä on tullut osa arkeamme ja jokaiselle tärkeä kansalaistaito

Impact of Memory Grant Feedback on Azure SQL Managed Instance

Issue
Incorrect memory grants on certain queries can lead to extremely high CPU spikes in an Azure SQL MI. This is usually expected in high workload production Azure SQL MI systems that have high rate of query execution. The spike in CPU utilization al… Continue reading Impact of Memory Grant Feedback on Azure SQL Managed Instance

Lesson Learned #368: Connection Retry-Logic using ODBC API code

This week I had a service request where our customer didn’t have a connection retry logic implemented in their application code in the event of a connection failure to Azure SQL. I would like to share an example about how to implement it. 
 
Continue reading Lesson Learned #368: Connection Retry-Logic using ODBC API code

Lesson Learned #367: Query Antipattern and Ring Buffer in Azure SQL Database

A few days ago, a customer asked us how they could capture statistics changes that result in a new execution plan, receive a notification when queries have anti-patterns, or changes in automatic SQL Server optimization. Next, I would like to show you s… Continue reading Lesson Learned #367: Query Antipattern and Ring Buffer in Azure SQL Database

SCSM 2019 – How to configure Notification Channel with Exchange Online mailbox

Note: This article applies for configuration of Email notifications with Exchange Online for SCSM2019 only. For SCSM2022 users, we have released a new Hotfix that adds support for Modern Auth.
 
Introduction
Microsoft Service Manager (SCSM) uses S… Continue reading SCSM 2019 – How to configure Notification Channel with Exchange Online mailbox

Security Hardening Best Practices for PostgreSQL Flexible Server

Over 3 million consumers suffered from corporate data breaches in 2023 so far., according to SafeSmartLiving website, tracking major data breach announcements.  Now more than ever, it’s important for enterprises to fully understand the risks … Continue reading Security Hardening Best Practices for PostgreSQL Flexible Server

GitHub Copilot Fundamentals Learning Path – Your New AI programming friend!

Hi!
Ready to meet your new best friend? Say hello to GitHub Copilot, the AI pair programmer that’s about to change the way you code. It’s like having a super-smart friend who’s always ready to help. No matter the scenario, writing code, fixing bugs, or… Continue reading GitHub Copilot Fundamentals Learning Path – Your New AI programming friend!