Use the Scripted Extensions menu available when right-clicking on a table in JetBrains DataGrip to run this script. It will then generate POCOs using the table structure. Save aa Generate POCOs.groovy.

Yesterday I found myself needing to rename a bunch of files given a text file with the new names, so I had to use some of my (few) bash skills. I’m sure I could have done it in fewer lines, but the bash script below did the job.

Screen Lock Disable Timer allows you to disable your swipe or pattern screen lock (aka keyguard) temporarily. Useful if you need to turn your screen on and off repeatedly for a while and don’t want to unlock each time!

The below exception is easily remedied by removing all entries that relate to Commerce Server authentication module from your web.config. You are probably not using that module. 🙂

[COMException (0x800a0cc1): AuthManager(CommerceServer): Error reading Commerce Server administration database. Check the AddressKeyName setting in the CSApp.ini file for the site and ensure that it refers to the name of a Commerce Server application that exists for the site. Site name: 'MySite' Application name: 'MySite' Auth resource property: 's_SecureHostname' HRESULT: 0x800A0CC1]

For a while now I’ve tried to find a tool that would allow me to export a SharePoint 2007 list to Excel, modify the data and then import it to another system. In my case I wanted to move data between our many testing environments and modify it easily and in bulk.

Having failed to find a good solution for this I’ve created a tool. It’s published on GitHub and named SharePoint listitem manager. The current version is v0.11 which does the basics (export and import), but I hope to expand and improve the tool as time goes.

At the moment I don’t provide any binaries to download. Feel free to clone the repo and build the solution yourself. The tool is totally untested so I don’t want to release it as a binary quite yet.

Stack Overflow

When you first start off trying to solve a problem, the first solutions you come up with are very complex, and most people stop there. But if you keep going, and live with the problem and peel more layers of the onion off, you can often times arrive at some very elegant and simple solutions.– Steve Jobs, 2006