Splitting Strings With OPENJSON

2019-05-06 1 Comments

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

Parsing JSON Data In SQL Server

2019-05-05

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

2018-11-14

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

2017-11-06

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

2017-10-02

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

2017-05-29

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

2017-01-26

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

2017-01-10

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

2016-06-03

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

2016-03-16

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