Dew Drop Weekly Newsletter 483 - Week Ending May 15, 2026
#dewdrop #newsletter #aspnetcore #javascript #css #azure #xaml #windowsdev #cpp #csharp #dotnet #efcore #ai #mcp #devops #agile #IoT #appdev #podcasts #m365 #sqlserver #data #powershell #devtools
Dew Drop – May 14, 2026 (#4668)
https://www.alvinashcraft.com/2026/05/14/dew-drop-may-14-2026-4668/
#dotnet #windowsdev #ai #webdev #csharp #cloud #visualstudio #vscode #appdev #sqlserver #dewdrop
MS SQL Arrow
mssql-python 드라이버가 이제 Apache Arrow 구조를 직접 지원하여 SQL Server에서 데이터를 Polars, Pandas, DuckDB 등 Arrow 네이티브 라이브러리로 빠르고 메모리 효율적으로 가져올 수 있게 되었다. 이 기능은 Python 객체 생성과 가비지 컬렉션 부담을 줄여 특히 DATETIMEOFFSET 같은 시간 관련 타입에서 큰 성능 향상을 제공한다. 기존 fetch API와 호환되며, 배치 단위 또는 스트리밍 방식으로 데이터를 처리할 수 있어 대용량 데이터 처리에 적합하다. 현재 Linux에서 NVARCHAR 타입의 성능 개선 작업이 진행 중이다.
https://devblogs.microsoft.com/python/introducing-apache-arrow-support-in-mssql-python/
Lee Markum presents 'Buttons, Levers, and Dials: What to Do With Key SQL Server Settings!' at Nebraska.Code() this July.
https://nebraskacode.amegala.com/
#SQLServer #MAXDOP #CostThreshold #MAXServer #QueryStore #DBA #Developer #Microsoft #SQL #SoftwareDevelopment #TechConference #Nebraska #Heartland #Midwest #ProgrammingLife
If I'm remembering correctly, the primary SQL Hosts at my employer date back to May 2023 when new hardware was purchased.
We have not run Windows Updates or installed a Cumulative Update for SQL Server on these machines. Not ever.
I've done extensive testing in our non-PROD environments, and scheduled dozens of maintenance windows for the PROD environment. But something (and it's never me) always 'gets in the way'.
For years, my website lived on a fairly typical stack—WordPress hosted through GoDaddy. It worked. It was easy. And like most things that “just work,” I didn’t think too hard about it… until I did.At some point, I started asking a simple question: Why...
#sqlserver #azure #ai #git #copilot #devops
After 8 months working intensively with AI as a cloud DBA, I see it less as a magic tool and more as a powerful amplifier. With context, versioning, instruction files, agents, and human supervision, AI can greatly improve automation, documentation, and troubleshooting.
Dew Drop Weekly Newsletter 482 - Week Ending May 8, 2026
#dewdrop #newsletter #javascript #css #azure #blazor #cpp #xaml #windev #csharp #dotnet #ai #mcp #agile #devops #dotnetmaui #appdev #podcasts #m365 #data #sqlserver #powershell #cli
In recent years, we’ve seen an upturn in adoption of the open-source database engine PostgreSQL. Commercial databases like Oracle and SQL Server can become quite expensive as applications grow to massive scale. Oracle licensing is complex and very expensive. While we at DCAC still love SQL Server and it’s at the heart of our business, we do see the demand for PostgreSQL cropping up amongst clients. PostgreSQL is a solid database engine—I’ve built applications on it, however as economist Milton Friedman famously said, “there is no such thing as a free lunch.” If you talk to any database expert, you’ll
Alvin Ashcraft 🐿️
sayzard
Nebraska.Code
Dave Mason
Denny Cherry & Assoc
