MCT Summit

Posted on


The 2016 MCT Summit in Sydney Australia invites Microsoft Certified Trainers from Australia, New Zealand and beyond to a two-day event co-hosted by the MCT community and Microsoft. MCT events are your best opportunity to interact with your peers and engage directly with Microsoft. Come learn about the future of Microsoft learning, the MCT Program, how to teach a specific course or technology, or how to become a better trainer

Microsoft’s Worldwide MCT/MCP Program Manager, Patrick Thomas will be here from Microsoft Corporation, Redmond, USA as well as Chee Sing Chen, Microsoft Asia Pacific Learning Experiences Director will be in attendance and you will have the ability to find out more about Microsoft’s MCT Program Strategy and Vision.

Registration is now open and Agenda details are available HERE

Disclaimer: Microsoft respects your privacy. Review our online Privacy Statement.

If you would prefer to no longer receive this communication, please email MCTPM@Microsoft.com with “UNSUBSCRIBE” in the subject line. To set your contact preferences for other Microsoft communications, see the communications preferences section of the Microsoft Privacy Statement.

Microsoft Corporation
One Microsoft Way
Redmond, WA, USA 98052

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.

 

 

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

Welcome to AEA for Aghilas

Posted on Updated on


Cool I am now part of the AEA committee

Dear Aghilas,

Welcome to the Association of Enterprise Architects (AEA). As a new member, you have joined forces with EA professionals worldwide who are working together to advance the profession of Enterprise Architecture and promote professional excellence.

Your username for the AEA is aghilas.yakoub and your Membership Number is ………

To sign into the AEA website please go to: https://www.globalaea.org

After logging in you will be able to manage your Profile by editing your bio,managing preferences and email subscriptions to blogs and forums.

You will also be able to access content and features, such as blogs, photo gallery, networks, and our AEA community via messaging, connections, groups,chapters, Work Groups, and Forums. You will be able to connect with fellow members, share ideas and expertise.

We hope you enjoy our online community and look forward to your participation!

Association of Enterprise Architects (AEA)

Togaf

Tips

Posted on Updated on


MAILING  SQL SERVER

Below a post aimed to alert you if a volume is exceeded on your SQL Server, for example, the basic transaction data may exceed certain thresholds for that access your agent SQL SERVER, configure it in such a way as to send mails.

Mail Alert

Audit SQL SERVER

You gave rights to a user, you want to know if that user has rights has spread another user, simple to make, use SQL SERVER Audit, create an audit specification

“SERVER_ROLE_MEMBER_CHANGE_GROUP”

You use both nodes Audit (audit and Create output formatting) & Specification (Create the specification)

audit

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

For your security management of your database, choose the concept of Role personalized, permission on a schema, add users to your role (Just as it would have been done with the Principal, Identity, Permission, Claims in C # ). Associating the scheme now to the role and not to different users.

Custom Role

Compatibility Level (Tips SQL Server)

Posted on Updated on


This post is intended to include the steps to migrate and change basic version of SQL SERVER 2005 data on 2014

It’s simple to make a BACKUP of Full aging database (SQL 2005), do the RESTORE of the database on the target server (Data Log & Database).

However consider changing the COMPATILITY LEVEL on the 2014 base,

ALTER DATABASE database_name 
SET COMPATIBILITY_LEVEL = { 90 | 100 | 110 | 120 }

Note : 120 is the compatibility level for SQL SERVER 2014

Link : https://msdn.microsoft.com/fr-fr/library/bb510680(v=sql.120).aspx

Policy Management & Tips

Posted on Updated on


It is interesting how implement code standards for stored procedures in Sql Server, stored procedures system are prefixed with “sp_”, for our user stored procedures, let the prefix of “usp_”, this is done with Policy Management (see SSMS – the object explorer, root).

PM2

Right-click on Policy Management and select New Condition, Type a name and condition as well as the body of your condition, we have decided to select the Name filter expression LIKE (‘usp_%’).

PM0

The next step is to create a policy associated with this codition, right-click Policy Management and select New Policy, select the Check Condition list, the condition created previously, the evaluation mode must be set to “On change: prevent prevention “, the default mode is” on Demand “and policies can not be enabled in this mode, for the Target, make sure you select all the databases and all stored procedures.

PM

SQL Server – Slow Finish

Posted on Updated on


As part of optimizing your SQL queries, if you want to line of code to include the execution plan, drag this instruction before execution.

SET STATISTICS SHOWPLAN_XML ON

If you want to optimize the recovery of your data in an environment with a default isolation level of Read Committed or SERIALIZBLE, slide this instruction before execution.

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

As part of query optimization, you can associate a clean SQL query execution plan for you so to override the behavior of the query optimizer, see reference Plan in SQL Server Management Studio, you can create your SEEK FORCE clauses on your favorite index etc.

link : https://technet.microsoft.com/fr-fr/library/bb895390(v=sql.105).aspx

You can sometimes just be an update statistics 🙂

For the database novice, the positioning of the index is very important and is based on real data collecting tools (Production Environment)

As for the SQL Server after try: Database Engine Tuning Advisor, included in SSMS since the 2012 version.

GC.Collect

Astuces SQL Server

Posted on Updated on


This note aims to put the focus on database issues

How to increase the performance of a view by saving the data to disk?

Create a cluster view (clustered).

What is XACT_ABORT?

cancel or not a transaction inside stored procedure, for example, if an error occurs at a treatment

SET XACT_ABORT ON

How to solve the fragmentation problem index?

Use Rebuild or Reorganize index

The result is obtained with function sys.dm_db_index_physical_stats.

Below results  :  

avg_fragmentation_in_percent : The percent of logical fragmentation (out-of-order pages in the index).

fragment_count : The number of fragments (physically consecutive leaf pages) in the index.

avg_fragment_size_in_pages : Average number of pages in one fragment in an index.

If avg_fragmentation_in_percent is greater than 5% and less than 30%

                => ALTER INDEX REORGANIZE

If avg_fragmentation_in_percent value is greater than 30%

                => ALTER INDEX REBUILD WITH (ONLINE = ON)

Tips Net

Posted on Updated on


Below is a set of frequently asked questions as part of a .Net development platform, this post is also inspired some topics discussed in the Microsoft Best Practise
How to validate the compliance of a development compared to an architecture with a Build? (Ultimate License Requirements)

Create diagram Layer empty, move layers from solution on diagram and add dependencies,

Create Gated CheckIn Build (Based on Shelveset), and in arguments of Build add : /p:ValidateArchitecture=true

How to detect copy and paste source code? (VS Prerequisites 2013)

Use Analyse Solution for Code Clones available under the section ANALYSIS

How to force the update of SSRS reports in a TFS platform (available under the Portal Server )?

Access to Administration console TFS, select Reporting tab, click on Start Rebuild link

Diagnosing a proxy TFS source control ?

Use web service ProxyStatistics available on application layer

GC.Collect