Vlad4h ago

Next week I'm heading to Data Saturday Croatia 2026 for my first-ever speaking appearance at a Data Saturday event!

I'll be talking about heaps for longer than most people would find healthy in my session:
"A Heap of Trouble: The Hidden Costs of Heaps in SQL Server"

Can't wait to connect with fellow Data Platform folks and share some insights.
If you're there, come say hello!

https://datasaturdays.com/Event/20260613-datasaturday0075

#DataSaturday #DataSaturdayCroatia #SQLServer #MSSQL #DBA #SQL #MVPBuzz

Alvin Ashcraft 🐿️4h ago

Dew Drop Weekly Newsletter 486 - Week Ending June 5, 2026

https://zc.vg/0IC3d?m=0

#dewdrop #newsletter #azure #javascript #blazor #windowsdev #xaml #winui #csharp #dotnet #cpp #ai #mcp #dotnetmaui #devops #agile #appdev #python #podcasts #m365 #sqlserver #data #powershell #cli

Rad Web Hosting5h ago

How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)

This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mssql #selfhosting #apache #selfhosted #freetds #sqlserver

mastodon.raddemo.host1d ago

How to Install #Microsoft SQL Server on #Ubuntu #VPS (10 Minute Quick-Start Guide)

This article provides a guide for how to install Microsoft SQL Server on Ubuntu VPS.
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is used to store, retrieve, manage, and analyze data in a structured way using SQL (Structured ...
Continued 👉 https://blog.radwebhosting.com/install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #selfhosting #mssql #sqlserver #apache #selfhosted #freetds

Dave Mason1d ago

It's flattering when coworkers think I know everything about SQL Server. But I think we all understand that's impossible.

In fact, I've sometimes told people that there's more about SQL Server I *don't* know than I do know (and that's probably true).

Recently, a coworker had an issue with database mail and was asking why their process was failing. I had to tell them "I don't know."

I think it took them a couple of days to accept my answer.

#DBA
#SQLServer

Denny Cherry & Assoc4d ago
John Morehouse Blogged: John Morehouse https://www.dcac.com/2026/06/01/introduction-to-contained-availability-groups/ Introduction to Contained Availability Groups #sqlserver
Introduction to Contained Availability Groups

Availability Groups have been one of the best high availability and disaster recovery options in SQL Server for a long time. They let us move a group of user databases together, keep replicas synchronized, offload some read-only workloads, and give app...

Denny Cherry & Associates Consulting
Alberto Morillo5d ago
mssql-django 1.7: Django 6.0, SQL Server 2025, and a Lot of Catching Up
#django #sqlServer #ODBC
https://techcommunity.microsoft.com/blog/sqlserver/mssql-django-1-7-django-6-0-sql-server-2025-and-a-lot-of-catching-up/4503166?wt.mc_id=DP-MVP-4015656
mssql-django 1.7: Django 6.0, SQL Server 2025, and a Lot of Catching Up | Microsoft Community Hub

For years, Django developers who needed SQL Server have had to navigate a patchwork of community forks and half-maintained backends. mssql-django changed...

TECHCOMMUNITY.MICROSOFT.COM
Alberto Morillo5d ago
SQL Connectivity and Drivers
#SQLServer #Dotnet #Java #C #python #go #php
https://learn.microsoft.com/en-us/sql/connect/?view=sql-server-ver17
SQL Connectivity and Drivers - SQL Server

Find resources for the platform of your choice to help you focus on building great applications, for SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure Database, and SQL Server on Azure VMs.

Chris Woody Woodruff5d ago

Was talking with folks from the EF Core team about common anti-patterns. I walked through offset pagination, Skip().Take(), and forgot to mention keyset pagination.

I should have. So I wrote the post I should have brought.

Skip().Take() isn't wrong, it's misapplied. On large or write-heavy tables, it's slow (OFFSET reads and discards every skipped row) AND silently skips or duplicates records under concurrent writes.

Keyset fixes both.

https://www.woodruff.dev/pagination-in-entity-framework-core-why-skip-take-falls-apart-on-hot-tables/

#dotnet #efcore #sqlserver

Pagination in Entity Framework Core: Why Skip/Take Falls Apart on Hot Tables - Chris Woody Woodruff | Fractional Architect

If you've built an ASP.NET Core API or list view backed by Entity Framework Core, you've almost certainly written something like this: var page = await _db.Orders .OrderBy(o => o.Id) .Skip((pageNumber - 1) * pageSize) .Take(pageSize) .ToListAsync(); It works. It matches the page-number UI most users expect. Every EF Core tutorial uses it. It's also

Chris Woody Woodruff | Fractional Architect -
Alvin Ashcraft 🐿️May 29

Dew Drop Weekly Newsletter 485 - Week Ending May 29, 2026

https://zc.vg/zSvvK?m=0

#dewdrop #newsletter #aspnetcore #azure #javascript #css #windowsdev #xaml #cpp #dotnet #csharp #ai #mcp #python #devops #agile #appdev #IoT #podcasts #m365 #sqlserver #data #powershell #gamedev