Posts tagged "sql server"

Give a reporting service narrow database permissions and test denied writes using its real account. Read-only access still needs data and resource limits.

Reproduce a blocked SQL Server read from Rust, check READ_COMMITTED_SNAPSHOT and distinguish lock timeout 1222 from an application timeout.

Connect Tiberius with verified TLS, bind one value, and handle a nullable result before moving existing SQL Server work into Rust.

Use Tiberius bulk copy with checked constraints and explicit transactions, then verify rollback, committed rows and rejected data separately.

Capture actual SQL Server plans from Rust with bound parameters, then separate parameter-sensitive behavior from a slow query that only looks identical.