Mapping the Universe with SQL Server 

13 min read

This blog post was co-authored by Joseph Sirosh, Corporate Vice President, and Rimma V. Nehme, Principal Software Engineer, at the Data Group at Microsoft.   Figure 1: Visible objects of the Sloan Digital Sky Survey (SDSS) DR7 dataset. Over the last 15 years a database helped revolutionize an entire field of science. Astronomical discovery and Read more

4 Comments

Announcing SQL Server on Linux 

<1 min read

Today, we announced our plans to bring SQL Server to Linux. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017.  Read Scott Guthrie’s blog post Read more

9 Comments

TLS 1.2 support availability for SQL Server 

1 min read

Microsoft is ensuring that customers can remain compliant with the current changes in guidance for using strong cryptography for implementing security control. A number of known vulnerabilities has been reported against SSL and earlier versions of TLS which has changed the security guidance to move to TLS 1.2 for support secure communication. There has been Read more

1 Comment

Video: To the future of analytics with SQL Server, BI and Cortana Analytics Suite 

1 min read

How cool is data analytics? Super cool! If you think that description sounds like hype, you should watch the video of Jason Wilcox’s Foundational session at PASS as he presents fascinating examples that demonstrate how Microsoft’s data platform and Azure Machine Learning is making “The Future of Analytics” real today. Wilcox discusses how advanced analytics Read more

Microsoft Business Intelligence PASS keynote: Five minutes to sign up; five minutes to WOW! 

1 min read

See how you can get real-time interactive visualizations of customer data, as Microsoft Corporate Vice President James Phillips demonstrates exciting new capabilities available with Power BI and Microsoft’s powerful data platform, including SQL Server, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Datazen, and Azure SQL Database. In this video of Phillips’ PASS Read more

1 Comment

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

5 min read

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

4 Comments

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

2 min read

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

Real-Time Operational Analytics Using In-Memory Technology 

3 min read

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

Speeding up Business Analytics Using In-Memory Technology 

3 min read

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

3 Comments

SQL Server 2016: Advanced Capabilities without Expensive Add-Ons 

2 min read

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

1 Comment

Get the most out of SQL Server 2016 

2 min read

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