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
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
Muddy new hiking boots beside a worn old pair on a porch step, a walking stick leaning on the rail.

Evaluating a New SQL Server Version in One Week

August 16, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Migration, SQL Server, SQL Upgrade, Testing

Evaluating a New SQL Server Version in one week works when you install, restore, run a real workload, compare results, and write a decision.

Read More
A new cast iron stove in an old farmhouse kitchen with a dented old kettle sitting on top of it.

What Changes When You Move to a New Major Version

May 12, 2009
Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Deprecated Feature, SQL Migration, SQL Server, SQL Upgrade

A New Major Version of SQL Server changes the engine while database compatibility, query plans, and deprecated features need separate review.

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

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