Reputation
12,635
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
28 59
Newest
 Nice Answer
Impact
~376k people reached

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
Sep
24
awarded  Autobiographer
Sep
1
comment How to architect an analytical BI platform?
I doubt you'd find any objective case studies on this sort of kit. It starts at 6 digits and goes up from there, so independents like AnandTech are never going to buy up a batch of machines for comparison. The majority of literature will come from the vendors and should be taken with a grain of salt.
Aug
31
revised How to architect an analytical BI platform?
added 40 characters in body
Aug
31
comment How to architect an analytical BI platform?
There is a question hidden in here, asking whether OP is likely to need a different DBMS platform to support ETL for the system. @sfactor - you might try re-phrasing the question to make this a bit more clear.
Aug
31
answered How to architect an analytical BI platform?
Aug
20
comment Stored Procedure null parameter within where clause
You can also inline this sort of thing with and isnull (@Parameter3, Table1.ID2) = Table1.ID2, although the query optimiser won't get much more joy from it.