We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Which is best? SQL Server vs Postgres

Formal Metadata

Title
Which is best? SQL Server vs Postgres
Alternative Title
Dear SQL Server, I'm filing for divorce.
Title of Series
Number of Parts
20
Author
Contributors
License
CC Attribution - NonCommercial - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date2012
LanguageEnglish
Producer

Content Metadata

Subject Area
Genre
Abstract
Falling in love with the free spirit of Postgres Using the StackOverFlow datasets, we'll ditch all the drama of a Microsoft stack and convert from SQL Server to Postgres on Windows. Once we do that, we'll migrate our entire DB and Web App from Microsoft to Linux using Postgres and Mono with as few code changes as possible. Having the StackOverFlow dataset loaded into SQL Server and a mock StackOverFlow app in ASP.NET MVC3, we are going to show various ways to ETL into Postgres from SQL Server on Windows. Once that is done, we'll go over some basics of going from Postgres on Windows to Postgres on Linux as we attempt to migrate our app. Once we get our back-end moved, we'll show just how easily you can wire up ASP.NET MVC3 to Postgres and then move our entire stack to Linux using Nginx and Mono. Since I am a SQL Server DBA, I will also be adding lots of opinion on where Postgres really shines compared to SQL Server and where it doesn't. This session will be informative, entertaining and incredibly nerdy.