Learn validating JSON parameters before changing data with ISJSON, JSON_PATH_EXISTS, TRY_CAST, and a single clear list of input errors.
SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions
What is Business Intelligence? A plain introduction to BI and the key terms that go with it, like decision support, data mining, OLAP, reporting and forecasting.
Adding Business Hours to a Timestamp in T-SQL
Add business hours through a stored work calendar, skip closed dates and nights, and calculate ticket deadlines without a minute loop.
SQL SERVER – Enable Automatic Statistic Update on Database
Automatic statistics updates respond to changing data and query needs. I inspect the setting and estimates before treating it as a tuning fix.
VALUES Type Inference: Cast Before Combining Rows
VALUES type inference chooses a common column type. Preserve formatting-sensitive text by making source conversions explicit before combination.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3
Part 3 of how to Remove Bookmark Lookup, RID Lookup and Key Lookup. A covering index holds every column the query uses in SELECT, JOIN and WHERE.
Connecting PHP to SQL Server
Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.