Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: April 2013

Resolving data redundancy up front

 

Introduction

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, 325 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, 293 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, 189 reads

Posted in Simon Says on 20 April 2013

Monitoring SQL Server Agent job run times

Introduction


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, 2,105 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

Introduction

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, 271 reads

Posted in Simon Says on 8 April 2013