Viewing 15 posts - 1 through 15 (of 322 total)
It was this line:
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
That gave me an error, however
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add
June 10, 2020 at 2:38 pm
Really good article, this was something I had never attempted before and following your notes I now have SQL Server running on Ubuntu. ;o)
Only issue I had was with a...
June 7, 2020 at 12:53 pm
Nice article, however one issue I have with DMA is that it displays a green tick mark for databases that will migrate with no issue, however it is still worth...
February 25, 2019 at 8:13 am
Is it possible to move this to 2016 Development and T-SQL forum?
December 20, 2018 at 9:29 am
Just be aware that the DMA tool shows a green tick mark for databases that will upgrade, however you should click the name as it will show any issues with...
December 20, 2018 at 8:04 am
You'll incur the wrath of Allan Hirt!
December 20, 2018 at 5:18 am
You can now use Database Backup Compression with TDE: https://www.brentozar.com/archive/2016/07/tde-backup-compression-together-last/
Just make sure you are patched to the very latest level, as they are bringing fixes out...
November 19, 2018 at 3:59 am
Thank you Jeff, my pleasure. This is part of a huge migration to Azure (we go live this weekend) however once I get my life back, yeah I think that's...
September 4, 2018 at 3:37 pm
I am just please we found a solution as when you are dealing with 10+ year old code and you are moving it to Azure/Cloud you can run into issues...
September 4, 2018 at 3:48 am
Right, we have a solution! Two things, one of the DBAs here decided to stick the offending code into a temp table. Hey presto - the process runs in just over...
September 3, 2018 at 9:25 am
Another update (for anyone that cares) 😀 I did some tests with running the process and using resource monitor to see what was going on whilst it was running. CPU,...
September 2, 2018 at 4:06 pm
August 31, 2018 at 8:36 am
Do you mean move data from Oracle to a VM on Azure (IaaS) running SQL Server? Or do you mean Oracle to Azure SQL Database? (PaaS)
August 31, 2018 at 5:25 am
Have you tried this method?
August 31, 2018 at 3:17 am
Just a further update on this for anyone with similar issues. Firstly we looked at the entire on-premise SQL environment to see what was happening:
1. MAXDOP was set...
August 31, 2018 at 2:50 am