I currently rue the day when I decided to install SQL Server on a Windows Server without the desktop experience. Microsoft really did such a good job with SQL Server on Linux, in comparison, SQL Server on Core is just a nightmare. Anyway, I installed an evaluation version of SQL Server 2019 that expired just yesterday. I have a license and would like to add the new license key. So, as has been stated in many places all over the internet, I'm running the following command setup.exe /q /action=editionupgrade /instancename=NameOfMyInstance /PID=LicenseKey /IACCEPTSQLSERVERLICENSETERMS When I run this command, I'm first being informed that a valid key was detected and that I should make sure I have the proper license for it. But that's it, it hangs there and doesn't proceed. I ran the same command again, with progress indication turned on. This is where it hangs:

[...]
Sco: Attempting to connect script
Connection string: Data Source=.\NameOfMyInstance;Initial Catalog=msdb;Integrated Security=True;Pooling=False;Connect Timeout=300;Application Name=SqlSetup

So, to me it seems that in order to proceed with the setup, it really insists on connecting to the database. Which is not possible, of course, since the service is down and cannot be started due to the missing license. I'm at my wit's end. On server's with a desktop experience, this is really easy and works every time, you just run the edition upgrade with the installer, that's it. I'm really not sure what I can do here and any help from someone smarter is much appreciated. EDIT: Yes, it's definitely a problem that it tries to connect. After the timeout of 300 seconds, it complains that it cannot connect to the server and just tries again, in an endless loop.

We are planning to buy a SQL Server 2012 Enterprise edition license from AWS Marketplace for our company. We have exhausted our previous licenses and we need to add a new region with SQL Server in cloud. This SQL instance will be in peer-to-peer replication with SQL instances in other regions. I also found Microsoft certified vendors who sell these licenses. These vendors clearly specify the number of cores for which SQL edition is licensed. In AWS Marketplace though, I don't find the number of cores specified. Does that mean if I use a R5.2X EC2 instance to host this SQL edition, it will be licensed (and billed) for 4 physical cores and if I use it in a R5.4x EC2 instance, it will be licensed(and billed) for 8 physical cores? If anyone has experience buying SQL Server in AWS Marketplace, please advise. Thanks in advance!

I need to understand the below scenario On Sql server 2014 with compatibility mode of 2008R2, having 80 logical processors with 20 distributed amongst 4 numa nodes. I. E numa node 1 has 0-19 , numa node 2 has 20-39 and so on. While checking the cpu usage, we believe workload should be equally distributed amongst all of them. Sometime i see like equal distribution to some extent amongst all numa nodes to their processors. But some time lets say during maintainence window like backup or index main jobs or runs, why is that lets say numa node 0 and 1 will not have any equal usage compares to 2 and 3 or vice versa. As far as i think it should be equally distributed. Note we are running enterprise core edition. Is this expected or something missing in the settings of these cores? Update@ As said by Randolph, some process can go single threaded, i got it, but why out of the 80 they are using 80-90 % of cpu on few processors while other sitting idle. Cant the workload be equally divided when say there are 10-15 with high usage showing while remaining 50 odd processors sitting idle

please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally sized files. I want to size the files to fill the capacity of the drive. The dedicated drive has a capacity of 50GB but a recent ad hoc user query pushed the size up to 47GB (log is 2GB). Are the following order of steps correct? Will it require a restart of SQLServer? Will the files be used proportinally by SQL Server correctly after, i.e. not pushing contention to a new file? 1) Shrink the original data file down to 12GB using DBCC SHRINKFILE. * Size taken up by the drive should now be 14GB (2GB log + 12GB data file 1) 2) Add 3 new additional data files at 12GB each. * The drive should now be full at 50GB capacity This will be done during a planned outage on a production system, but wanted to know if there will be any potential issues with the approach? Thanks in advance.

- Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 - Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the server core of the Primary server that is the failover cluster (6 core) in my case or I can go with 4 core on the Log Shipped server to save licensing costs?

I'm trying to add the full-text search to sql server via command line since we got a core-server. I already searched the web but all I get is adding it with GUI or re-installing the complete SQL-instance. Anybody got any idea how to do? (Hope it's on-topic, sorry otherwise: I'm not a DBA, where should I ask?)

I am curious about patching on SQL Server. Does anyone know if SPs and CUs make any changes to user database files or is it just the database engine and instance level binaries that get modified/updated? Thanks

See this question for reference. https://dba.stackexchange.com/questions/107680/can-data-streams-from-informatica-to-sql-server-be-multi-threaded I've got most of my problem figured out. I've split up the one large table into four smaller tables. I'm now moving the data from the four source tables to four target tables. Each in their own mapping. In Workflow Manager, each mapping is a separate session, inside of its own workflow. And then I have a master workflow with four command tasks calling the four workflows. How do I isolate the connections so that each command connects to the target SQL Server database, so that each runs on a different processor? EDIT: Informatica also has functionality called "Partitioning", which does exactly what I did here. It splits the data up however you want. But there is some Informatica server level setup for this to work.

I'm in the process of building the lab for 70-462 exam. On page 49 of the text, it provides the command to install SQL 2012 on Windows Server Core: Setup.exe /qs /Action=install /Features=SQLEngine,IS,Conn /InstanceName=MSSQLServer /SQLSYSADMINACCOUNTS="Contoso\kim_akers" /IAcceptSQLServerLicenseTerms When I run this code, it appears things are running fine, the GUI window comes up and shows progress, then all the sudden it quits, the GUI goes away, and then I'm left with the following at the CLI: The following error occurred: Object reference not set to an instance of an object. Error restult: -2147467261 Result facitlity code: 0 Result error code: 16387 Please review the summary.txt log for further details I've done some searching and haven't come up with much. Further, I don't know how to access this "summary.txt" file as it isn't anywhere to be found on the C:\ drive, so I can't see what file is stating. Other details: - This is a lab built on top of Windows 8.1 (x64) using the Hyper-V feature. - 16 GB of RAM, with 2GB installed for each - Huge hard drive - 8-core CPU - The same ISO/DVD was used to install all the graphical versions of SQL server, so I don't think it is corrupt download - All OSes are x64 Windows Server 2008 R2 - SQL Server 2012 x64 SP1 (I've also tried with SQL 2012 minus SP1) If anything else is needed, let me know. **Edit #1 5-10-15 1:15pm CST** When I execute the dir command in the folder suggested by Shanky, I get: - (DIR) Datastore_ComponentUpdate - (DIR) Datastore_GlobalRules - (DIR) resources - (DIR) Watson_1 - Detail_ComponentUpdate.txt - Detail_GlobalRules.txt - Registry_SOFTWARE_Microsoft_MSSQLServer.reg_ - Settings.xml - Setting_GlobalRules.xml - SQL-CORE_20150510_091104_Watson_ComponentUpdate.txt - Summary_SQL-CORE_20150510_091104_ComponentUpdate.txt - Summary_SQL-CORE-20150510_091104_GlobalRles.txt - SystemConfigurationCheck_Report.htm

Is there a command at the CLI or in PowerShell that will list the components installed for SQL? I'm looking for something like the Feature List you can get from running the discovery report from Tools in the SQL Server Installation Center program option. I'm running SQL Server 2012 on the CORE version of Windows Server 2008 R2 Enterprise. I've searched around the Net, but haven't found anything useful.

When using a traditional installation of SQL Server one has the Installed SQL Server features discovery report. Googled and found no info if some equivalent was available for the core installation. It outputs to HTML so that is another reason why I believe it is not available (though one could still type its text). So basically, I'd like to know if there is an equivalent on the core version, or what powershell (or command line) could be run to get the same info (version, installed features)?