geography Point uses latitude, longitude and SRID arguments. Its coordinate order differs from POINT text, so inspect both returned properties.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.
Filtered Indexes and Where They Help
Filtered indexes help SQL Server target active rows in a larger table; learn useful predicates, parameter limitations, and how to verify plan choices.
SQL SERVER – SQL Server Management Studio and Client Statistics
Query cost does not tell you how much data a query returns. Client statistics in SQL Server Management Studio do, and there are three ways to turn them on.
ALLOW_PAGE_LOCKS OFF Stops REORGANIZE
ALLOW_PAGE_LOCKS OFF prevents a rowstore index from being reorganized. A controlled example shows the maintenance error, checks the index setting and verifies that enabling page locks allows REORGANIZE without changing the stored rows.
SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
Reader Bob explains why aggregate concatenation results depend on expression location, using an ANSI point of view, and shares a similar example to run.
Giving Web Developers Safe Database Access
Give web developers safe database access with narrow roles and views, a reporting replica where useful, and audit that identifies real changes.
Storing Files in the Database or on Disk
Storing files in the database requires tradeoffs in transactions, backup size, and access; compare varbinary, FILESTREAM, FileTable, and paths.
Finding the Real Error Behind an SSMS Dialog
Finding the real error behind an SSMS dialog starts with technical details, inner exceptions, and a safe query-window reproduction.
SQL SERVER – Outer Join in Indexed View – Question to Readers
Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?