SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2013

Resolving data redundancy up front



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

0 comments, 1,216 reads

Posted in Simon Says on 22 April 2013

SQL Saturday 207 Yaounde Cameroon

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

0 comments, 1,160 reads

Posted in Simon Says on 20 April 2013

SQL Saturday Total NOVICE sessions

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

0 comments, 582 reads

Posted in Simon Says on 20 April 2013

Monitoring SQL Server Agent job run times


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

2 comments, 5,041 reads

Posted in Simon Says on 18 April 2013

Restoring databases to a set drive and directory


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

0 comments, 822 reads

Posted in Simon Says on 8 April 2013