Dltd

Executing Python in MSSQL

MSSQL 2017 includes Microsoft Machine Learning Services, which allows for the execution of Python and R scripts within MSSQL via sp_execute_external_script. This is an expansion of the functionality available in MSSQL 2016, which allowed for the execution of R scripts with SQL Server R Services. Examples of how to abuse this functionality with R scripts are available elsewhere.

To execute Python code:

• Machine Learning Services (In-Database) and Python must have been selected during installation
• External scripts must be enabled
  • EXEC sp_configure 'external scripts enabled', 1
  • RECONFIGURE WITH OVERRIDE
  • Restart the database server
• The user must have EXECUTE ANY EXTERNAL SCRIPT

Dltd

#include <TFT_eSPI.h>
#include <BLEDevice.h>
#include <BLEScan.h>

class MyAdvertisedDeviceCallbacks : public BLEAdvertisedDeviceCallbacks {
public:
  void onResult(BLEAdvertisedDevice advertisedDevice);
  bool isNewDevice(BLEAddress address);
  void displayDeviceInfo(BLEAdvertisedDevice device);
  void displayMessage(String line, int fontSize, uint16_t textColor, uint16_t bgColor, bool flash, bool center);