Cloud and Datacenter Management Blog

Microsoft Hybrid Cloud blogsite about Management

Leave a comment

#Microsoft MAP Toolkit 9.6 Now Available! #Winserv #SQL2016 #Azure #Office365 #Cloud #Tool


Microsoft MAP Toolkit 9.6

The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier desktop, server and cloud migrations. MAP provides detailed readiness assessment reports and executive proposals with extensive hardware and software information, and actionable recommendations to help organizations accelerate their IT infrastructure planning process, and gather more detail on assets that reside within their current environment. MAP also provides server utilization data for Hyper-V server virtualization planning; identifying server placements, and performing virtualization candidate assessments. More information about MAP Toolkit can you find here

Software Requirements:
        • Operating system. Any of the following:
          • Windows 10 (Professional, Enterprise and Ultimate editions only)
          • Windows 8.1 (Professional and Enterprise editions only)
          • Windows 8 (Professional and Enterprise editions only)
          • Windows 7 with Service Pack 1 (Professional, Enterprise, and Ultimate editions only)
          • Windows Server 2012 R2
          • Windows Server 2012
          • Windows Server 2016
          • Windows Server 2008 R2 with Service Pack 1
        • .NET Framework 4.5 (download from
        • Installation of all updates for the operating system. Note: In some cases updates may not install automatically. To download updates for your computer manually, go to
        • By default, the MAP Toolkit will install SQL Server 2012 Express LocalDB during setup. You may also use an existing installation of SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you create an instance named “MAPS” before running the MAP Toolkit installer. The MAP Toolkit requires the collation order of the database engine to be set to “SQL_Latin1_General_CP1_CI_AS”.


        • Some of these prerequisites require restarting your computer. You may have to restart multiple times if all the prerequisites are not met prior to running Microsoft Assessment and Planning Toolkit setup.

Scenario-dependent requirements:

    • For machines that will be used to run the Forefront Endpoint Protection Usage Tracking, Lync Usage Tracking, Exchange Server Usage Tracking, or Volume Licensing scenarios, please note: PowerShell 2.0 or higher must be installed.
    • For machines that will be used to collect Oracle schema information, please note: The 64 bit Oracle client must be installed on the MAP machine to collect the schema information. If the 64 bit client is not installed, MAP will only be able to collect instance information. MAP will not collect schema information if the 32 bit Oracle client is installed.


Export results in Excel for Windows Server 2016 Assessment Example


Microsoft Azure Virtual Machine Sizing Example in Excel


With MAP Toolkit Training available 😉

You can download MAP Toolkit 9.6 here


Leave a comment

#Microsoft System Center Management Packs (CTP1) for #SQL Server #Sysctr #MSOMS

Instance View


The new features and fixes introduced in CTP1 management packs are as follows:

New SQL Server 2008/2008 R2/2012 MP Features and Fixes

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • SQL 2005 MP files were excluded from the installer
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

New SQL Server 2014/2016 MP Features and Fixes

  • Memory-Optimized Data Garbage Collection Fill Factor monitor and rule were disabled by default
  • Memory-Optimized Data workflows were disabled for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed issue: in some cases, Set Database Online/Offline tasks did not work for databases of SQL Server 2016 cluster instance
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.

The Operations Manager team encourages you to provide any feedbacks on the management packs by sending them to

Creating Datacenter and Instance Dashboards

SQL Dash

With this System Center Management Pack CTP1 for SQL Server there is also an Awesome SQL Server Dashboard Guide to help you
building your own Dashboards in SCOM.

Entity Health

Here you can download the System Center Management Pack CTP1 for SQL Server and the Documentation.


SCUG Banner

Leave a comment

Migrating #Microsoft #SQL Server Databases to #Azure Guidelines

Azure SQL CloudThis blogpost will give you the information about migrating Microsoft SQL Server databases to Azure.
I see a lot of questions on the Microsoft TechNetMSDN forums about how to get my database secure in Microsoft Azure

Before you do a SQL migrate you can do a SQL Assessment via Microsoft Operations Management Suite.

OMS SQL Recommendations

You can see a step-by-step blogpost on my blog for the results for example :
 ‘Do your SQL Assessment with Microsoft OMS before your New Project Starts in Production’

Here you find Microsoft Azure technical documentation on Migrate to Azure :

SQL Migrating

SQL Server database migration to SQL Database in the cloud

For export and import Azure SQL Databases :


Export a BACPAC of a SQL Database

Import a BACPAC of a SQL Database

Copy a SQL Database

Migrating SQL to Azure1

There is also an Awesome Free Microsoft E-Book about Migrating SQL Server Databases to Azure by Carl Rabeler

MVA Course Migrating SQL to Azure

You find here a brand New  Microsoft Virtual Academy video Course about Migrating SQL Databases to Azure

SCUG Banner

Leave a comment

#SQL 2016 Hybrid Hyperscale Architecture and implementation guidance #Azure

SQL16 Hybrid Hyperscale

One of the major trends in the last few years has been a huge explosion in amount of data being generated by OLTP systems often coupled with the need to retain ever longer durations of historical data that needs to be made available for querying on demand. In order to meet customer needs in terms of data retention and performance, hosted database implementations had to choose between the following less than optimal options:

  • expanding and managing local storage which led to increasing cost
  • archive less frequently queried data into offline backup systems like tapes which prevents on-demand querying
  • simply put in place more aggressive data retention policies that reduced the need for this data to be stored in the first place leading to data loss

SQL Server 2016 introduces a number of major capabilities which enable seamless scale-out of SQL Server for low cost storage which is available for anytime On-Demand querying using Azure. With Azure’s almost limitless storage, hosters can offer low cost hyper-scale benefits to their SQL Server implementations for their customers. In this document, detailed technical guidance is provided in the context of a customer scenario on how to implement a hyper-scale database offering. For the implementation, the following SQL Server 2016 capabilities are leveraged

  • Stretched database and Azure Stretch database service
  • AlwaysOn Availability Groups with asynchronous replica in Azure
  • In-Memory ColumnStore
  • Temporal Database

The following Guide explains these capabilities and also enumerate considerations that the Hosting Service Provider (HSP) database administrator has to keep in mind while implementing this offer.


Here you find SQL 2016 Hybrid Hyperscale  Architecture and implementation guidance 

Leave a comment

Join the Microsoft #Cloud Roadshow in The Hague May 19-20 2016 #Azure #Office365 #AzureStack and More

Microsoft Cloud Road Show The Hague

Build your cloud skills in The Hague

Join Microsoft for a free two-day technical training event for IT professionals and developers that provides best practices and insight directly from the experts who build and run the cloud services across Office 365, Microsoft Azure, Windows 10 and more. Whether you know your way around the cloud or are just getting started, you’ll learn something new and walk away ready to apply your new skills.

Space is limited so reserve your free seat today here

I will be there also to help the community 😉

Hands-on Labs

Go beyond the session, immerse yourself in a virtual hands-on lab and experience Microsoft’s products and services first hand.

Explore VirtualLabs

Leave a comment

Do your #SQL Assessment with Microsoft OMS before your New Project Starts in Production #MSOMS

OMS Dashboard

Microsoft Operations Management Suite (OMS) Dashboard Online

Lot of Enterprise Organizations do New Microsoft Projects on-premises in Datacenters installed by the IT Department or by external third party with a
Microsoft SQL instance solution configured. Before your New project is going into production for your customers, It’s very good to do a
Microsoft Operations Management Suite (OMS) SQL Assessment to see if your SQL Solution is installed and Configured well.

If you don’t have a Microsoft Operations Management Suite Plan, you can get one here

OMS Ebook

Installing MSOMS agents on your SQL Servers or get connected with SCOM first with this Free E-Book

SQL Assessment solution

When you Login to OMS, you have to add the SQL Assessment Solution

When the SQL Assessment Solution is activated, It can take a while because the assessment has to collect data of the SQL settings.

When It’s finished collecting data you will see this on your MSOMS Dashboard :


Click on the SQL Assessment here

SQL Assessment dash

Here you see the SQL Assessment Dashboard

It does SQL Assessments on the following topics :

  • Security and Compliance
  • Availability and Business Continuity
  • Performance and Scalability
    Upgrade, Migration and Deployment
    Operations and Monitoring
    Change and Configuration Management

Here you see Microsoft Best Practices Advice for your SQL environment, but It’s also helping you to get the job done if configuration is needed
like in this example :

OMS SQL Recommendations

Here we get advice about Backup settings

OMS Recommendation

In this recommendation there is also a link to Recovery Models (SQL Server) to help you out

So Before your New Project goes into Production state for your Customers, It’s important to get fully in Control of the best practices with #MSOMS on
your Solution.


Get Started Today with Microsoft Operations Management Suite (OMS) here

Here you can find more Technical Documentation on MSOMS

And Follow Microsoft OMS and Microsoft MVP’s on Twitter Hashtag #MSOMS