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

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

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

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

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
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
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.

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 -