quinta-feira, 1 de dezembro de 2016

[From Technet] Using SQL Tools with SQL Server on Linux

Today, developers can use SQL Server in a variety of environments including on-premises, in datacenters, in virtual machines, in clouds such as Azure, AWS and Google, and also as a Platform as a Service (PaaS) offering with Azure SQL Database and Azure SQL Data Warehouse.

We recently announced SQL Server v.Next CTP1 on Linux and Windows, which brings the power of SQL Server to both Windows — and for the first time ever — Linux. Developers can now create applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.

As part of this announcement, we have released new SQL tools and also updated existing SQL tools. Developers can use these tools to connect to and work with SQL running anywhere, including SQL Server on Linux, Windows or Docker.

  • New mssql extension for Visual Studio Code: Get the free mssql extension from the VS Code marketplace and connect to SQL running anywhere, get IntelliSense and keyword completion while typing T-SQL queries, and run your queries to see results — all within Visual Studio Code and on Linux/macOS/Windows!
  • New SQL command line tools for Linux: We’ve created Linux-native versions of your favorite SQL command line tools such as sqlcmd and bcp and sqlpackage and also added the new mssql-conf tool that lets you configure various properties for the SQL Server instance on Linux (e.g., SA password, TCP port and collation).
  • New versions of SSMS, SSDT and SQL PowerShell: We have released updated versions (v17.0 RC1) of our flagship SQL Server tools including SQL Server Management Studio (SSMS), Visual Studio SQL Server Data Tools (SSDT) and SQL PowerShell with support for the SQL Server v.Next on Windows and Linux.

The picture below summarizes the expanded SQL tools portfolio with these announcements. Going forward, we plan to continue our close collaboration with customers and the broader SQL community to enhance our SQL tools portfolio and incrementally create multiplatform SQL tools for developers and database administrators.


Get started today

  • Try the new getting started tutorials that show you how to:
    • Install SQL Server on Linux/macOS/Docker/Windows
    • Create a simple app using languages such as C#, Java, Node.js, PHP and Python with SQL Server
    • Create a simple app using popular web frameworks and Object Relational Mapping (ORM) frameworks with SQL Server
    • Try out some cool SQL Server features that can make your apps shine
  • Get the latest v17.0 RC1 versions of SQL Server Management Studio (SSMS) and SQL Server Data Tools (SSDT)
  • Get the mssql extension for Visual Studio Code, and develop apps with SQL Server on Linux/macOS/Windows
  • Take a look at the source code for the mssql extension on github and submit your ideas and pull requests!

Connect with us

Learn more

Other videos in this series

from SQL Server Blog http://ift.tt/2gqHRvc

quarta-feira, 30 de novembro de 2016

[From Technet] SQL Server on Linux: High availability and security

With SQL Server on Linux, Microsoft brings SQL Server’s core relational database engine to the growing enterprise Linux ecosystem. Both High Availability and Disaster Recovery (HADR) and security are aspects of SQL Server that are critically important for enterprises. This article highlights the HADR and security solutions for SQL Server on Linux that are available today, as well as the roadmap for what’s coming soon.

HADR landscape

SQL Server offers solutions for various HADR scenarios and it comes with a set of features and capabilities that can help organizations achieve a wide range of availability SLAs goals. From Simple HADR solutions like VM failover with durable storage, to shared disk failover clustering and log shipping (Standard DR) or Always On Availability Groups for mission-critical workloads, these solutions offer different Recovery Point Objective (RPO*), Recovery Time Objective (RTO**), failover and workload load balancing capabilities, enabling customers to choose the optimal solution depending on their business needs:

SQL Server Linux HADR Solutions

*RPO – the maximum time frame your organization is willing to lose data for, in the event of an outage
*RTO – the maximum downtime that your organization can endure in the event of an outage

For SQL Server running on Linux, our goal is to preserve the capabilities framed in the diagram above. We are starting to enable support for some of these solutions starting with the SQL Server v.Next Community Technology Preview (CTP) 1 release.

In Windows, SQL Server relies upon Windows Server Failover Clustering to provide the infrastructure features supporting the HADR scenarios. Similarly, on Linux platforms, SQL Server is natively integrated with popular clustering solutions like Pacemaker, so it can benefit from the health monitoring, failure detection or failover coordination of the clustering layer. Please visit our reference documentation on business continuity for SQL Server on Linux for more details about supported platforms and clustering solutions and end-to-end functional samples.

Security solutions

According to the National Institute of Standards and Technology (NIST) public security board, SQL Server has the lowest number of reported security vulnerabilities across the major database vendors (NIST, February 2016). With SQL Server 2016, security was further enhanced by additional security features such as Always Encrypted, Row-Level Security and Dynamic Data Masking.

SQL Server on Linux will support the same advanced, security functionality that enterprises depend on to protect,  control, and monitor access to their data. These capabilities are all built- in:

SQL Server on Linux Security

This layered approach to data security, in addition to Microsoft’s overall commitment to advancing security and privacy protection, enables enterprises to secure their data and achieve regulatory compliance more easily than ever before.

You can find out more about these enterprise-grade security capabilities as well as HADR solutions planned for SQL Server on Linux by watching the video above. The clip also includes a demo on how to register a SQL Server instance to be part of a Linux cluster setup using Pacemaker, as well as a demo on how to migrate an encrypted database from Windows to an instance of SQL Server running on Linux.

Get started

You can get started with many of these capabilities today:

Learn more

Stay tuned for additional SQL Server Blog posts in the coming weeks, including connectors, and developer tools on Linux!

from SQL Server Blog http://ift.tt/2fRJy43

segunda-feira, 28 de novembro de 2016

[From Technet] Recognizing the top Database Systems contributors on MSDN forums!

We are planning to launch a monthly leaderboard for the top contributors on MSDN forums. This is a pilot effort for Database Systems, including SQL Server, Azure SQL Database, Azure SQL Data Warehouse, and SQL Server VMs on Azure questions on MSDN. Read more about it on the Azure blog and send in your feedback to leaderboard-sql@microsoft.com.

Congratulations to our October 2016 Top 10 contributors!

MSDN Contributors Leaderboard

from SQL Server Blog http://ift.tt/2gAVmFc

[From Technet] Microsoft releases the latest update to Analytics Platform System

Microsoft is pleased to announce that the appliance update, Analytics Platform System (APS) 2016, has been released to manufacturing and is now generally available. APS is Microsoft’s scale-out Massively Parallel Processing fully integrated system for data warehouse specific workloads.

This appliance update builds on the SQL Server2016 release as a foundation to bring you many value-added features. APS 2016 offers additional language coverage to support migrations from SQL Server and other platforms. It also features improved security for hybrid scenarios and the latest security and bug fixes through new firmware and driver updates.

SQL Server 2016

APS 2016 runs on the latest SQL Server 2016 release and now uses the default database compatibility level 130 which can support improved query performance. SQL Server 2016 allows APS to offer features such as secondary index support for CCI tables and PolyBase Kerberos support.


APS 2016 supports a broader set of T-SQL compatibility, including support for wider rows and a large number of rows, VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX). For greater analysis flexibility, APS supports full window frame syntax for ROWS or RANGE and additional windowing functions like FIRST_VALUE, LAST_VALUE, CUME_DIST and  PERCENT_RANK. Additional functions like NEWID() and RAND() work with new data type support for UNIQUEIDENTIFIER and NUMERIC. For the full set of supported T-SQL, please visit the online documentation.

PolyBase/Hadoop enhancements

PolyBase now supports the latest Hortonworks HDP 2.4 and HDP 2.5. This appliance update provides enhanced security through Kerberos support via database-scoped credentials and credential support with Azure Storage Blobs for added security across big data analysis.

Install and upgrade enhancements

Hardware architecture updates bring the latest generation processor support (Broadwell), DDR4 DIMMs, and improved DIMM throughput – these will ship with hardware purchased from HPE, Dell or Quanta. This update offers customers an enhanced upgrade and deployment experience on account of pre-packaging of certain Windows Server updates, hotfixes, and an installer that previously required an on-site download.

APS 2016 also supports Fully Qualified Domain Name support, making it possible to setup a domain trust to the appliance. It also ships with the latest firmware/driver updates containing security updates and fixes.

Flexibility of choice with Microsoft’s data warehouse portfolio

The latest APS update is an addition to already existing data warehouse portfolio from Microsoft, covering a range of technology and deployment options that help customers get to insights faster. Customers exploring data warehouse products can also consider SQL Server with Fast Track for Data Warehouse or Azure SQL Data Warehouse, a cloud based fully managed service.

Next Steps

For more details about these features, please visit our online documentation or download the client tools.

from SQL Server Blog http://ift.tt/2fXrZNC

terça-feira, 22 de novembro de 2016

[From Technet] Technical Preview: Database Experimentation Assistant

This post is authored by Christina Lee, Program Manager – Data Group SEALS Team


Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers upgrading from previous SQL server versions (starting 2005 and above) to any new version of the SQL server can use these analysis metrics provided by tool, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data to build higher confidence and have a successful upgrade experience.

What Can I Do?

DEA offers the following capabilities for workload comparison analysis and reporting:

  • Set up automated workload capture and replay of production database (using existing SQL server functionality Distributed Replay & SQL tracing)
  • Perform statistical analysis on traces collected using both old and new instances
  • Visualize data through analysis report via rich user experience

With DEA, you can:

  • Capture Trace: you can automatically capture a production workload trace with only a few inputs. Learn how to capture trace.
  • Replay Trace: you can replay a trace on current and new/proposed instances of SQL. Learn how to replay trace.
  • View Workload Analysis Reports: you can generate new reports to gain insights on how workload performance changes across versions of SQL. In addition to generating a new report, you can view previously generated reports. Learn how to generate reports.

DEA can be used through command line: learn how to use DEA command line.

Supported versions

Source: SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016
Target: SQL Server 2012, SQL Server 2014, and SQL Server 2016


You can install from Microsoft Download Center. Run ‘DatabaseExperimentationAssistant.msi’ to install Database Experimentation Assistant.


For questions, please visit the FAQs for DEA. If you have further questions or would like to provide feedback, please email us at deafeedback@microsoft.com.

from SQL Server Blog http://ift.tt/2gcRGcJ

segunda-feira, 21 de novembro de 2016

[From Technet] Source Control in SQL Server Management Studio (SSMS)

This post was written by Ken Van Hyning, Engineering Manager, SQL Server Client Tools.

In the latest generation of SQL Server Management Studio, we moved to the Visual Studio 2015 Isolated Shell. While this provides SSMS a modern IDE foundation for many functional areas, it also had some consequences. Specifically, the integration with source control systems in SSMS no longer works the way it did in SSMS 2014 and prior.  Previously, one could install the Visual Studio MSSCCI provider and then integrate with various source control systems. Visual Studio 2015 does not support MSSCCI so that is no longer an option to use in SSMS.

Of course, the good news is that Visual Studio 2015 includes TFS and Git source control integration. With the move to VS 2015 Isolated Shell, SSMS should be able to use these packages as well, right? The answer is…yes…but! The issue for SSMS is that the TFS source control integration package VS provides also includes the entire suite of TFS integration features. If we include this package by default, SSMS will have Team Explorer in its entirety which includes things such as work item tracking, builds, etc. This doesn’t fit in the overall experience SSMS is designed for, so we aren’t going to include this package as part of SSMS. The full TFS integrated experience is included as part of SQL Server Data Tools which is designed for a more developer-centric set of scenarios.

That said, if source code integration is an important aspect of how you use SSMS, you can enable the Visual Studio packages manually.

Enabling source control integration in SSMS

To enable TFS integration in SSMS, follow these steps:

  1. Close SSMS if it is running.
  2. Install Visual Studio 2015 on your SSMS machine. If you don’t already have Visual Studio, Community Edition will work fine. This is a large download but you can save some space by unselecting all languages during the Visual Studio install if your only purpose is to enable Source Control in SSMS.
  3. Edit the ssms.pkgundef file found at C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\ssms.pkgundef.
    • At the top of this file there are a series of packages grouped together related to TFS Source Control features. These packages must be removed from the pkgundef file. This can be done by either deleting the section or commenting out each line using ‘//’. Here is an example of what the section should look like if commented out:// TFS SCC Configuration entries.  The TFS entries block Team Explorer from loading.
      // Microsoft.VisualStudio.TeamFoundation.VersionControl.HatPackage
      // Microsoft.VisualStudio.TeamFoundation.Lab
      // GitHub Package
      // Team Foundation Server Provider Package
      // Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPackage
      // Microsoft.VisualStudio.TeamFoundation.Build.BuildPackage
      // Microsoft.VisualStudio.TeamFoundation.WorkItemTracking
      // Microsoft.VisualStudio.TeamFoundation
      // Microsoft.TeamFoundation.Git.Provider.SccProviderPackage
      // Microsoft.VisualStudio.TeamFoundation.VersionControl.SccPcwPluginPackage
      // Microsoft.VisualStudio.TeamFoundation.VersionControl.HatPackage
      // Visual SourceSafe Provider Package
      // Visual SourceSafe Provider Stub Package
      // Microsoft.VisualStudio.TeamFoundation.Initialization.InitializationPackage
      // Team Foundation Server Provider Stub Package
      // Microsoft.VisualStudio.Services.SccDisplayInformationPackage
      // Microsoft.VisualStudio.TeamFoundation.Lab.LabPcwPluginPackage
      [$RootKey$\ToolsOptionsPages\Source Control]
      // TFS SCC Configuration entries.

Once completed, start SSMS and the “Team” menu should be visible in the SSMS menu bar. This menu and related features are the standard Visual Studio functionality. This enables connections to TFS servers or Git servers. Please refer to the following Visual Studio documentation for more information:

from SQL Server Blog http://ift.tt/2fVC51V

quinta-feira, 17 de novembro de 2016

[From Technet] SQL Server 2016 SP1 brings new innovation opportunities to software partners

Yesterday at Connect(); we announced SQL Server 2016 Service Pack 1 (SP1), which introduces a common programming surface across SQL Server editions. This move makes innovative database features such as in-memory performance across workloads, encryption at rest and in motion, and the ability to query across structured data and unstructured data in Hadoop available to applications of all sizes. Our Independent Software Vendor (ISV) partners now have greater flexibility to adopt advanced database features while supporting multiple SQL Server editions – without having to maintain separate code for each. Your customers gain the flexibility to choose the SQL Server edition that fits their workload, then scale as they go.

As Nick Craver, Architecture Lead at Stack Overflow noted in Joseph Sirosh’s Connect(); announcement blog, this eliminates the burden of programming to different editions. “With SQL Server 2016 SP1, we can run the same code entirely on both platforms and customers who need Enterprise scale buy Enterprise, and customers who don’t need that can buy Standard and run just fine. From a programming point of view it’s easier for us and easier for them.” This means that ISV partners who have been eyeing the performance benefits of in-memory OLTP or the greater security enabled by supporting Always Encrypted now can get started with these innovative features that will help differentiate their applications, regardless of the editions they support.

To help you on your journey to SQL Server 2016, Microsoft is launching the SQL Server 2016 ISV Accelerator Program, a set of resources to help you quickly assess your application for SQL Server 2016 support, leverage the latest features, and learn more about the opportunity to work with Microsoft to bring your applications to market.  When you enroll in the program, you’ll have access to a set of SQL Server 2016 training and reference materials and help from Microsoft SQL Server subject matter experts. In addition, you’ll be on a path that can help market your application to Microsoft customers more broadly.

As we look to the future, Microsoft continues to invest in SQL Server programmability features, tooling and connectors to help developers and partners grow their applications. And with our announcement of the next version of SQL Server on Linux and Windows, partners and customer will have even more flexibility in the platforms, languages, and data they use with SQL Server.

We hope you’ll join us on this journey. The best way to get started is to begin today with SQL Server 2016 SP1. Sign up now to get access to tools and resources, and begin innovating with Microsoft’s data platform.

from SQL Server Blog http://ift.tt/2glQuc6

quarta-feira, 16 de novembro de 2016

[From Technet] Announcing the Next Generation of Databases and Data Lakes from Microsoft

This post was authored by Joseph Sirosh, Corporate Vice President of the Microsoft Data Group.

Microsoft Connect() 2016

For the past two years, we’ve unveiled several of our cutting-edge technologies and innovative solutions at Connect(); which will be livestreaming globally from New York City starting November 16. This year, I am thrilled to announce the next generation of SQL Server and Azure Data Lake, and several new capabilities to help developers build intelligent applications.

1. Next release of SQL Server with Support for Linux and Docker (Preview)

I am excited to announce the public preview of the next release of SQL Server which brings the power of SQL Server to both Windows – and for the first time ever – Linux. Now you can also develop applications with SQL Server on Linux, Docker, or macOS (via Docker) and then deploy to Linux, Windows, Docker, on-premises, or in the cloud.  This represents a major step in our journey to making SQL Server the platform of choice across operating systems, development languages, data types, on-premises and the cloud.  All major features of the relational database engine, including advanced features such as in-memory OLTP, in-memory columnstores, Transparent Data Encryption, Always Encrypted, and Row-Level Security now come to Linux. Getting started is easier than ever. You’ll find native Linux installations (more info here) with familiar RPM and APT packages for Red Hat Enterprise Linux, Ubuntu Linux, and SUSE Linux Enterprise Server. The public preview on Windows and Linux will be available on Azure Virtual Machines (coming soon) and as images available on Docker Hub, offering a quick and easy installation within minutes.  The Windows download is available on the Technet Eval Center.

We have also added significant improvements into R Services inside SQL Server, such as a very powerful set of machine learning functions that are used by our own product teams across Microsoft. This brings new machine learning and deep neural network functionality with increased speed, performance and scale, especially for handling a large corpus of text data and high-dimensional categorical data. We have just recently showcased SQL Server running more than one million R predictions per second and encourage you all to try out R examples and machine learning templates for SQL Server on GitHub.

The choice of application development stack with the next release of SQL Server is absolutely amazing – it includes .NET, Java, PHP, Node.JS, etc. on Windows, Linux and Mac (via Docker). Native application development experience for Linux and Mac developers has been a key focus for this release. Get started with the next release of SQL Server on Linux, macOS (via Docker) and Windows with our developer tutorials that show you how to install and use the next release of SQL Server on macOS, Docker, Windows, RHEL and Ubuntu and quickly build an app in a programming language of your choice.

SQL Server

2. SQL Server 2016 SP1

We are announcing SQL Server 2016 SP1 which is a unique service pack – for the first time we introduce consistent programming model across SQL Server editions. With this model, programs written to exploit powerful SQL features such as in-memory OLTP, in-memory columnstore analytics, and partitioning will work across Enterprise, Standard and Express editions. Developers will find it easier than ever to take advantage of innovations such as in memory databases and advanced analytics – you can use these advanced features in the Standard Edition and then step up to Enterprise for Mission Critical performance, scale and availability – without having to re-write your application.

Our software partners are excited about the flexibility that this change gives them to adopt advanced features while supporting multiple editions of SQL Server.

“With SQL Server 2016 SP1, we can run the same code entirely on both platforms and customers who need Enterprise scale buy Enterprise, and customers who don’t need that can buy Standard and run just fine. From a programming point of view, it’s easier for us and easier for them,” said Nick Craver, Architecture Lead at Stack Overflow.

To be even more productive with SQL Server, you can now take advantage of improved developer experiences on Windows, Mac and Linux for Node.js, Java, PHP, Python, Ruby, .NET core and C/C++. Our JDBC Connector is now published and available as 100% open source which gives developers more access to information and flexibility on how to contribute and work with the JDBC driver. Additionally, we’ve made updates to ODBC for PHP driver and launched a new ODBC for Linux connector, making it much easier for developers to work with Microsoft SQL-based technologies. To make it more seamless for all developers Microsoft VSCode users can also now connect to SQL Server, including SQL Server on Linux, Azure SQL Database and Azure SQL Data Warehouse.  In addition, we’ve released updates to SQL Server Management Studio, SQL Server Data Tools, and Command line tools which now support SQL Server on Linux.


3. Azure Data Lake Analytics and Store GA

Today, I am excited to announce the general availability of Azure Data Lake Analytics and Azure Data Lake Store.

Azure Data Lake Analytics is a cloud analytics service that allows you to develop and run massively parallel data transformations and processing programs in U-SQL, R, Python and .Net over petabytes of data with just a few lines of code. There is no infrastructure to manage, and you can process data on demand allowing you to scale in seconds, and only pay for the resources used. U-SQL is a simple, expressive, and super-extensible language that combines the power of C# with the simplicity of SQL. Developers can write their code either in Visual Studio or Visual Studio Code and the execution environment gives you debugging and optimization recommendations to improve performance and reduce cost.

Azure Data Lake Store is a cloud analytics data lake for enterprises that is secure, massively scalable and built to the open HDFS standard. You can store trillions of files, and single files can be greater than a petabyte in size. It provides massive throughput optimized to run big analytic jobs. It has data encryption in motion and at rest, single sign-on (SSO), multi-factor authentication and management of identities built-in through Azure Active Directory, and fine-grained POSIX-based ACLS for role-based access controls.

Azure Data Lake Petabytes of Data

Furthermore, we’ve incorporated the technology that sits behind the Microsoft Cognitive Services inside U-SQL directly. Now you can process any amount of unstructured data, e.g., text, images, and extract emotions, age, and all sorts of other cognitive features using Azure Data Lake and perform query by content. You can join emotions from image content with any other type of data you have and do incredibly powerful analytics and intelligence over it. This is what I call Big Cognition. It’s not just extracting one piece of cognitive information at a time, not just about understanding an emotion or whether there’s an object in an image, but rather it’s about joining all the extracted cognitive data with other types of data, so you can do some really powerful analytics with it. We have demonstrated this capability at Microsoft Ignite and PASS Summit, by showing a Big Cognition demo in which we used U-SQL inside Azure Data Lake Analytics to process a million images and understand what’s inside those images. You can watch this demo (starting at minute 38) and try it yourself using a sample project on GitHub.

4. DocumentDB Emulator

We live on a Planet of the Apps, and the best back-end system to build modern intelligent mobile or web apps is Azure DocumentDB – planet-scale, globally distributed managed NoSQL service, with 99.99% availability and guarantees for low latency and consistency, all of which is backed by an enterprise grade security and SLA.

Today I am happy to announce a public preview of DocumentDB Emulator which provides a local development experience for the Azure DocumentDB. Using the DocumentDB Emulator, you can develop and test your application locally without an internet connection, without creating an Azure subscription, and without incurring any costs. This has long been the most requested feature on the user voice site, so we are thrilled to roll this out to everyone.

Furthermore, we’ve added .NET Core support in DocumentDB. The .Net Core is a lightweight and modular platform to create applications and services that run on Linux, Mac and Windows. With DocumentDB support for .Net Core, developers can now use .Net Core to build cross platform applications and services that use DocumentDB API.

Planet of the Apps

5. Other Announcements

  • Today we also are announcing the General Availability of R Server for Azure HDInsightHDInsight is the only fully managed Cloud Hadoop offering that provides optimized open source analytic clusters for Spark, Hive, Map Reduce, HBase, Storm, and R Server backed by a 99.9% SLA. Running Microsoft R Server as a service on top of Apache Spark, customers can achieve unprecedented scale and performance by combining enterprise-scale analytics in R with the power of Spark. With transparently parallelized analytic functions, it’s now possible to handle up to 1000x more data with up to 50x faster speeds than open source R – helping you train more accurate models for better predictions than previously possible. Plus, because R Server is built to work with the open source R language, all of your R scripts can run without significant changes.
  • We are also announcing the public preview of Kafka for HDInsightan enterprise-grade, open-source streaming ingestion service which is cost-effective, easy to provision, manage and use. This service enables you to build real-time solutions like IoT, fraud detection, click-stream analysis, financial alerts, and social analytics. Using out-of-the-box integration with Storm for HDInsight or Spark Stream for HDInsight, you can architect powerful streaming pipelines to drive intelligent real-time actions.
  • Another exciting news is the availability of Operational Analytics for Azure SQL Database. It’s the first fully managed Hybrid Transactional and Analytical Processing (HTAP) database service in the cloud. The ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time allows developers to build a new level of analytical sophistication into their applications.  Developers can eliminate the need for ETL and a data warehouse in some cases (using one system for OLAP and OLTP, instead of creating two separate systems), helping to reduce complexity, cost, and data latency. The in-memory technologies in Azure SQL DB helps achieve phenomenal performance – e.g., 75,000 transactions per second for order processing (11X performance gain) and reduced query execution time from 15 seconds down to 0.26 (57X performance gain). This capability is now a standard feature of Azure SQL DB at no additional cost.

We are making our products and innovations more accessible to all developers – on any platform, on-premises and in the cloud. We are building for a future where our data platform is dwarfed by the aggregate value of the solutions built on top of it. This is the true measure of success of a platform – when the number and the value created by the apps built on top is far larger than the platform itself.

The live broadcast of Connect(); begins on November 16th at 9:45am EST, and continues with interactive Q&A and immersive on-demand content. Join us to learn more about these amazing innovations.


from SQL Server Blog http://ift.tt/2f0oBQL

[From Technet] SQL Server 2016 Service Pack 1 generally available

Microsoft is pleased to announce the availability of SQL Server 2016 Service Pack 1 (SP1). With SQL Server 2016 SP1, we are making key innovations more accessible to developers and organizations across all SQL Server editions, so it will be easier than ever to build advanced applications that scale across editions as your business needs grow. Developers and application partners can now build to a common programming surface across all editions when creating or upgrading intelligent applications and use the edition which scales to the application’s needs.

With SQL Server 2016 SP1, we want to make it easier than ever for developers and partners to build and upgrade applications that take advantage of advanced performance, security, and data mart capabilities.  SQL Server 2016 with Service Pack 1 also offers the most consistent platform from on-premises to cloud with industry leading TCO for applications of all sizes.  Standard edition sets the bar for rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. You can also easily upgrade to Enterprise edition for mission critical capabilities as your workload scales, without having to re-write your app. Enterprise edition continues to deliver the highest levels of mission critical scalability, availability, and performance as well as maximum virtualization through licensing rights that come with software assurance.


The capabilities in SQL Server 2016 SP1 which are now being make available to Standard edition and Express edition for the first time include:

  • Faster transaction performance from In-memory OLTP, faster query performance from In-memory ColumnStore, and the ability to combine the two for real-time Hybrid Transactional and Analytical Processing, also known as Operational Analytics;
  • Data warehousing or data mart performance features such as partitioning, compression, change data capture, database snapshot, and the ability to query across structured and unstructured data with a single node of PolyBase; and
  • The innovative security feature Always Encrypted for encryption at rest and in motion, as well as fine-grained auditing which captures more detailed audit information for your compliance reporting needs. In addition, row-level security and dynamic data masking are being made available to Express edition for the first time.

This is also exciting for customers and partners who are currently using older versions of SQL Server Standard edition, and now have more great reasons to modernize or upgrade their applications and take advantage of the new features in SQL Server 2016.

We encourage SQL Server 2016 customers to start taking advantage of the great capabilities in Service Pack 1 today. In addition to the features newly available to your application, Service Pack 1 also contains fixes released in Cumulative Updates (CUs) 1, 2 and 3 and the supportability and diagnostics improvements first introduced in SQL Server 2014 SP2. All SQL Server 2016 customers can download Service Pack 1 from the Microsoft Download Center.

If you haven’t moved to SQL Server 2016 yet, but are ready to start evaluating all the great features now available, you can create an Azure VM with SQL Server 2016 SP1. For additional details about the capabilities of SQL Server 2016, read more at http://ift.tt/AxdirB or for more information on editions, learn more See how the capabilities of SQL Server Stack up at our feature and editions comparison page. To hear more about opportunities that SQL Server 2016 SP1 create for your organization, you can reach out for additional information at this SQL Server Standard edition page.

from SQL Server Blog http://ift.tt/2ggS2D8

[From Technet] Announcing SQL Server on Linux public preview, first preview of next release of SQL Server

This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing

Today, we are excited to announce the public preview of the next release of SQL Server on Linux and Windows, which brings the power of SQL Server to both Windows – and for the first time ever – Linux.  SQL Server enables developers and organizations to build intelligent applications with industry-leading performance and security technologies using their preferred language and environment. With the next release of SQL Server, you can develop applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud.

We have seen strong reception for the private preview to date with more than 50% of Fortune 500 companies applying for the private preview.


Easy, Fast, and Efficient

We have made it easier than ever to get started with SQL Server. You’ll find native Linux installations with familiar RPM and APT packages for Red Hat Enterprise Linux and Ubuntu Linux, and packages for SUSE Linux Enterprise Server will be coming soon as well. The Windows download is available on the Technet Eval Center. Finally, the public preview on Windows and Linux is also available on Azure Virtual Machines (coming soon) and as images available on Docker Hub, offering a quick and easy installation within minutes.

SQL Server offers tremendous performance. In-Memory OLTP today delivers up to 100x faster reads and 30x faster writes. SQL Server also owns multiple top TPC-E performance benchmarks1 for transaction processing and top TPC-H performance benchmarks2 for data warehousing, as well as top performance benchmarks with leading business applications. We also recently showcased SQL Server running more than one million R predictions per second. With the next release of SQL Server, we are bringing these leading innovations to Linux. On top of this performance, SQL Server also provides incredible efficiency, and removes the need to architect the scale of your application.

Tooling on Linux

Today, we have released updated versions of our flagship SQL Server tools including SQL Server Management Studio (SSMS), Visual Studio SQL Server Data Tools (SSDT) and SQL Server PowerShell with support for the next release of SQL Server on Windows and Linux. We are also excited to announce the new SQL Server extension for Visual Studio Code that is available now on the Visual Studio Code marketplace. Developers can use the SQL Server extension for VS Code on macOS/Linux/Windows with SQL Server running anywhere (on-premises, on Linux and Windows, in any cloud, in virtual machines, Docker, SQL Server 2016 or the next release of SQL Server preview) and with Azure SQL Database and Azure SQL DW. Native command-line tools are also available for SQL Server on Linux.

The new SQL Server Migration Assistant (SSMA) 7.1 release helps you quickly convert Oracle, MySQL, Sybase, and DB2 databases to SQL Server on both Linux and Windows. Download SSMA 7.1 today for Oracle, MySQL, Sybase, DB2, and Access.

Other improvements in the next version of SQL Server

The next release of SQL Server brings the power of SQL Server to Linux. In addition, this release includes in-memory, advanced analytics, columnstore, and SQL Server Integration Services (SSIS) enhancements. For more information on what is new with this release, see What’s New in SQL Server.

Stay tuned for additional capabilities in future previews!

Get started today

Try the preview of the next release of SQL Server today! Get started with the preview of SQL Server on Linux, macOS (via Docker) and Windows with our developer tutorials that show you how to install and use SQL Server v.Next on macOS, Docker, Windows, RHEL and Ubuntu and quickly build an app in a programming language of your choice.

Learn more

Visit the Connect(); webpage to watch overview, security, high availability, and developer tools videos about SQL Server on Linux on-demand, watch the Microsoft Mechanics video to see how to get started in under one minute, and go to the next release of SQL Server webpage to get started with interactive SQL Server on Linux hands on labs for Linux administrators new to SQL Server and for existing SQL Server database administrators new to Linux, and read detailed documentation. Sign up to stay informed about new SQL Server on Linux developments.

Stay tuned for additional SQL Server Blog posts in the coming weeks, including SQL Server high availability, security, connectors, and developer tools on Linux!

1 http://ift.tt/2fgSAVm

2 http://ift.tt/1muMLB0

from SQL Server Blog http://ift.tt/2f0pQiL