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

Archives: October 2009

Happy Halloween to the DBA - Pumpkin Carving as a Team Building Exercise

 

The past couple of days we have had some fun with a Team Building exercise by means of designing our Pumpkin for an internal competition between teams.  Unfortunately we did not win anything, nor even make the top three, but we certainly did have some fun – and… Read more

0 comments, 878 reads

Posted in The Database Hive for SQL Server DBAs on 30 October 2009

Notes on a Migration from Oracle to SQL Server

 

I have to admit, when asked to perform a migration from Oracle to SQL Server over the past couple of months, I was a bit apprehensive.  After having passed an all-nighter to finish the project off recently, starting at 3pm, and finally heading home around 6:30am, there was…

Read more

0 comments, 265 reads

Posted in The Database Hive for SQL Server DBAs on 26 October 2009

DRP for SQL Server in French - traduction en français du plan de relève – part 5

Here I go again, trying to finish up the translation. Thank you very much to local MVP Eric Moreau for his help fixing my mistakes so far :)Here's a complete final draught en français.

Configuration de l'instance SQL Serveur

 

Nos serveurs exploitent la version 64-bit de moteur de la base… Read more

0 comments, 302 reads

Posted in The Database Hive for SQL Server DBAs on 26 October 2009

A DBA's Role with Respect to Improving Microsoft Dynamics CRM 4.0 Performance

1linerForward: here's a webinar from Microsoft regarding this subject, the following is a summary of what was required to improve CRM performance.  

Microsoft's Customer Relationship Management platform runs on SQL Server and falls under most of the typical performance improvement techniques (and should be regularly checked with tools like Activity…

Read more

1 comments, 1,266 reads

Posted in The Database Hive for SQL Server DBAs on 15 October 2009

DRP for SQL Server in French - traduction en français du plan de relève – part 4

La liste des fichiers restaurés devrait se trouver dans le répertoire suivant :

\\ServeurDeBD\Disque$\DirSauvegardesProd\DBlog\

 

Dès que la restauration a été complétée, nous devrions avoir un nettoyage automatique des vieux fichiers de sauvegarde grâce à un script PowerShell ou un fichier de commandes batch. Ce nettoyage devrait être fait au… Read more

0 comments, 321 reads

Posted in The Database Hive for SQL Server DBAs on 14 October 2009

DRP for SQL Server in French - traduction en français du plan de relève – part 3

 

Here is Part 3 of the translation for the French version of the Disaster Recovery for SQL Server Databases - comments welcome.  Donc, cela veut dire corrigez-moi SVP, surtout quand il y a des phrases mal formées.

 

Considérations à prendre par l'analyste de la base de données (DBA)…

Read more

0 comments, 535 reads

Posted in The Database Hive for SQL Server DBAs on 5 October 2009