Skip to content

David Costello

dmcostello.com

  • Home
  • About
  • Articles
    • Internet
    • Programming
    • Uncategorised
  • Projects
  • Resources
    • Downloads
    • Links
  • Contact

SQL

Code Scraps: Finding duplicate records in MySQL

22nd January 2019 @davidcostello42

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 […]

 Code Scraps, Programming  Data, MySQL, Programming, SQL  Leave a comment

Code Scraps: Retrieve all tables in a SQL Server database

24th August 2018 @davidcostello42

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 […]

 Code Scraps, Programming  MySQL, SQL, SQL Server  Leave a comment

Programmatically storing your Database for Source Control

18th June 201817th September 2018 @davidcostello42

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 […]

 Programming  Bash, Batch Scripts, Command Line, GIT, MySQL, Oracle, Poweshell, Programming, Shell, Source Control, SQL, SQL Server, SQLite, SVN  Leave a comment

Code scraps: MSSQL Configuration Manager

30th May 2018 @davidcostello42

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 […]

 Computing  MSSQL, SQL, SQL Server, T-SQL, Windows  Leave a comment

Forgotten your MySQL root password? No problem!

6th May 201715th September 2017 @davidcostello42

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 […]

 Programming, Security  Command Line, MySQL, Programming, Security, SQL  Leave a comment

Bulk generate SQL, JSON objects or code markup using Excel / Spreadsheet

15th August 201615th September 2017 @davidcostello42

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 […]

 Programming  Data, Data Formatting, HTML, JSON, Programming, SQL  Leave a comment

Search

Archives

  • January 2021
  • October 2020
  • March 2019
  • January 2019
  • December 2018
  • October 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • March 2017
  • February 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • June 2014
Proudly powered by WordPress | Theme: Moesia by aThemes