Share via


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

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

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

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

Consider the following scenario:1) You have a .NET 4.0 application connecting to SQL Server 2005 or...

Date: 05/25/2011

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

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

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

The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL...

Date: 01/08/2010

Next>