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
An old narrow pair of railway wheels on its axle resting beside a newer, wider track it no longer fits.

Checking 32-Bit Leftovers: Linked Server Providers and ODBC Drivers

March 27, 2011
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Migration, SQL Server, SQL Server Agent, SSIS

Find 32-bit dependencies in linked servers, Agent steps, SSIS execution choices, and Windows ODBC drivers before a server move.

Read More
An old car drives along an empty road at dusk, past a roadside garage with its shutters closed.

End of Support: What Actually Stops Working

December 19, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Server Security, SQL Upgrade

End of Support does not shut down SQL Server, but it changes security updates, fixes, and help; plan an exit before risk grows.

Read More
An upright piano on a dolly at the foot of narrow stairs while a mover measures the doorway with a string

Assessing a Database Before a Migration

August 24, 2010
Pinal Dave
SQL Tips and Tricks
Compatibility Level, DBA, Query Store, SQL Migration

Assessing a database before a migration covers features in use, compatibility, size, dependencies, and the evidence needed before a date is promised.

Read More
Three wooden gauges with finite end stops and fitted measuring bars in a sunlit workshop.

Unsigned Integers: Safe Type and Range Mapping

July 12, 2010
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Datatype, SQL Migration, SQL Server

Map unsigned integers to SQL Server types without narrowing their range. Keep strict source-text validation separate from destination CHECK constraints.

Read More
A brass balance scale on a market stall weighing a heap of vegetables against a stack of plain iron weights.

Estimating Cloud Database Cost From Your Workload

May 6, 2010
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Licensing, SQL Migration

Cloud database cost depends on measured compute, storage, backup retention, and network egress; build a workload-based estimate before migrating.

Read More
Hands fitting old wooden drawers into a new cabinet, one drawer too wide to slide into its opening

Mapping MySQL Data Types to SQL Server

February 19, 2010
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Datatype, SQL DateTime, SQL Migration, SQL Server

Mapping MySQL data types requires checking signed ranges, text encoding, date limits, and application behavior before choosing SQL Server columns.

Read More
A railway guard seen from behind holding a raised red flag beside a waiting train on an empty platform

A Migration Cutover Checklist

January 13, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Migration, SQL Server Agent

A migration cutover checklist covers final backup, logins, jobs, linked servers, DNS, validation, and an explicit go or no-go decision.

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

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