Tags : #sqlserver

09

May

SSMS 17.7 is now available
SSMS 17.7 is now available

This post is co-authored bySandy Winarko, Principal PM, SQL Server.

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.7!

Download SSMS 17.7 and review the Release Notes to get started.

SSMS 17.7 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.

In addition to enhancements and bug fixes, SSMS 17.7 comes with several exciting new features:

Support package scheduling in Azure-SSIS integration runtime. Support for SSIS package scheduling in SQL Agent on SQL Managed instance. It is now possible to create SQL Agent jobs to execute SSIS packages on the managed instance. Replication monitor now supports registering a listener for scenarios where publisher database and/or distributor database is part of Availability Group. So with this release of SSMS, you can monitor replication environments where publisher database and/or distribution database is part of Always On. Fixed bug fixes Scheduling SSIS Activities in ADF Pipelines via SSMS

Unlike on-premises SQL Server/Azure SQL Managed Instance (MI) that have a native/first-class SSIS job scheduler as part of SQL Server/MI Agent, Azure SQL Database does not have any. Consequently, if you use Azure SQL

08

May

The May release of SQL Operations Studio is now available

This post is co-authored by Karl Burtram, Senior Software Engineer, SQL Server.

We are excited to announce the May release of SQL Operations Studio is now available.

Download SQL Operations Studio and review the Release Notes to get started.

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our Github.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this May release is the sixth major update since the announcement. If you missed it, you can view the April release announcement.

The May Public Preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top Github issues.

Highlights for this build include the following.

Announcing Redgate SQL Search extension available in Extension Manager Community Localization available for 10 languages: German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese and Traditional Chinese! GDPR-compliant build has reduced telemetry collection, improved opt-out experience and in-product links to Privacy Statement Extension Manager has improved Marketplace experience to easily discover community extensions SQL Agent extension Jobs and

08

May

Database scoped default online options is in preview for Azure SQL DB

This post is authored byJosh Gnanayutham, Program Manager, Azure SQL Database.

We are happy to announce that database scoped default options for online and resumable are now available for public preview. With this feature, you can set a default behavior for online and resumable rather than defining the option for each individual statement.

You can also avoid accidentally performing an operation that takes your database offline. By setting online as the default for your database, you can ensure that every supported operation will be elevated to online. You can override these set defaults by defining an option for online or resumable in the statement.

Users can set these defaults using the ELEVATE_ONLINE and ELEVATE_RESUMABLE database scoped configuration options. Both options will cause the engine to automatically elevate supported operations to online or resumable execution. You can enable the following behaviors using these options:

You can set either option to FAIL_UNSUPPORTED if you would like to execute all operations online or resumable and fail operations that are not supported for online or resumable. You can set either option to WHEN_SUPPPORTED if you would like to execute supported operations online or resumable and run unsupported operations offline or nonresumable. You can

07

May

Azure AD  authentication with Azure SQL DB using Multi-Factor Authentication  enabled by Azure AD Conditional Access

https://blogs.msdn.microsoft.com/sqlsecurity/2018/05/07/azure-ad-authentication-with-azure-sql-db-using-multi-factor-authentication-enabled-by-azure-ad-conditional-access/Source: https://blogs.msdn.microsoft.com/sqlsecurity/2018/05/07/azure-ad-authentication-with-azure-sql-db-using-multi-factor-authentication-enabled-by-azure-ad-conditional-access/   The attached document describes the detail steps required to setup and execute Azure Active Directory (AD)  authentication with Azure SQL DB/DW using Multi-Factor Authentication (MFA) enabled by Azure AD Conditional Access.SQL.AAD_.MFA_.Aut_.HandOnLab1

30

Apr

Replication Enhancement – Improved Distribution Database Cleanup

https://blogs.msdn.microsoft.com/sql_server_team/replication-enhancement-improved-distribution-database-cleanup/Source: https://blogs.msdn.microsoft.com/sql_server_team/replication-enhancement-improved-distribution-database-cleanup/   Replication Distribution database is the perhaps the most important entity in the entire replication topology. Apart from storing the replication metadata and history for replication agents, the distribution database, in case of transactional replication, also provides intermediate READ MORE

25

Apr

The April release of SQL Operations Studio is now available
The April release of SQL Operations Studio is now available

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce the April release of SQL Operations Studio is now available.

Download SQL Operations Studio and review the Release Notes to get started.

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this April release is the fifth major update since the announcement. If you missed the March release announcement can be viewed here.

The April Public Preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top Github issues.

Highlights for this build include the following.

Public preview release of SQL Agent extension Added new extensions and improved existing extensions Improvements to Server Reports Extension Release of SSMS Keymap extension Release of AlwaysOn Insights extension Release of MSSQL Instance Insights Release of MSSQL Db Insights Added Visual Studio Code 1.21 platform source code refresh Improved large and protected file support for

25

Apr

The April release of SQL Operations Studio is now available
The April release of SQL Operations Studio is now available

This post is authored by Alan Yu, Program Manager, SQL Server.

We are excited to announce the April release of SQL Operations Studio is now available.

Download SQL Operations Studio and review the Release Notes to get started.

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this April release is the fifth major update since the announcement. If you missed the March release announcement can be viewed here.

The April Public Preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top Github issues.

Highlights for this build include the following.

Public preview release of SQL Agent extension Added new extensions and improved existing extensions Improvements to Server Reports Extension Release of SSMS Keymap extension Release of AlwaysOn Insights extension Release of MSSQL Instance Insights Release of MSSQL Db Insights Added Visual Studio Code 1.21 platform source code refresh Improved large and protected file support for saving Admin protected and

25

Apr

Modernize to cloud with Azure SQL Database
Modernize to cloud with Azure SQL Database

Companies are embracing digital transformation by migrating to the cloud. IT organizations are continuously looking for new ways of optimizing how they use the data that fuels their operations. Modernizing to the cloud offers the right mix of operational efficiencies and business enablement to drive continued growth. IT optimization now requires new perspectives to consider:

eliminate time spent managing long tail of applications lift and shift to managed cloud, free up limited IT resources to drive transformation, and migrate business critical apps to the cloud extend and innovate

One way IT organizations can confront challenges on their transformation journey is by adopting a PaaS (Platform as a Service) solution like Azure SQL Database. Azure SQL Database is a fully-managed relational database-as-a-service that provides the best and most economical cloud destination for your SQL data. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.

Within SQL Database, there is a new deployment option called Managed Instance that enables you to quickly and confidently move your SQL Server data (2005 and newer) at scale to the cloud. SQL Database shares a common code base with SQL Server and supports

25

Apr

Modernize to cloud with Azure SQL Database
Modernize to cloud with Azure SQL Database

Companies are embracing digital transformation by migrating to the cloud. IT organizations are continuously looking for new ways of optimizing how they use the data that fuels their operations. Modernizing to the cloud offers the right mix of operational efficiencies and business enablement to drive continued growth. IT optimization now requires new perspectives to consider:

eliminate time spent managing “long tail” of applications – lift and shift to managed cloud, free up limited IT resources to drive transformation, and migrate business critical apps to the cloud – extend and innovate

One way IT organizations can confront challenges on their transformation journey is by adopting a PaaS (Platform as a Service) solution like Azure SQL Database. Azure SQL Database is a fully-managed relational database-as-a-service that provides the best and most economical cloud destination for your SQL data. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.

Within SQL Database, there is a new deployment option called Managed Instance that enables you to quickly and confidently move your SQL Server data (2005 and newer) at scale to the cloud. SQL Database shares a common code base with SQL Server and supports most

24

Apr

SQL Server 2016 Service Pack 2 is now available
SQL Server 2016 Service Pack 2 is now available

The SQL Server team is excited to bring you the second service pack release for SQL Server 2016. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2016 deployments.

SQL Server 2016 Service Pack 2 (SP2) contains a roll-up of released hotfixes as well as multiple improvements centered around performance, scalability, and supportability based on feedback from customers and the SQL community. These improvements enable SQL Server 2016 to perform faster and with expanded supportability and diagnostics. It also showcases the SQL Server product teams commitment to providing continued value into in-market releases.

SQL Server 2016 Service Pack 2 includes:

Performance and scale improvements for SQL Server, such as improved database backup performance on large memory machines and added backup compression support, which helps performance of almost all databases. Supportability and diagnostics enhancements, such as improved troubleshooting and additional information about statistics used during query plan optimization. New improvements based on Connect feedback items filed by the SQL Server