Blog Offline

After two years of writing, my (previous…) hosting provider unfortunately managed to lose all my articles; they couldn’t even recover the configuration from their own backup! I did recover all of the content from my own backups and will re-post all articles in due course. [Read More]

Deploy or Migrate a Database using Scripts - part 1

A database migration is always a headache for DBAs.  There are different approaches one may take, some being simpler than others. A couple of weeks ago, in the Migrate Databases Using Backup-Restore article, I explained how a database migration can be carried out effortlessly and with minimal downtime.  This is... [Read More]

T-SQL to Transfer Data based on Periodic Date Ranges

I don’t think I’d be wrong in stating that almost all transactional and analytical systems store or make use of date, time, or parts of to achieve the respective functional targets.  A task I had to complete once was to find a way to retrieve data based on the period... [Read More]