-
-
SQL Server 2016 CTP 3.2: Introducing end-to-end mobile BI
The SQL Server 2016 Community Technology Preview (CTP) 3.2 is now available for download! In SQL Server 2016 CTP 3.2, part of our new rapid preview model, we made enhancements to several features which you can try in your development and test environments. Additionally, a number of Mobile BI additions and enhancements will be available -
Tuning Workload Performance with Query Store
As your database grows, it is not unusual to experience performance problems caused by queries that once performed well, but now perform poorly. Without the ability to see all the changes in the query execution over time, it is difficult to figure out why regressions happen and what you can do to prevent them. Troubleshooting -
Planning an efficient upgrade from SQL Server 2005: Step 2 of 3
Step 2: Target destinations for each application and workload As you know, the end of support deadline for SQL Server 2005 is on April 12, 2016. In this three- part blog series, we are discussing important steps to take as you plan your upgrade. In our last post, we walked through the importance of discovering -
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 -
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 -
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 -
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 -
Real-Time Operational Analytics Using In-Memory Technology
Operational workloads refer to the business transactions that are critical to running a business. For example, a retail store has a transactional system to create or modify new orders, and a credit card company tracks all charges made by vendors on behalf of its customers. These transactional systems are critical to businesses, as any downtime -
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 -
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.” With SQL Server 2016 the advanced capabilities you need in a data platform are built in. You don’t need to purchase expensive add-ons to get necessary functionality immediately: Looking for -
Get the most out of SQL Server 2016
Blog post series to highlight new features and enhancements available with SQL Server 2016. Data, and the ability to extract actionable intelligence from it, is driving transformation in how we do business today. With SQL Server 2016, it’s never been easier to capture, transform, mash-up, analyze and visualize any data, of any size, at any -
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. But data security is so important that it can also be a competitive differentiator. Indeed, Forrester Research reports a focus on data security can help drive customer loyalty and retention, create opportunities for premium offers -
Introducing: SQL Server 2016 Community Technology Preview 3.1
The SQL Server 2016 Community Technology Preview (CTP) 3.1 is now available for download! This release fully embraced the “Cloud First” tenet, as this release build was deployed to SQL Azure Database service first, running in production prior to the release build. In SQL Server 2016 CTP 3.1, part of our new rapid preview model, -
SQL Server 2016 Community Technology Preview 3.1 is available
The SQL Server engineering team is pleased to announce the immediate availability of SQL Server 2016 November public preview release CTP 3.1. To learn more about SQL Server 2016, visit the SQL Server 2016 preview page. To experience the new, exciting features in SQL Server 2016 and the new rapid release model, download the preview