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
Migration feature table.

Oracle to SQL SERVER Migration – Triggers Used While Migration

December 28, 2016
Pinal Dave
SQL Tips and Tricks
Oracle, SQL Migration, SQL Trigger

Moving from Oracle to SQL Server is like switching phones: old habits come along. A client tuning case about the triggers used during the migration.

Read More
Table mapping Oracle Number types to SQL Server types, from Number(19,0) to BigInt down to Number(10,4) to SmallMoney, with a note that Int or BigInt as a safe bet caused implicit converts

Oracle Number Data Types: The SQL Server Mapping Table

June 14, 2016
Pinal Dave
SQL Tips and Tricks
Oracle, SQL Datatype, SQL Migration, SQL Server

Oracle number data types need the right SQL Server match during a migration. Here is the full mapping as a table, and the implicit converts a safe bet of Int or BigInt caused for one product team.

Read More
A temporary wooden footbridge crosses a river from an old cottage to a newly built house.

Extended Security Updates Explained

October 12, 2014
Pinal Dave
SQL Tips and Tricks
SQL Licensing, SQL Migration, SQL Patch, SQL Server, SQL Server Security

Extended Security Updates give eligible older SQL Server releases limited critical security coverage while you complete a migration.

Read More
Two railway tracks of slightly different widths meeting, hands adjusting a carriage's red wheel at the join

Migrating From PostgreSQL to SQL Server: Types and Syntax Differences

August 9, 2014
Pinal Dave
SQL Tips and Tricks
PostgreSQL, SQL Datatype, SQL Migration, SQL Server

Plan migrating from PostgreSQL by checking identity values, Unicode, timestamps, paging, returned rows, collations, and upsert behavior.

Read More
Heavy snow boots on a hot sandy beach beside a pair of red sandals

MySQL Habits That Trip Up Developers Moving to SQL Server

April 25, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Collation, SQL Migration, SQL Server

Replace six MySQL habits with SQL Server equivalents for LIMIT, AUTO_INCREMENT, quoting, GROUP BY, duplicate inserts, and collations.

Read More
Two hands lifting an old wooden strongbox onto a moving trolley, its iron key tied to the handle with red string.

Moving SSRS Reports to a New Server

April 13, 2014
Pinal Dave
SQL Tips and Tricks
Reporting Services, SQL Backup and Restore, SQL Migration, SQL Reports, SQL Server

Moving SSRS reports to a new server requires the ReportServer databases, encryption key, data source checks, and subscription rehearsal.

Read More
A small one-person tent and a large family tent side by side at a campsite

Azure SQL Database or Managed Instance

February 23, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Migration, SQL Server Agent

Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.

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

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