What TypeScript Type Should I Use for Multiple SQL Server Rows?
I'm building an Express app with TypeScript and using the mssql package to communicate with SQL Server. One of my stored procedures returns multiple rows, with three related…
MSSQL
What Are These Open Ports on My Linux Server, and How Did They Get There?
I ran netstat on a server I believe is running Linux and found ports 445, 1433, 3306, and 21 open. I'm not sure what services normally use these…
What’s the best approach for multi-layered project documentation?
I'm starting a new team and have a lot of freedom in how I want to set things up. We're primarily developing Windows Forms using C# and Visual…
Help with MSSQL Untrusted Domain Error on Windows 2025
I'm dealing with a frustrating issue connecting to an MSSQL server from a web server, both running on Windows 2025. The error I keep getting is "login is…
How can we safely provide customer access to our database?
We're reaching a point where our customers want to access the raw data directly instead of going through our BI tools. I'm open to this idea since it…
Why is my RDS MSSQL Snapshot Taking So Long?
I'm experiencing an issue with the automated nightly snapshots for our 170GB MSSQL database on RDS. The snapshots are taking around 2 hours to complete, and we're using…