Microsoft SQL Server Support Blog
SQL Server information from the folks at Microsoft Support
All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...
Date: 01/25/2017
All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...
Date: 01/25/2017
Sample code to process object in Azure Analysis Services Visit this web page Data providers for...
Date: 01/25/2017
SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle
Problem: You are unable to change the size set parameter in the data source of an SSAS model that...
Date: 01/25/2017
Problem: You may see Analysis Services tabular model workspace databases remain on the Azure...
Date: 01/24/2017
The information posted originally in this blog is now out-of-date due to change in the Azure...
Date: 01/24/2017
Problem 1: When you try to design an SSRS report to get data form an Azure Analysis Services server,...
Date: 01/24/2017
When you inadvertently set SQL Server’s ‘max server memory’ to a very low value, you may experience...
Date: 08/24/2016
You are not able to start more than 4 SSAS tabular model instances with default configuration settings
I have worked on a few cases with this problem. You are not able to start more than 4 SSAS tabular...
Date: 07/27/2016
Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....
Date: 06/10/2016
Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....
Date: 05/04/2016
We have 2 customers getting an out of memory error when they backup or restore a large tabular model...
Date: 11/17/2015
Problem: When you open Excel 2016, go to the Power Pivot tab, click the Mange button to bring up...
Date: 11/09/2015
Problem: Teradata can accepts authentication of different types. Teradata can authentication user...
Date: 09/29/2015
Note: Power BI software is updated frequently. This is written based on the Power BI Personal...
Date: 08/27/2015
After the introduction of the StringStoresCompatibilityLevel property in SSAS dimension after SQL...
Date: 08/24/2015
After SQL Server 2012 is released, SSISDB provides stored procedures to create SSIS package...
Date: 08/24/2015
This is a very little known problem regarding how SSRS query designer having trouble showing cells...
Date: 08/24/2015
Marco Russo has a great article regarding optimization on high cardinality column in tabular model...
Date: 08/24/2015
Power BI allows you to upload an Excel file that contains a report that gets data from the...
Date: 06/16/2015
Recently I worked on a case regarding a COM error when opening the data source view (DSV) of an...
Date: 06/10/2015
There is a known limitation on SQL Server 2012 and 2014 SSAS tabular model. If you have a table with...
Date: 06/10/2015
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
In SQL Server Analysis Services (SSAS), you may encounter the following error message in the...
Date: 06/10/2015
When working with SQL Server Analysis Services, it is not uncommon to see this error message "An...
Date: 12/16/2014
We recently saw some cases where customer migrated their SQL Database to Basic edition. After the...
Date: 11/13/2014
This is the fifth installment in a blog series. The previous entry is located here We ended the last...
Date: 11/01/2013
This is the fourth installment in a blog series. The previous entry is located here Based on the...
Date: 11/01/2013
This is the third installment in a blog series. The previous entry is located here Based on the...
Date: 11/01/2013
The introductory post in this blog series is located here Windows Azure SQL Database has a firewall...
Date: 11/01/2013
Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database...
Date: 11/01/2013
By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our...
Date: 02/08/2012
By Gregory Suarez | Sr. Escalation Engineer | SQL Server The CTP release of the Microsoft SQL Server...
Date: 01/26/2012
The other day I was working with a customer who was in the process of developing SSIS "Control Flow"...
Date: 12/07/2011
We use certificates while setting up database mirroring for two partners that are in a workgroup or...
Date: 08/24/2011
Recently I got a case and the customer was trying to create an SSIS package to e-mail results of...
Date: 06/14/2011
In this blog I will discuss a connection timeout issue that one of my customers was having after...
Date: 06/14/2011
App using SQLClient(.NET 4.0) will automatically construct an SPN when using shared memory with windows authentication
Consider the following scenario:1) You have a .NET 4.0 application connecting to SQL Server 2005 or...
Date: 05/25/2011
ADO.NET application connecting to a mirrored SQL Server Database may timeout long before the actual connection timeout elapses, sometimes within milliseconds
Recently we had few cases, where .NET Applications, connecting to a mirrored SQL Server Database,...
Date: 05/25/2011
Consider this scenario where you have a linked server from one SQL server to another SQL Server....
Date: 02/22/2011
The Denali discs will not contain any of the Books Online content; setup only installs the help...
Date: 02/03/2011
Recently we had a case where customer wanted to stream output parameter using SNAC 11. Rather than...
Date: 01/18/2011
SharePoint 2007 using ADFS v1 authentication integrated with Reporting Services 2008 : "Object Moved" error
If SharePoint 2007 is configured to use Web SSO authentication by using ADFS v1, when trying to...
Date: 01/10/2011
When a package is being loaded, the runtime will enumerate all of the connection managers, tasks,...
Date: 12/31/2010
Recently we came across a case where the customer was running a Data Flow Task that was executing to...
Date: 12/31/2010
Recently we came across a case where the customer was developing a .NET managed application using...
Date: 11/04/2010
How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433
If you try to view a netmon trace in Netmon 3.4, you will see TDS traffic is nicely parsed for you....
Date: 06/30/2010
While debugging a dump, we commonly see various CPU registers. Each register has different purpose....
Date: 06/30/2010
Recently I have worked on couple of cases where customers were trying to use N-tier configuration of...
Date: 04/19/2010
How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2
The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL...
Date: 01/08/2010