Foreign key constraints in SQL Server: yes or no? 🥊 The eternal debate is back in this week's Reading Notes, along with Azure Service Bus tips and how to pick a cheaper AI model.
c5m.ca/RN-714
@fboucheros.bsky.social
@fboucheros.bsky.socialForeign key constraints in SQL Server: yes or no? 🥊 The eternal debate is back in this week's Reading Notes, along with Azure Service Bus tips and how to pick a cheaper AI model.
c5m.ca/RN-714
@devartsoftware.bsky.socialWe’re proud to sponsor Boston Data and AI Saturday 2026! 🎉
Join the data community on Oct. 3 in Burlington, MA, for a free day of learning around SQL Server, PostgreSQL, AI & more.
#Devart #dbForge #SQLServer #PostgreSQL #DatabaseTools #DataAndAI
@radwebhosting.comHow 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 ...
Continued 👉 #sqlserver #freetds #selfhosted #selfhosting #apache #mssql
@infoq.comAgoda moved its 1.5 TB hotel Price Cache from 72 SQL Server shards to DragonflyDB to handle rising read/write volumes.
The result? ~8× lower P99 read latency, with two DragonflyDB clusters providing high availability.
🔗 Read more: buff.ly/YXhFCzJ
@albertomorillo.bsky.socialResolve last-page insert PAGELATCH_EX contention in SQL Server. Article recently updated by Microsoft using AI.
#TSQL #transactsql #databases #SQLServer #troubleshooting #performance
learn.microsoft.com/en-us/troubl...
@albertomorillo.bsky.socialTroubleshoot slow queries that result from ASYNC_NETWORK_IO wait type. Article recently updated by Microsoft using AI.
@justrie.bsky.socialWant to submit a WORKSHOP for #FabCon or #SQLCon in Atlanta Mar 8-12, 2027?
⏩ Act fast.
☎️ The call for content is currently open but only for another week.
Workshop Call for Content closes Friday, September 25th.
#SQLServer #MicrosoftFabric #PowerBI #SQLFamily
aka.ms/fabcon-works...
🚀 Building a DBA Agent for Your SQL Server Estate
🎤 Anthony Nocentino | 📅 Wed, Sep 23 · 3:00 PM ET
Build a DBA agent with MCP: availability, backups, security & observability, with humans in control.
@sqlserverbuilds.bsky.socialNew SQL Server 2025 Cumulative Update:
sqlserverbuilds.blogspot.com#sql2025x
17.0.5005.3 CU9 for SQL Server 2025
#SQLServer #SQLServer2025
@sqlserverbuilds.bsky.socialNew SQL Server 2022 Cumulative Update:
sqlserverbuilds.blogspot.com#sql2022x
16.0.4295.3 CU27 for SQL Server 2022
#SQLServer #SQLServer2022
@hugokornelis.bsky.socialNew blog post! In this detailed and deep #SQLServer #Plansplaining post, I revisit the execution plan for frameless window aggregation (OVER without ORDER BY), to address some details previously overlooked, which leads me to uncover a bug and an invisible property.
@glennalanberry.bsky.socialMicrosoft released SQL Server 2025 CU9 and SQL Server 2022 CU27 yesterday. They were a few days "late" (from their normal release cadence).
They both have a higher-than-normal level of fixes, many of which are security related.
@mysticmindb.bsky.socialPolecat, the Critter Stack's SQL Server document store, has three ways to search and @jeremydmiller.bsky.social added these recently:
- full text, BM25 ranked
- vector, over SQL Server 2025's VECTOR type
- hybrid search.
Know more at mysticmind.dev/polecat-sear...
@gp-pulipaka.bsky.social
@edwardsdna.bsky.socialChannel9 Data Streaming for Modern Applications in SQL Server 2025, Azure SQL, and Fabric SQL | Data Exposed: Change Event Streaming (CES) is now in public preview across all of Microsoft SQL. Learn about it, see some demos, and get the best tips and tricks.
@dcac.comhttps://buff.ly/3RnJqKb Questions about #sqlserver on Linux? Check out the course on LinkedIn, "Learning SQL Server Development on #Linux" and see if SQL Server on Linux is the correct solution for your data platform needs.
@erikej.bsky.socialI've updated DacDeploySkip with improvements that make SQL database deployments easier:
• Simpler CI/CD configuration
• Support for publish profiles
This makes deployment settings easier to manage across environments.
Read more: buff.ly/6oztrUo
@dcac.comhttps://buff.ly/496Dahn Server #emergencies always seem to happen at 3 a.m. Getting assistance at 3 can be tricky unless you have DCAC's Emergency Response package. Our ER package provides methods to contact the DCAC team anytime to get help with emergencies. #sqlserver
@datamechanic.proSame Logic, Different Engine: PySpark Through a SQL Lens
mrneilbryan.substack.com/p/same-logic...
#DataEngineering #PySpark #Databricks #Python #BigData #CloudData #SQLServer
@dcac.comhttps://buff.ly/48gHxFY Learn how to build more #secure #applications using the advanced #security features in #SQLServer, including Row Level Security, Always Encrypted, and more.
