🔹 Feature: Python in Excel 🌐 Video: https://youtu.be/Egos00xPEF4 🔹 What It Does: Seamlessly integrates Python capabilities directly into Excel, allowing advanced data analysis, visualization, and automation within familiar Excel workflows. What is it giving you: ✅ Works in Cloud: No need instal Python locally ✅ Basic licenses enough: Office E3 or Buissness Office licenses are […]
🔹 Feature: Query Hint Recommendation Tool 🔹 What It Does: An extension to SQL Server Management Studio to optimize your queries efficiently. What is it giving you: ✅ Establishes Baseline Performance Ensure your queries are measured against consistent performance metrics. ✅ Identifies Helpful Hints Based on Actual Elapsed Time Focus on real execution time metrics, […]
🔹 Feature: The SharePoint + Copilot Advantage – Metadata Understanding 🔹 What It Does: Metadata is the descriptive information attached to files (think tags, categories, dates, and custom labels). It transforms a basic document library into a dynamic, searchable knowledge base. What It’s Giving You: ✅ Enhanced Search Precision: By enriching SharePoint content with metadata, […]
Open KUDU with powershell. List all processes Get-Process | Sort-Object {$_.Threads.Count} -Descending | Select-Object ProcessName, Id, @{n=’Threads’;e={$_.Threads.Count}}, @{n=’Memory_MB’;e={[math]::Round($_.WorkingSet64/1MB,2)}} | Format-Table -AutoSize Select the ID with more threads – not SCM one – you can confirm it in KUDU console go to c:\devtools\sysinternals cd c:\devtools\sysinternals check current logs: dir c:\home\logfiles Create memory dump: ./procdump.exe -accepteula -ma […]
🔹 Feature: Copilot Formula in Excel 🔹 What It Does: Supercharges your Excel experience with AI-driven capabilities, making data tasks smarter and faster! ✅ Condense Information: Summarize long strings or cell ranges into concise insights. ✅ Generate Sample Data: Quickly create placeholder or demo data for prototypes. ✅ Classify Content: Assign categories or sentiment tags […]