SQL Server Team articles

Avatar photo
SQL Server Team
Published 
3 min read

Automated Backup and Automated Patching for SQL Server in Azure Portal and PowerShell 

In an effort to provide an extra level of convenience, we are releasing two features that will simplify the effort to ensure the health of your SQL Virtual Machine and your data. These features, Automated Backup and Automated Patching, automate the processes of backing up and patching your SQL Virtual Machines. Incredibly easy to set up, these features require little input to manage.
Published 
6 min read

Data Science Perspectives: Q&A with Microsoft Data Scientists Val Fontama and Wee Hyong Tok 

You can’t read the tech press without seeing news of exciting advancements or opportunities in data science and advanced analytics. We sat down with two of our own Microsoft Data Scientists to learn more about their role in the field, some of the real-world successes they’ve seen, and get their perspective on today’s opportunities in these evolving areas of data analytics.
Published 
4 min read

Relational Data Warehouse + Big Data Analytics: Analytics Platform System (APS) Appliance Update 3 

This blog post was authored by: Matt Usher, Senior PM on the Microsoft Analytics Platform System (APS) team Microsoft is happy to announce the release of the Analytics Platform System (APS) Appliance Update (AU) 3. APS is Microsoft’s big data in a box appliance for serving the needs of relational data warehouses at massive scale.
Published 
1 min read

Now Available: Updated SQL Server PHP and JDBC Drivers 

As part of SQL Server’s ongoing interoperability program, we are pleased to announce the general availability of two SQL Server drivers: the Microsoft JDBC Driver for SQL Server and the SQL Server Driver for PHP are now available! Both drivers provide that robust data access to Microsoft SQL Server and Microsoft Azure SQL Database.
Published 
1 min read

The Best of Both Worlds: Top Benefits and Scenarios for Hybrid Hadoop, from On-Premises to the Cloud 

Historically, Hadoop has been a platform for big data that you either deploy on-premises with your own hardware or in the cloud and managed by a hosting vendor. Deploying on-premises affords you specific benefits, like control and flexibility over your deployment.  But the cloud provides other benefits like elastic scale, fast time to value, and automatic redundancy, amongst others.
Published 
2 min read

Azure HDInsight Adds Deeper Tooling Experience in Visual Studio 

To allow developers in Visual Studio to more easily incorporate the benefits of “big data” with their custom applications, Microsoft is adding a deeper tooling experience for HDInsight in Visual Studio in the most recent version of the Azure SDK. This extension to Visual Studio helps developers to visualize their Hadoop clusters, tables and associated storage in familiar and powerful tools.
Published 
1 min read

Azure HDInsight Clusters Allows Custom Installation of Spark Using Script Action 

Apache Spark is a popular open source framework for distributed cluster computing. Spark has been gaining popularity for its ability to handle both batch and stream processing as well as supporting in-memory and conventional disk processing. Starting today, Azure HDInsight will make it possible to install Spark as well as other Hadoop sub-projects on its clusters.