I know I’m late here....but is anyone else excited about the partnership with Azure? Having deployed and maintained a SAS 9.4 instance in AWS, and constantly trying to optimize and bind AWS to disclose how they are supporting SAS operational requirements, I’m so excited to hear that MS will optimize SAS’ needs for running in the cloud! ... View more

My organization recently purchased Databricks as a complimentary analytic platform to run alongside SAS. While using Databricks natively through their notebook yields awesome performance via Spark technology, I am now wondering if I can use Databricks to replace all my current Oracle connections. Initial tests using pass-thru via ODBC has showed awesome performance gains (queries that would take hours if run in an Oracle database finish in under one to two minutes using a 11 node cluster). In spite of the potential, performance is only good when SAS does not try to orchestrate the completion of a query, and further, expecting users to only use pass-thru when connecting to Databricks is unrealistic. We are also doing a POC for MEMSQL as an alternative solution. My question, Margret or Tony, if you're reading this post please let me know if you've done any testing with these technologies :-), has anyone tried using Databricks or MEMSQL to underlay SAS 9.4 or SAS Viya? We recently purchased Viya and will be deploying in prod in late summer. We need to decide on a data layer, Oracle, Databricks, MEMSQL, or HDFS? So many options and I am hopeful someone has already blazed a path. If not I guess this will be a whitepaper for next year's SASGF!      Thanks everyone!  ... View more

Have you ever wondered who is hogging all the storage? Below are a few quick scripts you can consolidate in a .sh file that will expose data hoarders and will help you keep your environment nice and tidy!   echo -e "------------------------------------\n Storage Snapshot on `date`\n -------------------------------------" echo "Storage Snapshot" sudo df -h echo -e "------------------------------------\n   Top Storage Usage by SAMBA Share /mnt/storage \n -------------------------------------" sudo du -hs /mnt/storage/* | sort -hr | head echo -e "------------------------------------\n   10 Largest Files on SAMBA Share w/ Last Mod Date - /mnt/storage \n -------------------------------------" sudo find /mnt/storage -type f -exec du -Sh --time {} + | sort -rh | head echo -e "------------------------------------\n   Top Storage Usage for SASHOME /home\n -------------------------------------" sudo du -hs /home/* | sort -hr | head echo -e "------------------------------------\n   10 Largest Files in SASHOME w/ Last Mod Date - /home \n -------------------------------------" sudo find /home -type f -exec du -Sh --time {} + | sort -rh | head echo " "echo -e "------------------------------------\n   SAMBA Usage Report \n -------------------------------------" sudo smbstatus –b     Email output: ~$ ./storage.sh > ~/storage.txt ~$ mail -s "SAS Storage Snapshot for SASApp on `date`" sasadmins < /home/userid/storage.txt   * sasadmins is an alias set in the /etc/aliases   ~$ sudo vi /etc/aliases             add the following:                      sasadmins:          email1@address, email2@addres... ~$ sudo newaliases – this updates the config so you can use the new alias ... View more