Azure Data Studio 1.41 release
Microsoft SQL Server Blog
by Erin Stellato
1w ago
We are less than one month into 2023 and already have a new release of Azure Data Studio to shareintroducing 1.41! With this release, we migrated to a new authentication library, made improvements based on user requests and feedback, and addressed a slew of existing issues that had been logged by usersincluding some that were really old. We would like to express our gratitude to the community for creating issues in GitHub, and for engaging with the engineering team when more information was needed. To those users that provided logs or more detail about their environment and the problem: thank ..read more
Visit website
Working with time series data in SQL Server 2022 and Azure SQL
Microsoft SQL Server Blog
by Kendal Van Dyke
3w ago
Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not time-based and may be updated often, time series data is typically written once and rarely, if ever, updated. Some examples of time series data include stock prices, telemetry from equipment sensors on a manufacturing floor, and performance metrics from SQL Server, such as CPU, memory, I/O, and network utilization. Time series data is often used for historical comparisons, anomaly detection ..read more
Visit website
Cardinality Estimation Feedback in SQL Server 2022
Microsoft SQL Server Blog
by Kate Smith
2M ago
Part of theSQL Server 2022 blog series. Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptionsknown as the model. The model determines how we interpret statistics and data coming from various sub expressions, and so, for any given set of statistics, different models will arrive at different cardinality estimates.  SQL Server 2022 The most Azure-enabled release yet, with continued performance, security ..read more
Visit website
Manage, govern, and secure all your SQL Servers with new hybrid capabilities enabled by Azure Arc 
Microsoft SQL Server Blog
by Peter Carlin
2M ago
Part of the SQL Server 2022 blog series. In the face of changing market conditions and pressure to accelerate growth, the ability for customers to do more with less is critical. And while the cloud has long been the north star for realizing efficiencies and accelerating innovation, at Microsoft, we understand that these benefits also need to happen outside of the cloud. In 2021 we announced the general availability of Azure Arc-enabled SQL Managed Instance. Previously only available in Azure, Azure Arc-enabled SQL Managed Instance allows customers to build new cloud native appli ..read more
Visit website
Azure Data Studio November release
Microsoft SQL Server Blog
by Timi Oshin and Erin Stellato
2M ago
In this release of Azure Data Studio, we have exciting news to share across several of our core features and extensions. The first is the announcement of the general availability (GA) of Table Designer and Query Plan Viewer. We would like to extend a huge thank you to our engineering teams who have worked tirelessly over the past few months on improvements to these features. We would also like to thank the MVPs and community members who provided feedback on these features. We are grateful for continued engagement from users as we work to make Azure Data Studio the tool of choice for cloud data ..read more
Visit website
New SQL Server on Azure Virtual Machines and Azure SQL Managed Instance DR benefits
Microsoft SQL Server Blog
by Logan Carrington
2M ago
Customers who are running their SQL Server workloads using SQL Server on Azure Virtual Machines and Azure SQL Managed Instance are now eligible for new high availability (HA) and disaster recovery (DR) benefits. These are in addition to existing HA/DR benefits that are explained in detail in the SQL Server licensing materials and this previously published blog. The new benefits are the capability to license a disaster recovery and a high availability secondary for free for SQL Server on Azure Virtual Machinesa new benefit for pay-as-you-go customersand licensing geo-redundant disaster recovery ..read more
Visit website
SQL Server 2022 is now generally available
Microsoft SQL Server Blog
by Rohan Kumar
2M ago
Part of theSQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability1. This marks the latest milestone in the more than 30-year history of SQL Server. SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform. The platform seamlessly integrates operational databases, analytics, and data governance. This enables customers to adapt in real-time, add layers of intelligence to their applications, unlock fast and predictive ..read more
Visit website
Link feature for Azure SQL Managed Instance: Connecting SQL Server 2022 to the cloud, reimagined
Microsoft SQL Server Blog
by Dani Ljepava
2M ago
Part of theSQL Server 2022 blog series. We are excited to announce general availability (GA) of the link feature for Managed Instance for SQL Server 2022the most Azure-enabled release of SQL Server yet. We are also excited to announce a limited preview of the managed disaster recovery (DR) to Azure SQL Managed Instance. Link feature for SQL Server 2022 (GA) Overview The link feature, announced in the March SQL Server 2022 preview, is reimagining the connection between SQL Server hosted anywhere and the fully managed platform as a service (PaaS) service Azure SQL Managed Instance, providing unp ..read more
Visit website
Memory Grant Feedback: Persistence and Percentile Grant
Microsoft SQL Server Blog
by Kate Smith
3M ago
Part of the SQL Server 2022 blog series. Memory grant feedback (MGF) is an existing feature in SQL Server, with two critical improvements available in SQL Server 2022: feedback persistence, and percentile grant feedback. These two features enhance the benefits of memory grant feedback as it already existed in SQL Serverallowing for less re-learning of appropriate grants and preventing fluctuating grant requirements from blocking the benefit of memory grant feedback. Memory grant feedback This existing feature aims to prevent costly spills or wasteful memory allocation of queries by remembering ..read more
Visit website
Intelligent Query Processing: degree of parallelism feedback
Microsoft SQL Server Blog
by Kate Smith
3M ago
SQL Server 2022, Updates Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; Current DOP methods are inefficient The degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any time a query is using parallelism, there is always the question of if it’s using the right amount of parallelism. Sometimes, if the degree of parallelism is too high, it can introduce inefficiencies into the query execution. If the degree of parallelism is too low, we may be missing out on some of the speed-up that parallelism can provide. Use ..read more
Visit website

Follow Microsoft SQL Server Blog on Feedspot

Continue with Google
OR