Practical Kotlin Deep Dive Course: Unlocking the 'How' and 'Why' behind Kotlin fundamentals and internal mechanisms. by Jaewoong is the featured course on Leanpub!

Link: https://leanpub.com/courses/leanpub/kotlin-deep-dive-courses

#Android #Kotlin #Engineering #SqlServer

#databases #sqlserver #technicalDebt #entityFramework
So... At work, our product has many data grids, and uses Entity Framework, most of the grids are paged.
Paging is done via await orderedQuery. Skip((page-1)*pageSize). Take(pageSize).TolistAsync()
Page 2 loads had always been slow. EF "optimises" the generated query to use one parameter for the second page because page 2 is ... .Skip((1-1)*pageSize).Take(pageSize) ...
Both resolve to the same value. EF says "same value, same parameter!" Find whatever.
Except... SQL server builds and uses a different (and more costly) plan for the resulting OFFSET \@p ROWS LIMIT \@p that is consistently worse than it they had didn't values that produces OFFSET \@p1 ROWS LIMIT \@p2

Apparently it's been a known problem for a long time.

Until someone as dumb as me asks... Why not Skip as much as normal and Take one extra then don't use it the extra.

(await orderedQuery. Skip((page-1)*pageSize). Take(pageSize+1).TolistAsync()).Take(pageSize)

/1

How to Load and Save Images in Blazor Image Editor with SQL Server

https://www.syncfusion.com/blogs/post/load-save-image-blazor-image-editor-sql-server?utm_source=alvinashcraft&utm_medium=email&utm_campaign=alvinashcraft_blog_edmmar26

#dotnet #blazor #aspnetcore #ref #webdev #syncfusion #csharp #sqlserver

Testing out Airbyte OSS today. Had to rollback the SQL Server connector to several versions previous as the current one is just straight up broken. But the old version is working well.

Hoping to use this to replace my super jank SnowSQL based SQL Server import to Snowflake.

#data #airbyte #oss #sqlserver #snowflake

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 #selfhosting #selfhosted #apache #sqlserver #freetds #mssql

Sharing some thoughts on the importance of #SQLServer transaction logs...

https://debthedba.wordpress.com/2026/03/27/flashing-neon-sign-for-the-transaction-log/

Dew Drop Weekly Newsletter 476 - Week Ending March 27, 2026

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

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

Do I know anyone who can help answer this question? https://stackoverflow.com/q/79915185/16454
My IDEs all treat `$[(DatabaseName)]` as a difference in schema compare instead of ignoring the stored procedure or view as identical. This happens because of the new SDK-style sqlproj format, which is not supported in Visual Studio yet (we're all using Macs anyway).

#SqlServer #VisualStudioCode #JetBrains #Rider #dotnet

Dew Drop – March 24, 2026 (#4631)

https://www.alvinashcraft.com/2026/03/24/dew-drop-march-24-2026-4631/

#dotnet #ai #webdev #csharp #windowsdev #cloud #appdev #visualstudio #sqlserver #dewdrop

New: video about the new Data Type Assistant in #DatabaseWorkbench, development tool for #SQLServer, #Firebird, #Oracle, #SQLite, #MySQL, #MariaDB, #PostgreSQL, #InterBase and #NexusDB.

#databasedevelopment #databasetools
https://www.youtube.com/watch?v=n2NfwXdqg0A