GitHub

SQL Server First Responder Kit

You're a DBA, sysadmin, or developer who manages Microsoft SQL Servers. It's your fault if they're down or slow. These tools help you understand what's going on in ...
GitHub

kansiris/SQL-interview-questions

1 What is an inner join in SQL? 1 What is an outer join in SQL? 1 What is full join in SQL? 1 What is left join in SQL Server? 1 What is a right join in SQL Server? 1 What is database engine in SQL ...
InfoWorld

Using PostgreSQL as a vector database in RAG

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...
Microsoft

Return an Array from Flow to PowerApps (Response Method)

Update 2018-06-06: Please not that in the step involving reviewing the schema for the Response step, be sure to check that each column’s type is specified as string, integer, boolean, etc. or the flow ...
Microsoft

Return an array from a SQL Stored Procedure to PowerApps (Split Method)

Author’s note: this blog has been updated with a link to the Request – Response method. Users who want to execute a SQL stored procedure in Flow can now send its resulting array into PowerApps. The ...