Public Preview: Azure SQL Database – Managed Instance Management Pack
We are happy to announce the public preview release of System Center Management Pack for Azure SQL Database – Managed Instance! This is a brand new MP to monitor the new Azure SQL Database – Managed Instance. We are looking forward to getti …
Released: System Center Management Packs for SQL Server 2008-2016 (7.0.2.0)
We are happy to announce that updates to SQL Server Management Packs (2008-2016) have been released. Downloads available: Microsoft System Center Management Pack for SQL Server 2016 Microsoft System Center Management Pack for SQL Server 2014 Micro …
JSON in SQL Server – Use cases
JSON support in SQL Server 2016+ and Azure SQL Database enables you to combine relational and NoSQL concepts and easily transform relational to semi-structured data and vice-versa. JSON is not a replacement for the exiting relational models, and there …
Simplify REST API development for modern Single-page apps with SQL Server
JSON functionalities that are added in SQL Server 2016 and Azure SQL Database enable application developers to easily expose relational data from database tables and create REST API that will provide data to modern JavaScript single-page applications. …
SQL Setup ToolSuite Introduction (3) – SQL Registry Viewer
You may want to know what registry keys will be added to system for a SQL server installation. If you use some registry snapshot tool to compare the window registries change of before and after the SQL installation you will find there are 40000~60000 m …
SQL Setup ToolSuite Introduction (2) – Product Browser
Oftentimes when I worked on a setup case I hope I have a simple tool to tell me the detailed installed product properties and patch information. In Windows control panel I can find all installed products and its update but it doesn’t provide detailed i …
SQL Setup ToolSuite Introduction (1) –FixMissingMSI
If you have encountered missing cached MSI/MSP issues during SQL server setup, you may have knew below article: How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server updatehttps://support.microsoft …
Simplify data access using de-normalized models
Classic relational databases enable you to create highly normalized data models with schema that might contain a lot of tables. Logical entities are broken into several tables and every complex property of the primary entity (for example, list, array, …
Working with Azure IoT data in Azure SQL Database
IoT use cases commonly share some patterns in how they ingest, process, and store data. First, these systems need to ingest bursts of data from device sensors of various locales. Next, these systems process and analyze streaming data to derive real-tim …
SQL Server 2017 on Linux webcast series
The world’s leading database is now available on Linux by bringing Microsoft SQL Server to Linux, Microsoft continues to embrace open source solutions. SQL Server 2017 brings the best features of the Microsoft relational database engine to the en …
Cumulative Update #10 for SQL Server 2014 SP2
The 10th cumulative update release for SQL Server 2014 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …
Webinar: Modernize your applications with cloud and on-premises data solutions from Microsoft
Customers today demand the latest innovations in every solution you deliver. How can you make sure your data infrastructure not only keeps up, but drives innovation? Data is the core of modern applications. Two key trends that help organizations extrac …
Cumulative Update #7 for SQL Server 2016 SP1
The 7th cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing mo …
The January release of SQL Operations Studio is now available
This blog post was authored by Alan Yu, Program Manager, Microsoft SQL Server. We are excited to announce the January release of SQL Operations Studio is now available. Download SQL Operations Studio and review the release notes to get started. SQL Ope …