Tags : #sqlserver

11

Jul

The July release of Azure Data Studio is now available

https://cloudblogs.microsoft.com/sqlserver/2019/07/11/the-july-release-of-azure-data-studio-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/07/11/the-july-release-of-azure-data-studio-is-now-available/     This post and release activities were co-authored by Vasu Bhog, an intern on the Azure Data Studio team. Were excited to announce that the July release ofAzure Data Studiois now available. You can download Azure Data READ MORE

Share

01

Jul

SQL Server 2019 on Windows containers now in Early Adopters Program

Starting with SQL Server 2017s support for Linux and containers, Microsoft has been on a journey of platform and operating system choice. SQL Server 2019 containers simplify application development, continuous integration and deployment (CI/CD) pipelines, and production workloads by making it easier to deploy SQL Server in these environments. Today, were happy to continue down this journey, and announce the availability of SQL Server 2019 Windows-based container images in the Early Adopters Program.

SQL Server 2019 on Windows containers

SQL Server in Windows containers help developers build and ship SQL Server applications faster. Developers and database administrators (DBAs) can start a new SQL Server instance in a container in seconds without any installation for fast development. SQL Server containers can also be used alongside application containers to simplify building and testing applications. Containers can further aid application and database development by easily integrating into existing CI/CD pipelines where new SQL Server instances are required on demand and stopped when they are no longer required.

SQL Server on Windows containers also help IT professionals manage and deploy SQL Server in organizations. IT professionals can pre-configure and build on top of the SQL Server containers to provide standardized deployments for development, test, and production teams.

Share

26

Jun

https://cloudblogs.microsoft.com/sqlserver/2019/06/26/sql-server-2019-community-technology-preview-3-1-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/06/26/sql-server-2019-community-technology-preview-3-1-is-now-available/     Were excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.1. Customers can download this free build, try out features in this release and prior releases, and provide feedback to the READ MORE

Share

20

Jun

Announcing native backup for SQL Server 2008 end of support in Azure

With SQL Server 2008 and 2008 R2 approaching end of support, many customers are moving to Azure. They see this milestone as an opportunity to reimagine and transform their infrastructure with the power of cloud computing. Azure’s offer of free extended security updates for three years provides a new lease on life to these servers while giving organizations time to upgrade.

Of the available migration options, if you choose to lift and shift your on-premises SQL Server to an Azure virtual machine as-is, you will still need to manage backups. Although you moved your SQL Server to Azure, you dont have to move your legacy backup application thats likely infrastructure-heavy and difficult to scale in the cloud. Instead, Azure Backup is an enterprise-scale, zero-infrastructure solution that protects SQL Server on Virtual Machines (VM) in Azure without the need to deploy and manage any backup infrastructure. This offering is already generally available for more recent SQL Server versions, and today were excited to announce Azure Backup support for SQL Server 2008 and 2008 R2 end of support in public preview.

Built-into Azure, the solution is designed to automatically scale protection to thousands of databases with terabytes of data, so you get the peace

Share

06

Jun

The June release of Azure Data Studio is now available

https://cloudblogs.microsoft.com/sqlserver/2019/06/06/the-june-release-of-azure-data-studio-is-now-available/Source: https://cloudblogs.microsoft.com/sqlserver/2019/06/06/the-june-release-of-azure-data-studio-is-now-available/     We’re excited to announce the June release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio and review the release notes to get started. Note: After downloading Azure READ MORE

Share

23

May

Advanced data security for SQL Server is coming to Azure Virtual Machines

This post was written by Michael Makhlevich

Our customers have asked for this and weve been listening advanced data security is now available for SQL Server onAzure Virtual Machines!Using just a few simple steps, you can nowprotectyour SQL ServerinstallationsonAzure VMswith Microsofts advanceddatasecurity capabilities.

Advanced data security for SQL Server on Azure VM currently includes functionality for surfacing and mitigating potential database vulnerabilities and detecting anomalous activities that could indicate a threat to your server. To get started today, read the Advanced data security for SQL Server onVMsetup instructions.

Why you should enable advanced data security for SQL Server on Azure VM

While in public preview, advanced data security for SQL Server on Azure VM is free and includes:

Vulnerability assessment – A database scanning service that can discover, track, and help you remediate potential database vulnerabilities. Detected vulnerabilities across all connected SQL Servers will appear in one unified dashboard! Advanced threat protection – A detection service that continuously monitors your database for suspicious activities and provides action-oriented security alerts on anomalous database access patterns. All alerts will appear in your centralized go-to location for security management in the Azure portal the Azure Security Center threatsdashboard.

For fulldetails regarding

Share

22

May

SQL Server 2019 community technology preview 3.0 is now available

Were excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.0. For customers in the Early Adoption Program, CTP 3.0 is the first release where you’re able to run SQL Server 2019 in production. To apply, please reach out to your assigned Program Manager for more information. Check out the What’s new in SQL Server 2019 preview documentation to learn more.

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

Big data clusters Scale out by supporting deployment configurations with an increased number of SQL Server instances in the compute pool. You can now specify up to 4 instances in the compute pool for optimal performance of your queries against data pool, storage pool, or other external data sources. The mssqlctl utility includes updates to ease the big data cluster management experience with enhancements to the login experience. There is also a new command to list the cluster endpoints. Persistent volumes abstract the details of how the storage is provided and how its consumed. In this release, were enhancing the supported storage configurations by enabling you to customize storage classes independently for logs and data. With these changes, we

Share

21

May

A SQL Server tale of two cities
A SQL Server tale of two cities

No one disputes that data is critical to the lifeblood of business, applications, and the computer industry. SQL Server sits at the forefront of any discussion about data these days. So its no coincidence that SQL Server is seen, heard, and felt at major industry events. As a leader in the Azure Data SQL Server team, I found myself speaking and presenting at two big recent events with two of our major partners DELL and Red Hat. First, at Dell Technologies World in Las Vegas and then the next week at the Red Hat Summit in Boston. While each event has its own focus, we were able to present how SQL Server has become a modern data platform across these two audiences, giving our customers choice with compatibility.

Dell Technologies World 2019 Las Vegas

This is the first time the SQL Server engineering team has presented and met with customers at Dell Technologies World. What was once a small event in Austin, Texas years ago, Dell Technologies World has grown to 15,000 attendees with everything from servers, storage, hybrid, IoT Edge, data, machine learning, and more. Dell is an important partner for Microsoft and the SQL Server team. Dell servers

Share

16

May

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux.

Together with our partners, SQL Server continues to innovate with high-performing, enterprise-ready solutions that deliver unparalleled price performance. Were pleased to share the results for the TPC-H (the industry standard for benchmarking data warehouse) performance at 3TB with HPE that currently holds the record as the industrys fastest 2-socket non-clustered solution, and 10TB with Cisco, as well as the TPC-E (the industry standard for benchmarking online transaction processing) performance at 10TB with Lenovo. Check out the results below.

 

System Performance Database Operating System HPE Proliant DL380 Gen10

1,244,450 QphH@3000GB

Learn more about price performance

SQL Server 2017 Enterprise Edition

SUSE Linux Enterprise Server 15

 

Cisco UCS C480 M5 Server

1,651,514 QphH@10000GB

Learn more about price performance

SQL Server 2017 Enterprise Edition

Red Hat Enterprise Linux 7.6

 

 

The table above shows the TPC-H data warehousing results published on SQL Server 2017 with configuration

Share

13

May

#SQLDataWins is back!
#SQLDataWins is back!

You love data. You love the way it helps you and your organization make better decisions. You love the way it creates real insight into trends that are shaping our world. Plus, data is just plain cool; whats not to love about that?

We love data too. Thats why were excited #SQLDataWins is running for a second year! #SQLDataWins is a sweepstakes that celebrates data and your ability to use it in solving problems and helping your organization grow. Starting May 13th, youll help us complete some memes we can all relate to for a chance to win great swag.

Visit @SQLServer every Monday for the next four weeks to check out a new meme and select the answer that you think fits best. Tweet your response no later than 11:59 PM Pacific Time on Thursday each week. Be sure to use the handy auto-generated tweet, including #SQLDataWins and the original image, for a chance to win.

Hot tip: Check back every week for a new meme!

FAQs How do I enter?

Its easy! Follow these three simple steps by Thursday at 11:59 p.m. Pacific Time:

Visit SQL Server on Twitter. Find this weeks #SQLDataWins meme (hint: it will

Share