Tag Archives: databases

SQL Server database and table listing

Leave a comment

I generally work with MySQL, not MS SQL Server. So when I needed some basic automated info about a SQL Server’s database/table layout I was thankful for the following two pages: Get list of databases from Sql Server – Stack Overflowhttp://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-serverHow can I get the list of available databases on a SQL server instance? I’m planning to make a list of them in a combo box in vb.net. Get a list of all database on a SQL Server: SELECT name

Read more Misc Links, Software Tips, Work

[Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’

Leave a comment

Last night I had an error show up a couple times while using Navicat to backup database on Weblogs.us. This was the error: [Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’ On this server MyISAM was preferred so I had specifically disabled InnoDB, yet something was trying to deal with InnoDB and it was causing the backup error . To determine which table(s) were causing the problem, I used the following SQL statement: SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA =

Read more computer tips, Weblogs.us, Work

Google Refine: a Few Sample Transformations and Helpful URLs

Leave a comment

Google Refine is a powerful tool to help cleanup data from a variety of sources. I’m gradually becoming more familiar with it and the powerful transformation tools that it offers. Here are: a few sample transformation expressions, and… sample data the result “=” after the transformation is applied The first example provides labels and explanations, the rest of the examples omit the labels and explanations but follow the same syntax. I hope these are helpful to you! NOTE: there are

Read more computer tips, Work