quinta-feira, 16 de novembro de 2017

[From Technet] SQL Server 2017: A proven leader in database performance

This post was authored by Bob Ward, Principal Architect, and Jamie Reding, Senior Program Manager and Performance Architect, Microsoft Database Systems Group.

SQL Server continues to be a proven leader in database performance for both analytic and OLTP workloads. SQL Server 2017 is fast, built-in with capabilities and features such as Columnstore indexes to accelerate analytic performance and Automatic Tuning and Adaptive Query Processing to keep your database application at peak speed.

Recently, Hewlett Packard Enterprise (HPE) announced a new world record TPC-H 10TB benchmark result¹ using SQL Server 2017 and Windows Server 2016 on their new DL580 Gen10 Server. This new amazing result at 1,479,748 Composite Query-per-Hour (QphH) was achieved at price/performance of .95 USD per QphH continuing to show SQL Server’s leadership in price and performance.

HPE also announced the first TPC-H 3TB result² on a 2-socket system using SQL Server 2017 and Windows Server 2016 with their DL380 Gen Server. They achieved a stellar 1,014,374 QphH on only 2-sockets. These results continue to show how powerful SQL Server can be to handle your analytic query workloads including data warehouses.

SQL Server also is a proven leader for OLTP workloads. Lenovo recently announced a new world-record TPC-E benchmark result³ using SQL Server 2017 and Windows Server 2016. This is now the #1 TPC-E result in both performance at 11,357 tpsE and price/performance at 98.83 USD per tpsE for systems with 4 sockets or more. This result was achieved on Lenovo’s ThinkSystem SR950 server using 4 sockets at 112 cores which represents a 25% performance gain from the previous 4 socket result with 16% more cores.

SQL Server 2017 is the world leader in TPC-E and TPC-H performance, price, and value and continues to demonstrate it is one of the fastest databases on the planet, in your cloud or ours.


  • ¹ 10TB TPC-H non-clustered result as of November 9th, 2017.
  • ² 3TB TPC-H non-clustered result as of November 9th, 2017.
  • ³ TPC-E benchmark result as of November 9th, 2017.

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

quarta-feira, 15 de novembro de 2017

[From Technet] Announcing SQL Operations Studio for preview

We are excited to announce that SQL Operations Studio is now available in preview. SQL Operations Studio is a free, light-weight tool for modern database development and operations for SQL Server on Windows, Linux and Docker, Azure SQL Database and Azure SQL Data Warehouse on Windows, Mac or Linux machines.

Download SQL Operations Studio to get started.


It’s easy to connect to Microsoft SQL Server with SQL Operations Studio and perform routine database operations—overall lowering the learning curve for non-professional database administrators who have responsibility for maintaining their organization’s SQL-based data assets.

As more organizations adopt DevOps for application lifecycle management, developers and other non-professional database administrators find themselves taking responsibility for developing and operating databases. These individuals often do not have time to learn the intricacies of their database environment, making hard to perform even the most routine tasks. Microsoft SQL Operations Studio takes a prescriptive approach to performing routine tasks, allowing users to get tasks done fast while continuing to learn on the job.

Users can leverage their favorite command line tools (e.g. Bash, PowerShell, sqlcmd, bcp and ssh) in the integrated terminal window right within the SQL Operations Studio user interface. They can easily generate and execute CREATE and INSERT scripts for SQL database objects to create copies of their database for development or testing purposes. Database developers can increase their productivity with smart T-SQL code snippets and rich graphical experiences to create new databases and database objects (such as tables, views, stored procedures, users, logins, roles, etc.) or to update existing database objects. They also have the ability to create rich customizable dashboards to monitor and quickly detect performance bottlenecks in your SQL databases on-premises or in Azure.


SQL Operations Studio comes at an opportune time for users who use clients running macOS or Linux. Many users who use or plan to deploy SQL Server 2017, which became generally available in September 2017, also use Macs as their clients. They will now be able to use a free database development and operations tool from Microsoft that runs natively on their OS of choice.

SQL Operations Studio has been forked from Visual Studio Code with the objective to make it highly extensible. It’s built on an extensible microservices architecture and includes the SQL tools service built on .NET Core. Users will be able to download it from GitHub or Microsoft.

We hope you love this new tool.  It’s received great reviews from the community testing it in private beta and, with your feedback, we can make it even better. Join us in improving SQL Operations Studio by contributing directly at the GitHub repo.

If you have questions or would like to add comments, please use the comments section below. We would love to hear from you!

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

[From Technet] SQL Server 2017 Features Bring ‘Choice’ to Developers

Data is everywhere today: in the cloud, on premises, and everywhere in between, tied up in systems of nearly endless complexity. Microsoft solutions allow developers to innovate while also scaling and growing their data infrastructure. In SQL Server 2016 SP1, SQL Server made available a consistent programmable surface layer for all its editions, making it easy to write applications that target any edition of the database.  This year’s release takes it a step further with native support for Linux and Docker.

Microsoft puts the needs of the developer front and center in its data solutions. We have created the most advanced set of tools to radically lower the barriers to getting data – of any type, from anywhere – into the application design and build process. Today with the preview of Microsoft SQL Operations Studio, you can now access, run and manage this data from the system of your choice, on Windows, Linux and Docker.

Committed to choice for both database platform and tools

SQL Server 2017 also makes it easier to drive innovation via a CI/CD pipeline with the support of Docker containers.  Since the Community Technology Preview of SQL Server 2017, there have been over 2 million Docker pulls.  You can use any container orchestration layer, as SQL Server 2017 effectively becomes an application component within your compiled code hosted in the container.  It is light weight and very fast to install – SQL Server on Linux installs in less than a minute.  As a result, you can update the entire software stack with each check-in and deployment. Learn more on DevOps using SQL Server.

There are also SQL Server client drivers for the major languages, including C#, Java, PHP, Node.js, Python, Ruby and C++. Any language that supports ODBC data sources should be able to use the ODBC drivers.  And any language based on the JVM should be able to use the JDBC or ODBC drivers. Choose any of the above languages to trial at our new hands-on labs.

In the spirit of choice, the data tools team today released SQL Operations Studio for public preview (see below). It is a light weight, cross-platform database development and operations tool designed to help non-database professionals with routine tasks necessary to update and maintain a database environment. It’s based on .NET Core and forks from Visual Studio Code, making it extremely extensible and easy to use. Download it, try it out, and please give us feedback via GitHub issues!


R + Python built-in for in-database analytics

The confluence of cloud, data and AI is driving unprecedented change. The ability to manage and manipulate data and to turn it into breakthrough actions and experiences, is foundational to innovation today. We view data as the catalyst to augment the human ingenuity, removing friction and driving innovation. We want to enable people to change and adapt quickly. Most of all, we want to equip today’s innovators and leaders to turn data into the insights and applications that will improve our world.

Developers and data scientists who explore and analyze data also have several new options.  Now that SQL Server 2017 on Windows supports R and Python natively, they can either write R or Python scripts in the text editor of choice, or they can embed their scripts directly into their SQL query in SQL Server Management Studio. See example below:


Or if the analysis calls for highly complex joins, SQL Server 2017 also supports graph-based analytics, making it possible to describe nodes and edges within a SQL query. See example below:





CREATE TABLE located_at(address varchar(100)) AS EDGE;



In-memory + performance for blazing-fast applications

And we mentioned, choice does not need to sacrifice performance!  SQL Server 2017 also has some great performance enhancing features, including adaptive query processing (AQP) and automatic plan correction (APC).  AQP uses Adaptive Memory Grants in SQL Server to track and learn how much memory is used by a given query to right-size memory grants.  While APC ensures continuous performance by finding and fixing performance regressions.  Customers have been highly favorable of these features, including dv01 who switched off their OSS stack on AWS to move everything to their stack run on SQL Server.

In-Memory OLTP is the premier technology available in SQL Server and Azure SQL Database for optimizing performance of transaction processing, data ingestion, data load, and transient data scenarios.  Expect to see a 30x-100x increase in performance by keeping tables in-memory and using natively compiled queries.

A couple of steps to consider if you’re going to use In-Memory OLTP:

1. Recommended to set the database to the latest compatibility level, particularly for In-Memory OLTP:


2. When a transaction involves both a disk-based table and a memory-optimized table, it’s essential that the memory-optimized portion of the transaction operates at the transaction isolation level named SNAPSHOT:


3. Before you can create a memory-optimized table, you must first create a memory-optimized FILEGROUP and a container for data files:

ALTER DATABASE AdventureWorks ADD FILEGROUP AdventureWorks_mod CONTAINS memory_optimized_data
ALTER DATABASE AdventureWorks ADD FILE (NAME='AdventureWorks_mod', FILENAME='c:\var\opt\mssql\data\AdventureWorks_mod') TO FILEGROUP AdventureWorks_mod

Security built-in at every level

Every edition of SQL Server provides a robust set of features designed to keep organizational data separate, secure, and safe. Two of the most interesting security features for developers are Always Encrypted and Row-Level Security.

Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national identification numbers (social security numbers), stored in Azure SQL Database or SQL Server databases. Always Encrypted allows customers to encrypt sensitive data inside their applications and never reveal the encryption keys to the Database Engine (SQL Database or SQL Server). The driver encrypts the data in sensitive columns before passing the data to the Database Engine, and automatically rewrites queries so that the semantics to the application are preserved. Similarly, the driver transparently decrypts data, stored in encrypted database columns, contained in query results. See the graphic below:

Row-Level Security (RLS) enables customers to control access to rows in a database table based on the characteristics of the user executing a query (for example, group membership or execution context).

Row-Level Security simplifies the design and coding of security in an application. Row-Level Security enables organizations to implement restrictions on data row access. For example, an organization can ensure that employees can access only those data rows that are pertinent to their department, or restrict a customer’s data access to only the data relevant to their company.

To configure Row-Level Security, follow the steps below:

1. Create user accounts to test Row-Level Security

USE AdventureWorks2014; 

2. Grant read access to users on required table

GRANT SELECT ON Sales.SalesOrderHeader TO Manager; 
GRANT SELECT ON Sales.SalesOrderHeader TO SalesPerson280;

3. Create a new schema and inline table-valued function

CREATE FUNCTION Security.fn_securitypredicate(@SalesPersonID AS int) 
 RETURN SELECT 1 AS fn_securitypredicate_result WHERE ('SalesPerson' + CAST(@SalesPersonId as VARCHAR(16)) = USER_NAME()) 
 OR (USER_NAME() = 'Manager');

4. Create a security policy adding the function as both a filter and block predicate on the table

ADD FILTER PREDICATE Security.fn_securitypredicate(SalesPersonID) 
 ON Sales.SalesOrderHeader, 
ADD BLOCK PREDICATE Security.fn_securitypredicate(SalesPersonID) 
 ON Sales.SalesOrderHeader 

5. Execute the query to the required table as each user to see the result (can also alter the security policy to disable policy)

Thanks for joining us on this journey to SQL Server 2017. We hope you love it! Going forward, we will continue to invest in our cloud-first development model, to ensure that the pace of innovation stays fast, and that we can bring you even more and improved SQL Server features soon.

Here are a few links to get started:

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

sexta-feira, 3 de novembro de 2017

[From Technet] Three years in a row – Microsoft is a leader in the ODBMS Magic Quadrant

We’re happy to report that Gartner has positioned Microsoft in the Leaders Quadrant in the 2017 Magic Quadrant for Operational Database Management Systems again this year. This is the third year that Microsoft has been positioned farthest in completeness of vision and ability to execute in the operational database management systems market.

At Microsoft, we’re dedicated to helping both enterprises and individuals realize their full potential. Our industry position in Operational DBMS is due to the unequaled capabilities of SQL Server.

The release of SQL Server 2017 brings the power of SQL Server to Windows, Linux, and Docker containers for the first time ever. Developers are able to build intelligent applications using preferred languages and environments, while enjoying in-memory performance across workloads, mission-critical high availability, and in-database advanced analytics. You can develop once and deploy anywhere in a consistent experience across your datacenter and public cloud.

SQL Server proves itself, year over year, to be the least vulnerable DBMS in the industry. Built for security from the ground up, SQL Server offers customers a layered protection approach that incorporates encryption, authentication, and monitoring and auditing at the disk, database, and application levels. Innovative security technologies like Always Encrypted, for encryption at rest and in motion, help transform global operations for the better.

Perhaps most noteworthy for organizations living in the real world of cost-benefit analyses, SQL Server 2017 remains one of the most cost-competitive DBMS offerings in the enterprise space. In fact, you can get all the robust business capabilities in SQL Server 2017 built-in to a single product SKU, without expensive add-ons — for one great, low total cost of ownership.

But don’t just take our word for it. We encourage you to take the time to read the full Gartner report.

And then take a moment to see how you can get free licenses when you migrate to SQL Server 2017. We’re confident you’ll find the industry-leading database you know and love — now across operating systems and application platforms, on-premises and in the cloud.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner’s research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner complete document is available now. 

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

quarta-feira, 1 de novembro de 2017

[From Technet] SQL Server 2017 and Azure Data Services – The ultimate hybrid data platform

This post was authored by Rohan Kumar, General Manager Database Systems Engineering.

Today at PASS Summit 2017, we are showcasing new advances across SQL Server 2017 and our Azure data services. And we’re demonstrating how these products – both on-premises and in the cloud – come together to form the ultimate hybrid data platform. Our recent announcements, here at PASS Summit and at Ignite in September are great examples of how we’re empowering data professionals – like our community here at PASS Summit 2017 – to do more and achieve more.

With the recent launch of SQL Server 2017, the first database with AI built-in, you can now run your production workloads on Linux, Windows, and Docker. SQL Server 2017 delivers a mission-critical database with everything built-in, on the platform of your choice. And, it can unlock seamless DevOps with Docker Enterprise Edition containers, bringing efficiency and simplicity to your innovation. New features enable analysis of graph data, and advanced analytics using Python and R. We have incorporated your feedback to add features that will make your day-to-day job easier like Adaptive Query Processing and Automatic Plan Correction by finding and fixing performance regressions automatically.

In addition, SQL Server 2017 running on Windows and Linux can take advantage of new leaps forward in hardware. As demonstrated today by Bob Ward, SQL Server 2017 on SUSE Enterprise Linux Server on an HPE ProLiant DL380 Gen 10 Server with scalable persistent memory ran queries more than 5 times faster than a fast SSD drive array at 50% of the cost – making it the world’s first enterprise-grade diskless database server.

These new cross-platform capabilities have made SQL Server accessible to users of Windows, Linux and Mac. At PASS Summit, we are excited to provide a sneak peek at Microsoft SQL Operations Studio. In a few weeks, users will be able to download and evaluate this free, light-weight tool for modern database development and operations on Windows, Mac or Linux machines for SQL Server, Azure SQL Database, and Azure SQL Data Warehouse. Increase your productivity with smart T-SQL code snippets and customizable dashboards to monitor and quickly detect performance bottlenecks in your SQL databases on-premises or in Azure. You’ll be able to leverage your favorite command line tools like Bash, PowerShell, sqlcmd, bcp and ssh in the Integrated Terminal window. Users can contribute directly to SQL Operations Studio via pull requests from the GitHub repository.

For customers who are ready to modernize to the cloud, Azure SQL Database Managed Instance and Azure Database Migration Service, both now in private preview, making it easy to lift-and-shift your on-premises SQL Server workloads with few or no changes. The upcoming Azure Hybrid Benefit for SQL Server enables customers to use on-premises SQL Server licenses for the easiest lift and shift of SQL Server workloads to the fully-managed cloud.

Azure SQL Database is ready for your most mission-critical workloads. Today, we demonstrated the high scale and performance of SQL Database, with the ability to insert 1.4 million rows per second. In addition, we are making it easier than ever to gain insights from data at this scale. We recently made generally available, the ability to run advanced analytics models from Azure Machine Learning super-fast from T-SQL, with new Native T-SQL scoring. And in today’s demos, we show how you can use this new capability to score large amounts of data in real time – at an average of under 20ms per row!

Starting in early 2016, we have been delivering machine-learning based customer value directly into the Azure SQL Database managed service. More recently, we’ve delivered several intelligent capabilities including automatic tuning, performance monitoring and tuning, Adaptive Query Processing, and Threat Detection. These capabilities significantly reduce time requires to manage anywhere from one to thousands of databases and help proactively defend against potential threats. And the preview Vulnerability Assessment feature helps you more easily understand your security and compliance with new initiatives like GDPR.

In addition to sharing the same “everything built-in” SKU model with SQL Server for lower total cost of ownership versus competitors, Azure SQL Database adds value to your database with these built-in administration features. Now it’s easier than ever to move to Azure SQL Database with our new partnership with Attunity. Customers can now take advantage of Attunity Replicate for Microsoft Migrations, a free offer that accelerates migrations from various database systems, including Oracle, Amazon Redshift, and PostgreSQL to the Microsoft Data Platform.

To simplify analytics in the cloud, we’re releasing a public preview of new hybrid data integration capabilities in Azure Data Factory including the ability to run SSIS packages within the service. This means you can run your SSIS data integration workloads in Azure, without changing the packages – for true hybrid data integration across on-premises and cloud. And our SSIS partner technologies like Biml can now work to automate and enhance data integration across on-premises and cloud.

Dramatic scale investments are now in public preview for Azure SQL Data Warehouse. With the new Compute-Optimized Tier, you can get up to 100x the performance and 5x the scale. This new tier builds on the existing optimized for elasticity tier – giving customers the benefit of a fully-managed platform that suits the demands of their workload.

Visualizing data helps users across the organization take informed action. Microsoft delivers Business Intelligence capabilities to help customers model, analyze, and deliver business insights, which can be consumed by business users on mobile devices, on the web or embedded in applications.

Analysis Services helps you transform complex data into semantic models making it easy for business users to understand and analyze large amounts of data across different data sources. The same enterprise-grade SQL Server Analysis Services you’ve used on-premises is also available as a fully managed service in Azure. With today’s announcement of the Scale Out feature for Azure Analysis Services, you can easily set the number of replicas for your Azure Analysis Services instances to support large numbers of concurrent users with blazing fast query performance.

Power BI is a market leading SaaS service that is easy to get started and simple to use, with data connections to many on-premises and cloud data sources. It allows users across roles and industries to go from data to insights in minutes. A recent key addition to the Power BI portfolio is Power BI Report Server. Power BI Report Server enables self-service BI and enterprise reporting, all in one on-premises solution by allowing you to manage your SQL Server Reporting Services (SSRS) reports alongside your Power BI reports. Today we announce the availability of a new version of Power BI Report Server that will enable keeping Power BI reports on-premises that connect to any data! Read more on the Power BI blog.

Microsoft’s guiding principle has been to build the highest performing, most secure, and consistent data platform for all your applications across on-premises and cloud. By joining us on this journey, you can build upon your investments in SQL Server to expand the scope of your role in your organization, from database systems to advanced analytics and artificial intelligence. We look forward to working with you!

If you aren’t with us at PASS Summit 2017 this week, you can still see the announcements and demonstrations by purchasing session recordings to stream or download and watch at home. Sign up at the PASS Summit Website.

If you’d like to learn more about the latest enhancements in the Microsoft Data Platform, visit our data platform webpage, or data platform overview on Azure.

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

segunda-feira, 30 de outubro de 2017

[From Technet] Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote

PASS Summit 2017 takes place from November 1 to November 3, in Seattle, Washington at the Washington State Convention Center. This year’s event guarantees to be an exciting time to reconnect with the community, see friends old and new, and learn about new product features and enhancements. Microsoft would like to invite you to join us for the Day 1 Keynote by Rohan Kumar, which takes place on Wednesday, November 1, at 8:30 AM.

Rohan and the Microsoft Data and AI engineering teams will highlight how our customers and community have shaped the latest products and feature enhancements — many of them based on your feedback. This continuous innovation loop is how we have accelerated innovation across our products and services. But the process doesn’t focus on code, it focuses on you and your requirements. Product telemetry, technology blogs, PASS meetups, all the time and anyway we can, we want to listen to what you have to say.

The keynote will be jam-packed with practical demonstrations, giving you a chance to see your feature requests in action. In fact, there are so many great announcements and demos coming that we made a list of the Top five reasons to join us for the PASS Summit 2017 Day 1 Keynote:

  1. Accelerate performance – Bob Ward will demonstrate the super fast performance that SQL Server 2017 can achieve, while Conor Cunningham will talk about why performance tuning doesn’t have to be manual drudgery anymore.
  2. Get started with Dev Ops – Tobias Ternstrom and Mihaela Blendea will show you quick and painless new ways to set up a development environment, made possible by SQL Server 2017 support for Windows and Linux containers.
  3. Create powerful insights in real time – Danielle Dean will demonstrate how high performance and scale in Azure SQL Database can combine with built-in AI to create new and powerful insights from IOT data.
  4. Conquer analytics at scale Community member Scott Currie, CEO of Varigence, will show you how the latest version of Azure Data Factory can combine with partner technologies like BIML to automate data movement in the cloud. Julie Strauss will show off incredible analytics performance gains made possible by the new compute-optimized tier in Azure SQL Data Warehouse.
  5. Leverage business intelligence across on-premises and cloud – Christian Wade will demonstrate fast, interactive analysis over large amounts of data in Analysis Services, on-premises and in the cloud. And Riccardo Muti will showcase new features in Power BI Premium that can bring interactive reports and queries and stunning visualizations to your users, wherever your data lives.

That was just a taste of the demos that we hope will surprise you, please you, and make your life just that much easier when you take your new knowledge back to work next week. Registration for this event is almost full, but there are still a few passes left. Or, you can purchase session recordings to stream or download and watch at home. Sign up at the PASS Summit Website.

If you’d like to learn more about the latest enhancements in the Microsoft Data Platform, visit our data platform webpage, or data platform overview on Azure.

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

[From Technet] Modernize your applications across on-premise and cloud with the Microsoft Data Accelerator Program

Your customers are demanding the latest innovations in every solution you deliver. How do you make sure that your apps meet — and exceed — your customers’ expectations? Leverage the Microsoft Data Accelerator Program, an efficient and reliable upgrade service, to modernize your on-premise or cloud applications. This year, we have expanded the program to support the scenarios below.

Modernize to SQL Server 2017 to begin your journey to cloud

With SQL Server 2017, now on Windows, Linux, and Docker containers, you can build modern applications using the language of your choice, on-premises or in the cloud. SQL Server 2017 offers tremendous performance features for your mission-critical, intelligence, and data warehouse applications. In-Memory OLTP delivers up to 30x faster transaction processing and columnstore indexes deliver up to 100x faster analytical processing. In addition to these features, SQL Server also owns the top TPC-H performance benchmarks for data warehouse.¹ With SQL Server 2017, you can inject intelligence into your applications with transformative insights and real-time analytics at up to one million R predictions per second.² Leverage these latest enhancements while protecting your application data with the least-vulnerable database over the last seven years.³

Modernize on-premises SQL Server or Oracle apps to Azure SQL Database

Seamlessly transform your on-premises apps to SaaS solutions at a cost-effective scale, with flexible performance and unmatched PaaS capabilities, using Azure SQL Database. Azure SQL Database is a fully-managed relational database-as-a-service that you can use to build data-driven applications in the programming language of your choice. It includes features like provisioning and resizing, built-in high availability (HA), automatic backup, point-in-time-restore, and active geo-replication. In addition to the benefits of PaaS, Azure SQL Database also includes built-in intelligence that helps you dramatically reduce the costs of running and managing databases and maximizes both the performance and security of your applications.

Leverage open source investments by modernizing on-premises apps to Azure SQL Database for MySQL and PostgreSQL

Microsoft Azure is the first-class cloud platform for open source technology that empowers you to bring the tools you love, along with the skills you already have, to build and deploy any application. With Azure Database for MySQL and Azure Database for PostgreSQL, you can now choose your favorite database engine delivered as a fully-managed service with high-availability and dynamic scalability. These services bring the community version of PostgreSQL and MySQL to the cloud, and seamlessly integrate with most common open source programming languages (such as PHP, Python, and Node.js) and application development frameworks (such as WordPress, Magento, Drupal, Django, and Ruby on Rails). If you want to quickly build and deploy a new app, you can now take advantage of managed service capabilities offered by Azure while continuing to use the familiar community tools with your MySQL or PostgreSQL databases.

Lift and shift on-premises SQL Server apps to the cloud with Azure SQL Database Managed Instance

SQL Database Managed Instance is an expansion of the existing Azure SQL Database service designed to quickly and easily move your SQL apps to a fully-managed PaaS, without re-designing your application. Azure SQL Database Managed Instance provides high compatibility with on-premises SQL Server programming model and out-of-box support and tools to manage data and enable new scenarios in the cloud for your applications. This includes features like SQL CLR, SQL Server Agent, and cross-database querying. Using a fully-managed PaaS database frees your IT overhead, dramatically reducing operational costs and redirecting resources to more value-add activities. Azure SQL Database Managed Instance is scheduled to be available for public preview later this fall.

Apply to our Microsoft Data Accelerator program to upgrade your on-premises applications or begin the journey to migrate them to the cloud. The Microsoft Data Accelerator provides access to highly reliable, automated upgrade services for the four scenarios highlighted above. Backed by the rich experience of upgrading thousands of applications, Microsoft Data Accelerator enables you to modernize your applications and provide a broader range of platform choices to your customers.

Learn more and apply for the Microsoft Data Accelerator Program.


¹via www.tpc.org
²via www.tpc.org
³According to the National Institute of Standards and Technology, SQL Server has had the fewest security vulnerabilities over the past seven years when compared with other major database vendors.

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

segunda-feira, 23 de outubro de 2017

[From Technet] Ask the team that built SQL Server 2017 anything on October 25, 2017

Hi! We’re Travis Wright and Tobias Ternstrom from the Microsoft SQL Server engineering team and we along with other members of the team are hosting a Reddit Ask Me Anything session on /r/Database, Wednesday, October 25, 2017, from 10:00 am to 11:30am PDT.

Why are we doing an AMA?

SQL Server 2017 was made generally available on October 2, on Windows, Linux and Docker containers. With this release, customers have an even wider choice of development languages, data types, and operating systems. We’re excited to connect with you on Reddit to tell you more about our experiences bringing it to market and answering your questions!

We’re also getting ready to join thousands of data professionals in Seattle from October 31 – November 3rd at the PASS Summit 2017. We look forward to this gathering every year. If you’re attending or planning to watch online, this AMA is a great time to catch up beforehand.

Join us! We’re looking forward to having a conversation with you.

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

terça-feira, 10 de outubro de 2017

[From Technet] What’s new in SQL Server Management Studio 17.3

This post was authored by Alan Yu, Program Manager, Microsoft SQL Server

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

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

SSMS 17.3 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.3 comes with two new exciting features:

  • Import Flat File Wizard
  • XEvent Profiler

Import Flat File Wizard

The Import Flat File Wizard streamlines the import experience of flat files (.csv, .txt) with an intelligent framework, requiring minimal user intervention or specialized domain knowledge.

A common task for a user is to import a flat file to a SQL table. The existing SSMS Import Data wizard provides a much broader set of import capabilities and configuration for defining SQL Server Integration Services packages. This can be useful in many cases, but for the simple task of importing a flat file into a table, a more streamlined experience is desirable. There is a need for a tool or technology that simplifies the import experience by reducing the amount of user configuration required to properly import complex flat file structures.

New import technology

To address this need, we are using the Microsoft Program Synthesis using Examples (PROSE) SDK. This SDK allows us to take raw semi-structured data and identify patterns in it to perform predictive file splitting, helping the wizard “learn” the structure of a flat file to infer column names, types, delimiters, and more.

This simplifies the import flat file experience by requiring the user to only provide an input file and unique file name, and the wizard takes care of the rest.

Try it now

Try the Import Flat File Wizard yourself by following a step-by-step tutorial.

XEvent Profiler

The XEvent Profiler is an easy to launch and customizable SSMS feature that quickly displays a live target view of extended events.

In SSMS, the existing extended events functionality already provides a flexible definition of sessions and views, but lacks the “quick view” capability of SQL Profiler. XEvent Profiler generates that view just as fast as SQL Profiler, while also allowing for view customization that can be shared with other SSMS users as a *.viewsettings file.

The diagram below illustrates how quick it is to view extended events in your database.

Try it now

Try the XEvent Profiler yourself by following a step-by-step tutorial.

We challenge you to try out this new feature over SQL Server Profiler. If there are any gaps that require you to use SQL Server Profiler over XEvent Profiler, feel free to comment on this blog. We hope to fill those gaps in future releases.

Contact us

We are open to any questions, feedback, or any feature suggestions for future releases. Please contact us using our form, or tweet to our team’s engineering manager @sqltoolsguy.


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

[From Technet] Webinar: Get enterprise-grade features at open-source prices with SQL Server 2017 on Linux

IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of both. By taking advantage of SQL Server 2017 on Linux, you’ll get enterprise-grade features at open-source pricing — all backed by Microsoft support and security. It’s never been easier or more cost effective to make the move.

SQL Server 2017 combines the best of databases and analytics into one product. New enhancements include real-time intelligence due to faster transactions with In-Memory OLTP, new T-SQL enhancements for in-memory tables and natively compiled stored procedures, ColumnStore performance improvements, and support for LOBS.

Join our speakers Debbi Lyons, Sr. Product Marketing Manager and Travis Wright, Principal Program Manager for a webinar on how SQL Server 2017 on Linux provides intelligence on a trusted, industry-leading platform while enabling innovation for all your data.

In this live webinar and Q&A, you’ll learn:

  • What’s new with SQL Server 2017 on Linux and the benefits of building your next Linux project with SQL Server.
  • How to leverage Microsoft’s offer to get a discounted subscription rate.
  • Quick and easy ways to get started with SQL Server 2017, and our suite of free tools available.

Join us Thursday, October 12, 2017, at 9:00 AM Pacific Time (UTC-7). Register now for this webinar on how your data ecosystem can benefit from SQL Server 2017 on Linux.

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