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 […]

Czytaj dalej

🔹 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 […]

Czytaj dalej

🔹 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 […]

Czytaj dalej

During uploading fresh repository to GIT especially to Azure Devops – you can see: This push was rejected because its size is greater than the 5120 MB limit for pushes in this repository. The idea is to split across the commits. Here is a script that can do it automatically based on file size. Invocation […]

Czytaj dalej

Microsoft Fabric has been around for a few years now and brings data tools together in one SaaS platform — from copying databases to running analytics on the fly. Before, we often used separate services like Azure Data Factory, but now it’s all in one place.  Are you using Microsoft Fabric already, or sticking with […]

Czytaj dalej