This site is a test bed for everything I learn and is mostly for my own benefit. As such it may be down from time to time and is subject to frequent changes.
Thought of the day: Life is too short to be conventional
Recent Blog Entries
Rerunnable data update scripts for Microsoft SQL Server
Published: Oct 18, 2022
We can implement a SQL Server equivalent of MySQL/MariaDB's "INSERT IGNORE" using MERGE INTO as follows... ...more
Rerunnable Data Update Scripts for MySQL/MariaDB
Published: Oct 11, 2022
Using the INSERT IGNORE statement you can easily manage reference table's data using re-runnable sql scripts. ...more
Preventing Windows Ubuntu Dual Boot Superblock Corruption
Published: Apr 12, 2022
Whenever I switch to ubuntu from windows on my dual boot system I get an error that the superblock is corrupt and I cannot load ubuntu until I fix the corruption using the command line. The issue appears to be windows messing from the ext4 partition. ...more
Resolving directory lookup error on SQLServer backup restore
Published: Apr 6, 2021
Restoring a SQL Server database to a new server with a different file system structure can result in a Directory Lookup error since SQL Server makes assumptions about file locations. Fortunately there is a simple solution by using 'WITH MOVE' ...more
New Year - New Server - New Direction?
Published: Mar 23, 2021
What happened with the blog and whats next ...more
Twitter Updates
- I don't need or want algorithms choosing what I see or when.
- Hey @elonmusk if you want my $8 dollars you need to do one thing. Make it so that when I choose "latest tweets" as… https://t.co/DGR19ZExlD
- New blog entry: "Rerunnable data update scripts for Microsoft SQL Server" https://t.co/iIYF1iN8TC #SQLServer
- New blog entry: "Rerunnable Data Update Scripts for MySQLMariaDB" https://t.co/lG47PFbIQH #mariadb #MySQL
- New blog entry: "Preventing Windows Ubuntu Dual Boot Superblock Corruption" https://t.co/J2MiTX1DlC #Ubuntu #Windows
