8thString

When opening a PyDev console using Jython 2.7b3, I am getting the following error message. console: Failed to install '': java.nio.charset.UnsupportedCharsetException: cp0 This does not show up in Jython 2.5. Note that this was already reported elsewhere, like: http://sourceforge.net/p/jython/mailman/message/32935457/ http://bugs.jython.org/issue2222%3E To workaround this issue, add  -Dpython.console.encoding=UTF-8 in PyDev configuration, see below for details.

c:\> sqlcmd -S .\Db_INSTANCE -Q "DROP DATABASE dbname" Where: Db_INSTANCE is the name of SQL Server instance dbname is the name of the database to drop Reference(s): http://windows-linux-admin.blogspot.com/2011/06/deleting-database-with-sqlcmd.html

This may apply to other SQL Server 2005 products but since I haven't not tried them myself, I can't definitely say that this is the case. Anyway, on default SQL Server 2005 Express install it will create one sql server instance named "SQLEXPRESS." For most occasions this should do just fine but in some cases a named/new instance is necessary to partition/compartmentalize the development of an application. Creating a new sql server instance is actually very easy. To create a new instance, do the following: a) Secure a copy of SQL 2005 Express installation media. b) Run setup.exe. c) Accept license agreement. After accepting the agreement, the installation program will perform various other checks like disk space available... etc. d) "Welcome to the Microsoft SQL Server Installation Wizard" just lazily hit on "Next" button. e) In System Configuration Check screen, if the reports are okay then proceed, hit on "Next" button again. f)

c:\> sqlcmd -S .\DB_INSTANCE -Q "exec sp_databases" Reference(s): http://windows-linux-admin.blogspot.com/2011/06/list-all-databases-with-sqlcmd.html

Send email via GMAIL using Python. Note: Need to disable CAPTCHA and enable access for less secure apps https://www.google.com/settings/security https://accounts.google.com/DisplayUnlockCaptcha References: www.mkyong.com/python/how-do-send-email-in-python-via-smtplib/ http://joequery.me/guides/python-smtp-authenticationerror/

This is similar to this post but using MIMEText to make it a little readable.