Day 20 of 60 — SQL Server from Scratch to Master. Today: Stored Procedures — the professional standard for encapsulating business logic in SQL Server. The pattern I use in every search SP I build: ...

I am unsure why this is the case. A partial theory is that the underlying code is type checking using the SqlDbType enumeration ordering, and VarChar is 23rd on that list. However, that would only ...

SQL Server performance often lives or dies by how you handle concurrency, and Read Committed Snapshot Isolation (RCSI) is the lever most people want to pull. It’s often pitched as the "silver bullet" ...

Why you should use Parameters.AddWithValue with MySqlConnector, and why it's OK to use with MySQL. There's some advice out there that insists calling cmd.Parameters.AddWithValue "needs to stop". That ...