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 a friendly open guidebook beside database towers, gears and a winding path

Verify a Migrated Database: Row Counts and Checksums per Table

July 3, 2018
Pinal Dave
SQL Tips and Tricks
DBA, SQL Azure, SQL Migration

You can verify a migrated database with two numbers per table: a row count and a checksum. In this test the row counts matched in both copies while the checksums exposed a changed price and a changed city. It also shows the case change that one checksum function missed and another caught.

Read More
Seven cloth bundles of silverware on a sideboard, one opened and freshly polished beside a red tin.

Splitting DBCC CHECKDB Across the Week for a Large Database

May 2, 2018
Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Server, SQL Server DBCC

Keep a large database under regular integrity checks by splitting DBCC CHECKDB work across seven nights and auditing coverage.

Read More
A reusable tool kit remains organized while one tool is inspected beside a sample joint.

PowerShell – How to Install dbatools?

April 25, 2018
Pinal Dave
SQL Tips and Tricks
DBA, PowerShell, SQL Server

dbatools installs as a PowerShell module on a Windows management machine. Rob Sewell, known as DBA with Beard, introduced me to it.

Read More
Three wheelbarrows beside three pebble heaps, the biggest heap next to the wide red barrow.

Faster Backups With BUFFERCOUNT and MAXTRANSFERSIZE, Measured

April 12, 2018
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Performance, SQL Server

Measure faster backups by changing BUFFERCOUNT, MAXTRANSFERSIZE, and backup stripes one at a time while tracking speed and memory.

Read More
A frog on a stone at the edge of a pond with tadpoles in the water below, a red dragonfly above

JSON Column Index in SQL Server: Index One Property

April 5, 2018
Pinal Dave
SQL Tips and Tricks
DBA, JSON, NoSQL, SQL Index

A JSON column index is one of the first tools a DBA needs when documents arrive in SQL Server. This test stores 100,000 recipes as JSON, searches one property with no index, then indexes it through a computed column. It also shows the cast that quietly breaks the match and how missing keys behave.

Read More
A polished wooden ship's wheel on an old ship's bridge with a child's swimming bag hanging from one spoke.

Finding User Objects in master Created by Accident

July 24, 2017
Pinal Dave
SQL Tips and Tricks
DBA, SQL Dependency, SQL Server, SQL System Table, System Database

Find user objects in master, inspect their purpose and dependencies, and prepare a safe move without removing deliberate server helpers.

Read More
A bookcase with every shelf about two-thirds full, leaving space for new books, one being slipped into a gap.

Finding Which Indexes Use a Custom Fill Factor Setting

March 22, 2017
Pinal Dave
SQL Performance
DBA, SQL Data Storage, SQL Index, SQL Server

Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.

Read More
Previous 1 … 5 6 7 8 9 10 11 … 45 Next
  • Books
  • Testimonials
  • Privacy Policy

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