Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Background Wanted to give a quick update on the Azure Data Studio Extension, sqlops-spexecutesql-to-sql. Lineage Azure Data Studio – Extension – "sqlops-spexecutesql-to-sql" Original Post Date Posted :- 2019-August-24th Link Bug Report Outline Filed a bug. The code is on GitHub and path way to filling a bug it to : Sojourn to GitHub Access Pejman … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql” ( v1.0.1 )

Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql”

Background Reviewing a few SQL Statements and noticed some of them came across as prepared statements. Wanted to see if I will be able to understand them by converting them to plain generic SQL. SQL Sample SQL Here is a sample SQL Traditional SQL Here is a hand crafted comversion Azure Data Studio Extension I … Continue reading Azure Data Studio – Extension – “sqlops-spexecutesql-to-sql”

PostgreSQL – SQL – Aggregate Functions – Day 01

Background Let us take a quick look at a couple of Aggregate functions available in PostgreSQL. DDL Region State DML Region State Query array_agg Code Output Output.DBeaver Output.Azure Data Studio array_to_string Code Output Output.DBeaver Output.Azure Data Studio Error Dbeaver Exception java.lang.NullPointerException Summary PostgreSQL offers solid tooling for SQL data aggregation. Unfortunate, Dbeaver throws an exception … Continue reading PostgreSQL – SQL – Aggregate Functions – Day 01

PostgreSQL / Explain Plan :- DBeaver & Azure Data Studio

Background Playing around some more with PostgreSQL. SQL Here is the simple SQL. Dbeaver SQL Editor Enter SQL in to DBeaver SQL Editor. Execution Plan Request Request via Menu - Explain Execution Plan Initiate Request To get the query's execution plan, please do the following :- Select the Query Execute the Query The Query is … Continue reading PostgreSQL / Explain Plan :- DBeaver & Azure Data Studio

Azure Data Studio :- Extension – PostgreSQL

Background Let us use Azure Data Studio to connect to PostgreSQL. Prerequisites Here we installed Azure Data Studio. Steps Choose the extensions icon, or access menu and choose Extensions In the Extension panel, choose PostgreSQL Right click on your selection and choose to install Once installed, choose to reload Access Connections pane Register PostgreSQL Instance … Continue reading Azure Data Studio :- Extension – PostgreSQL

Azure Data Studio :- Installation

Background Having a hard time getting SQL Server Management Studio ( SSMS ) to work in a very edge case. Sought to see if I can get around it. Azure Data Source What is Azure Data Studio? Link Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises … Continue reading Azure Data Studio :- Installation