SQL Nexus 6.0 is released to github
With codeplex shutting down, we have moved SQL Nexus to github with a new release (6.0). Now both Pssdiag/SQLDiag manager and SQL Nexus are on github. Where to get it As you navigate to SQL Nexus, you can download code and released binary f …
Demo: Identify and fix plan change regression in SQL Server 2017 RC1
Plan change regression happens when SQL Database changes a plan for some T-SQL query, and the new plan has the worse performance than the previous one. SQL Server 2017 has Automatic Tuning feature that enables you to easily find plan change regres …
Microsoft Drivers v4.3.0 for PHP for SQL Server released!
This post was authored by Meet Bhagdev, Program Manager, Microsoft Hi all, We are excited to announce the Production Ready release for the Microsoft Drivers v4.3.0 for PHP for SQL Server. The drivers now support Debian Jessie and macOS. The driver enab …
Monitoring automatic tuning actions using XEvents
SQL Server 2017 can automatically tune your queries by identifying and fixing SQL plan change regressions. SQL Server tracks last known good plans for each query, and if the plan for the query changes, last know good plan will be used if performance of …
SQL Server 2017 containers for DevOps scenarios
This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in …
First release candidate of SQL Server 2017 now available
We are pleased to announce the first public release candidate for SQL Server 2017, Release Candidate 1 (RC1), which will be made available later today. This means that development work for the new version of SQL Server is complete along most dimensions …
Public Preview of Compatibility Level 140 for Azure SQL Database
Today we are announcing the official public preview of compatibility level 140 in Azure SQL Database. Compatibility level 140 enables the following query optimizer changes: A trivial plan referencing Columnstore indexes will be discarded in favor of a …
Microsoft JDBC Driver 6.2 for SQL Server released
This post was authored by Andrea Lam, Program Manager, SQL Server We are happy to announce the full release of the Microsoft JDBC Driver 6.2 for SQL Server. The JDBC Driver provides Java database connectivity from any Java application, application serv …
Webcast: Intro to Microsoft SQL Server on Linux with containers
With our community technology previews of SQL Server 2017, Microsoft is bringing the industry-leading performance and security of SQL Server to Linux and containers for the first time. SQL Server running on Red Hat Enterprise Linux and Red Hat OpenShif …
“What are you waiting for?” – Introducing wait stats support in Query Store
Troubleshooting waits previously. Nobody likes to wait. SQL database is multithreaded system that can handle thousands of queries executed simultaneously. Since queries that are executed in parallel compete for the same resources (tables, memory, etc) …
Released: Public Preview for SQL Server 2017 and Replication Management Pack (CTP4)
We are happy to announce SQL Server 2017 Management Pack CTP4 bits with new features are ready (6.7.60.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). Please download the public preview bits at: …
SQL Server : large RAM and DB Checkpointing
SQL Server : large RAM and DB Checkpointing Hi everyone, This post’s purpose is to establish a summary of the specific behaviors with relation to DB Checkpoint that may happen within SQL Server when running with a large quantity of allocat …
Released: System Center Management Pack for SQL Server, Replication, AS, RS, Dashboards (6.7.31.0)
We are happy to announce new updates to SQL Server Management Pack family! Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server Database Engines, Databases, SQL Server Agents, and other related compo …
Azure SQL databases in logical servers, elastic pools, and managed instances
Azure SQL Database is a Database as a Platform service designed for applications that will use database as self-contained services. Databases can be grouped together to simplify management options, share the resources. There are different options that …