Tags : #sqlserver

18

Jul

Microsoft Drivers v4.3.0 for PHP for SQL Server released!
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:

Added PHP 7.1 support Added Unicode Column name support (issue #138) Support for transparent connections to AlwaysOn Availability Groups. The driver quickly discovers the current AlwaysOn topology of your server infrastructure and connects to the current active server transparently. Added support for sql_variant data type with limitation (issue #51 and issue #127) Debian Jessie (tested on Debian 8.7) and macOS (El Capitan and above) support Connection Resiliency support for Windows Connection pooling support for Linux and macOS Fixed 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

17

Jul

SQL Server 2017 containers for DevOps scenarios
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,

17

Jul

First release candidate of SQL Server 2017 now available
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

03

Aug

Looking for your biggest career opportunity at Microsoft?

Are you looking for your biggest career opportunity at Microsoft? It’s an exciting time to become part of the Cloud and Enterprise team in the Enterprise Partner Group (EPG). As Global Technical Lead for Data Platform I am excited about READ MORE

10

Jul

Announcing Spark for Azure HDInsight public preview
Announcing Spark for Azure HDInsight public preview

From Data Plaform Blog: Lighting up interactive insights on big data By T. K. “Ranga” Rengarajan, corporate vice president, Data Platform Today, we’re announcing the public preview of Spark for Azure HDInsight and the upcoming general availability of Power BI READ MORE

09

Jul

Datazen Publisher for Windows 7 Preview now available
Datazen Publisher for Windows 7 Preview now available

From Data Plaform Blog: We are pleased to announce the availability of Datazen Publisher for Windows 7 Preview. Datazen Publisher is the single point for creation and publishing of rich, interactive visualizations. You can simply connect to the Datazen Server READ MORE

01

Jul

Preview the new JDBC 4.2 for SQL Server Driver

From Data Platform Blog: Today we are pleased to announce availability of the Community Technology Preview (CTP) of the Microsoft JDBC 4.2 Driver for SQL Server! The driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL READ MORE

24

Jun

From Data Platform Blog: From Tiffany Wissner, Senior Director, Data Platform In the SQL Server CTP 2 blog, T.K. Ranga Rengarajan, CVP of SQL Server engineering, discussed bringing cloud first innovations to SQL Server 2016. This includes a rapid preview model READ MORE

24

Jun

From Data Platform Blog: Following the release of SQL Server 2016 CTP 2.0 last month, the SQL Server engineering team is excited to announce the immediate availability of CTP 2.1 release for download. The release includes improvements for three new READ MORE

24

Jun

Azure SQL Data Warehouse opens for Limited Public Preview
Azure SQL Data Warehouse opens for Limited Public Preview

From Data Platform Blog: By Tiffany Wissner, Senior Director, Data Platform At the Build conference in April, we announced Azure SQL Data Warehouse, our new enterprise-class elastic data warehouse-as-a-service. Today, we’re pleased to announce that Azure SQL Data Warehouse is READ MORE