Swift – how to take a substring from another string (simple method)

Method:

func getSubstring(inputString: String, start: Int, end: Int) -> String{

    if(start >= inputString.count || end >= inputString.count){
        return "ERROR"
    }

    let start = inputString.index(inputString.startIndex, offsetBy: start)
    let end = inputString.index(inputString.startIndex, offsetBy: end)
    let range = start..<end

    let mySubstring = inputString[range]

    return String(mySubstring)
}

Usage:

 
        getSubstring(inputString: "String to search"
                     ,start: <START INDEX>
                     ,end: <END INDEX>)
        

Example:

    let fileName = "20211112_data_file.sqlite"

    let year = getSubstring(inputString: fileName, start: 4, end: 8)
    let month = getSubstring(inputString: fileName, start: 9, end: 11)
    let day = getSubstring(inputString: fileName, start: 10, end: 12)

    let date = day+"/"+month+"/"+year

    print(date)

Outpout:

    12/11/2021

Mac OSX – Stop OS X apache service and prevent automatic running (OS X SERVER)

I already run MAMP as a local server environment for apache and MySQL, so when I installed Mac OS X Server, which runs it’s own instance of apache, my server encountered problems with MAMP which failed to start.

After some investigation I found the OS X Server instance of Apache started with the system resulting in MAMP failing to start, with no obvious setting to disable the in-built apache services in the OS X Server app settings.

Here’s how to prevent the service starting automatically, then kill the existing service:

Step 1: Locate the following file: /Library/Server/Web/Config/Proxy/apache_serviceproxy.conf

Step 2: Comment out the listening ports in the file

Example using standard ports, change:
Listen 80
Listen 443

To:
# Listen 80
# Listen 443

This prevents apache from starting.

Step 3: Stop inbuilt apache server. Open Terminal, type: sudo killall httpd

Type the following to check http instance have stopped: ps -Al | grep httpd

Inbuilt apache service should now stop and won’t re-start.

Windows – How to free disk space by deleting previous Window(s) installations

Step 1: Click on the Windows search bar or press the start key on your keyboard, type cleanup, then select Disk Cleanup.

Step 2: Click ‘Clean up System file’

Step 3: Scroll to, and select, Previous Windows Installations. Click start to begin the cleanup process which will include the removal of previous Windows installations from your disk.

This freed almost 30Gb on my disk. This, of course, means you’re unable to revert back to your previous Windows installation so proceed with that in mind. I found the disk space more valuable than holding on to the files.

Mac OSX – How To Connect To A Remote Mac Using Apple Screen Sharing, For Free!

This article describes how to remote view another Mac using Apple Screen Sharing. There is no need to run any third party software as it can all be done using apple’s built in Screen Sharing services, for free! I’m using OS X EL Capitan, Version 10.11.13.

There is just one catch; both devices must use the same iCloud account. If you’re looking to connect to a Mac using different iCloud account then VNC is a good option. For now, I’ll concentrate on connecting to another Mac logged in with the same iCloud account.

Step 1: Open System Preferences on the Mac you plan to connect to from another device. click the Apple icon in the top-right bar, then select System Preferences

Step 2: Click the Sharing icon.

Step 3: Tick Screen Sharing in the Service list

Step 4 (Optional): That’s all the configuration required to access you Mac remotely if on the same WLAN/LAN. The following step is required if you plan to connect to your Mac from a separate network. Head back to System preferences then select iCloud.

Tick Back To My Mac.

<img src=

Step 5: Head over to your other Mac device and open Finder. You should now see your remote Mac’s name under Shared devices. Click your device, then click Share Screen

NOTE: If your remote Mac doesn’t appear in your Shared list, you may need to re-start Finder to scan for your device. (Apple Menu —> Force Quit… —> Select Finder and hit Relaunch)

The Share Screen button will Launch Apple’s built in Screen Sharing app allowing you to view and control your remote Mac.

You can right-click the Screen Sharing app icon from the dock while the app is running, then click Options, then Keep In Dock. This makes it easier to find the app in future. When the app is closed you can you can now right-click the app icon from the dock, then select your remote Mac to quickly connect.

 

 

 

SQL – How To Return Ref of Inserted Row

It is extremely useful to return the URN, or any other field, of a newly inserted row for a given table in a single query. The OUTPUT clause makes this possible.

insert into MY_TABLE (Field_1, Field_2, Field_3)
OUTPUT Inerted.REF
values (‘Foo’,’Bar’,’Example’)

The above example returns the REF field, which contains auto-incremented urn in MY_TABLE.

Mac OSX – How to switch between windows of same application

You can switch between applications by using the keyboard shortcut [ Apple + tab ]. Switching between Safari and XCode for example.

This is an invaluable time saving shortcut. But what about switching between windows of the same application?

Thats covered too. You can switch between windows of the same application by using the keyboard shortcut [ Apple + ` ]. Switching between multiple Finder windows or between XCode projects for example.

the ` key is located left of the z-key on a standard keyboard.

SQL – View SQL Server Database Mail Log (All / Successful / Failed)

SQL Server keeps a log of mail sent via Database Mail and the sp_send_dbmail Stored Procedure.
I find these code snippets useful to view mail history including sent and failed items. You can view address, subject & body, file attachment(s), status, sent date, etc.

All Messages – regardless of status and deliverability
SELECT top 50 *
FROM [msdb].[dbo].[sysmail_allitems]
ORDER BY [send_request_date] DESC
Sent Items
SELECT TOP 50 *
FROM [msdb].[dbo].[sysmail_sentitems]
ORDER BY [send_request_date] DESC
Failed Items
SELECT TOP 50 *
FROM [msdb].[dbo].[sysmail_faileditems]
ORDER BY [send_request_date] DESC

SQL – The EXECUTE permission was denied on Stored Procedure

The EXECUTE permission was denied on the object ‘STORED_PROC’, database ‘MYDB’, schema ‘dbo’

This massage is received when the SQL Server account under which you make the request doesn’t have permission to execute the stored procedure. you can overcome this problem by modifying the permissions of the SP.
If you want to grant public access, so all users can execute the procedure:

USE [DATABASE];
GRANT EXEC ON dbo.[MYSTOREDPROCEDURE] TO PUBLIC

 

If you want to tighten security to allow only specific users to execute the SP, which is advisable, then its:

USE [DATABASE];
GRANT EXEC ON dbo.[MYSTOREDPROCEDURE] TO MYUSER

OR

USE [DATABASE];
GRANT EXEC ON dbo.[MYSTOREDPROCEDURE] TO MYGROUP