Tags : #sqlserver

18

Mar

The March release of Azure Data Studio is now available

https://cloudblogs.microsoft.com/sqlserver/2019/03/18/the-march-release-of-azure-data-studio-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/03/18/the-march-release-of-azure-data-studio-is-now-available/     Were excited to announce the March 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. Please note: If youre currently READ MORE

Share

18

Mar

Enterprise-scale Backup for SQL Server Databases
Enterprise-scale Backup for SQL Server Databases

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduce overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in Azure: SQL Azure Database, SQL Managed Instance or SQL Server on Azure Virtual Machine (VM).

For the first two implementation types, backups are automatically managed by Azure internally. However, a significant number of customers choose to lift and shift SQL Server from on-premises physical or virtual environments to Azure VM to reduce friction and lower migration costs or risks. Should you choose to do so, youll still need to own and manage the backups for the SQL Server VM. Although you moved your SQL Server infrastructure from on-premises to Azure, the good news is that you dont have to move your backup infrastructure to cloud, thanks to Azure Backup!

Azure Backup fulfills the cloud promise of a cost-effective, elastic-scale, zero-infrastructure solution that eliminates the need to deploy or manage backup infrastructure, agents, or storage accounts. While it offers long term retention and central management capabilities to help IT admins govern and meet their compliance requirements, it lets SQL Admin continue

Share

07

Mar

Free cloud data services training roundup
Free cloud data services training roundup

To help you stay up to date on online training opportunities, were releasing a monthly list of the latest free data and artificial intelligence (AI) trainings in one convenient post.

SQL Server and Windows Server 2008 end of support

End of support is coming for two commonly deployed server products, Windows Server 2008 and SQL Server 2008, which means the end of regular security updates. Don’t let your infrastructure and applications go unprotected. We’re here to help you migrate to current versions for greater security, performance, and innovation. Learn more about end of service support options to carry your organization into the future.

Transform your business with a modern data estate

End of support is coming soon for SQL Server and Windows Server 2008/R2, which means the end of security updates for these versions. Learn what your options are for replacing these installations by joining this training. Youll hear Microsoft and Lenovo experts discuss using a modern data estate to help improve security, performance, and analytics, and learn new ways to reduce your total cost of ownership (TCO).

Register Now Transform Windows Server 2008 apps and infrastructure

End of support for Windows Server 2008 and

Share

04

Mar

We are moving!
We are moving!

https://blogs.msdn.microsoft.com/sql_server_team/we-are-moving/Source: https://blogs.msdn.microsoft.com/sql_server_team/we-are-moving/   This blog is in the process of being migrated to one of the new consolidated SQL Server and Azure SQL Database blogs on the Microsoft TechCommunity website. Once the migration is complete, we will post the new READ MORE

Share

04

Mar

Three reasons to choose Microsoft for your hybrid data platform

Companies today are faced with the trade-off of the security of having an on-premises solution and the convenience of moving their data to the cloud. With Microsoft, companies no longer have to make the choice. SQL Server and Azure SQL Database provide the most consistent hybrid data platform with frictionless migration across on-premises, cloud, and private cloud, all at a lower cost. In this post, well review three reasons why Microsoft should be your hybrid data platform of choice.

It’s consistent

Microsoft is a truly consistent hybrid platform, with the same code base across on-premises, Azure, and Azure Stack. With Azure Stack, you can extend Azure services and capabilities to on-premises environments without any code changes. Interoperability between SQL Server, SQL Server in an Azure Virtual Machine, and Azure SQL Database ensures business continuity and you can easily set up disaster recovery through Always On availability groups.

Download the Azure Stack datasheet

Set up disaster recovery for SQL Server

It’s frictionless

The task of migrating your databases to the cloud can be daunting. Microsoft can help you manage the migration seamlessly with several tools and services that simplify the process with minimal

Share

01

Mar

SQL Server Management Studio 18.0 Public Preview 7 Released

After a brief gap since releasing SQL Server Public Preview 6, and having survived through the February 2019 Snowcalypse in Seattle, Im happy to share that everyone in the SQL Tools team has made it out alive. I am also very excited to announce the Public Preview 7 of SQL Server Management Studio (SSMS) 18.0 is now available. Weve added new features, and a host of bug fixes in this incremental build.

You can download SSMS 18.0 Public Preview 7 today and find additional details in the Release Notes.

SSMS improvements include: When connecting to Azure SQL Database Managed Instance (DB/MI), you can connect to it with <Default> as the initial db. SSMS settings migration (from 17.x and older to 18.0 Preview) When you install SSMS 18 Public Preview 7, it detects any existing versions of 17.x or older and prompts the user if they want to migrate the SSMS settings to SSMS 18. This is a one-time prompt and only happens if a previous version is detected.

Added Showplan support to LocalCube RelOp for DW ROLLUP and CUBE Added support for Edge Constraint in the Graph database Added support to import/export data tier application with

Share

01

Mar

SQL Server 2019 community technology preview 2.3 is now available

At the SQL bits keynote today, we announced the release of SQL Server 2019 community technology preview 2.3, the fourth in a monthly cadency of preview releases. Previewed in September 2018, SQL Server 2019 is the first release of SQL Server to closely integrate Apache Spark and HDFS with SQL Server in a unified data platform.

This CTP 2.3 preview brings the following new features and capabilities to SQL Server 2019:

Big data clusters Submit Spark jobs on SQL Server big data clusters from IntelliJ Application deployment and management experience for deploying a variety of data-related apps including operationalizing machine learning models using R and Python, running SQL Server Integration Services (SSIS) jobs, and more Database engine Accelerated database recovery to provide constant time recovery and instant rollback for long running transactions Performance enhancements in query plan recompilations, transaction log management, and Query Store SQL Graph enhancement to enable cascaded deletion of edges upon the deletion of nodes SQL Server Analysis Services (SSAS) Calculation groups in tabular models that reduce the number of measures by reusing calculation logic Getting started

Ready to learn more? Here are some ways to

Share

20

Feb

Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK!
Join us at SQL Bits 2019 February 27-March 2 in Manchester, UK!

Data never rests, nor does the data platform. It keeps evolving as more organizations turn to data driven insights to stay ahead and prepare for the future.

Be a part of the largest SQL Server professional gathering in Europe at SQL Bits 2019. At SQL Bits, you have the unique opportunity to meet with community leaders sharing their real world experience and Microsoft product teams providing deep insights into Microsoft data solutions.

For those attending this year, weve put together a quick guide below on some of the Data and AI sessions you can look forward to. Cant wait until SQL Bits? Check out the conference sessions to get a taste of what you wont want to miss at SQL Bits 2019.

SQL Bits is also running a promotion right now to share their love for data. Save 50% when you add an extra day using the code: welovedata

Register Now Keynote Friday, March 1

Data Never Rests

Speaker: Buck Woody and Bob Ward

In todays world, the growth of data is ushering in an era of rapid innovation. Microsofts goal is to bring the best hybrid data platform to help data professionals in building

Share

13

Feb

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

Were excited to announce the February 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 youre currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the latest version, please follow these instructions. After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.

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.

Check out this video for a general overview of Azure Data Studio.

The key highlights for the February release include: Introducing Admin pack for SQL Server Added Profiler filtering Added Save as XML Added Data-Tier Application Wizard improvements Updates to the SQL Server 2019 Preview extension Turned on results streaming by default Bug fixes

For a list of the complete updates, refer to the release notes.

Introducing Admin pack for SQL Server

For the first time, our Extension marketplace now supports extension packs. This makes it easier for you

Share

06

Feb

Azure Data Studio – Setting up your environment
Azure Data Studio – Setting up your environment

This blog entry comes from Buck Woody, who recently rejoined the SQL Server team from the Machine Learning and AI team.

For those of you who havent met me or read any of my books or blog entries, its great to meet you! Ive been a data professional for over 35 years, worked at a variety of places like NASA, various consulting firms, and here at Microsoft since 2006. I started on the SQL Server team, and then helped ship Microsoft Azure. After that I spent some time in Microsoft Consulting Services, then over to the Machine Learning team in Microsoft Research, and then the Machine Learning and AI team. Ive rejoined the SQL Server team to help with the inclusion of ApacheSpark, Kubernetes, and the Machine Learning and AI features. Ill still be blogging at my regular location, and from time to time Ill chime in here on the SQL Server blog. As I learn something new, Ill share it. This time Ive learned about a great new tool the team has put together.Azure Data Studio is a new tool that you can use to work with SQL Server.

You may be thinking wait – don’t we already have

Share