Working with JSON in SQL Queries 

q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files). 

SQL is far from dead: it’s one of the most in-demand skills that you find in job descriptions from the data science industry, whether you’re applying for a data analyst, a data engineer, a data scientist or any other roles. This is confirmed by 70% of the respondents of the 2016 O’Reilly Data Science Salary Survey, who indicate that they use SQL in their professional context.  

Generating HTML from SQL Server Queries 

5 Monitoring Queries for SQL Server 

In this article I will explain some general purpose queries. I think each developer should have knowledge of these queries. These queries are not related to any specific topic of SQL. But knowledge of such queries can solve some complex tasks and may be used in many scenarios, so I decided to write an article on these queries. 

High CPU usage is a very common problem in SQL Servers. Any query with a bad query plan can steal CPU time and harm system response time.