SQL Server: how to crawl all databases for data

Some weeks back I was challenged to figure out a way to easily, and without killing the server, track the location of some string data on all databases on a certain server. This is the result. (Btw, I’m not a DBA and this may not be the most optimal solution). Worked without any damage and gave the expected results.

In the last 3 years SQL Server has been around on my regular developer life but not with too much challenges. MySql, Sqlite3, etc is also also part of the fun but I tend to forget some stuff. This is reminder.

SQL Server: (re)import CSV data the easy way

Importing data into SQL Server is not hard using the import data feature but I really don’t appreciate the fact that there is no way to save that import profile/rules for later reuse. Solution: use BULK INSERT from a regular reusable sql script.

BULK INSERT (Transact-SQL) is a really nice feature that allows to easily create a reusable data import script capable of import one or many CSV files. I’m going to build a simple script using this nice feature.

Device Emulation with Google Chrome Dev/Canary

This week, after seeing a snapshot that my friend ‘led’ posted on Facebook about some mobile tests for one of his projects, I’ve noticed about a certain device emulation feature on Chrome developer tools. Hum…. that is interesting.

A simple Google search directed me right away for something I’ve already was aware but with some new funky stuff:

After the sexy photo we’ll get on how to install Chrome Canary build on Windows 8 and Chrome Dev on Arch Linux.