Tags : #sqlserver

10

Dec

Availability Groups on Kubernetes in SQL Server 2019 preview
Availability Groups on Kubernetes in SQL Server 2019 preview

Starting with SQL Server 2017, Microsoft embarked on a journey to support SQL Server deployments on Linux and containers, in order to provide a choice of deployment platform for our customers and partners. With the preview of SQL Server 2019, we announced new capabilities for deploying SQL Server with High Availability and Disaster Recovery on containers in Kubernetes. The capability is provided through the new SQL Server Operator for Kubernetes, which provides mechanisms for Always On Availability Groups, adding high availability and disaster recovery capabilities for container deployments of SQL Server.

Customers today are gravitating towards adopting SQL Server on containers for a plethora of deployment scenarios, including local application development testing for DevOps pipelines and in some cases production deployment. SQL Server containers, orchestrated through container frameworks like Kubernetes, provide a consistent, isolated and reliable behavior alongside providing the ease of usage, deployment, and management. The ability to deploy a SQL Server container with Availability Groups, provides an Enterprise-class HA and DR for these deployments.

SQL Server 2019 HA Operator

The Kubernetes operator for SQL Server is the key component which provides the functionality to deploy, manage and maintain the SQL Server HA deployment. The operator implements and registers

Share

26

Nov

SQL Server 2017 on Linux: Support for third-party AD providers
SQL Server 2017 on Linux: Support for third-party AD providers

https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2017-on-linux-support-for-third-party-ad-providers/Source: https://blogs.msdn.microsoft.com/sql_server_team/sql-server-2017-on-linux-support-for-third-party-ad-providers/   In the past, SQL Server on Linux has required SSSD to be configured for AD Authentication to work. SSSD is a very powerful service which provides support AD authentication and integration. However, there are some third-party AD READ MORE

Share

21

Nov

SSMS 17.9.1 is now generally available
SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1.

Download SSMS 17.9.1 today and for details please see the Release Notes.

This is a minor update to 17.9 with the following important improvements:

Occasionally, SSMS closes MFA query editor connections with no outstanding transactions. A simple way to repro this is as follows: Open a New Query window in SSMS Connect to Azure SQL DB with MFA Create a global temp table, insert some data and run a SELECT from the table After a few seconds, re-run the above SELECT statement The Temp table may have been dropped, in certain scenarios.

Based on a few CSS cases and the impact of these issues, we decided to release a minor update for the benefit of our customers.

DAC Wizards: DacFX Import/Export fails with the below error during import: Failed to connect to server sqlce.database.windows.net. (Microsoft.SqlServer.Smo). SSMS Restore plan: SSMS does not generate correct restore plan and picks up an older full backup, despite having newer full backups.

With 17.9 (wrong plan)

With 17.9.1 (Right plan)

SMO:Updated Microsoft.SqlServer.SqlManagementObjects NuGet package to include a readme.txt

Share

19

Nov

Failover Detection Utility – Availability Group Failover Analysis Made Easy

https://blogs.msdn.microsoft.com/sql_server_team/failover-detection-utility-availability-group-failover-analysis-made-easy/Source: https://blogs.msdn.microsoft.com/sql_server_team/failover-detection-utility-availability-group-failover-analysis-made-easy/   To analyze the root cause for the failover of an Availability group, users are required to perform coordinated analysis of various logs including the Cluster Logs, SQL Error Logs, and the Availability groups extended events logs. This READ MORE

Share

16

Nov

SQL Server 2014 Service Pack 3 is now available
SQL Server 2014 Service Pack 3 is now available

The SQL Server team is excited to bring you the third service pack release for SQL Server 2014. This service pack is now available for download from the Microsoft Download Center as well as the Microsoft Update Catalog, Microsoft Developer Network, Microsoft Evaluation Center, MBS Partner Source, and the Volume Licensing Service Center. As part of our commitment to software excellence, this upgrade is available to all customers with existing SQL Server 2014 deployments.

SQL Server 2014 Service Pack 3 (SP3) features improvements centered around performance, scalability, and diagnostics based on the feedback from customers and the SQL community. These improvements enable SQL Server 2014 to perform faster and scale out-of-the-box on modern hardware design.

Key aspects of this release include: Improved database backup performance on large memory machines and improved database restore performance for compressed backups Support enhancements for CLONEDATABASE with a new DBCC option and Service Broker support Support enhancements for Showplan XML in scalar user-defined functions and exposed information about memory fractions

This release includes over eight improvements and 21 support and diagnostic enhancements.

Find more information on SQL Server 2014 SP3 in our KB article, and download the new server pack today by visiting

Share

15

Nov

SSMS 18.0 Public Preview 5 Released
SSMS 18.0 Public Preview 5 Released

We are very excited to announce the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, etc.

You can download SSMS 18.0 Public Preview 5 here.

New features include: Static Data Masking Query Tuning Assistant Ability to launch Azure Data Studio from SSMS SSMS improvements include: SSMS – Exposed “Maximum size for error log files” under “Configure SQL Server error logs” SSMS/Object Scripting – Adding new menu items for “CREATE OR ALTER” when scripting objects Database Compatibility Level Upgrade New option under <Database Name> Tasks> Database Upgrade. This will start the new Query Tuning Assistant to guide the user through the process of: Collecting a performance baseline before upgrading the database compatibility level Upgrading to the desired database compatibility level Collecting a second pass of performance data over the same workload Detecting workload regressions and providing tested recommendations to improve workload performance

 

SSMS Query Store Improved usability of some reports New Query Wait Statistics report

Vulnerability Assessment – Enabled Vulnerability

Share

13

Nov

Creating a data hub for your analytics with PolyBase
Creating a data hub for your analytics with PolyBase

Data is the new currency of the digital world, and Microsoft is uniquely positioned to help businesses and consumers get the most out of their data assets. With the leading database in the world, SQL Server, and the rapidly growing Azure cloud data platform, Microsoft is delivering a modern data platform. We are witnessing a paradigm shift in data management where data in different silos are being brought together to create high-value data sets that are used to drive critical business divisions in industry verticals like retail, banking, healthcare, and more.

SQL Server 2016 introduced a new feature called PolyBase that enables your SQL Server instance to process Transact-SQL queries that read data from Hadoop. The same query can also join with relational tables in your SQL Server. SQL Server 2019 CTP 2.0 introduces new connectors for PolyBase including SQL Server, Oracle, Teradata, MongoDB, Azure SQL DB, Azure SQL DW, Cosmos DB, and virtually any ODBC-accessible data source.

The arrival of the new connectors enables customers to leverage PolyBase for creating a virtual data hub for a wide variety of data sources within the enterprise. Its very common to find an enterprise scenario where data from an Oracle database needs

Share

07

Nov

Announcing: Preview of Machine Learning Services with R support in Azure SQL Database

We are excited to announce that Machine Learning Services with support for R is now available for public preview on Azure SQL Database. Machine Learning Services has transformed SQL Server into a versatile machine learning platform. We are now bringing the same in-database machine learning capabilities to the fully managed Azure SQL Database. We are beginning with support for the R language in this preview release and will be adding Python language support in a future update.

End to end machine learning with R in Azure SQL Database

Using Machine Learning Services with R support in Azure SQL Database, you can

Run R scripts to do data preparation and general purpose data processing You can now bring your R scripts to Azure SQL Database where your data lives, instead of having to move data out to some other server to run R scripts. You eliminate the need for data movement and associated problems related to latency, security, compliance, etc. Train machine learning models in database You can train models using open source algorithms or Microsoft’s scalable algorithms in RevoScaleR and MicrosoftML packages in database. You can easily scale your training to the entire dataset rather than relying on

Share

07

Nov

Harness the future with the ultimate hybrid platform for data and AI

Today Im excited to give the Day 1 keynote at PASS Summit v.20, a gathering of our longtime community of SQL Server users and data professionals. PASS Summit is an amazing chance to see the faces of old and new friends. Its a place to meet with customers and fans to continually learn about their evolving needs and to help us grow as a SQL community and develop the best data platform products in the market.

Hybrid connects all your data

Now more than ever, we are architecting for hybrid, because we are hearing from customers that they will be running data workloads on-premises and in the cloud rarely just one or the other. We believe that the value Microsoft can add is to provide a great and consistent experience wherever they deploy. One example of this commitment is Azure SQL Database Managed Instance, which was recently made generally available. Managed Instance enables organizations to migrate their SQL Server workloads to Azure with zero code changes and offers an easy path to the cloud at an incredible value and with security, intelligent performance and management tools that are unique to our cloud database services. The end of extended support for

Share

06

Nov

The November release of Azure Data Studio is now available
The November release of Azure Data Studio is now available

We are excited to announce the November release of Azure Data Studio (formerly known as SQL Operations Studio) is now available.

Download Azure Data Studioand review the Release Notes to get started.

Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to the latest version, follow these instructions. When you download Azure Data Studio, remember to enable preview features by default at first launch, and then you can disable in settings if you dont need it otherwise. By not enabling the preview features, you will be missing preview experiences like Query Plans, certain extension support, and more.

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our Github.

Azure Data Studio was announced Generally Available at Microsoft Ignite 2018. If you missed it, catch up by reading the GA announcement on the SQL Server blog. You wont want to miss the great orthogonality matrix included comparing SSMS and Azure Data Studio and answers to many of your questions.

In Novembers version of the monthly release

Share