Lmst

Dew Drop Weekly Newsletter 469 - Week Ending February 6, 2026

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

Dew Drop – February 6, 2026 (#4599)

https://www.alvinashcraft.com/2026/02/06/dew-drop-february-6-2026-4599/

#dotnet #ai #webdev #cloud #visualstudio #windowsdev #csharp #gamedev #sqlserver #mobiledev #dewdrop

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/how-to-install-microsoft-sql-server-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #selfhosted #freetds #mssql #sqlserver #apache #selfhosting

I’m excited to announce that I’ll be speaking at Data Saturday Croatia 2026.
My session title is "A Heap of Trouble: The Hidden Costs of Heaps in SQL Server."

This will be my first appearance as a speaker at a Data Saturday event, and I am looking forward to sharing insights with the community.
https://datasaturdays.com/Event/20260613-datasaturday0075

#DataSaturday #DataSaturdayCroatia #SQLServer #MSSQL #SQL

I'm speaking at Data Saturday Croatia 2026
A heap of trouble: the hidden
costs of heaps in SQL Server
6/13/2026 10:15 am — Zagreb, Croatia
Vlad Drumea

New blog post:
In which I cover the process of setting up SQL Server 2025 on Ubuntu 24.04, connecting and restoring a sample database.
https://vladdba.com/2026/02/02/sql-server-2025-ubuntu-24-04/
#linux #ubuntu #virtualbox #sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql

[Blog] Don’t Miss Out - SQL Server Query Tuning Fundamentals Starts Next Monday! https://www.sqlpassion.at/archive/2026/02/02/dont-miss-out-sql-server-query-tuning-fundamentals-starts-next-monday/ #sqlserver #performance #troubleshooting #indexing

Dew Drop Weekly Newsletter 468 - Week Ending January 30, 2026

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

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

UPDATE: AUL SQL 0.6.2

What's New

Extended support for TDS with TLS authentication, now you can connect to the aul server 0.6.2 with DBeaver, for example, which uses the JDBC MSSQL driver (and any other application that uses that JDBC driver)

This is AUL SQL, an open source database server aiming to be (almost) compatible with Microsoft SQL Server for most sane uses, sometimes faster, definitely cheaper, and always more free.

https://github.com/ha1tch/aulsql/tree/main

Previously It listened on SQLServer-compatible ports, and supported most of the TDS protocol, but it did so primarily with Go clients which use the official go-mssqldb package.

#db #database #mssql #sqlserver #microsoft #postgres #softwaredevelopment #software #compsci #programming #golang #foss

SQLMind Studio: Công cụ AI dành cho DBA SQL Server, tự động kiểm tra schema & viết SQL an toàn. Tính năng chính: phát hiện cơ sở dữ liệu, bảng, cột; xác thực truy vấn trước thực thi; tối ưu hiệu năng. Đã cập nhật phiên bản 5.5.0. Đăng ký dùng thử ngay hôm nay! #SQLServer #DBA #AI #CôngNghệ #PhầnMềm

https://www.reddit.com/r/SaaS/comments/1qqh0fm/sql_server_dbas_i_built_a_schemaaware_ai_tool_to/

NEW: AUL SQL 0.6.0

This is AUL SQL, an open source database server aiming to be (almost) compatible with Microsoft SQL Server for most sane uses, sometimes faster, definitely cheaper, and always more free.

https://github.com/ha1tch/aulsql/tree/main

Advantages:

It listens on SQLServer-compatible ports, and supports most of the TDS protocol with TLS (tested against clients which use the official go-mssqldb package)
It supports most of T-SQL, using my earlier projects tsqlparser and tgpiler
Stored procedures are now text files, for which you can use standard versioning practices.
Existing backend: SQLite

Use cases / scenarios

Ready to use for local testing of small applications without a real MS SQL Server (for the subset of T-SQL currently supported by the existing backend)
Can be used to start migrating small applications that use trivial MS SQL DDL / DML

Future versions:

Planned backends: Postgres and Mysql
JIT compiling hot path stored procedures to Go
Integration with modern, external user management, and ACLs
Modern telemetry
Heterogeneous clustering (formerly joked about as "Bob SQL")

#db #database #mssql #sqlserver #microsoft #postgres #softwaredevelopment #software #compsci #programming #golang #foss

Dew Drop – January 28, 2026 (#4592)

https://www.alvinashcraft.com/2026/01/28/dew-drop-january-28-2026-4592/

#dotnet #webdev #ai #windowsdev #visualstudio #vscode #mobiledev #csharp #cloud #sqlserver #dewdrop

got it done before February: now supporting #postgres
upload or copy paste query plans in xml for #postgres, #sqlite and #sqlserver
c&c welcome
https://querydiff.com

I recently waisted an hour (or maybe two...) trying to connect to a fresh install of #microsoft #sqlserver
I tried to connect using username/password but this has to be be enabled in the settings before you can use this. Of course I knew this but I kind of forgot...
The joy of being a software engineer :blobcatfacepalm2:

Dew Drop Weekly Newsletter 467 - Week Ending January 23, 2026

https://zc.vg/7ynR3?m=0

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