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

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…

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

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…

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

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)…