Postgres vs MSSQL

preview_player
Показать описание
#sqlserver #sql #dba #database #azure #microsoft #tips #brentozar #pollgab #computerscience #computerconsulting #database #databaseadministrator #careergoals #spanishsubtitles #Postgres #Postgressql

10:32 Justin: Besides price, is PostgreSQL miles ahead of SQL Server?
Postgres vs MSSQL
  1. Brent Ozar Unlimited
Рекомендации по теме
Postgres vs MSSQL 0:00:43

Postgres vs MSSQL

SIMPLY EXPLAINED: MYSQL 0:05:31

SIMPLY EXPLAINED: MYSQL vs POSTGRESQL vs SQL SERVER

Why PostGreSQL is 0:10:21

Why PostGreSQL is better than MS SQL

MySQL vs Postgresql 0:16:05

MySQL vs Postgresql vs Microsoft SQL Server Management Tools | Which Option is Best?

Postgres vs SQL 0:00:42

Postgres vs SQL Server

Comparing SQL Server 1:01:15

Comparing SQL Server and PostgreSQL | PostgreSQL 101

Differences Between MS 0:09:23

Differences Between MS SQL Server and Postgres

PostgreSQL vs MySQL 0:06:33

PostgreSQL vs MySQL

PostgreSQL 101 Webinar 0:31:08

PostgreSQL 101 Webinar Comparing SQL Server and PostgreSQL - Q&A Session | Redgate

Understanding SQL Flavors: 0:03:47

Understanding SQL Flavors: PostgreSQL vs SQL Server Explained

PostgreSQL in 100 0:02:37

PostgreSQL in 100 Seconds

MSSQL vs Postgres 0:01:44

MSSQL vs Postgres

PostgreSQL Features That 0:00:55

PostgreSQL Features That You Can't Do in SQL Server

MySQL vs PostgreSQL 0:10:41

MySQL vs PostgreSQL Performance Benchmark (Latency - Throughput - Saturation)

MySQL vs PostgreSQL 0:04:12

MySQL vs PostgreSQL vs SQLServer

Why I switched 0:02:33

Why I switched from MongoDB to PostgreSQL (Rasmus Porsager)

Some Differences Between 0:22:09

Some Differences Between SQL Server and Postgres Part 1

Databases: Postgres vs 0:01:31

Databases: Postgres vs SQL Server

Roadmap for Learning 0:04:52

Roadmap for Learning SQL

SQL vs MySQL 0:00:56

SQL vs MySQL vs PostgreSQL #shorts

SQLite vs PostgreSQL 0:14:01

SQLite vs PostgreSQL Performance

SQL и POSTGRESQL 0:05:36

SQL и POSTGRESQL | Урок #4. Почему PostgreSQL?

MySQL vs PostgreSQL: 0:02:17

MySQL vs PostgreSQL: Which Database Should You Choose?

MongoDB vs. PostgreSQL: 0:14:35

MongoDB vs. PostgreSQL: Performance & Functionality

Комментарии
Автор

For me Range indexes are great in Postgres. I’m glad MsSql also added partition tables.

keyboard_g
Автор

Fully integrated sql language is a huge advantage for db logic. The fact that you can use user_id() and other internal functions in sqlserver at any time during ddl, dql, or dml makes it a no-brainer for choice. Cross-table constraints checks, views with built-in checks... huge plusses for data integrity and business logic. As far as price point is concerned, you can operate on the express version for up to 10gb until you are revenue generating, after which you can operate a standard license relatively inexpensively.

I think you pay the price for the lack of features in postgres with complexity due to having to install and manage databases that require extra external configuration, and external business logic to make your data work the way you need it to.

weneedtogoback