Skip to content

SQL Server Blog

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

Step 3: Identify your upgrade strategy As the end-of-support deadline for SQL Server 2005 draws near (April 12, 2016), you are probably starting to think about your upgrade strategy. Upgrading SQL Server is a multistage effort that takes time. Planning your SQL Server upgrade early will help you save money and prevent unnecessary business interruptions....

Read more

Enhanced Always On Availability Groups in SQL Server 2016

Always On Availability Groups Always On Availability Groups are a fundamental component of the availability story for SQL Server, and provide a robust disaster recovery solution as well. Availability Groups were first introduced in SQL Server 2012, replacing the prior Database Mirroring technologies. They enable a DBA to configure two SQL instances to host replicas...

Read more

Watch the PASS Keynote Video: “Accelerating Your Business with a Modern Data Strategy”

The annual PASS Summit provides an opportunity for the SQL Server community to meet, share expertise, and gain firsthand insights into advances in the Microsoft data platform technology directly from Microsoft executives. The fall 2015 PASS Summit gave attendees the opportunity to learn about the upcoming release of SQL Server 2016 when Joseph Sirosh, corporate...

Read more

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. SQL Server 2016 and Azure SQL DB have In-Memory OLTP in public preview, and contain many improvements to In-Memory OLTP, making it drastically easier to adopt in an existing application, and allowing many other applications...

Read more

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. Fortunately, Microsoft offers exceptional tools and support to help you smoothly upgrade from SQL Server 2005 to SQL Server 2014 and Microsoft Azure SQL Database before the end-of-support deadline on April 12, 2016. In this series of three blog posts, we’ll...

Read more

Speeding up Business Analytics Using In-Memory Technology

New challenges Businesses have always used data and analytics for improved business decisions. As the new age of the IOT (Internet of Things) approaches, businesses are experiencing exponential data growth and the challenges that come along with managing large data sets. At the same time, tools like Power Pivot democratize data access to these large...

Read more