Skip to content
Microsoft SQL Server Blog

Posts

PASS Data Community Summit keynote: a bridge to a new universe 

It is almost time for PASS Data Community Summit 2021, a free online conference for the Microsoft data platform professional. The conference, hosted by Redgate, will include the latest SQL Server and Azure data innovations, practical training, and networking to empower you to transform your career and your organization. This year’s event is coming to...Read more

Move SQL Server licenses without Software Assurance to Azure 

Migrating your on-premises infrastructure and architecture to the cloud may seem like a daunting task, especially if you don’t have Software Assurance for your on-premises licenses. While this may seem difficult and challenging, there is a pain-free way to bring your existing on-premises licenses to the cloud through Azure Dedicated Host. Not only does Azure...Read more

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 2022, 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 2022 with Windows Server 2019 to take advantage of advanced multi-layer security, hybrid capabilities, and enhancements to...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