Use sp_invoke_external_rest_endpoint in SQL Server 2025 with controlled permissions, JSON responses, protected credentials, and retries.
SQL SERVER – How to Find Out When Your SQL Login Will Expire?
A client wanted a script to show when each SQL login will expire. LOGINPROPERTY makes it easy on SQL 2008 onwards. Here is the query I used.
Encrypt PII Data in SQL Server 2016: Notes from the Field #132
To encrypt PII data in SQL Server, first decide where each value must stay readable. Mike Lawell’s guest lesson is kept, and tested examples now show what masking hides, what cell-level encryption protects, and why Always Encrypted rejects plaintext sent from a query window.
SQL Server Audit: Tracking Who Read or Changed Sensitive Tables
Configure SQL Server Audit for reads and changes, inspect file records by user and time, and plan retention and target failures.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
SQL SERVER – Why DBAs Need to Know about Kerberos – Notes from the Field #126
Not everyone knows about Kerberos. Many think it is a two headed dog from mythology, well that is true but when we talk about database,
SQL SERVER – Handling XML Documents – Notes from the Field #125
Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.