-
Moving a LAMP site
I’ve done this in the past, but thought this time I’ve got to take notes. It can be used as a crude check list in the future. Don’t underestimate the power of a practical, down-to-earth check list! Perhaps documents like this should be kept in a wiki page, for easy updating to avoid being stale,…
-
Search objects in SQL Server databases with pyodbc
Command line utility to search for objects based on names. Search results will be displayed in well formatted tabular format, left-justified. 1. pyodbc installed; 2. Use trusted authentication by default. Find the relevant code to adjust to login/password as needed; 3. -w for wild card search. Default is exact name match, case insensitive in almost…
-
Questions on Text processing with Python
No need to waste time on proving the importance of text processing, I suppose. Here is an automation use case I had in mind when I started my search: sucking out all domain\login inside a block of text. Yes, I can build my own regular expressions, and I have done that in the past. But,…
-
Drop a schema and all its objects in SQL Server
Via Ranjith Kumar S, a script to drop all objects in a schema and then the schema itself in SQL Server. I made very slight modifications so stored procedure creation is unnecessary. All you need is adjusting values for @SchemaName and @WorkTest variables. Limitations: 1. If a table has a PK with XML or a…
-
Packages needed for building MySQL/MariaDb/Percona
From a stock/standard/typical/desktop install of Linux, it seems these are required in order to build MySQL/MariaDb/Percona forks: gcc gcc-c++ automake libtool bison ncurses (Thanks Justin!) Do apt-get, yum, rpm, emerge, or whatever to get them before doing configure, make and such. I am missing one, and I think it has “curse” or something like that…