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 of three containers on a long table: a spice rack of identical plain jars in perfect rows with one vermilion lid, a tackle box with mixed compartments, and a loose heap of shells, stones and dried leaves.

Structured, Semi-Structured and Unstructured Data Explained

October 26, 2012
Pinal Dave
SQL Tips and Tricks
Database, JSON, SQL Data Storage, SQL Datatype

Structured, Semi-Structured and Unstructured Data differ in where the schema lives and how you query them. This post compares the three shapes and runs one query across a table, a json column and free text in SQL Server 2025.

Read More
Punch needle beside a continuous stitched row with its last loose loop withdrawn

Gapless Invoice Numbers That Restart Every Year

October 25, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Transactions

Finance hates a missing invoice number. A small counter table and one short transaction keep the numbers gapless and restart them each year.

Read More
Gouache painting of two disconnected brass couplers on a braided cable between file boxes, with a red test clip.

SQL Server Connection Errors: SQL in Sixty Seconds #030

October 24, 2012
Pinal Dave
SQL Video
SQL Connection, SQL Error Messages, SQL in Sixty Seconds, sqlcmd

SQL Server connection errors have a different message for each cause. The tests here trigger seven of them against a local SQL Server 2025 instance, show what the client says, what the ERRORLOG records, and how to find the port an instance listens on.

Read More
SQL SERVER - Order By Numeric Values Formatted as String

SQL SERVER – Order By Numeric Values Formatted as String

October 23, 2012
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL String

A column holds alphanumeric values that start with a number, and ORDER BY sorts them as text. Here is how to sort the rows by the Numeric part instead.

Read More
A roofer laying overlapping wooden shingles: one long continuous run, a bare gap, then a short second run.

Merging Overlapping Date Ranges Into Continuous Periods

October 22, 2012
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL DateTime, SQL Scripts, SQL Server

Use running end dates when merging overlapping ranges, choose boundary rules, and return continuous periods without losing nested intervals.

Read More
Three wooden shoe lasts of different sizes on a cobbler's shelf, a leather upper tacked over the middle one.

Server Configuration as Code

October 21, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, DevOps, SQL Server Configuration

Configuration as code keeps SQL Server instance settings in reviewed scripts, with environment values, drift checks, and repeatable application.

Read More
SQLAuthority News - Who I Am And How I Got Here - True Story as Blog Post

SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post

October 20, 2012
Pinal Dave
Personal
Best Practices

People ask me for the secret to success. At John Sansom’s invitation, I wrote the true story of who I am and how I got here.

Read More
An aquarium built into a wall between two rooms, the same fish seen from both sides as a hand feeds them.

FileTable: Files You Can Open in Explorer and Query in T-SQL

October 19, 2012
Pinal Dave
SQL Tips and Tricks
Filestream, SQL Backup and Restore, SQL Data Storage, SQL Server

Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.

Read More
Column names in archive table.

SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

October 18, 2012
Pinal Dave
SQL Tips and Tricks
SQL System Table

A reader had archive and current tables in pairs, but the schemas drifted apart. Here is my way of finding different ColumnName values in almost identical tables.

Read More
A hand holding a steel punch over a new silver spoon on an anvil, ready to stamp its maker's mark.

Audit Columns From Day One: CreatedAt, UpdatedAt and Who Changed It

October 17, 2012
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Constraint and Keys, SQL DateTime, SQL Server, SQL Trigger

Add audit columns with UTC timestamps and trusted change identities, maintain updates in procedures, and know when history is needed.

Read More
Previous 1 … 361 362 363 364 365 366 367 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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