SQL Server Best Practices - Microsoft SQL Server Blog

Best Practices December 10, 2015 5 min read

Speeding up Transactions with In-Memory OLTP in SQL Server 2016 and Azure SQL Database

In-Memory OLTP, a performance feature in SQL Server since 2014, allows you to speed up transactional workloads up to 30X.

Best Practices December 10, 2015 2 min read

Planning an efficient upgrade from SQL Server 2005: Step 1 of 3

Step 1: Discover what’s in your database environment Upgrading a database can seem daunting.

Best Practices December 9, 2015 3 min read

Real-Time Operational Analytics Using In-Memory Technology

Operational workloads refer to the business transactions that are critical to running a business.

Best Practices December 8, 2015 3 min read

Speeding up Business Analytics Using In-Memory Technology

New challenges Businesses have always used data and analytics for improved business decisions.

Best Practices December 3, 2015 2 min read

SQL Server 2016: Advanced Capabilities without Expensive Add-Ons

What does the industry leading SQL Server 2016 have in common with spaghetti sauce? Just the fact that if you need something, “it’s in there.

Best Practices December 1, 2015 2 min read

Get the most out of SQL Server 2016

Blog post series to highlight new features and enhancements available with SQL Server 2016.

Best Practices December 1, 2015 2 min read

Always Encrypted Data Security and Competitive Advantage

As data becomes the center of digital business, your organization’s ability to secure data is crucial for compliance and confidentiality.

Best Practices November 4, 2015 5 min read

Fast Backup and Restore with File-snapshot Backup

SQL Server Data Files in Azure allows you to create databases in SQL Server running in on-premises or in a virtual machine with a dedicated durable location in Azure blob storage.

Best Practices November 3, 2015 3 min read

Are you encouraging data professionals to move from doing repairs to being innovators?

If you’re a business or IT decision-maker, when you send IT staff to a technical conference you’re probably thinking about the value of having well-trained technologists to make sure your infrastructure keeps running smoothly.

Best Practices October 26, 2015 4 min read

Azure Key Vault Integration for SQL Server in Azure VMs

Earlier this year we announced a service called Azure Key Vault (AKV), a cloud-hosted Hardware Security Module (HSM) backed service for managing cryptographic keys and other secrets used in your cloud application.

Best Practices October 13, 2015 2 min read

Mature Data Management: Key to Business Success

Data is at the center of today’s business strategy in successful organizations.

Best Practices June 2, 2015 1 min read

Assess the health of SQL Server deployments in Azure VM using Microsoft Operations Management Suite

Do you want to assess the health of your SQL Server deployments on Azure Virtual machines? Do you want to ensure that you have an optimal SQL Server configuration? At Ignite 2015 we released a tool for this.

Explore SQL Server 2025