MSSQL database restoration to different database

You can get a range of different problems when trying to restore an MSSQL database to a different database. There are also a range of different solutions However, the following steps work for me.

These steps require MS SQL Management Studio.

In MS SQL Management Studio, create the target database, make note of the location of the database file and log file.
Start the restore process and select the appropriate backup file and backup date
On the "Restore Database" dialog, on the "General" tab, under "Destination" select the desired target database.
Select the "Files" tab. Within the "Files" tab, you'll see that the data and log file are pointing to the old database, change both the data and log file to be the database you created in step 1
In "Options", select the "Overwrite" option (WITH REPLACE)

Setting aspnet on linux to startup as a service

Good guide at https://swimburger.net/blog/dotnet/how-to-run-aspnet-core-as-a-service-on-linux

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)

Using SQL to query a CSV file

Using SQL to query a CSV file SELECT * FROM OPENROWSET ( BULK 'csv file name' , DATA_SOURCE = 'DataLake' , FORMATFILE='formatfile.fmt' , FORMATFILE_DATA_SOURCE = 'DataLake' ) AS x

Pauls Blog

Search This Blog