Category Archives : #SQLServer

14

May

A new update for mssql-cli, an interactive CLI, is now available

We have released our second major update for mssql-cli since our public preview announcement in December. You can view the public preview announcement here.

mssql-cli is a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is part of the dbcli community.

See the install guide to download mssql-cli and get started.

mssql-cli auto-completion in action

In this release (v0.13.0), highlights include:

Apt-get and Linux packaging support GDPR Compliance New demo video Apt-get and Linux packaging support

One of the key issues Linux users run into when setting up mssql-cli for the first time is not having the right version of Python or having to install Python for the first time. We want to make the first experience with mssql-cli painless, thus we added apt-get support in order to package Python with your installation to help improve the acquisition experience.

For full instructions to acquire mssql-cli for each Linux distribution, please check out the Linux installation guide.

Note: For those who already installed mssql-cli via pip install, please run

sudo pip uninstall mssql-cli

Then, follow the installation instructions.

GDPR compliance

As many of us are familiar with, GDPR is

14

May

Visualize geographic spatial data from SQL Server directly in Tableau 2018.1

This is a partner post authored with the Tableau team

As part of Microsofts open and flexible platform for data and analytics, were always excited when partners add features that will expand customer options and extend business functionality. Business intelligence partner Tableau has recently introduced enhancements that will make it easier for their users to process spatial data stored in SQL Server.

The SQL Server database engine has two spatial types geometry and geography. The geography spatial type helps organize geospatial mapping data into SQL Server tables and works with several SQL-native graphing functions to answer questions like how far apart two geographic locations are, or what locations fall within a certain radius.

Before, customers had to process geography spatial data stored in SQL Server into Shapefiles before they could access it from Tableau. Now with Tableau 2018.1, customers can connect to and visualize data stored in SQL Server directly. This means Tableau will recognize spatial data in your SQL Server tables without any intermediate steps, and customers can leverage spatial operations for geography supported by SQL Server or custom queries to work with geographic data stored in SQL Server. Alongside support for native spatial data, Tableau 2018.1 also includes

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 saving Admin protected and

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

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