Another option for splitting strings in TSQL. This one addresses a shortcoming of STRING_SPLIT. [...Read More]

Get started with a few examples using the OPENJSON and JSON_VALUE functions. [...Read More]

Using a function for something it wasn't meant for...just for fun. [...Read More]

A stored procedure can return multiple result sets. Why can't I do the same with sp_execute_external_script? ?? [...Read More]

I've finally found a tangible example of something I could use R for. [...Read More]

A look at SQL Server Extended Events and how to handle them using the QueryableXEventData class in a C# GUI app. [...Read More]

An embarrassing tale of keyboard shortcuts, Find/Replace, the Visual Studio Shell, and Microsoft Connect. [...Read More]

For T-SQL Tuesday #86, Brent Ozar asks us to "Find the most interesting bug or enhancement request on Connect.Microsoft.com". [...Read More]

Microsoft has improved the process for downloading SQL Server Express 2016. [...Read More]

Thoughts on Microsoft's Data Driven Event for SQL Server 2016. [...Read More]