Code Scraps: Finding duplicate records in MySQL
This is a quick code scrap to illustrate how to identify duplicate field values in record sets in MySQL. The code may also work for other SQL languages, but do […]
SQL
Code Scraps: Retrieve all tables in a SQL Server database
MySQL has a really useful command called SHOW TABLES. It lists you all the tables available in the connected database. Unfortunately Microsoft SQL Server doesn’t have such a useful shorthand […]
Programmatically storing your Database for Source Control
Databases are often a critical part of most applications today. But how do you go about storing them for Source Control purposes? There are a number of approaches – the […]
Code scraps: MSSQL Configuration Manager
I’m working in MS SQL Server 2014. I needed to make some modifications to the connection information but discovered the SQL Server Configuration Manager was missing from the Windows Start […]
Forgotten your MySQL root password? No problem!
I recently forgot the root password to a MySQL instance on one of my machines. Follow this quick and easy guide for whenever this happens to you. Stop MySQL sudo […]
Bulk generate SQL, JSON objects or code markup using Excel / Spreadsheet
Sometimes I have had a need to turn an un-formatted or unstructured data set into a database table or more recently into a set of JSON objects. The source data […]