Reputation
13,035
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 29 61
Newest
 Caucus
Impact
~432k people reached

Jul
28
awarded  Caucus
Jul
24
awarded  Great Answer
Jul
20
awarded  Nice Answer
Jun
10
awarded  Yearling
Jun
4
revised Is business intelligence (BI) primarily a technical project or a business project?
added 118 characters in body
May
26
comment Why have both a postmaster and postgres executable?
It was historical. Back in in the earlier days of Postgres it used a fork-exec process to spawn instances of the DBMS, which would then attach to shared memory and synchronisation resources. This was widely used on unix based DBMS platforms of the client-server era - Informix SE, INGRES, interbase, early versions of Sybase, Progress and probably some others worked in this way. Even Oracle has a mode where you can bring it up in this way. Postmaster was a gateway daemon that listened on a port (5432 by default) and spawned instances of the main server when a client connected to it.
Apr
20
awarded  Nice Answer
Apr
6
reviewed Approve What characters are word breakers in English for SQL Server 2005 and 2008 R2?
Apr
6
reviewed Close Time series and gap filling
Mar
11
awarded  Custodian
Mar
11
reviewed No Action Needed mysqlfailover utility (as a HA tool)
Mar
6
comment Integrating Postgres/GIS data in a SQL Server environment without generating 'data islands'
PostgreSQL is a reasonable choice as it has mature support for spatial data and plays nicely with most GIS frontends. You can still master the population and other data on SQL Server and then export it to PostgreSQL (or the other way if needed). SSIS is your friend here.
Feb
18
awarded  Enlightened
Feb
18
awarded  Nice Answer
Feb
2
awarded  Nice Answer
Feb
2
awarded  Nice Answer
Jan
22
awarded  sql-server-2008
Jan
20
answered Datawarehouse bad practice?
Jan
14
comment Free universe tool monitoring all database
Shopping list questions are off-topic for dba.se as they are primarily opinion based and do not necessarily have a definitive correct answer. See the FAQ
Oct
22
awarded  Taxonomist