To Split Comma Separated Value String inputs, I use STRING_SPLIT with CROSS APPLY. The example associates each class with its student.
SQL SERVER – Fix Error: Invalid object name STRING_SPLIT
A reader on SQL Server 2016 got Invalid object name STRING_SPLIT when trying the new function. Here is why the error shows up and how to fix it.
Splitting DBCC CHECKDB Across the Week for a Large Database
Keep a large database under regular integrity checks by splitting DBCC CHECKDB work across seven nights and auditing coverage.
SQL SERVER – How to Get SQL Server Agent Properties?
During a health check someone asked if SQL Server Agent has settings to tune. It does. Here is how to get SQL Server Agent properties with a simple script.
SQL SERVER – Installation Error – Unable to Open Windows Installer File – 2147286960
Installing SQL Server 2016 failed with “Unable to open Windows Installer file” and error -2147286960. Here is what caused it and how I fixed the setup.
How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171
When SQL Server Agent is disabled, you cannot expand it in SSMS to see its jobs. Here is how to list all the SQL Server Jobs with a simple query instead.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException. The Registry Key is Missing
A reader hit MissingRegistryKeyException during a service pack, but my earlier fix did not help. Here is another cause of the missing registry key and the fix.