Month: November 2015

Welcome to MS MCT Trainers for Aghilas

Posted on Updated on


Cool 🙂 I am now Microsoft Trainer team, and I can animate MC training with my clients, future sessions at IBS Consulting, whom I thank, Many thanks to Philippe, Michael, Nadège and Raef.

November 17, 2015

Dear Technical team leader Philippe Kajmar:

Thank you for taking the time to complete the Microsoft Certified Trainer (MCT) reference form for yakoub aghilas. We have received your response and the instructional skills requirement for this candidate has been approved .

Sincerely,

MCT Program Team

Microsoft respects your privacy. Review our online Privacy Statement.

Microsoft Corporation
One Microsoft Way
Redmond, WA, USA 98052

MCT.png

Application Status

Thank you for submitting your MCT application on November 10, 2015.

Your MCT application status is listed as: Approved.

Your instructional skills validation status is listed as: Approved by both Reference and Regional Service Center.

Please note that it can take up to 10 business days for the Regional Service Center to validate your instructional skills upon receipt.

If we have not received payment and instructional skills validation within 90 days of application submission, your application will be cancelled.

Renewal Information
Your renewal anniversary date is November 18, 2016. You can renew your membership 90 days prior to your renewal anniversary date.

 

 

This entry was posted in MCT, Trainer.

Audit database with DBCC & sys.dm_exec_requests (Tips)

Posted on Updated on


You can follow different aspects of your database, put the focus on the following subjects, for example :

– Ensure that the index and data pages are correctly linked.

– Pointers are consistent.

For this used the command DBCC with type CHECKTABLE.

DBCC CHECKTABLE ('Clients') WITH PHYSICAL_ONLY
GO

However you can edit different aspects, below a link that describes every possible aspect was audited

Link : https://technet.microsoft.com/en-us/library/aa258281(v=sql.80).aspx

We will change perimeters we will look a blocked processing, suspended, however, the proposed solution remains little used, unlike sp_who2 ou sp_who,

This is the table which must be selected : sys.dm_exec_requests.

SELECT 
session_id,
status,
blocking_session_id,
wait_type, 
wait_time,
wait_resource,
transaction_id 
FROM sys.dm_exec_requests 
WHERE status = N'suspended';
GO

GC.Collect

This entry was posted in SQL SERVER.