Skip to content
Microsoft SQL Server Blog

Posts

Recent updates for Data-Tier Application Framework and SqlPackage 

In this article, we will cover some recent changes to the Data-Tier Application Framework (DacFx) and SqlPackage. DacFx is a library that provides APIs for database deployment and development scenarios and SqlPackage is a command line interface to DacFx for common uses. Earlier this year SqlPackage released updates including additional support for Azure Synapse Analytics...Read more

Know your options for SQL Server 2012 and Windows Server 2012 End of Support 

Customers trust Windows Server and SQL Server for their business-critical workloads. With SQL Server 2019, customers like Itaú Unibanco are taking advantage of the built-in intelligence, industry-leading performance, and security across both structured and unstructured data. Similarly, customers like CadDo are combining SQL Server 2019 with Windows Server 2019 to take advantage of advanced multi-layer security, hybrid capabilities, and enhancements to modernize...Read more

DBAs: It’s time to get up to speed with Azure 

The summer solstice has passed, and DBAs are still asking how to get up to speed with Azure. I’m even speaking at events on how to take advantage of Azure to do migrations to the cloud! Many I’ve spoken to are wondering what skills they need to add to their already impressive arsenal of technology....Read more

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...Read more

Cloudera Selects Azure as a Preferred Cloud Platform 

We are working to make Azure the best cloud platform for big data, including Apache Hadoop. To accomplish this, we deliver a comprehensive set of solutions such as our Hadoop-based solution Azure HDInsight and managed data services from partners, including Hortonworks. Last week Hortonworks  announced the most recent milestone in our partnership and yesterday we...Read more

Expanding the Availability and Deployment of Hadoop Solutions on Microsoft Azure 

Author: Shaun ConnollyVP Corporate Strategy – Hortonworks Data growth threatens to overwhelm existing systems and bring those systems to their knees. That’s one of the big reasons we’ve been working with Microsoft to enable a Modern Data Architecture for Windows users and Microsoft customers. A history of delivering Hadoop to Microsoft customers Hortonworks and Microsoft...Read more

Using SSDs in Azure VMs to store SQL Server TempDB and Buffer Pool Extensions 

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of workloads that use temporary objects heavily (e.g. queries handling large recordsets, index rebuilds, row versioning isolation levels, temp tables, and triggers). The latter improves the...Read more

Microsoft Azure Offers HDInsight (Hadoop-as-a-service) to China 

Microsoft today announced that Azure HDInsight is now available for all customers in China as a public preview, making it the first global cloud provider to have a publicly available cloud Hadoop offering in China. With this launch, Microsoft is bringing Azure HDInsight’s ability to process big data volumes from unstructured and semi-structured sources to...Read more

New Optimized OLTP and Data Warehousing SQL Server Images on Azure 

Microsoft Azure continues to offer customers more reasons why  Azure Virtual Machines are an ideal place to develop, test and run your SQL Server applications.  This promise is further enhanced with the release of new workload optimized images for SQL Server that provide greater performance and simplified setup when it comes to running data warehousing...Read more