Agent XPs can explain why SQL Server Agent is Missing from SSMS. I check edition and service state before changing configuration.
Shredding JSON Into Relational Tables in One Pass
Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
SQL SERVER – Last 5 SQL in Sixty Seconds Video
Today I am going to share the last 5 SQL in Sixty Seconds videos with you all. Please let me know which of the last 5 you find the most interesting and why?
Current Timestamp in Python and SQL: One Format, Two Tools
To get the current timestamp in Python, import datetime, call now and format the result with strftime. This post prints the same date and time in Python and in T-SQL, compares the two clocks, and shows how to ask for UTC in both.
sp_execute_external_script: Run Python Inside SQL Server
Before you write any Python, check four switches. Here is how to read them, what error 39023 means, and what to test on your own server.
CPU Scheduler Waiting on Disk: Read Pending Disk IO
A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.
SQL SERVER – Troubleshooting High CPU
We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.