The Azure Cosmos DB Emulator provides a local environment that emulates the Azure Cosmos DB service for development purposes. Using the Azure Cosmos DB Emulator, you can develop and test your application locally, without creating an Azure subscription or incurring any costs. When you’re satisfied with how your application is working in the Azure Cosmos DB Emulator, you can switch to using an Azure Cosmos DB account in the cloud.
The Azure Cosmos DB Emulator for DevOps is easy to install :
This quick start tutorial walks through how to create a SQL database in Azure. Azure SQL Database is a “Database-as-a-Service” offering that enables you to run and scale highly available SQL Server databases in the cloud. This quick start shows you how to get started by creating a SQL database using the Azure portal.
The SQL Query Editor is a browser query tool that provides an efficient and lightweight way to execute SQL queries on your Azure SQL Database or Azure SQL Data Warehouse without leaving the Azure portal. This quickstart demonstrates how to use the Query Editor to connect to a SQL database, and then use Transact-SQL statements to query, insert, update, and delete data in the database.
Query Editor Login
When you select a table you can edit the Data
You can edit the data here (preview)
Or delete a row.
This Feature in Microsoft azure is still in preview !
Microsoft is announcing the availability of version 9.7 of the Microsoft Assessment and Planning (MAP) Toolkit. This release of the MAP Toolkit helps increase the agility and cost effectiveness of deploying the latest Microsoft technologies. MAP 9.7 is updated to inventory, assess and report the SQL Server 2017 and components in the SQL Server assessment. It also helps organizations assess their environment for Windows 10, Windows Server 2016, Office 2016 and Office 365, track usage of Windows Server 2012, SharePoint Server 2013, and Exchange Server 2013, and preparing a migration to Windows Azure virtual machines.
Azure Cosmos DB is Microsoft’s globally distributed, multi-model database service for mission-critical applications. Azure Cosmos DB provides turn-key global distribution, elastic scaling of throughput and storage worldwide, single-digit millisecond latencies at the 99th percentile, five well-defined consistency levels, and guaranteed high availability, all backed by industry-leading SLAs. Azure Cosmos DB automatically indexes data without requiring you to deal with schema and index management. It is multi-model and supports document, key-value, graph, and columnar data models. As a cloud-born service, Azure Cosmos DB is carefully engineered with multi-tenancy and global distribution from the ground up.
5-Minute Quickstarts
Learn how to use Azure Cosmos DB to create a globally distributed database using one of the multi-model APIs:
Microsoft System Center Management Pack (Community Technology Preview) for SQL Server vNext Replication enables the monitoring of Replication as a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between the databases to maintain consistency.
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)
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 http://update.microsoft.com/.
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”.
Notes:
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
Lot of Success with Azure CosmosDB !
