This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting: a garden irrigation channel of stone with small wooden gates that direct the flowing water to different vegetable beds; one gate is vermilion

First Look at Apache Airflow 3.0: A Game-Changer in Workflow Orchestration

June 27, 2025
Pinal Dave
SQL Tips and Tricks
Apache Airflow, ETL, Python

If you’ve spent any time wrangling data pipelines, you know that Apache Airflow is a staple in the orchestration world. Let us learn.

Read More
Execution plan.

Apache Spark and Airflow in Action : My Experience

November 28, 2024
Pinal Dave
SQL Tips and Tricks
Apache Airflow, ETL, Python

Recently, I’ve been working with a large client where we’re diving deep into Apache Spark and Apache Airflow. Let us learn!

Read More
Tesseract OCR

Python – Simplifying Text Conversion with OpenCV and Tesseract OCR

November 30, 2023
Pinal Dave
SQL Tips and Tricks
Python

Instead, I took a clear photo and used OpenCV and Tesseract OCR to extract the text automatically. With just a few lines of code.

Read More
opencv

Python – Image Processing with OpenCV

November 29, 2023
Pinal Dave
SQL Tips and Tricks
Python

OpenCV provides a comprehensive set of tools and algorithms for image processing, allowing you to easily manipulate and enhance images.

Read More
jupyter notebook

Python – Why I Prefer Jupyter Notebook

November 20, 2023
Pinal Dave
SQL Tips and Tricks
Python

As a developer who frequently works on Python projects, I’ve come to prefer Jupyter Notebook for various reasons.

Read More
Gouache painting of a plain stone sundial next to a sand hourglass with a vermilion frame

Current Timestamp in Python and SQL: One Format, Two Tools

September 23, 2021
Pinal Dave
SQL Tips and Tricks
Python, SQL DateTime, SQL Server

To get the current timestamp in Python, import datetime, call now and format the result with strftime. This post prints the same date and time in Python and in T-SQL, compares the two clocks, and shows how to ask for UTC in both.

Read More
A sushi rolling mat shaping ingredients outside their original bowls

sp_execute_external_script: Run Python Inside SQL Server

September 22, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Python, SQL Server

Before you write any Python, check four switches. Here is how to read them, what error 39023 means, and what to test on your own server.

Read More
1 2 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com