When you use the BACKUP DATABASE statement in SQL Server 2005 (and beyond) you can use the READ_WRITE_FILEGROUPS option and the Read-only Filegroups will not be backed up.

A common SQL habit is to use SELECT * on a ... to rework them for a more sane schema. Sometimes the only way to tame this beast is to select a subset of columns, which keeps other queries from ...

Immortalized by “Little Bobby Drop Tables” in XKCD 327, SQL injection (SQLi ... Is your web application read only, for example? Does it need to have DROP TABLES privileges?

SqlQuery, which was available from the DbContext's Database object, allowed you to submit any SQL statement ... FromSql("Select * from Customers") .ToList(); Effectively, then, FromSql is tied to a ...

This interleaved execution means that workload performance issues due to heavy use of TVFs is fixed for free by upgrading to SQL Server 2017. There are some restrictions in the first iteration of the ...