How to manage projects and Environments using Python and Spyder in Windows?

I have been fiddling around for quite sometime on how to manage more than 1 projects using the Spyder IDE which i got installed using the Anaconda Distribution. Reading through a lot of blogs, I finally understood that I failed to understand how Python works, and how Spyder works. Here i’m just going to lay […]

Read More How to manage projects and Environments using Python and Spyder in Windows?

How to use PowerShell and MS Access together?

https://blogs.technet.microsoft.com/heyscriptingguy/2006/10/02/how-can-i-use-windows-powershell-to-pull-records-from-a-microsoft-access-database/I had a requirement earlier, where i was required to perform a lookup against a huge set of data, nearly 150K lines. Initially i used PowerShell to do a linear search, and it was taking forever. I tried different techniques, such as indexing using hashtables and many fancy stuff. But, the lookup time wasn’t coming […]

Read More How to use PowerShell and MS Access together?