Category Archives: SharePoint

Performance and Tuning: Page Life Expectancy

SQL Server 2012 – Performance and Tuning: Page Life Expectancy

The Buffer Manager object provides counters to monitor how SQL Server uses:
* Memory to store data pages.
* Counters to monitor the physical I/O as SQL Server reads and writes database pages.
* Buffer pool extension to extend the buffer cache by using fast non-volatile storage such as solid-state drives (SSD).

A Performance Profile: how one would approach performance tuning each.  The performance profile of OLTP differs significantly from a Relational Data Warehouse or Reporting application.  It is helpful to understand these differences and the objectives for high performance.

OLTP applications are characterized by high volumes of small identical transactions.  These can include SELECT, INSERT, UPDATE and DELETE operations.  The implications are significant in terms of database design, resource utilization and system performance.

You can find the value of the PLE by running the following query.

SELECT [object_name],



FROM sys.dm_os_performance_counters

WHERE [object_name] LIKE ‘%Manager%’

AND [counter_name] = ‘Page life expectancy’

There are performance problems if any of the following are true, here we go

Resource issue Rule Description Value Source Problem Description
Database Design Rule 1 High Frequency queries having # table joins >4 Sys.dm_exec_sql_text,


High Frequency queries with lots of joins may be too normalized for high OLTP scalability
Rule 2 Frequently updated tables having # indexes >3 Sys.indexes, sys.dm_db_operational_index_stats Excessive index maintenance for OLTP
Rule 3 Big IOs

Table Scans

Range Scans

>1 Perfmon object

SQL Server Access Methods


Missing index, flushes cache
Rule 4 Unused Indexes index not in* * Sys.dm_db_index_usage_stats Index maintenance for unused indexes
CPU Rule 1 Signal Waits > 25% Sys.dm_os_wait_stats Time in runnable queue is

pure CPU wait.

Rule 2 Plan re-use < 90% Perfmon object

SQL Server Statistics

OLTP identical transactions should ideally have >95% plan re-use
Rule 3 Parallelism: Cxpacket waits >5% Sys.dm_os_wait_stats Parallelism reduces OLTP throughput
Memory Rule 1 Avg page life expectancy < 300 (seconds) Perfmon object

SQL Server Buffer Manager

SQL Server Buffer Nodes

Cache flush, due to big read

Possible missing index

Rule 2 Avg page life expectancy Drops by 50% Perfmon object

SQL Server Buffer Manager

Cache flush, due to big read

Possible missing index

Rule 3 Memory Grants Pending >1 Perfmon object

SQL Server Memory Manager

Current number of processes waiting for a workspace memory grant
IO Rule 1 Avg Disk seconds / read > 20 ms Perfmon object

Physical Disk

Reads should take 4-8ms with NO IO pressure
Rule 2 Avg Disk seconds / write > 20 ms Perfmon object

Physical Disk

Writes (sequential) can be as fast as 1ms for transaction log.
Rule 3 Big IOs

Table Scans

Range Scans

>1 Perfmon object

SQL Server Access Methods

Missing index, flushes cache
Rule 4 If Top 2 values for wait stats are any of the following:






Top 2 Sys.dm_os_wait_stats If top 2 wait_stats values include IO, there is an IO bottleneck
Blocking Rule 1 Block percentage > 2% Sys.dm_db_index_operational_stats Frequency of blocks
Rule 2 Block process report 30 sec Sp_configure, profiler Report of statements
Rule 3 Avg Row Lock Waits > 100ms Sys.dm_db_index_operational_stats Duration of blocks
Rule 4 If Top 2 values for wait stats are any of the following:

1. LCK_x

Top 2 Sys.dm_os_wait_stats If top 2 wait_stats values include locking, there is a blocking bottleneck

OLTP identical transactions mean plan re-use is desirable.  CPU utilization can thusly be reduced with plan re-use and join reduction.  IO performance can be improved with good indexing, join reduction, and high page life expectancy.  Sorts can be limited with index usage.  Blocking can be reduced with index design and short transactions.


— Microsoft Certified Solutions Associate (MCSA)

MS SQL database backup file

MS SQL database backup file

SQL Server 2016 Community Technology Preview 2 (CTP2) through current version).

To make your database secured and protective; it helps you to restore your inaccessible files of the main database when any type of corruption or damage occurs. But, what if backup also corrupt, while attempting to restore database from backup file. There could be multiple reasons behind such disaster situation, here in this write-up you will get to know about the reason and solutions behind such case, where SQL Server user faces corruption.

— SQL Server database backup and not able to restore their databases.

Transact-SQL Syntax Conventions

SQL backup files are basically a replica of your original SQL database, which can be located in different locations on the system. There could be multiple reasons of inaccessible backup file. Here are some most common causes of damaged SQL BAK files:

— Virus attack
— Abrupt system shutdown
— Use of a wrong driver
— Bad sectors in your system’s hard disk
— Sudden removal of a selected tables, records, and procedures
— unconventional functioning of Hard disk
— Improper shutdown of application
— Wrong database synchronization
— System crash
— corrupt database system rules and tables

The most common error message during restoration of database is: ‘Backup or restore operation terminating abnormally.’ A Backup restoration error occurs when a filemark in the backup device could not be read. There could be multiple causes of when a user encounters a filemark error. The most common reasons are:

— A media failure may arise on the same device where the backup is stored
— A write failure may occur while creating the backup file
— Loss of connectivity may arise while creating a network backup
— A failure in the Input/Output path occurs in the disk just after successful write to the disk

Manual Solution:-
After backup restore error the first thing you could do is to check whether all the sets of backup have issues or just some sets have issues. It might be possible that only some sets of backup have issues due to which you are getting restore error. In order to retrieve other backup sets from the device, you need to specify the file number. In case, there are multiple backup sets available on a single device, then to determine the usable backup, you can run the following query:


If you got the usable set from the disk, copy it to another drive for usage and try to restore the damaged files with the help of SQL restore commands. Here are some of the SQL commands that you can use to restore corruption in your SQL database backup, the following essential backup concepts:

Backup Types

Transaction Log Truncation

Formatting Backup Media

Working with Backup Devices and Media Sets

Restoring SQL Server Backups

To recover a database use the following command. This will put your database in the “restoring” state

RESTORE DATABASE <DB Name> FROM DISK='<Backup Location>’ WITH FILE = <FileNumber>

— Write the backup set number instead of ‘FileNumber’ that you want to restore.

The following command will take the database, which is in ‘restoring’ state and make it available for end users.

RESTORE LOG <DB Name> FROM DISK = ‘<Backup Location>’

“Before you can create the first log backup, you must create a full backup ”

The above mentioned commands are used to restore corrupt backup file of SQL database. However, these corrupt backup recovery solutions provided by Microsoft are not applicable for deep corruption cases. In order to restore your highly damaged or corrupt SQL backup database you can always choose a third party SQL backup recovery software. These professional utilities are designed to restore data from a corrupt (.BAK) SQL backup file.

BACKUP DATABASE AdventureWorks2012
TO DISK=’X:\SQLServerBackups\AdventureWorks1.bak’,
MEDIANAME = ‘AdventureWorksStripedSet0’,
MEDIADESCRIPTION = ‘Striped media set for AdventureWorks2012 database;

Third party applications have functions to restore SQL backup file due to all above mentioned reasons. Before buying any professional backup recovery tool, you need to choose the most reliable one. For that you should use the online demo versions of the backup recovery applications to test their efficiency.

For more information, see: Full File Backups (SQL Server) and Back Up Files and Filegroups (SQL Server).

For more information and examples, see SQL Server Backup and Restore with Microsoft Azure Blob Storage Service. For a tutorial, see Tutorial: SQL Server Backup and Restore to Windows Azure Blob Storage Service.
Security: Beginning with SQL Server 2012, the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups. It is still possible to restore backups created with passwords.

Permissions: BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.

Ownership and permission problems on the backup device’s physical file can interfere with a backup operation. SQL Server must be able to read and write to the device; the account under which the SQL Server service runs must have write permissions. However, sp_addumpdevice, which adds an entry for a backup device in the system tables, does not check file access permissions. Such problems on the backup device’s physical file may not appear until the physical resource is accessed when the backup or restore is attempted.

Let me know if you have any further question and your comments will be learning point.

— Microsoft Certified Solutions Associate (MCSA)


Troubleshooting SQL Server problems

MS SQL Server is a separate technology, it is often the case that when problems occur, uncertainty arises regarding the root cause, and problem scope is rarely well outlined. Although many of the details here are not specific to SQL Server problems, they are good practices for troubleshooting many types of complex IT issues. On correct understanding the problem and its cause therefore, accurate root cause diagnosis is very important. Sometimes it is obvious what caused the problem, but not always.

Here we go regardless of the problem, you will need to do some forensic analysis to determine the cause of the problem.

1. Define the problem/ establish a clear problem statement.
2. Determine the problem’s impact/ The IT chef & stake holders often don’t want to know technical details.
3. Engage the correct resources/ both internal or external.
4. Identify potential causes/ meet all necessary parties physically or virtually.
5. Plan and coordinate tasks across teams.
6. Select a communication plan and review/ document the plan and agree who will keep management, end users, and the technical team updated.
7. Identify root cause.
8. Determine solution.
9. Test and implement/ even if the problem does not exist in the test or pre-production environment, implement the fix there first.
10. Review

SQL Server is typically affected by the following bottlenecks:
🙂 Memory
🙂 File I/O
🙂 Locking, blocking, or deadlocking

Start with SQL Server Performance Monitor, make sure that the disk counters are on. To do so, run diskperf from a command prompt (cp). If the disk counters are not on, run diskperf -y and then restart the computer. SQL Server Performance Monitor log, collect the following information:

🙂 Paging file
🙂 Process
🙂 Processor
🙂 All SQL Server counters
🙂 Memory
🙂 Threads
🙂 Logical disk
🙂 Physical disk
🙂 System

In most cases, you should be able to find enough information using these tools to provide you with enough clues to determine the cause of a particular problem. A good DBA troubleshooting approach, adopting a positive attitude with moderate determination and persistence to identify the root cause and resolve issues sure helps.

A positive attitude leads to better quality results, faster resolution, and it will reduce the stress level for you and co-workers during the troubleshooting process.

SQL DBA behaviors and attitudes are characteristic of the most effective database professionals when troubleshooting complex problems. Remain calm, problems are never random — Problems with computers happen for a reason. Avoid prejudice OR looking for fixes, think ahead, it’s common to see spend a lot of time troubleshooting numerous issues that have nothing to do with the main source of the problem. Determine the problem’s real impact on the company business.

🙂 How severely is the system affected?
🙂 How many users cannot work?
🙂 Is money being lost? quantify the amount.
🙂 What is the visibility of the issue?
🙂 Are external customers affected?
🙂 Could any compliance obligations be breeched?
🙂 How serious are the consequences if the problem persists?

IT and business agreements a service-level agreement (SLA), recovery point objective (RPO) and recovery time objective (RTO). Environment overview (network diagram, application architecture), Windows System and Application Event Logs and SQL Server Error Logs, give time to understand the problem and application environment often leads to a higher quality and faster problem resolution. Gather all relevant logs to a single location:

🙂 Windows and System Event logs
🙂 SQL Server Error Logs
🙂 Dump fi les
🙂 Application logs

Many problems begin life as an application behavior or performance issue, and there may be other software components or interactions that could affect the database platform. Simply DBA bring in and nothing to with data or database, anyway what to look for when troubleshooting each major problem.

🙂 Connectivity issues -Netowrk (NIC)
🙂 Performance issues — For a performance problem you need to determine if the problem is on the client, the middle tier, the server on which SQL Server runs, or the network.
🙂 Hardware bottlenecks — Identify resource contention around disk(Review the PerfMon disk counters for Average Disk Sec/Read and Average Disk Sec/Write to verify that the time to make a read or write is ideally below 20 to 30 milliseconds for OLTP systems, higher for decision support systems), CPU (maximum degree of parallelism), network, or memory(AWE feature was discontinued in SQL Server 2012).
🙂 SQL Server issues — As well as hardware contention, SQL Server has fi nite internal resources, such as locks, latches, worker threads, and shared resources such as tempdb.
🙂 Compilation issues — If possible, identify one user query that is slow, the most common causes are insufficient resources. This could be caused by a sub-optimal query plan as a result of missing or outdated statistics, or ineffi cient indexes. SQL Server performance issues with simple tools Data Collector Set, performance trace using the most basic tool:


* Click on Start | Run and type Perfmon.exe

* Go to “Data Collector sets”, expand it and then right click on “User Defined”.

* Choose to create a new “Data Collector Set”.

* Give a name to the set, e.g. “SQLPerf”. Also choose to “Create Manually (Advanced)”. Click on Next.

* Then choose to “create data logs” and check only the “Performance counter” option. Click on Next.

DBA like to add all the counters and all instances from the below Perfmon objects, so that we can capture all the details. Operating System Objects:

* Memory

* Network Interface

* Objects

* Paging File

* Physical Disk

* Process

* Processor

* Redirector

* Server

* Server Work Queues

* System

* Thread

SQL Server Objects:

* SQLServer: Access Methods

* SQLServer: Buffer manager

* SQLServer: Locks

* SQLServer: SQL Statistics

I usually set the interval of the Perfmon Log to 10 to 20 seconds. After you stop the trace, it should be saved have a file extension of .blg. After all this hardwork what comes out, the latter case usually indicates that the performance problem is somewhere outside of SQL Server. Other think, dba want to eascape from problemo and complain other dude’s (:

Let me know if you have any further question and your comments will be learning point.

Microsoft Certified Solutions Associate (MCSA)

Career in Crime?

Career in Crime?








Personally, i prefer to go for government: 






Dad has only three fingers!

Cloud Academy

Microsoft Private Cloud

  • Modules: Private Cloud Overview; Private Cloud: Infrastructure Overview; Private Cloud: Application Overview
  • This course focuses on proving an overview of the Microsoft cloud technologies and how using these technologies can help your business build, deploy, and maintain a private cloud. Module 2 will provide an infrastructure overview and how to use System Center 2012 to provision a private cloud. We will examine the set of tools available to you to configure and deploy infrastructure components; enabling you to deliver IT as a Service. The third module will provide an overview of the tools in System Center 2012 used to manage the underlying resources to achieve predictable application service delivery, and how to keep your applications running healthy by improving performance and monitoring.

Licensing the Private Cloud

System Center Advisor

  • Module: Overview
  • This module will help you discover the benefits of this useful new software assurance benefit from Microsoft. We will explain the benefits of Advisor and how it can be used to optimize your installations of Windows Server, and Server Workloads such as Microsoft SQL Server, Microsoft Exchange, and Microsoft SharePoint. You will also understand Advisor’s high-level architecture for optimizing data security, privacy, and control, all delivered through a user-friendly cloud service. Additionally, we will show how to use the Advisor service to proactively avoid problems, resolve issues faster, and reduce downtime. We will show you how to make the most use out of this tool to help you better manage your data center and cloud infrastructure.

System Center 2012 Licensing Overview

  • Module: Overview
  • This presentation will provide an overview of the new System Center 2012 Licensing programs. We will look at these programs in the context of Microsoft private cloud solutions, and how the combination of the Windows Server 2008 operating system and System Center enables you to obtain the most cost effective licensing you need for your private cloud. As System Center 2012 is being delivered as an integrated private cloud management solution, we will analyze the server management license transition programs for existing System Center users. Further, we will discuss specific Microsoft licensing programs such as the Enrollment for Core Infrastructure, and how licensing for private cloud solutions maximizes your private cloud value while simplifying purchasing.

System Center 2012 Operations Manager

  • Modules: Overview; Configuration and Deployment; Dashboards and Data Visualization
  • In this course, we will provide an overview of Operations Manager, and how its functionality can help drive higher value from your existing IT assets by leveraging a single console. In addition, we will discuss how to use customizable dashboards to monitor and manage your physical, virtual, networking, application, and cloud resources.

System Center 2012: Orchestrator & Service Manager

  • Modules: Overview; Best Practices for Monitoring and Operating the Datacenter and Private Cloud; Data Warehouse and Reporting.
  • ​In this course, we will discuss how the System Center 2012 Orchestrator and Service Manager components enable you to deploy, automate, update, and manage service offerings within your private cloud. Microsoft’s approach to self-service delivery will be discussed, and how System Center responds to end-user service requests. We will cover methods to challenging operational issues, and how using Orchestrator and Service Manager can allow the IT Pro to automate, standardize and offer self-service IT processes in the private cloud.

Windows Server 2012: First Look

  • Modules: Overview; Beyond Virtualization; The Power of Many Servers; Modern Workstyle Enabled; Every App, Any Cloud
  • In April 2012, Microsoft officially announced that the product previously code named Windows Server “8” will be named Windows Server 2012. This updated Windows Server 2012: First Look course builds on the original Windows Server “8” First Look course with the addition of 4 new modules designed to go into more detail around the core Windows Server 2012 platform capabilities.  After completing this course, you will learn how to cloud optimize your IT with Windows Server 2012 and how to take advantage of the skills and investment you have already made in building a familiar and consistent platform. With Windows Server 2012, you gain all the Microsoft experience behind building and operating private and public clouds, delivered as a dynamic, available, and cost-effective server platform. This course will cover how Windows Server 2012 delivers value in four key ways including how it takes you beyond virtualization, delivers the power of many servers, opens the door to every app on any cloud, and enables the modern work style.

Who tell everthing is $cost, check and leave your comment both + or – it will be learning point. I am getting so much junk comments, delete all of them at once, see you next month with other topic.



SharePoint 2010 Roles

Roles and Responsibilities


25 Tools in SharePoint,  here are the:

  1. Shortcuts
  2. Favorites
  3. Pin the Taskbar
  4. Search
  5. Mapped Drives
  6. Folders
  7. List Views
  8. Scopes
  9. Advanced Search on metadata
  10. RSS Feeds
  11. My Site Links
  12. Wikis
  13. Publishing navigation
  14. Content Types/Metadata
  15. Publishing links to Office Clients
  16. Personalization Sites
  17. User Profiles
  18. URL Taxonomies
  19. Authoritative Pages
  20. Best Bets
  21. Roll-up Web Parts
  22. Filter Web Parts
  23. Tags, Ratings
  24. Information Management Policies
  25. Workflows

Microsoft Sharepoint 2010 Administrator’s

Role Responsibilities and   Tasks SharePoint Team Your Company
System Administrator Responsible for the   acquisition, installation and maintenance of the hardware infrastructure.
  • Provide day-to-day operation support to        Portal Team
  • Review existing infrastructure setup,        develop best practices and operation guidelines
  • Install software that supports the        environment
  • Install operating system security updates
  • Install operating system updates,        upgrades and service packs
  • Maintain system, application, security        and SharePoint, IIS event logs
  • Maintain registry settings and        environmental settings.
  • Manage Windows cluster services
  • Manage Network Load Balancing

Operation TeamCompany team

Backup AdministratorResponsible for   Backing up the whole SharePoint environment.

  • SQL Server Backup (Shared with SQL Admin)
  • IIS Backup
  • SharePoint Backup

Operation TeamCompany teamSharePoint Farm   AdministratorResponsible for global   portal and WSS configuration, shared services, policies, procedures, and portal vision and SharePoint configuration:

  1. Application Management
  • SharePoint Web Application Management
  • SharePoint Site Management
  • External Service Connections
  • Office SharePoint Server Shared Services
  • Application Security
  • Search Administration
  • Workflow Management
  1. Operations
  • Topology and Services
  • Security Configuration
  • Logging and Reporting
  • Upgrade and Migration
  • Global Configuration
  • Backup and Restore
  • Data Configuration
  • Content Deployment
  1. Shared Services Administration:
  • User Profiles and My Sites
  • Search
  • Excel Services Settings
  • Audiences
  • Office SharePoint Usage Reporting
  • Business Data Catalog

Operation TeamCompany teamSQL Administrator

  • SQL backups and restores (plan for backup and restore and maintain the SLA)
  • SQL Maintenance
  • SQL Security and Performance Tuning
  • Manage SQL Cluster Services

Operation TeamCompany teamActive Directory   Resource(s)Responsible for   ensuring the portal is leveraging AD appropriately.

  • Assist with Setting up the portal to use        AD for authentication
  • Assist in synchronization of portal with        AD
  • Set SPNs and Kerberos settings

Operation TeamCompany teamEnterprise Site   Collections AdministratorResponsible for all   Site collections on a web application:

Site Collection Level:  

  • Search settings
  • Search scopes
  • Search keywords
  • Recycle bin
  • Site directory settings
  • Site collection usage reports
  • Storage space allocation
  • Site collection features
  • Site hierarchy
  • Portal site connection
  • Site collection audit settings
  • Audit log reports
  • Site collection policies
  • Site collection object cache
  • Site collection cache profiles
  • Site collection output cache
  • Variations
  • Variation labels
  • Translatable columns
  • Variation logs

Site Level:

  • Regional settings
  • Site libraries and lists
  • Site usage reports
  • User alerts
  • RSS
  • Search visibility
  • Sites and workspaces
  • Site features
  • Delete this site
  • Site output cache
  • Content and structure

Site Galleries:

  • Site content types
  • Site columns
  • Site templates
  • List templates
  • Web Parts
  • Workflows
  • Master pages and page layouts

Look & Feel:

  • Master page
  • Title, description, and icon
  • Navigation
  • Page layouts and site templates
  • Welcome page
  • Tree view
  • Site theme
  • Reset to site definition
  • Searchable columns

Site Actions:

  • Edit Page
  • Create Page
  • Create Site
  • Show Page Editing Toolbar
  • View All Site Content
  • View Reports
  • Site Settings
  • Manage Content and Structure

Operation TeamCompany teamEnterprise Security AdministratorResponsible for   managing security on the site collection level to create and change   permission levels on the Web site and assign permissions to users and groups.

Note: Automations will try to minimize role demand   and delegate some responsibilities to Site Owners and Contributors.

Support TeamCompany teamSite Owner (Team Sites)Primary and Secondary   site owner.

Site Actions:

  • Edit a Page
  • Create a Page
  • Show Page Editing Toolbar
  • View All Site Content
  • View Reports
  • Site Settings
  • Manage Content and Structure

Site Administration:

  • Regional Settings
  • Site libraries and lists
  • Site usage reports
  • User alerts
  • Content and structure


  • Site content types
  • Site columns
  • Web Parts
  • Master pages and page layouts

Look & Feel:

  • Master page
  • Title, description and icon
  • Navigation

User and Permissions:

  • People and Groups (view only)
  • Advanced permissions (view only)

Operation Team

Support Team

Company teamSite Owner   (Publishing)Primary and Secondary   site owner.

Site Actions:

  • Edit a Page
  • Create a Page
  • Show Page Editing Toolbar
  • View All Site Content
  • View Reports
  • Site Settings
  • Manage Content and Structure

Site Administration:

  • Regional Settings
  • Site libraries and lists
  • Site usage reports
  • User alerts
  • Content and structure

Look & Feel:

  • Title, description and icon

User and Permissions:

  • People and Groups (view only)
  • Advanced permissions (view only)

Operation Team

Support Team

Company teamContributorContributing on  contents. Meaning can add, delete and edit specific items.End UserCompany teamReaderRead and subscribe to   alerts and RSS feeds.End UserCompany teamDeveloperResponsible for   building the framework and features of the portal.

  • Build the SharePoint look and Feel
  • Modify SharePoint Templates as Needed
  • Build New Web Parts
  • Write ASP.Net Code
  • Participate in Design Tasks as needed
  • Participate in Development and Testing as needed

Development TeamCompany teamProduct Management Responsible for   business advocacy and Satisfied stakeholdersDevelopment TeamCompany teamProgram ManagementResponsible for   resources and features advocacy

  • deliver solution within project        constraints
  • Coordinate optimization of project        constraints

Development TeamCompany teamArchitectureResponsible for designing solutions within project constraintsDevelopment TeamCompany teamTesterResponsible for   approving solution for release ensuring all issues are identified and   addressedDevelopment TeamCompany teamUser Experience

(SharePoint Designer)

Responsible for   Maximizing solution usability and enhancing user effectiveness and readiness

  • Connect with SharePoint Designer
  • Change images, CSS, Master pages and        layouts (drafts only)
  • User Interface responsibilities

Development TeamCompany teamRelease / OperationsResponsible for smooth   deployment and transition to operationsDevelopment Team

Operational Team

Change Management   (Release Management)

Any feedback will be warmly welcome because i do believe that we can learn from each other.


MS SQL & SharePoint Server Adminstrator 2010 – MCITP & MCTS

Free Learning & Roadmap

Free of Charge Learning Resources

Guided labs let you try Microsoft products with no installation required.

Register for free downloadable beta and trial software and get resources that enhance your evaluation experience.

On-demand 60-to-90–minute live broadcasts featuring interactive technical presentations, product demonstrations, and Q&A sessions.

The scariest moment is always just before you start, New to IT ?

Which path would you take for a career in Microsoft Technology?

Find the right direction to enhance your IT Professional career with the ICT Curriculum Roadmap.

Roadmap to guide you career in technology, download file from Microsoft

Download Microsoft XPS file (152 KB)

Download PDF file (225 KB)


Learning Centers


Welcome any comments or suggestion, will be great.



Premium Learning Resources


Learn at your own pace with online courses available anytime, from any location with Internet access.

Find training on a technology and in a format that suits you.

Get a prescriptive roadmap that focuses on your specific training needs.

Microsoft’s official community site for training and certification.

Microsoft Certifications

Get to the next level with Microsoft Certification.


More Certifications >

%d bloggers like this: