New answers tagged

1

I would not spend on dual controller; rather, if low service time are required, be sure to invest in enterprise-grade SSD: for maximum performance, you can/should use an Optane NVMe drive; if an Optane is too much, you can use an Intel P4610 (or Samsung equivalent); if budged is constrained, go with SATA drives as Intel S4610 or Samsung SM863a. Finally, I ...


0

So you're planning to give a whole load of users access to your database, merely not to have an audit trail where it actually should be? It's not "vague security concerns" that your colleagues have, but plain common sense. A database audit trail shows things like "this user updated/inserted/deleted that record". It doesn't say what actually happened, like "...


0

The package libssl1.0.0 on Debian (or Ubuntu) would refer to version 1.0.x of the Openssl library. In terms of connectivity, I would hope that MSSQL uses TLS 1.2 (or better, but I guess if they use Openssl 1.0 that means TLS 1.2 is the best available protocol version). Regarding the MSSQL packages, are there even packages for Debian? From what I can see ...


2

I think the simplest would be to try to telnet to MS SQL server from the command line: $ telnet <server-name-or-ip> 1433 If your connection was successful the screen goes blank, otherwise you'll see something like "Connecting to server-name-or-ip... Could not open connection to the host, on port 1433: Connect failed."


0

On the remote Microsoft SQL Server instance: make sure port TCP 1433 is open in the firewall. On the Ubuntu Server instance install the mssql-tools as described here: https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu sudo su curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/...


0

This is a very basic question, so I'll provide a basic answer, and that is: no, SQL doesn't have a way to import a spreadsheet. There are tools available depending on what programming language you choose, and you can "LOAD DATA INFILE" at least with MySQL (see this link http://www.mysqltutorial.org/import-csv-file-mysql-table/) for a CSV, but not an Excel ...


0

The specific answer depends on the database platform you are using. The basic steps are same. You need to "import" your raw data into the database. Your platform might have a GUI importer to ingest Excel, CSV etc. The raw data needs to be in a form that is readable by the database engine. For example, delimited text file or spreadsheet are good. In short, ...


0

You need to be sure that your connection string has password for your SQL Login or add configuration file for SSIS.


0

What is the output of $sqlServer You may also check this out: SQL PS Module Import SQL PS Module


-1

The current limitation of 2500 items expanded in one Object Explorer Node has been put in place to prevent the Tree View Control from exceeding the 64K limit when multiple Object Explorer nodes get expanded. The Windows XP and Windows Server 2003 version of the Tree View control has a bug where it just stops displaying nodes once the total number of nodes ...


0

Add the pdo.so library before all others of the pdo type. Use this order in php.ini extension=pdo.so extension=pdo_sqlsrv.so extension=sqlsrv.so After, restart with service apache2 restart Works for me.


1

The code you ran to change the server name looks correct assuming you have a default instance. If the results of [Select @@servername] and [Select * from sys.servers] returns the same name you changed it to, then it was changed successfully. The fact that the columns location, provider_string, and catalog contain NULL in the results appears not to be an ...


1

After deploying the SQL server you must reserve a Static External IP Address [1] and then assign the address to the VM instance with the SQL [2]. Then you can open the server ports following this public documentation [3]. This will be enough to make it work. If you are experimenting issues it would be nice to have more details like what is the error ...


0

If the research server only contains data based on the production DB, why not run SQL Server on your linux servers instead of MySQL? If your production database is less than 4GB (which it sounds like it is), you could run SQL Server Express edition for free. You would not need a separate export step. IT guys should already be making full and transaction ...


0

SQL Distributed Management Objects (SQL-DMO) is no longer included in SQL Server 2012, SQL-DMO applications should be converted to use SQL Server Management Objects (SMO). https://docs.microsoft.com/en-us/sql/database-engine/dev-guide/sql-dmo-mapping-to-smo?view=sql-server-2014 So no, on either Windows or Linux. Looks like the DMO replacement SMO ...


Top 50 recent answers are included