Issue: How To Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory. In this article, we are going to
Month: January 2022
Stop Using Production Data For Development
A common software development practice is to take data from a production system and restore it to a different environment, often called “test”, “development”, “staging”,
Top 9 Snowflake Productivity Tools in 2022
#1 – SnowSQL CLI client SnowSQL is the command-line client to execute SQL queries and perform all DDL and DML operations, including loading data into
How to enable slow query log in PostgreSQL [2022 update]
PostgreSQL allows logging slow queries to a file, with a configured query duration threshold. Parsing the slow log with tools such as EverSQL Query Optimizer will
Top 5 SQL Optimization Tools in 2022
Companies have more data in today’s world, and queries that took a few seconds might take a few minutes or even hours. If you have
What are you using for query formatting and linting?
I want my queries version controlled. So they’re in a git repo. I’d like to start running automatic linting and formatting tools on my queries
Any reason to not use FIPS county codes as primary keys?
I’m building a SQL database, and one of the tables will have all the US counties. I was going to make the table have a
SQL Server overloaded when trying to buy tickets, is it possible to automate requests in the future?
submitted by /u/SquareCalligrapher33 [link] [comments] Go to Source of this post Author Of this post: /u/SquareCalligrapher33 Title Of post: SQL Server overloaded when trying to
Why do we need to close the cursor object?
I’m trying to understand why one needs to close the cursors? What does it holds? Given a toy example, what would happen if we don’t
Recommended SQL learning path. From beginner to expert.
Hello all. I want to increase my SQL knowledge and master this. I am looking for a good learning path that I can follow to