Everyone writes about AI generating queries. Here are nine unusual ways my clients use AI with SQL Server, and I helped build every one.
SQL SERVER – FIX: Number Data Type from Oracle Linked Sever Shown in Scientific Notation
A client saw numbers from an Oracle linked server shown in scientific notation in SQL Server. Here is the query that shows the issue and how to fix it.
How is Oracle Temporary Table Different from SQL Server? – Interview Question of the Week #133
How is an Oracle temporary table different from SQL Server temp tables? A question from our hiring interviews, with the syntax on both sides.
Oracle to SQL SERVER Migration – Triggers Used While Migration
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.
SQL SERVER to Oracle Numeric Datatype Mapping
An app moved from Oracle to SQL Server slowed down under load. Here is what I learned about Oracle numeric datatype mapping while tracking it down.
Comparison – Logical Architecture between Oracle and SQL Server
Continuing my Oracle vs SQL Server series, I compare the Logical Architecture of both, using simple analogies to map what you know to what you don’t.
Comparison – Understanding Tables Between Oracle and SQL Server
How do Oracle’s table types map to SQL Server? Heap, index-organized, external, object and more, compared side by side with the SQL Server name for each.