48,802 reputation
476132
bio website
location Malta
age 45
visits member for 3 years, 11 months
seen Dec 24 at 9:06

aka Shawn

  • SQL Server Developer/DBA
  • MySQL Developer
  • British expat
  • Code monkey

Dec
23
comment Does Sql Server 2008 support Database Sharding
@clickstefan: which is what SQL Server/Oracle.PG/Sybase do too
Dec
22
comment Does Sql Server 2008 support Database Sharding
@clickstefan: none of those are real "scaling out" in the sense of "add more nodes"
Dec
22
comment What are the arguments against or for putting application logic in the database layer?
@Pacerier: adds complexity and now you have many scale out nodes to manage. When should these flush to persistent storage in the database. However, this Q is about ORMs and logic
Dec
12
comment Migrate SQL Server binary datadump to postgresql
You need to attach or restore it depends on the source format.
Dec
12
comment Migrate SQL Server binary datadump to postgresql
Not in any readable or useful way. For example, Red Gate Compare tools can read backups but only to compare against another live SQL Server database. Not to read for ETL or to extract data
Dec
12
answered Migrate SQL Server binary datadump to postgresql
Dec
11
answered MS SQL Server 2012 reusing numbers
Dec
8
awarded  Guru
Dec
6
comment Unable to install
@shanky this is the reason. An older version SQL on a newer OS
Dec
6
awarded  security
Dec
5
revised PostgreSQL - retrieving max primary key column to insert a new row - any alternatives?
added 121 characters in body
Dec
5
comment Cascade primary key update to all referencing foreign keys
Drop and recreate...
Dec
5
answered PostgreSQL - retrieving max primary key column to insert a new row - any alternatives?
Dec
5
answered Cascade primary key update to all referencing foreign keys
Dec
5
comment SA Account has not been disabled
See msdn.microsoft.com/en-us/library/ms189828.aspx for CHECK_POLICY etc
Dec
5
comment SA Account has not been disabled
Yes, it will break an application that uses it: if an app does, I'd suggest it's a badly writtn app. It won't break SQL Server the application though
Dec
5
answered SA Account has not been disabled
Dec
5
answered Unable to install
Dec
5
answered Filter and then sort products by availability
Dec
5
revised How to get data from multiple tables in one row
added 2 characters in body