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 open suitcase on a bed, one side empty with its straps showing and the other side packed with folded linens under a red strap.

DACPAC vs BACPAC Quiz: Which File Carries Your Data?

January 13, 2012
Pinal Dave
SQL Puzzle
Cloud Computing, Schema, SQL Backup and Restore, SQL Migration

This DACPAC vs BACPAC Quiz asks which file moves a database with its rows to Azure SQL Database. The answer is the BACPAC. A tested script shows what each file describes, and the SqlPackage commands show how to use them.

Read More
Two storks with red beaks rearranging sticks in a new nest on top of a village chimney

Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences

May 1, 2011
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Identity, SQL Migration, SQL Server

Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.

Read More
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
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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