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
Sealed glass jars of preserved peaches on a stone cellar shelf, with one jar opener hanging on a nail beside them.

Backing Up to Azure Blob Storage

April 19, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Backup and Restore, SQL Server

Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.

Read More
A parcel on a doormat before a closed blue door with a brass knocker, a gloved hand stepping back after knocking once.

Connection Retry Logic for Cloud Databases

April 12, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, Developer, SQL Azure, SQL Connection

Connection retry logic handles transient cloud database faults through bounded backoff, safe transaction retries, and driver connection resiliency.

Read More
A small one-person tent and a large family tent side by side at a campsite

Azure SQL Database or Managed Instance

February 23, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Migration, SQL Server Agent

Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.

Read More
An apartment block of bare balconies where only one is furnished with plants and a red awning

Running SQL Server on an Azure Virtual Machine

February 22, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Backup and Restore, SQL Server, Virtualization

SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.

Read More
Gouache painting of an old pencil sketch of a small building on worn paper beside a clean pale wood model of the same building, with a vermilion pencil resting between them.

Big Data Upgraded: The 2013 Series Rewritten for Today

October 30, 2013
Pinal Dave
SQL Tips and Tricks
Cloud Computing, Data Warehousing, Database, NoSQL

Big Data Upgraded is the reading path for 23 articles, most of them first written in 2013, now rewritten for today’s tools. Most new platforms now build on Spark, Parquet, open table formats and change data capture. Here is the whole set in reading order, with one line on each.

Read More
Gouache painting of a stone water mill with its wheel turning in a steadily flowing stream, and beside it a row of wooden barrels waiting for a cart, one barrel painted vermilion.

Batch vs Stream Processing: When Data Cannot Wait

October 29, 2013
Pinal Dave
SQL Tips and Tricks
Batch, Cloud Computing, Data Warehousing, ETL, Parallel

Batch vs Stream Processing is a choice about how long an answer can wait. This post compares an hourly batch job with a 5-minute stream window on the same six orders, covers the cost of real time and shows how to choose.

Read More
Gouache painting of a stack of loose blank pages being clipped into a sturdy ring binder with colored tabs along the edge and a vermilion ribbon bookmark, with older loose pages lying beside it.

Open Table Formats: Delta Lake and Apache Iceberg Explained

October 21, 2013
Pinal Dave
SQL Tips and Tricks
Cloud Computing, Data Warehousing, Database, File format

Open Table Formats turn a folder of Parquet files into a real table with transactions, history and safe schema changes. This post shows how Delta Lake and Apache Iceberg do it with a metadata layer, how a commit stays atomic, and what time travel means.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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