Sites Microsoft


SQL Server as a Machine Learning Model Management System

Publié le 17 octobre 2016 sur sql server team blog
 

This post was authored by Rimma Nehme, Technical Assistant, Data Group Machine Learning Model Management If you are a data scientist, business analyst or a machine learning engineer, you need model management – a system that manages and orchestra …

Developers: Don’t miss this PASS Summit pre-conference session

Publié le 17 octobre 2016 sur sql server team blog
 

The new era of data driven and intelligent applications is here – powered by a robust data platform and a secure cloud infrastructure. The cloud gives us the power to collect and integrate data from an enormous variety of sources, to process big …

SQL Server 2016 Express Edition in Windows containers

Publié le 13 octobre 2016 sur sql server team blog
 

We are excited to announce the public availability of SQL Server 2016 Express Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our SQL Server Samples GitHub repository. This image can be used i …

1,000,000 predictions per second

Publié le 11 octobre 2016 sur sql server team blog
 

This post is by Joseph Sirosh, Corporate Vice President of the Data Group at Microsoft. Transactional Workloads + Intelligence Online transaction processing (OLTP) database applications have powered many enterprise use-cases in recent decades, with num …

PASS Summit 2016: world’s biggest SQL Server event

Publié le 10 octobre 2016 sur sql server team blog
 

PASS Summit 2016 is nearly upon us. With only 4 weeks until the big event, now is the time to register! PASS Summit 2016 is community-driven event with three days of technical sessions, networking, and professional development. Don’t miss your ch …

Feature Spotlight: Transparent Data Encryption (TDE)

Publié le 5 octobre 2016 sur sql server security blog
 

As more and more businesses go digital and towards the cloud, security is more important than ever. We’re not all security experts, but with the responsibility we assume as businesses to be entrusted with protecting our customer’s data, it …

Default auto statistics update threshold change for SQL Server 2016

Publié le 4 octobre 2016 sur css sql server engineers
 

Lately, we had a customer who contacted us for a performance issue where their server performed much worse in SQL Server 2016 following upgrade.  To show us as an example, he even captured a video.  In the video, he showed that the session th …

Columnstore Index- Should I partition my columnstore Index?

Publié le 4 octobre 2016 sur Microsoft SQL Server database engine blog
 

Table partitioning is a perfect way to manage large tables especially in the context DataWarehouse (DW) which can be very large (think TBs). The table partitioning can help both in terms of how large amount of data can be managed as well as improving t …

Released: System Center Management Pack for SQL Server and Dashboards (6.7.7.0)

Publié le 4 octobre 2016 sur microsoft sql server release services
 

We are happy to announce that updates to SQL Server and Dashboard Management Packs have been released! Downloads available: Microsoft System Center Management Pack for SQL Server 2016 Microsoft System Center Management Pack for SQL Server 2014 Microsof …

Columnstore Index: In-Memory Analytics (i.e. columnstore index) Videos from Ignite 2016

Publié le 4 octobre 2016 sur Microsoft SQL Server database engine blog
 

I presented two talks on columnstore index during Microsoft Ignite Conference 2016 in Atlanta, GA. The talks focused on describing new enhancements to columntore index in SQL Server 2016 as well as sharing three customer success stories. Here is a high …

In-Memory OLTP Videos: What it is and When/How to use it

Publié le 3 octobre 2016 sur Microsoft SQL Server database engine blog
 

In-Memory OLTP is the premier technology for optimizing the performance of transaction processing in SQL Server. Last week at Microsoft Ignite 2016 we presented two session about the In-Memory OLTP technology in SQL Server and Azure SQL Database. For t …

The SQL Server Installer Version 2: Just Install It!

Publié le 3 octobre 2016 sur microsoft sql server release services
 

Back in July, I told you about a new installation experience for SQL Server. One of our goals from the outset was to ensure we could iterate and enhance this experience as we obtained feedback from the community. Today, we are proud to announce Version …

Windows Server 2016 and SQL Server 2016: Leveraging Hyper-V large-scale VM performance for in-memory transaction processing

Publié le 3 octobre 2016 sur sql server team blog
 

This post was authored by Liang Yang, Principal Performance Engineer on the Hyper-V team and Jos de Bruijn, Senior Program Manager on the SQL Server team. With Windows Server 2016, Microsoft has significantly bumped up the Hyper-V Virtual Machine (VM) …

Released: Localized Management Packs for SQL Server Product Family (6.7.2.0)

Publié le 30 septembre 2016 sur microsoft sql server release services
 

Localized versions of System Center Management Packs for SQL Server product family have been released! The corresponding English versions were released on 6/29/2016. These include SQL Server 2016 family of Management Packs as well as other in-market MP …


Pages :