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
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
A garden snail carries its shell from one wet stepping stone to the next, a silver trail behind it.

Contained Databases and Contained Users

February 5, 2009
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Migration, SQL Server Security

Understand contained users in SQL Server databases, how they travel with a database, and the security trade-offs of partial containment.

Read More
An old oak with a propped limb inside a low fence with one gate, a young sapling planted nearby.

Protecting an Instance You Cannot Patch Any More

August 8, 2008
Pinal Dave
SQL Tips and Tricks
SQL Migration, SQL Patch, SQL Server, SQL Server Security, SQL Upgrade

Protect an Instance You Cannot Patch with isolation, least privilege, disabled features, tested backups, and a firm retirement date.

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

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