Sites Microsoft


Azure SQL Data Warehouse opens for Limited Public Preview

Publié le 24 juin 2015 sur sql server team blog
 

By Tiffany Wissner, Senior Director, Data Platform At the Build conference in April, we announced Azure SQL Data Warehouse, our new enterprise-class elastic data warehouse-as-a-service. Today, we’re pleased to announce that Azure SQL Data Warehou …

SSDT June 2015 Preview

Publié le 24 juin 2015 sur sql server data tools team blog
 

Today we announce the latest preview of SQL Server Data Tools (SSDT). It is the first release from our fast-train preview program. Fast-train preview program implies that SSDT will be on a frequent release cadence, which starts today with the June 2015 …

Partial results in a query of a clustered columnstore index in SQL Server 2014

Publié le 23 juin 2015 sur microsoft sql server release services
 

As part of continuous improvement of the quality of SQL Server, we add new tests to stress the features in various ways. We recently discovered a corruption issue in clustered columnstore index in SQL Server 2014 as part of new stress tests. After anal …

Cumulative Update #1 for SQL Server 2014 SP1

Publié le 22 juin 2015 sur microsoft sql server release services
 

Dear Customers, The first cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Support site. Cumulative Update 1 contains all hotfixes in the initial release of SQL Server 2014 SP1 and all hotfixes in…(read …

Cumulative Update #8 for SQL Server 2014 RTM

Publié le 22 juin 2015 sur microsoft sql server release services
 

Dear Customers, The 8 th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 8 contains all the SQL Server 2014 RTM hotfixes which have been available since the initial…(rea …

Not able to use PFX format certificate in SQL Server?

Publié le 18 juin 2015 sur css sql server engineers
 

If you have a security certificate in PFX format that is generated by Microsoft Certificate store, you can not use it directly in SQL Server.   But you can use PVKConverter.exe tool to convert to PVK/DER format that can be used by SQL Server. …

Power BI PowerPivot report error after 30-second timeout

Publié le 16 juin 2015 sur microsoft sql server support blog
 

Power BI allows you to upload an Excel file that contains a report that gets data from the PowerPivot data model. When you refresh the report on the Power BI report gallery, you may get an error after 30 seconds An error occurred while working on the D …

Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement

Publié le 16 juin 2015 sur css sql server engineers
 

  In a previous blog, I talked about SQL 2014’s new Cardinality Estimator (new CE) and trace flags 9481 and 2312 can be used to control which version of Cardinality Estimator is used. In this blog, I will modify a real scenario customer hit …

Developing Web Apps using Always Encrypted

Publié le 12 juin 2015 sur sql server security blog
 

In our first post on the Always Encrypted technology, Getting Started with Always Encrypted, we showed how to develop a simple console app using Always Encrypted to protect sensitive information. In this article, we will demonstrate the process of deve …

SSAS DSV COM error that breaks SSDT SSAS design backward compatibility

Publié le 10 juin 2015 sur microsoft sql server support blog
 

Recently I worked on a case regarding a COM error when opening the data source view (DSV) of an Analysis Services multidimensional project.  Error HRESULT E_FAIL has been returned from a call to a COM component. (msddsp)    Below is the …

Operating System Error (665 – File System Limitation) Not just for DBCC Anymore

Publié le 10 juin 2015 sur css sql server engineers
 

The operating system error 665, indicating a file system limitation has been reached continues to gain momentum beyond DBCC snapshot files.    Over the last ~18 months I have reproduced issues with standard database files, BCP output, ba …

New SSAS tabular model parallel processing in SQL Server 2016 CTP2

Publié le 10 juin 2015 sur microsoft sql server support blog
 

There is a known limitation on SQL Server 2012 and 2014 SSAS tabular model. If you have a table with multiple partitions, when you process these partitions, only one partition can be processed in the same table. Partitions from different tables can be …

PowerPivot scheduled data refresh should use an Oracle account that does not have password expiration

Publié le 10 juin 2015 sur microsoft sql server support blog
 

I have a customer who encountered a server hang issue on the PowerPivot SSAS instance. No PowerPivot reports can run on the SharePoint site. The customer cannot even connect to the PowerPivot SSAS instance using SSMS or any client tool. The connection …

SSAS error “The operation has been cancelled because there is not enough memory for the application” when there is still a lot of memory available

Publié le 10 juin 2015 sur microsoft sql server support blog
 

In SQL Server Analysis Services (SSAS), you may encounter the following error message in the Logmsmdsrv.log file. Error(s): Server: The operation has been cancelled because there is not enough memory for the application. If using a 32-bit version of th …


Pages :