SQL Operations Studio

While creating a personalised SQL Training course for one of my customers, I came across the new SQL Operations Studio from Microsoft. SQL Operations Studio is a cross platform SQL tool that is currently in Preview, version 0.23.6 I believe.

So far I have used it on both Windows 10 and Apple OSX Sierra and it has proven to be reasonably stable for such a young product and has great potential. I’m looking forward to seeing how it turns out when development is further along 🙂

SQL Operations Studio on Windows 10

SQL Operations Studio on Windows 10

SQL Operations Studio on Mac OSX

SQL Operations Studio on Mac OSX

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Me

DataViewer Components for Xojo

Here’s a chance to get my Dataviewer Components for Xojo at a 20% Discount:

All Xojo Add-ons and Videos are 20% off through July 16th! Use coupon code SPASH and expand your toolbox now: http://bit.ly/2bAciyX #sale

Click here for more information on DataViewer

Looking for an App creating for your Windows or Mac Computer? What about an App for your iOS or Android Tablet or Phone, or A Web App? Bespoke, Custom, High Quality Applications. Contact Me

The Best SQL Tool for Mac: Updated

oneSql 1.0.1 was released earlier today and I'm very pleased to say that there was not a single bug fix 🙂 Surely a testament to the guys and girls who participated in the Beta program earlier this year. So a very big 'thanks' to them 🙂

This update consists of a change to the way the SQL Keywords mechanism works. Previously the file SQLKeywords.sjc was loaded from the application folder or the SupportFiles folder and all the SQL keywords were loaded into an array and this array was accessed after each keystroke when typing occured in the SQL Text Area. If a match was found then the appropriate action was taken, ie: the word was capitalised, or coloured etc.

In version 1.0.1 the array of SQL keywords is built internally without reference to the SQLKeywords.sjc file. However if this file is present any words within this file are added to the SQL keywords array. So for example any words that you wish to be treated as keywords for your own purposes, or any keywords you find that I have missed when building the keyword array, can be added in a file called SQLKeywords.sjc which needs to be located in the same folder as the oneSql application or in the SupportFiles subfolder.

In addition to the changes described above there are half a dozen small interface tweaks which just tidy things up very slightly.

Easy to Use SQL Tool | oneSql 101: User Prompts

Visual Guide to oneSql: Part 4, User Prompt Fields

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSqlupf5

upf2

upf3

upf5

upf

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: Preferences

Visual Guide to oneSql: Part 3

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql

 

prefswindow1

prefswindow2

 

prefswindow3

 

busbannerAffiliate Links

 

Easy to Use SQL Tool | oneSql 101: DataViewer

Visual Guide to oneSql: Part 2

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql

Results Tab Selected

dataviewerwindowexplained1

Database Objects Tab Selected

dataviewerwindowexplained2

Statement History Tab Selected

dataviewerwindowexplained3

 

busbannerAffiliate Links

Easy to Use SQL Tool | oneSql 101: Connections

Visual Guide to oneSql: Part 1

New, Easy to Use, Fast, Cross Platform, Multi-Language SQL Query Tool: oneSql oneSql Connection Window   busbanner Affiliate Links