Developer Edition is not the 180-day Evaluation Edition. I check the edition before treating a calculated date as an expiration.
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.
The Row Version Tag: Page Splits After Turning On RCSI
Turn on RCSI and every row you update gets a little bigger. On packed pages that means page splits, and I show the numbers on a small demo table.
SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW
A client database went SUSPECT after a cluster failure and DTC reinstall. The ERRORLOG showed a DTC/KTM in-doubt Transaction with UOW. How we fixed it.
SQL SERVER – Fix Error Msg 13602 working with JSON documents
Working with JSON documents in SQL Server 2016? You can’t use FOR JSON inside an UPDATE statement, and trying gives Msg 13602. Here is how to work around it.
Getting Started With R Services and Forecasting
R Services and forecasting meet when a data scientist’s R script has to run next to the data. This guest post by Eduardo Castro shows how to enable external scripts, install packages and run a forecast with sp_execute_external_script.
Documenting SQL Agent Jobs: Schedules, Steps and Owners in One Query
Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.