Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!
Java continues to be one of the most widely used programming languages for a variety of application scenarios and industries. The Microsoft JDBC Driver for SQL Server is used to connect Java applications to SQL Server, whether SQL Server is hosted in the cloud or on-premises, or provided as a platform-as-a-service.
With the release of SQL Server v.Next public preview on Linux and Windows, the ability to connect to SQL Server on Linux, Windows, Docker or macOS (via Docker) makes cross-platform support for all connectors, including the JDBC driver, even more important. To enable Java developers to use the newest SQL Server features, we have been updating the JDBC driver with client-side support for new features, including Always Encrypted and Azure Active Directory Authentication.
We recently open sourced the Microsoft JDBC Driver for SQL Server. In doing so, we included the Java source code on GitHub (under MIT License). By making the project available on GitHub, we hope to facilitate a quicker feedback loop for Java developers. This feedback will be used to inform the prioritization of the developed features to support the variety of Java applications that connect to SQL Server. We want to get the community involved as much as possible in the design and implementation of features and welcome pull requests. Weâve also included build scripts if youâd like to build the jars on your own.
We have also made the connector available on the Maven Central Repository. Maven is popularly used by Java developers to build projects and manage dependencies. Maven support has been one of the most popular requests for the JDBC driver, and we hope that its availability on the Central Repository will make it easier to obtain and use the JDBC driver in new and existing projects. Itâs as simple as adding the JDBC driver to your Maven projectâs POM file.
This connector can be used to connect Java applications to Azure SQL Database, Azure SQL Data Warehouse and SQL Server (including SQL Server v.Next public preview). We have two jars available to support JRE 7 and 8. To start using the JDBC driver or upgrade your existing JDBC driver to the newest version, you can use one of the methods below:
You can learn more about open sourcing the JDBC driver and support for Maven in this blog. We look forward to working more closely with the community to continue to bring the best support for Java applications connecting to SQL Server.Get started today
When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. We will explore a couple of these enhancements in this article. In particular, we will focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).
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.
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.
Redwood Shores, Calif.—Dec 1, 2016
Today, the European Commission and DIGITALEUROPE launched the Digital Skills and Jobs Coalition, a multi-stakeholder partnership to bolster computer science (CS) and coding proficiency at all levels within Europe’s workforce pipeline. In conjunction, Oracle announced a three-year investment totaling $1.4 billion in direct and in-kind support of CS education throughout the European Union (EU) member states.
Nearly 1,000 EU educational institutions currently collaborate with Oracle Academy, Oracle’s flagship program in education philanthropy that brings computer science education to nearly 3.1 million students in 110 countries. As part of today’s pledge, Oracle Academy aims to train 1,000 additional EU educators in CS, Java and Database instruction, as well as reach students across an added 1,000 EU educational institutions over the next three years.
“Digitally skilled professionals are critical to Europe’s competitiveness and capacity for innovation,” said John Higgins, Director General, DIGITALEUROPE. “Over the last ten years, we’ve seen the demand for workers with computer science and coding skills grow by four percent each year. Oracle’s efforts to bring computer science into classrooms across the European Union will help strengthen our digital economy.”
“At Oracle, we are thrilled to inspire and engage students from all different parts of the world in computer science,” said Alison Derbenwick Miller, Oracle Academy Vice President. “Earlier this year, Oracle made significant commitments to the White House’s CS for All and Let Girls Learn initiatives. Today’s announcement continues our momentum to advance digital education and increase diversity in technology fields globally.”
Additionally, Oracle Academy will drive several programs during the next three years, including:
Today’s commitment is an extension of Oracle’s pledge in 2013, which trained and empowered 1,246 EU educators to teach computer science, as well as added 203 EU educational institutions to Oracle Academy.
As Oracleâs flagship philanthropic educational program, Oracle Academy advances computer science education globally to drive knowledge, innovation, skills development, and diversity in technology fields, offering a free and complete portfolio of software, curriculum, hosted technology, faculty trainings, support, and certification resources. Supporting more than 3.1 million students annually in 110 countries, the program works with public and private partners to provide the tools educators need to engage, inspire and prepare students to become innovators and leaders of the future. Through Oracle Academy, students receive hands-on experience with the latest technologies, helping to make them college and career ready in the era of big data, cloud computing, the Internet of Things, and beyond.About Oracle
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.Trademarks
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Safe Harbor
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation.Talk to a Press Contact
Follow Oracle Corporate
Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.
Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records from the msdb database. If you are sending email using database mail and you are not periodically purging email information, then you might find out this is one of the reasons your msdb database is growing bigger.
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:
*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:
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:
Stay tuned for additional SQL Server Blog posts in the coming weeks, including connectors, and developer tools on Linux!
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 firstname.lastname@example.org.
Congratulations to our October 2016 Top 10 contributors!
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.Transact-SQL
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
SQL Server 2016 brings native support to advanced analytics in the database itself, using R Services. Learn what R is, what the on-premise advanced analytics options from Microsoft are, and how to get started using R Services with SQL Server 2016.
FOSDEM PGDay 2017 is a one day conference held this year on February 3rd followed immediately by the two day FOSDEM conference in Brussels at which we'll be hosting additional sessions on February 5th.
For more information on FOSDEM PGDay, please see:
For more information on FOSDEM, please see:
The call for papers for both the PGDay and FOSDEM Devroom has now been extended until midnight CET, 4th December. If you would like to submit a talk, please see the website:
Talks may be on any topic related to PostgreSQL in some way. Suggested topic areas include:
Of course, we're happy to receive proposals for talks on other PostgreSQL related topics as well.
NOTE: Please submit talks through our website for both the PGDay and FOSDEM Devroom. DO NOT use the FOSDEM Pentabarf system as we are notmanaging the PostgreSQL talks though it.
The PostgreSQL Europe team will also have a table throughout the FOSDEM event; please feel free to stop by to chat with us about PostgreSQL and pickup some swag!
This post is authored by Christina Lee, Program Manager – Data Group SEALS TeamOverview
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:
With DEA, you can:
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.Questions/Feedback
Version 4.0 of DbWrench is now available for download.
This release marks the switch from version 3 to version 4 of the product cycle. This release focused on the complete replacement of the editor code complete framework. We believe the new code complete framework is more compact and much more responsive. Also the look and styling for the database documentation has been improved.
It is our hope that these improvement will make DbWrench easier to use and make you more productive.
A free trial download of this latest version is available at www.dbwrench.com.
Thank you for your continued support of our product!
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:
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:
It’s interesting to note that sometimes VARCHAR2 fields are used to store numbers. Read on to see why this isn’t the best practice and how to get around the sorting issue if you can’t change the table.
Redwood Shores, Calif.—Nov 21, 2016
Oracle today announced that it has signed an agreement to acquire Dyn, the leading cloud-based Internet Performance and DNS provider that monitors, controls, and optimizes Internet applications and cloud services to deliver faster access, reduced page load times, and higher end-user satisfaction.
Dynâs solution is powered by a global network that drives 40 billion traffic optimization decisions daily for more than 3,500 enterprise customers, including preeminent digital brands such as Netflix, Twitter, Pfizer and CNBC. Adding Dynâs best-in-class DNS solution extends the Oracle cloud computing platform and provides enterprise customers with a one-stop shop for Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS).
âOracle already offers enterprise-class IaaS and PaaS for companies building and running Internet applications and cloud services,â said Thomas Kurian, President, Product Development, Oracle. âDynâs immensely scalable and global DNS is a critical core component and a natural extension to our cloud computing platform.â
âOracle cloud customers will have unique access to Internet performance information that will help them optimize infrastructure costs, maximize application and website-driven revenue, and manage risk,â said Kyle York, Chief Strategy Officer, Dyn. âWe are excited to join Oracle and bring even more value to our customers as part of Oracleâs cloud computing platform.â
More information about this announcement is available at www.oracle.com/dyn.
Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.Trademarks
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Product Roadmap
Oracle is currently reviewing the existing Dyn product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Dyn’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Dyn or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and Dyn, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Dyn, anticipated customer benefits and general business outlook. When used in this document, the words "anticipates", "can", "will", "look forward to", "expected" and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or Dyn, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or Dyn may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or Dyn. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor Dyn is under any duty to update any of the information in this document.Safe Harbor
The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation.Talk to a Press Contact
Follow Oracle Corporate
We are pleased to announce the launch of The Israel PostgreSQL Community website.
Our goal is to promote PostgreSQL knowledge and usage in Israel by collaboration of all interested in it users.
The site will publish PostgreSQL global and regional community news and events.
We will promote PostgreSQL usage among students and pupils by providing lectures in colleges and high schools. We'll be glad for any help from the community for any relevant presentation content that can be useful for those populations.
There is a forum with variety of topics and blog section with relevant posts.
We are going to organize PGDAY at the beginning of the next year in Israel.
We are calling all PostgreSQL users in Israel to join effort and build strong and valuable community.
We initiated the process of product documentation translation. This is the time consuming process and we'll be glad if other users will be able to help us.
Please visit us at http://postgresql.org.il/.
This post was authored by Tiffany Wissner, Senior Director of Data Platform Marketing
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.
While the performance of a mission-critical application sometimes takes center stage, IT staff are always aware that the performance of the overall system affects all applications. Database management systems, operating system software, physical data storage and retrieval, and backup and recovery operations all take part in providing a solid infrastructure for applications. For many customer facing applications, such as on-line transaction processing, the database management system is the key component.
This post was authored by Joseph Sirosh, Corporate Vice President of the Microsoft Data Group.
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 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.
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.
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.
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.
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.