quinta-feira, 21 de setembro de 2017

[From Technet] SQL Server PolyBase supports Hadoop.rpc.protection

This post was authored by Casey Karst; Program Manager II; Data Systems.

We are pleased to announce that PolyBase in SQL Server 2016 and later can connect to Hadoop clusters with the hadoop.rpc.protection configuration set to Integrity, Privacy or Authentication. By default, PolyBase uses the Authentication setting, but to connect to more secure Hadoop clusters Integrity or Privacy are needed.

Supporting this configuration allows PolyBase to connect and query Hadoop clusters that have wire encryption turned on. This enables a secure connection between Hadoop and SQL Server; as well as, among the Hadoop Data Nodes.

To connect to a Hadoop cluster with the hadoop.rpc.protection set to privacy or integrity, you will need to alter the core-site.xml file that is installed with PolyBase. This file is generally found at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\Polybase\Hadoop\conf.

In order to use the new configuration, you will need to add a new property with the name hadoop.rpc.protection and a value of either privacy or integrity. These values must match the hadoop.rpc.protection configuration on your Hadoop cluster.



Note: When changing XML files, please ensure that you input the correct values and maintain the validity of the XML file format. If the changes are invalid, PolyBase will not run.

This functionality is available in all SQL Server installations that currently have PolyBase installed. No update is required. This functionality is not available in Azure SQL Data Warehouse, Azure SQL Database, or Analytics Platform System.

For more information, please visit documentation on PolyBase Configuration.

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

quinta-feira, 31 de agosto de 2017

[From Technet] Six reasons to consider SQL Server 2017—especially if you’re on Linux

“Data is currency” is the rule of thumb in business. As with money, business data must be accessible, accurate, and usable across disparate contexts if an organization is to realize greater ROI while keeping costs under control. CIOs understand that the need to manage data—its location, composition, and utility—is as important as managing a balance sheet. For many companies, the solution is SQL Server, the industry gold standard for database management.

But what about the many tech startups and cloud enterprises running open-source platforms? These organizations face challenges with reliably integrating, categorizing, and accessing all types of business data in an often-heterogeneous world of platforms, apps, and devices.

The good news is SQL Server 2017 runs on Linux. Two Linux-based organizations, Convergent Computing and dv01, migrated to SQL Server 2017 for the capabilities and tools to manage and optimize their data “currency.” They share their stories in the new e-book, SQL Server 2017 on Linux: Top Six Reasons Companies Make the Move.

In the e-book, leadership at Convergent and dv01 cover the benefits they gained with SQL on Linux, including:

  • Flexibility. Use familiar languages on the platform and cloud of your choice.
  • Performance. Take advantage of faster queries with simultaneous analytics and transaction processing.
  • Security. Protect your data at rest and in motion with centrally managed, Always Encrypted protection.
  • Cost. Expand your hardware options and achieve ROI more quickly with Linux.
  • Simplicity. Migrate without the complexity of advanced customizations or third-party solutions.
  • Everything built in. Reduce TCO with all the enterprise-level features you need.

Download the free e-book to see how SQL Server 2017 can help your organization protect and optimize its data.

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

segunda-feira, 21 de agosto de 2017

[From Technet] Now available in India: Azure Database for MySQL and Azure Database for PostgreSQL

We recently announced public preview availability of Azure Database for PostgreSQL and MySQL in West and Central India. PostgreSQL and MySQL are ubiquitous names in the world of open source relational databases, as these database engines have been widely embraced by developers in recent years. Microsoft’s Azure cloud is a first-class platform for open source technology that allows you to bring the tools you love, along with the skills you already have, and deploy any application. The availability of Azure Database for MySQL and PostgreSQL services in India provides app developers the ability to choose from a wider number of geographies and deploy their favorite database on Azure — without the complexity of managing and administering the databases.

Learn more about the new availability of Azure Database for MySQL and Azure Database for PostgreSQL in our recent post on the Azure blog.

You can create an Azure Database for MySQL by following the steps mentioned in MySQL documentation, and you can create an Azure Database for PostgreSQL by following the steps outlined in PostgreSQL documentation. As you can see from the screenshots below, the “Location” drop-down now allows you to select India as a region!

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

quarta-feira, 2 de agosto de 2017

[From Technet] SQL Server 2017 Release Candidate 2 (RC2) is now available

Microsoft is pleased to announce availability of SQL Server 2017 Release Candidate 2 (RC2), which is now available for download.

The release candidate represents an important milestone for SQL Server.  Development of the new version of SQL Server along most dimensions needed to bring the industry-leading performance and security of SQL Server to Windows, Linux, and Docker containers is complete.  We are continuing to work on performance and stress testing of SQL Server 2017 to get it ready for your most demanding Tier 1 workloads, as well as some final bug fixes.

We invite you to test out RC2 today, and to let us know how it’s working for you.  If you have questions, you can join the discussion of SQL Server 2017 at MSDN. If you run into an issue or would like to make a suggestion, you can let us know through Connect. We look forward to hearing from you!

Get started with SQL Server 2017 RC2 today!

Try the release candidate of the SQL Server 2017 today! Get started with our updated developer tutorials that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice. For more ways to get started, try the following:

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

segunda-feira, 31 de julho de 2017

Divulgação dos cursos de graduação do SENAI/SC - 2017

Divulgação dos cursos de graduação do SENAI/SC - 2017

Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06

terça-feira, 18 de julho de 2017

[From Technet] Microsoft Drivers v4.3.0 for PHP for SQL Server released!

This post was authored by Meet Bhagdev, Program Manager, Microsoft

Hi all,

We are excited to announce the Production Ready release for the Microsoft Drivers v4.3.0 for PHP for SQL Server. The drivers now support Debian Jessie and macOS. The driver enables access to SQL Server, Azure SQL Database, and Azure SQL DW from any PHP application on Linux, Windows, and macOS.

Notable items for the release:



  • Fixed the assertion error (Linux) when fetching data from a binary column using the binary encoding (issue #226)
  • Fixed PECL installation errors when PHP was installed from source (issue #213)
  • Fixed issue output parameters bound to empty string (issue #182)
  • Fixed a memory leak in closing connection resources
  • Fixed load ordering issue in MacOS (issue #417)
  • Fixed the issue with driver loading order in macOS
  • Fixed null returned when an empty string is set to an output parameter (issue #308)
  • SQLSRV only
    • Fixed sqlsrv client buffer size to only allow positive integers (issue #228)
    • Fixed sqlsrv_num_rows() when the client buffered result is null (issue #330)
    • Fixed issues with sqlsrv_has_rows() to prevent it from moving statement cursor (issue #37)
    • Fixed conversion warnings because of some const chars (issue #332)
    • Fixed debug abort error when building the driver in debug mode with PHP 7.1
    • Fixed string truncation when binding varchar(max), nvarchar(max), varbinary(max), and xml types (issue #231)
    • Fixed fatal error when fetching empty nvarchar (issue #69)
    • Fixed fatal error when calling sqlsrv_fetch() with an out of bound offset for SQLSRV_SCROLL_ABSOLUTE (issue #223)
  • PDO_SQLSRV only
    • Fixed issue with SQLSRV_ATTR_FETCHES_NUMERIC_TYPE when column return type is set on statement (issue #173)
    • Improved performance by implementing a cache to store column SQL types and display sizes (issue #189)
    • Fixed segmentation fault with PDOStatement::getColumnMeta() when the supplied column index is out of range (issue #224)
    • Fixed issue with the unsupported attribute PDO::ATTR_PERSISTENT in connection (issue #65)
    • Fixed the issue with executing DELETE operation on a nonexistent value (issue #336)
    • Fixed incorrectly binding of unicode parameter when emulate prepare is on and the encoding is set at the statement level (issue #92)
    • Fixed binary column binding when emulate prepare is on (issue #140)
    • Fixed wrong value returned when fetching varbinary value on Linux (issue #270)
    • Fixed binary data not returned when the column is bound by name (issue #35)
    • Fixed exception thrown on closeCursor() when the statement has not been executed (issue #267)


  • No support for input/output parameters when using sql_variant type

Known issue

  • When pooling is enabled in Linux or macOS
    • unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostics information, such as error messages, warnings, and informative messages
    • Because of this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples here.


Let us know how we are doing and how you use our driver by taking our pulse survey: http://ift.tt/2tCpczk.

Get started

Getting Drivers for PHP5 and older runtimes

You can download the Microsoft PHP Drivers for SQL Server for PHP 5.4, 5.5, and 5.6 from the download center: http://ift.tt/1vkS3V4. Version 3.0 supports PHP 5.4, version 3.1 supports PHP 5.4 and PHP 5.5, and version 3.2 supports PHP 5.4, 5.5, and 5.6.

PHP Driver Version Supported
v3.2 PHP 5.6, 5.5, 5.4
v3.1 PHP 5.5, 5.4
v3.1 PHP 5.4

Meet Bhagdev (meetb@microsoft.com)


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

segunda-feira, 17 de julho de 2017

[From Technet] SQL Server 2017 containers for DevOps scenarios

This post was authored by Tony Petrossian, Partner Group Program Manager, Database Systems Group

SQL Server 2017 will bring with it support for the Linux OS and containers running on Windows, Linux, and macOS. Our goal is to enable SQL Server to run in modern IT infrastructure in any public or private cloud.

With support for containers, SQL Server can now be used in many popular DevOps scenarios.  Developers working with Continuous Integration/Continuous Deployment (CI/CD) pipelines can now include SQL Server 2017 containers as a component of their applications for an integrated build, test, and deploy experience.

CI/CD automation with containers – Using containers greatly simplifies the development, testing, and deployment of applications. This is achieved by the packaging of all dependencies, including SQL Server, into a portable, executable environment that reduces variability and increases the speed of every iteration in the CI/CD pipeline. This also enforces a consistent experience for all participants since they can share the same state of an application in their containers. Developers can improve applications in their local environments during the first part of the Continuous Integration process.

The development process starts by taking a container that represents the current state of a production application, including a subset of the sanitized data. Developers can then add their features and fixes to it, while having the ability to verify the functionality of the application at any moment. Then, the container can be sent to a testing/quality assurance environment where it can be tested with a larger, more representative dataset.

Continuous Deployment is a critical part of DevOps pipelines. With a successful CD pipeline, a validated and self-contained version of the application is available. Developers can publish and share fully configured containers with all application dependencies, including SQL Server, with their peers. This can significantly improve developers’ ability to collaborate as they can all work on the same exact configurations simultaneously without having to build the complicated environment necessary for developing and testing applications with many components.

Parallel testing made fast and easy – Developers can automate the large-scale testing of containerized applications that include SQL Server. Thousands of tests can execute in parallel using high-density container deployments with managed container services. Kubernetes, Docker Swarm, or other orchestration systems can be used to easily manage a large number of test executions. Long-running test cycles can be optimized by load balancing the executions across multiple pods that spin up on demand and spin down when finished.

The Microsoft SQL Server development team is now taking advantage of these capabilities in building, testing, and publishing the new versions of SQL Server 2017. The team uses Azure Container Services to deploy hundreds of containers managed by a large Kubernetes cluster to execute all daily tests of SQL Server. Hundreds of thousands of tests are executed within hours of the availability of a new build! This methodology has enabled the team to run more tests in less time with fewer resources.

Multi-OS development, test, and production environments – With the containerization of the app, developers no longer need to be concerned about aligning stages of the development and production pipeline with the same exact distribution and version of Linux. Developers can containerize their application environment, including SQL Server, to abstract it from the operating system of the underlying host. Whether part of the pipeline is operated on Ubuntu and other parts in Red Hat Enterprise Linux (RHEL), the ability to containerize the entire application environment eliminates the need to overcome challenges of a cross-platform environment. Developers are also free to choose their preferred development environment without worrying about compatibility issues in later parts of the pipeline. With SQL Server 2017, developers can run SQL Server Linux Docker images on macOS, Windows, and Linux.

Deploying SQL Server into production – As new versions of the application are tested and verified, builds of the containers are published for use in staging and production. The exact version of the SQL Server that was used throughout the development and testing pipeline is now in the production image, and the team can be confident that the entire stack, including SQL Server, has been tested as one unit and is ready for use.

Learn more about how to better integrate your SQL Server data/database on the DevOps cycle.

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

[From Technet] First release candidate of SQL Server 2017 now available

We are pleased to announce the first public release candidate for SQL Server 2017, Release Candidate 1 (RC1), available for download now. This means that development work for the new version of SQL Server is complete along most dimensions to bring the industry-leading performance and security of SQL Server to Windows, Linux, and Docker containers. In our seven community technology previews (CTPs) to date, SQL Server 2017 has delivered:

  • Linux support for tier-1, mission-critical workloads SQL Server 2017 support for Linux includes the same high availability solutions on Linux as Windows Server, including Always On availability groups integrated with Linux native clustering solutions like Pacemaker.
  • Graph data processing in SQL Server With the graph data features available in SQL Server 2017 and Azure SQL Database, customers can create nodes and edges, and discover complex and many-to-many relationships.
  • Adaptive query processing Adaptive query processing is a family of features in SQL Server 2017 that automatically keeps database queries running as efficiently as possible without requiring additional tuning from database administrators. In addition to the capability to adjust batch mode memory grants, the feature set includes batch mode adaptive joins and interleaved execution capabilities.
  • Python integration for advanced analytics Microsoft Machine Learning Services now brings you the ability to run in-database analytics using Python or R in a parallelized and scalable way. The ability to run advanced analytics in your operational store without ETL means faster time to insights for customers while easy deployment and rich extensibility make it fast to get up and running on the right model.

Key enhancements in Release Candidate 1

In SQL Server 2017 RC1, there were several feature enhancements of note:

  • SQL Server on Linux Active Directory integration – With RC1, SQL Server on Linux supports Active Directory Authentication, which enables domain-joined clients on either Windows or Linux to authenticate to SQL Server using their domain credentials and the Kerberos protocol. Check out the getting started instructions.
  • Transport Layer Security (TLS) to encrypt data – SQL Server on Linux can use TLS to encrypt data that is transmitted across a network between a client application and an instance of SQL Server. SQL Server on Linux supports the following TLS protocols: TLS 1.2, 1.1, and 1.0. Check out the getting started instructions.
  • Machine Learning Services enhancements – In RC1, we add more model management capabilities for R Services on Windows Server, including External Library Management. The new release also supports Native Scoring.
  • SQL Server Analysis Services (SSAS) In addition to the enhancements to SSAS from previous CTPs of SQL Server 2017, RC1 adds additional Dynamic Management Views, enabling dependency analysis and reporting. See the Analysis Services blog for more information.
  • SQL Server Integration Services (SSIS) on Linux The preview of SQL Server Integration Services on Linux<link> now adds support for any Unicode ODBC driver, if it follows ODBC specifications. (ANSI ODBC driver is not supported.)
  • SQL Server Integration Services (SSIS) on Windows Server RC1 adds support for SSIS scale out in highly available environments. Customers can now enable Always On for SSIS, setting up Windows Server failover clustering for the scale out master.

SQL Server 2017 for faster performance

SQL Server 2017 has several new benchmarks demonstrating faster performance than competitive databases, and against older versions of SQL Server:

Streamline your DevOps using SQL Server 2017

In SQL Server 2017, we have introduced support for SQL Server on Linux-based containers, a benefit for customers using containers in development or production. We’re also working to help developers get started developing an app for SQL Server as fast as possible with installation instructions, code snippets, and other handy information.

On our new microsite DevOps using SQL Server, which launched today, developers and development managers can learn how to integrate SQL Server in their DevOps tasks. Find demos, documentation, and blogs, as well as videos and conference presentations. Or, join the DevOps conversation at our Gitter channels.

Customers are already benefitting from SQL Server 2017

In fact, with our Early Adoption Program, customers can develop new applications for SQL Server 2017 or add Linux support to existing applications, and get the support and end-user license agreement that they need to go into production on SQL Server right now. Here are some customers already benefitting from SQL Server 2017 on Linux:

  • Convergent Computing A system integrator and longtime Microsoft partner, Convergent Computing was able to achieve a much faster return on server and storage hardware investments than usual by moving some tier-2 applications to inexpensive, white box servers running SQL Server 2017 on Linux.
  • dv01 – Financial technology startup dv01 started out with an open source database on a competitor cloud. But when it ran into performance and scale problems, SQL Server was able to give it 15X faster performance, plus in-database advanced analytics. And by moving to SQL Server 2017, dv01 could standardize its operating systems on Linux—all with an easy migration.

Get started with SQL Server 2017 RC1 today!

Try the release candidate of the SQL Server 2017 today! Get started with our updated developer tutorials that show you how to install and use SQL Server 2017 on macOS, Docker, Windows, and Linux and quickly build an app in a programming language of your choice. For more ways to get started, try the following:

Have questions? Join the discussion of SQL Server 2017 at MSDN. If you run into an issue or would like to make a suggestion, you can let us know through Connect. We look forward to hearing from you!

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

quarta-feira, 5 de julho de 2017

[From Technet] Microsoft JDBC Driver 6.2 for SQL Server released

This post was authored by Andrea Lam, Program Manager, SQL Server

We are happy to announce the full release of the Microsoft JDBC Driver 6.2 for SQL Server. The JDBC Driver provides Java database connectivity from any Java application, application server or Java-enabled applet to Microsoft SQL Server, Azure SQL Database and Azure SQL Data Warehouse. The driver is open source and available at no additional charge.

What’s new

Performance improvements for Prepared Statements
Improved performance for Prepared Statements through caching (including prepared statement handle re-use). This behavior can be tuned using new properties to fit your application’s needs.

Azure Active Directory (AAD) support for Linux
Connect your Linux applications to Azure SQL Database using AAD authentication via username/password and access token methods.

Federal Information Processing Standard (FIPS) enabled Java virtual machines
The JDBC Driver can now be used on Java virtual machines (JVMs) that run in FIPS 140 compliance mode to meet federal standards and compliance.

Kerberos Authentication Improvements
The JDBC Driver now has support for:

  • Principal/Password method for applications where the Kerberos configuration cannot be modified or is unable to retrieve a new token or keytab. This method can be used for authenticating to a SQL Server that only allows Kerberos authentication.
  • Cross-realm authentication using Kerberos integrated authentication without explicitly setting the server service principal name (SPN). The driver now automatically computes the REALM even when it has not been provided.
  • Kerberos constrained delegation by accepting impersonated user credentials as a GSS credential object via data source. This impersonated credential is then used to establish a Kerberos connection.

Added Timeouts
The JDBC driver now supports the following configurable timeouts you can change based on your application’s needs:

  • Query Timeout to control the number of seconds to wait before a timeout occurs when running a query
  • Socket Timeout to specify the number of milliseconds to wait before a timeout occurs on a socket read or accept

Get the latest JDBC jars

Add the JDBC driver to your Maven project by adding the following code to your POM file:


You can also download the JDBC driver 6.2 jars directly from:

Help us improve the JDBC Driver by filing issues on GitHub or contributing to the project.


Get started quickly with Java and SQL Server on your platform of choice with our tutorials.

For more detailed documentation, check out the JDBC documentation here.

Stay tuned for upcoming releases that will have additional feature support. This applies to our wide range of client drivers including:

Be sure to also check out other open sourced community developed drivers including:

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

[From Technet] Webcast: Intro to Microsoft SQL Server on Linux with containers

With our community technology previews of SQL Server 2017, Microsoft is bringing the industry-leading performance and security of SQL Server to Linux and containers for the first time. SQL Server running on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform has advantages for both the SQL Server and Red Hat Linux communities.

Join this webinar by experts from Red Hat and Microsoft as we cover:

  • The capabilities of Microsoft SQL Server on Red Hat Enterprise Linux and Red Hat OpenShift Container Platform
  • Advantage of running Red Hat OpenShift Container Platform on-premises and in Microsoft Azure
  • A demo of application compatibility between SQL Server on Windows and SQL Server on Red Hat Enterprise Linux

Register now to attend. The webcast takes place Tuesday, July 11, 2017 at noon EDT / 9 a.m. PDT.


Don Schenck
Director, Developer Experience, Red Hat
Don Schenck, Red Hat director of Developer Experience, focuses on Microsoft .NET on Linux. His mission is to bring .NET developers into the Linux and open source communities. Before joining Red Hat, Don was a developer advocate at Rackspace. He is the author of “Transitioning to .NET Core on Linux,” an O’Reilly book.

Vin Yu
Program manager, Microsoft
Vin Yu, Microsoft program manager, is on the SQL Server team, where he works with developers and companies adopting SQL Server on Linux. Vin is also interested in improving developer experiences, database monitoring, and tools.

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