8thString

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.

Zypper is the functionally equivalent to apt-get or aptitude for OpenSUSE. Man page should give you more information how to use it, you can also visit  http://en.opensuse.org/SDB:Zypper_usage_1  for additional information. For example, to update your current system with the latest packages open konsole and do: $: su #: zypper refresh #: zypper update To install plain old rpm do: $: su #: zypper install google-chrome-stable_current_i386.rpm This should install the downloaded stable version of Google Chrome. Of course you can substitute suitable rpm as necessary. To search for a package like libpng , do: $: zypper search libpng ~ts