Archives: April 2013
As all of us do when confronted with a problem, the resource of choice is to ‘Google it’.
This is where the plot thickens. Recently I was asked to stage data from numerous databases which were to be loaded into a data warehouse. To make a long story… Read more
SQL Saturday 207 Yaoundé Cameroon, is holding its first SQL Saturday on June 8th. Due to the remoteness from the US, Achilles Nguela has kindly opened the event to live meeting presentations. This is a really a great opportunity to make a BIG DIFFERENCE to the SQL Server community.… Read more
Have you ever been to a SQL Saturday where someone 'rocks up' for a beginner's presentation. In fact he or she works at a help desk and the boss sent him or her, to the event, to 'learn everything there is to know about SQL Server'.
This ACTUALLY happened to… Read more
A few months back, I was asked how long a particular nightly process took to run. It was a super question and the one thing that struck me was that there were a plethora of factors affecting the processing time. This said, I developed a query to ascertain process… Read more
Restoring databases to a set drive and directory
Often people say that necessity is the mother of invention. In this case I was faced with the dilemma of having to restore several databases, with multiple ‘ndf’ files, and having to restore them with different physical file names, drives… Read more