Can you find [blog.] in a column with LIKE? Most people I interview cannot. Here is how to search Special Characters in a table column the right way.
SQL Server – Performance Comparison of Function Trim and LTRIM(RTRIM)
A workshop question: what is the performance comparison of function TRIM and LTRIM(RTRIM) in SQL Server? Here are the test results.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
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.
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.
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.
PowerShell – Get Maximum Memory of Server with dbatools
Readers asked how to get started with dbatools. Here is a simple first step: finding the maximum memory of a server with one PowerShell command.