There are two new options for automating your SQL Notebooks with your SQL Servers. Earlier this month, the Insiders build of Azure Data Studio received the ability to add...
2019-10-02 (first published: 2019-09-23)
812 reads
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: ... Continue reading
2019-10-07 (first published: 2019-09-23)
847 reads
Data exploration is an essential piece of any new ETL (extraction-transformation-load) process. Knowing the structure, type, and even the semantics of data sources can help the ETL developer or...
2019-10-01 (first published: 2019-09-23)
414 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-02 (first published: 2019-09-23)
728 reads
‘Shortest path’ is by far the most feature of SQL Graph for now. What does this even mean? ‘Shortest path’ is the term accorded to the shortest distance between...
2019-10-08 (first published: 2019-09-22)
771 reads
In this post we saw how to create some graph tables with data. In this I will explore simple queries off of this data and how they compare with...
2019-10-01 (first published: 2019-09-21)
464 reads