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
#sqlServer
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
#dewdrop #newsletter #javascript #css #aspnetcore #azure #windev #xaml #dotnet #csharp #ai #mcp #dotnetmaui #devops #agile #python #IoT #appdev #podcasts #data #sqlserver #m365 #powershell
I have limited spare capacity for SQL Server & PostgreSQL consulting/training.
Focus areas:
• Perf tuning & troubleshooting
• PostgreSQL for SQL Server professionals
• Query planning, and production issues
If your database is slow, complex, or mid-migration: happy to talk.
A stored procedure with 13,400 lines of code written by a human.
And they pushed the code into production without any approval or oversight.
During development, I wonder if they ever thought to themselves "Ya know, maybe this isn't a good idea."?
Dew Drop – January 22, 2026 (#4588)
https://www.alvinashcraft.com/2026/01/22/dew-drop-january-22-2026-4588/
#dotnet #webdev #ai #csharp #windowsdev #visualstudio #sqlserver #mobiledev #cloud #dewdrop
Headline: Death of the DBA (Again)
Me: Yep, here we go again.
Microsoft Sets 2027 Deadline for SCOM Management Pack Support, Forcing Enterprise Azure Migration
#SQLServer #Microsoft #BigTech #Enterprise #Cloud #MicrosoftAzure #AzureMonitor
New blog post:
My first ever contribution to T-SQL Tuesday.
https://vladdba.com/2026/01/20/t-sql-tuesday-194-learning-from-mistakes/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql #tsql2sday
As an #introduction since the migration doesn't bring my history over. Hi all and #BeigeBless I am delighted to join this eclectic server and hope that I can live up to the high standards.
I am a medium old (re-entered the prime decades) white guy living in the middle of the US but don't hold that against me. Married, two kids that aren't exactly "kids". I used to talk a lot about #SSIS, #SQLServer, #python, C#, #Databricks but anymore I think just chat about what's going on in my life.
My newest joy has been my backyard chickens and not maintaining the website https://816chickens.com/
Undecided on me? Here's my easy follow criteria for you
Tea not coffee
Trans rights are human rights
The president is a bag of dicks
🧩 New post: Modernizing .NET – Part 8
ODBC driver setup for SQL Server, Redshift, Snowflake, Exasol, PostgreSQL — all on Linux/Docker.
Full guide on Medium → https://medium.com/@michael.kopt/%EF%B8%8F-modernizing-net-part-8-odbc-driver-configuration-on-linux-a9083eabc5bd
#DotNet #ODBC #Linux #Docker #CSharp #Database #Databases #SQLServer #Redshift #Snowflake #Exasol #PostgreSQL #SoftwareEngineering #LegacyCode
5 Companies or Projects That Use SQL Server. 🇺🇸
5 Empresas o Proyectos Que Usan SQL Server. 🇪🇸
🦄 https://nubecolectiva.com/blog/empresas-proyectos-usan-sql-server/
#programming #coding #programación #code #webdevelopment #devs #softwaredevelopment #sqlserver #microsoft
I spent some time writing up how to #unittest the creation and changing of #sql database components in #Microsoft #SqlServer 's #TSql . It's useful in restricted environments that won't allow other development tools that normally could conduct unit tests.
https://www.patreon.com/posts/148232620
Blog post from the past:
In which I cover ways of speeding up SELECT COUNT in SQL Server as well as some myths about best practices when it comes to SELECT COUNT.
https://vladdba.com/2023/08/21/speeding-up-select-count-in-sql-server/
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba
Dew Drop – January 13, 2026 (#4581)
https://www.alvinashcraft.com/2026/01/13/dew-drop-january-13-2026-4581/
#dotnet #webdev #ai #windowsdev #visualstudio #mobiledev #vscode #csharp #cloud #sqlserver #dewdrop
NEW POST:
✍ Monitoring TRUNCATE TABLE Operations
🔎 Monitoring SQL Server TRUNCATE TABLE operations has always been a challenge. But I think I've found a workable solution with Extended Events.
👤 Dave Mason
https://www.davemason.me/2026/01/13/monitoring-truncate-table-operations
John Morehouse Blogged: John Morehouse https://www.dcac.com/2026/01/12/azure-sql-managed-instance-next-gen-bring-on-the-iops/ Azure SQL Managed Instance Next-Gen: Bring on the IOPS #sqlserver
SQL 2025 + Power Platform. The new SQL Server 2025 has native AI vector support. You can now build RAG (Retrieval-Augmented Generation) apps using Power Apps that query SQL directly for semantic search. The gap between "Low Code" and "Pro Code" SQL just vanished.
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.raddemo.host #sqlserver #freetds #selfhosted #mssql #selfhosting #apache
Microsoft tried to stuff an ad bar into #SSMS, then pushed an update saying you can simply disable it if you don't like it... by editing the registry.
I saw some comments in another posting about this where people were saying "SSMS is free, and Microsoft needs to make money somehow." *facepalm*
https://developercommunity.visualstudio.com/t/Please-dont-show-ads-in-SSMS/11010321
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst