Über uns
I worked with SQL Server since its port from Sybase product to OS/2. I'm doing counseling for development teams about SQL techniques (queries, database management, performance). I'am also an SQL trainer for my company and our customers about database management, SQL querying and Advanced SQL Querying. I'm implied directly in some product development by writing stored procedures, triggers and queries. I'm a the team leader of the SQL team in my company.
Specialties: Microsoft Certified Technology Specialist MCTS SQL Server 2008, Implementation and Maintenance, Database Development
Articles by Maurice
-
L'intelligence artificielle, des solutions et des pièges.
L'intelligence artificielle, des solutions et des pièges.
By Maurice Pelchat
-
Une formation qui dure : le mentorat par consultation
Une formation qui dure : le mentorat par consultation
By Maurice Pelchat
-
Crise de ressources humaines en TI. La solution, le mentorat "Juste en temps".
Crise de ressources humaines en TI. La solution, le mentorat "Juste en temps".
By Maurice Pelchat
Contributions
Activity
-
LinkedIn, ta nouvelle fonctionnalité m’exaspère. Et je pense que je ne suis pas le seul à râler. Si vous testez cette fonctionnalité, sachez…
LinkedIn, ta nouvelle fonctionnalité m’exaspère. Et je pense que je ne suis pas le seul à râler. Si vous testez cette fonctionnalité, sachez…
Liked by Maurice Pelchat
-
New video explaining the recent advances in Quantum Computing: https://lnkd.in/dTtDkEgv featuring remarkable Krysta Svore from Microsoft
New video explaining the recent advances in Quantum Computing: https://lnkd.in/dTtDkEgv featuring remarkable Krysta Svore from Microsoft
Liked by Maurice Pelchat
-
As you may already know, my daily driver is Debian Linux. But I still use Windows for work. This morning I was prompted to update. So I did. And of…
As you may already know, my daily driver is Debian Linux. But I still use Windows for work. This morning I was prompted to update. So I did. And of…
Liked by Maurice Pelchat
Erleben Sie
-
Maurice Pelchat SQL Consulting
-
-
Bildung
Honors & Awards
-
SQL Server Magazine 2007 Innovator Award
SQL Server Magazine
This award was granted following a contest about innovative solutions in SQL Server.
The realization I submitted was about a database self-maintenance tool (YourSqlDba) that perform professional database maintenance especially for sites where there is no DBA, or accidental DBA. This free product is available at yoursqldba.codeplex.com. It has no software dependency since it is implemented as a SQL script. The script create and uses its own database YourSqlDba. It leverages SQL Agent…This award was granted following a contest about innovative solutions in SQL Server.
The realization I submitted was about a database self-maintenance tool (YourSqlDba) that perform professional database maintenance especially for sites where there is no DBA, or accidental DBA. This free product is available at yoursqldba.codeplex.com. It has no software dependency since it is implemented as a SQL script. The script create and uses its own database YourSqlDba. It leverages SQL Agent and Database Mail to schedule and run automatically maintenance jobs and do proper reporting and alterting of maintenance issues.
Maintenance tasks is automatically added as a job step of a job in SQL Agent. The job step consists into a call to the main stored procedure of YourSqlDba that. The many tasks of the maintenance can be customized via stored procedure parameters.
YourSqlDba was later reviewed by author Kevin Kline http://www.sqlmag.com/article/sql-server-2005/yoursqldba as a free maintenance tool.
YourSqlDba is frequently improved in features. Reliablility comes from the fact that we support it for our large customer base in their daily use. Upgrading is easy because the script is written in such a way that you just need to get it and rerun it to bring it to the latest version. You don't have to wonder at which version you are. The application itself is easy to maintain up-to-date since the script can be applied live with no downtime.
Languages
-
French
-
-
Englisch
-
More activity by Maurice
-
C’est exactement ce que je pense sur le sujet 🙏🏽👌🏼
C’est exactement ce que je pense sur le sujet 🙏🏽👌🏼
Liked by Maurice Pelchat
Other similar profiles
Gemeinsame Artikel erkunden
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
Explore MoreOthers named Maurice Pelchat
3 others named Maurice Pelchat are on LinkedIn
See others named Maurice Pelchat