ProfessionalAmateur

less info
241 reputation
211
bio website cosmonautdreams.com
location Denver, CO
age 36
visits member for 2 years
seen Jul 22 at 17:43

Senior Oracle JD Edwards EnterpriseOne Developer
EnterpriseOne JD Edwards CNC Administrator
https://github.com/ProfessionalAmateur
http://www.cosmonautdreams.com


Jul
2
awarded  Curious
May
6
comment Help understanding SQL Server Developer License when users test via webserver
Thanks. Its 100% testing only. Appreciate the input.
May
6
comment Help understanding SQL Server Developer License when users test via webserver
@MaxVernon - Thanks. Do you know how this is handled with employee turnover? If we buy 60 licenses for the dev box, but have turnover throughout the year (which is very common), but all the access is done via-multiplexing I'm not sure how to track active licenses for the year?
May
6
asked Help understanding SQL Server Developer License when users test via webserver
May
2
comment Compressions vs shrinking a database
It sounds like compression will increase your query performance (given that you have enough CPU to go around) and that shrinking will not affect query performance at all?
May
1
comment Restoring database from a server that uses data compression
Much appreciated. I'd have to check on licensing. It's for a large ERP install, Im not sure if we'd be able to switch to a developer version easily.
May
1
accepted Restoring database from a server that uses data compression
May
1
asked Restoring database from a server that uses data compression
Mar
27
accepted How does the Distributor know you have seeded/initialized your Subscriber using a backup?
Mar
17
comment How does the Distributor know you have seeded/initialized your Subscriber using a backup?
This is very helpful. When you create the publication, does it immediately start sending transactions to the distributor? Or does it wait until there is a subscription?
Mar
6
asked How does the Distributor know you have seeded/initialized your Subscriber using a backup?
Feb
11
awarded  Custodian
Feb
11
reviewed Approve suggested edit on Is my Publisher database my actual source database or is it a new database?
Feb
11
comment Is my Publisher database my actual source database or is it a new database?
Thanks. My next question is if we have a massive failure and need to restore the publisher to a point in time 24 hours ago, do we need to also restore the distributor database to a point 24+ hours ago? I think the answer is yes to to ensure the distributor only has records that are also in the publisher. There is no way the distributor to know the publisher has been restored in other words.
Feb
11
accepted Is my Publisher database my actual source database or is it a new database?
Feb
11
asked Is my Publisher database my actual source database or is it a new database?
Feb
11
awarded  Yearling
Feb
10
accepted Dropped the Distibution database before disabling publishing and distribution, how to proceed?
Feb
10
comment Dropped the Distibution database before disabling publishing and distribution, how to proceed?
Thanks, I had looked at this earlier and didn't think it would work because I had not done anything with the database yet. Found the MDF and LDF files and worked like a charm.
Feb
10
asked Dropped the Distibution database before disabling publishing and distribution, how to proceed?