Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server

Today, I worked on a service request where the DNS was providing an incorrect IP address randomly. In this article, I would like to share a PowerShell script that checks the DNS resolution every 5 seconds to help identify the issue.
 
This script … Continue reading Lesson Learned #495: Monitoring DNS Resolution with PowerShell of Azure SQL Server

Using Azure’s AI Language Service to Summarize and Extract Themes from Interview Transcripts

 
Imagine you’re a program evaluator or a qualitative researcher tasked with analyzing hundreds of interview transcripts. Each transcript is filled with valuable information, but the sheer volume and time-consuming nature of the task can be overw… Continue reading Using Azure’s AI Language Service to Summarize and Extract Themes from Interview Transcripts

Exploring Generative AI: An Hands-on Course on Prompt Engineering for non-tech students – Part 1

Introduction 
Generative Artificial Intelligence (AI) has transformed the digital landscape through “intent-based outcome specification,” a paradigm where users describe desired outcomes via detailed prompts instead of traditional commands. This c… Continue reading Exploring Generative AI: An Hands-on Course on Prompt Engineering for non-tech students – Part 1

Lesson Learned #494: High number of Executions Plans for a Single Query

Today, I worked on a service request where our customer detected a high number of execution plans consuming resources in the plan cache for a single query. I would like to share my lessons learned and experience to prevent this type of issue.
 
We… Continue reading Lesson Learned #494: High number of Executions Plans for a Single Query