GitHub

udf_native_json_value_path.sql

This UDF is enables JSON PATH (http://goessner.net/articles/JsonPath/) queries. It is base for dbo.udf_native_json_value function. IF @Json IS NULL OR @Token IS NULL ...
Ars Technica

Settle an argument: SQL update with left join + isnull() vs inner join

I've been in an argument with one of our devs that took an update statement with an inner join and made it a left join (because inner was missing some records somehow in the left table - tableB in ...
GitHub

Data Cleaning in SQL (SQL)

This is a guided project from Coursera, in which I have learnt about cleaning data in SQL using following methods For this project, open-source database (NorthWind Database) was used . ROW_NUMBER is a ...
Ars Technica

Powershell. SQL Query. How to determine if a query returns no results?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
InfoWorld

What is SQL? The lingua franca of data analysis

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...