Splitting Strings With OPENJSON 2019-05-06 Posted in: Development JSON SQL Server 2016 SQL Server 2017 T-SQL 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 Posted in: Big Data Development JSON SQL Server 2016 SQL Server 2017 T-SQL Get started with a few examples using the OPENJSON and JSON_VALUE functions. [...Read More]
Binary to Decimal via STRING_SPLIT 2018-11-14 Posted in: Development SQL Server SQL Server 2016 T-SQL Using a function for something it wasn't meant for...just for fun. [...Read More]
Multiple Output Datasets With R and SQL Server 2017-11-06 Posted in: Development R SQL Server 2016 SQL Server 2017 T-SQL A stored procedure can return multiple result sets. Why can't I do the same with sp_execute_external_script? ?? [...Read More]
Regular Expressions With R And T-SQL 2017-10-02 Posted in: Development R SQL Server SQL Server 2016 T-SQL I've finally found a tangible example of something I could use R for. [...Read More]
SQL Server Extended Event Handling via GUI 2017-05-29 Posted in: Database Administration Development SQL Server SQL Server 2016 SQL Server Event Handling A look at SQL Server Extended Events and how to handle them using the QueryableXEventData class in a C# GUI app. [...Read More]
Muscle Memory And CTRL+F 2017-01-26 Posted in: Database Administration Development Microsoft SQL Server 2016 An embarrassing tale of keyboard shortcuts, Find/Replace, the Visual Studio Shell, and Microsoft Connect. [...Read More]
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests 2017-01-10 Posted in: Database Administration SQL Server SQL Server 2016 T-SQL For T-SQL Tuesday #86, Brent Ozar asks us to "Find the most interesting bug or enhancement request on Connect.Microsoft.com". [...Read More]
Downloading SQL Server Express 2016 2016-06-03 Posted in: Database Administration Microsoft SQL Server 2016 Microsoft has improved the process for downloading SQL Server Express 2016. [...Read More]
SQL Server 2016: Data Driven Event Reaction 2016-03-16 Posted in: Microsoft SQL Server SQL Server 2016 Thoughts on Microsoft's Data Driven Event for SQL Server 2016. [...Read More]