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
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
A loaf of bread on a cooling rack in front of a new oven, one end darker than the rest

Migrating From MySQL to SQL Server: The Gotchas

January 9, 2010
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Collation, SQL Migration, SQL Server

Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.

Read More
An old brass kitchen tap above a sink, with new copper pipes visible in the open cupboard beneath

Migrating From Access to SQL Server

December 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Datatype, SQL Migration, SQL Server

Migrating from Access to SQL Server can keep the familiar front end while tables move, linked tables are tested, and Access queries are rewritten.

Read More
A hand fits a round-pin charger plug into a red travel adapter on a desk

Oracle to SQL Server: Translating NVL, ROWNUM and Sequences

August 31, 2009
Pinal Dave
SQL Tips and Tricks
Oracle, SQL Migration, SQL NULL, SQL Server

Translate Oracle to SQL Server expressions for NULLs, row limits, dates, sequences and concatenation, and test where they differ.

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

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