[SQL 2012] Installed wrong edition |
- Installed wrong edition
- Data Type Money is adding extra zero
- Syncing/Refreshing data from one environment to another
- GEO - Spatial
- Become a License Reseller or Not?
| Posted: 10 Sep 2013 05:32 PM PDT Hi,I installed Standard Edition of SQL Server 2012 instead of Enterprise Edition. Do I have to remove all of the features before installing enterprise edition or is there a shortcut I could take?ThanksG |
| Data Type Money is adding extra zero Posted: 10 Sep 2013 07:52 PM PDT Trying to copy one table to another in sql 2012, data type was set before me. Strangely, my end result have 10 times more money. I.e 27152555833.00 would appear as 271525558330.00 in end column?The tables are identical, anybody have any idea why it would happen? |
| Syncing/Refreshing data from one environment to another Posted: 10 Sep 2013 11:01 PM PDT Hi,We have dev,test and prod environments. The developers make the DDL and data changes on dev and the we will have to move this to test and after the successful testing changes has to be moved onto prod.Right now I am using redgate sql campare and sql data compare to achieve this.Is there any better way of doing this? Sometime a table data in one environment has to be updated with the data from the other as part of the database sync. For this I use import/export or BCP to move data to destination server db and then run the update command.I am wondering is there is any better ways of doing this?Thanks. |
| Posted: 10 Sep 2013 05:09 AM PDT I need to find the name of the county based on longitude and latitude values. Could someone give some ideas on how to do it? We will buy data somehow . I have done some coding but all I get is the nearest county. That may not be the right county because of boundaries.Any help would be greatly appreciated. |
| Become a License Reseller or Not? Posted: 10 Sep 2013 02:46 PM PDT I've been pondering this question for awhile now and i just can't seem to find worthwhile information without initiating the process possibly further than i'm interested.Now a bit of background...Been working for a software company going on 8 years now and we sell a mid-tier (40-60k typical installation cost) small business asset management system. We are a SQL Server product, yet as a company do not provide or even refer prospects and new clients to a var/lar to purchase SQL Server if they do not already have it for other packages.We've always taken the approach of letting the customer find a reseller, at which time they typically buy it from a local IT company, then pass it off to my company to install/configure/maintain/troubleshoot.This seems to be increasingly common as our markets move into more and more remote locales and smaller upstart companies.My question is, does anyone know if starting a small license reseller company to simply provide a complimentary service to our customers (our owners don't seem to have a problem with the idea) is worth it/a good idea simply to pick up 5-10 SQL Server licensing deals a year (most are going to be server + cal it seems as they are under ~25 users and that seems to be how most are being steered as far as i can tell)? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment