Database administrator with 14+ years of hands-on experience in database management and database design. After spending 15 years as a SQL Server DBA, I've witnessed numerous technological evolutions, ...

In this section, you'll learn how to create and use [native external tables](develop-tables-external-tables.md) in Synapse SQL pools. Native external tables have better performance when compared to ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

Temporal tables might increase database size more than regular tables, especially if you retain historical data for a longer period of time. Hence, retention policy for historical data is an important ...

returns all matching rows in both tables, in addition to rows in the left table that have no matching rows in the right table. returns all matching and unmatching rows from both tables. In all three ...

The indexes on a the tables of a large database make a huge difference in its performance and utility. Without an index, locating a single record in a large table can take several seconds; with the ...