Month: November 2015
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 .
MCT Program Team
Microsoft respects your privacy. Review our online Privacy Statement.
One Microsoft Way
Redmond, WA, USA 98052
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.
Your renewal anniversary date is November 18, 2016. You can renew your membership 90 days prior to your renewal anniversary date.
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
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