🔹 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 […]
🔹 Highlight: SQL Migration Options ✅ SQL Server version upgrades including migrations to Azure → Use SQL Server Management Studio (SSMS) What it gives you: • Familiar, built-in tooling for DBAs • Guided upgrade and compatibility checks • Minimal disruption for in-place or side-by-side upgrades ✅ Migrations to Azure SQL Database → Use Data Migration […]