Connecting to SQL Server DB compiling and running with Java

Introduction Hi everyone, I've been practising Java programming to prepare for Data Structures and Algorithms for my Uni course (for those interested... it's UO Applied Data Structures). And I've been following an old textbook from my TAFE days called The Java Way 2nd Edition by Gerard Sparke (an excellent book that helped me translate UML …

Simple Data Cleaning Trick In SQL

Hi Everyone, It's been a month since I've started my new job (Yay!!) and I've been doing a lot of Data Conversion!!! I wrote a dynamic script yesterday that removes whitespaces and any form of garbage data like #REF! or #N/A and so on from all character-based columns. I'm using cursors to go through all …

Connecting to MS SQL Server from R

Introduction I was asked at work to do some data analysis (sorry can't tell ya what it is ;)). And I realised that it was going to be a nightmare dumping the data into Excel doing analysis in Excel or writing a whole bunch of SQL queries, querying the same tables/datasets. So I decided to …

Connecting to the MSSQL in AutoIt Script

Connecting to MS SQL Server is pretty straight forward in AutoIt. Just like in Visual Basic, you will need to you create ADODB Connection and RecordSet (this is for the SELECT query) objects. The part is setting and opening the SQL Connection. Next part is executing the SELECT query and then outputting the results into …