
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: A Nation of Sheep Breeds a Government of Wolves.
Recent Blog Entries
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
Add a JQuery Validate rule for No Date Greater Than Today
Published: Sep 22, 2020
Share this snippet from my archives for adding a JQuery Validate rule which disallows any date greater than today ...more
Populating a database column with an incrementing value
Published: Aug 25, 2020
Here's a quick way to populate a table column with an incrementing value in sql server. ...more
You can sort on columns by their column number
Published: Aug 18, 2020
While not a great idea, it is possible (at least in SQL Server) to order on a column by its numeric column number in the query. ...more
Twitter Updates
- New blog entry: "Resolving directory lookup error on SQLServer backup restore" https://t.co/29tkKYybyT #SQLServer
- New blog entry: "New Year New Server New Direction" https://t.co/uErCKLam5F #Other #Personal
- Finally got around to deploying my new more powerful server so my site is back on the air.
- FYI, yes I know my site is down. The server crashed hard and is basically fubar'd. Im in the process of building a… https://t.co/JWUGAPorUp
- @BenNadel It does make me consider if it might be a nice feature to be able to define some kind of view post proces… https://t.co/mbI7ZWvvhF