Microsoft SQL Server Support Blog
SQL Server information from the folks at Microsoft Support
Azure Analysis Services – How to use a different user account in reporting and development tools
All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...
Date: 01/25/2017
Azure Analysis Services – How to switch to a different user account in reporting tools
All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure...
Date: 01/25/2017
Azure Analysis Services processing/refresh sample AMO code
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
Azure Analysis Services Preview shows workspace databases not being deleted
Problem: You may see Analysis Services tabular model workspace databases remain on the Azure...
Date: 01/24/2017
Azure Analysis Services Preview -How to add security group
The information posted originally in this blog is now out-of-date due to change in the Azure...
Date: 01/24/2017
Azure Analysis Services connection error “The connection string is not valid”
Problem 1: When you try to design an SSRS report to get data form an Azure Analysis Services server,...
Date: 01/24/2017
Client unable to establish connection.. error when you configure ‘max server memory’ to a low value
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 timeout error on SSAS data source after 1 minute
Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....
Date: 06/10/2016
Excel 2016 PivotTable timeout error on SSAS data source after 1 minute
Excel 2016 PivotTable report may generate an error message after running the report for 1 minute....
Date: 05/04/2016
SSAS tabular model database fails to restore due to out of memory error
We have 2 customers getting an out of memory error when they backup or restore a large tabular model...
Date: 11/17/2015
Excel 2016 PowerPivot MDX query designer error
Problem: When you open Excel 2016, go to the Power Pivot tab, click the Mange button to bring up...
Date: 11/09/2015
How to import data from a Teradata database into Excel 2013 using LDAP authentication
Problem: Teradata can accepts authentication of different types. Teradata can authentication user...
Date: 09/29/2015
Power BI Personal Gateway supplemental information
Note: Power BI software is updated frequently. This is written based on the Power BI Personal...
Date: 08/27/2015
SSAS MOLAP dimension size limit
After the introduction of the StringStoresCompatibilityLevel property in SSAS dimension after SQL...
Date: 08/24/2015
SSIS execution time out error when using SSISDB stored procedure [catalog].[create_execution]
After SQL Server 2012 is released, SSISDB provides stored procedures to create SSIS package...
Date: 08/24/2015
Error in MDX query result cell is not shown in SSRS query designer
This is a very little known problem regarding how SSRS query designer having trouble showing cells...
Date: 08/24/2015
Performance problems on high cardinality column in tabular model
Marco Russo has a great article regarding optimization on high cardinality column in tabular model...
Date: 08/24/2015
Power BI PowerPivot report error after 30-second timeout
Power BI allows you to upload an Excel file that contains a report that gets data from the...
Date: 06/16/2015
SSAS DSV COM error from SSDT SSAS design Data Source View
Recently I worked on a case regarding a COM error when opening the data source view (DSV) of an...
Date: 06/10/2015
New SSAS tabular model parallel processing in SQL Server 2016 CTP2
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
What is SSAS error "An unexpected exception occurred" or 0xC1000016
When working with SQL Server Analysis Services, it is not uncommon to see this error message "An...
Date: 12/16/2014
Timeout expired while publishing to SQL Database via SSDT
We recently saw some cases where customer migrated their SQL Database to Basic edition. After the...
Date: 11/13/2014
Is my query running fine in the cloud?
This is the fifth installment in a blog series. The previous entry is located here We ended the last...
Date: 11/01/2013
Do I need to upgrade my DBA skills for the cloud?
This is the fourth installment in a blog series. The previous entry is located here Based on the...
Date: 11/01/2013
Call the movers at 1800-Move-To-CloudDb
This is the third installment in a blog series. The previous entry is located here Based on the...
Date: 11/01/2013
Is your WA SQL Database open to the world?
The introductory post in this blog series is located here Windows Azure SQL Database has a firewall...
Date: 11/01/2013
Windows Azure SQL Database (WASD) Primer
Are you a SQL Server DBA who is now being asked to migrate databases to Windows Azure SQL Database...
Date: 11/01/2013
Use Microsoft Linux ODBC Driver and Linked Server to access OLEDB Data sources on Remote Systems
By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our...
Date: 02/08/2012
Use Existing MSDN C++ ODBC Samples for Microsoft Linux ODBC Driver
By Gregory Suarez | Sr. Escalation Engineer | SQL Server The CTP release of the Microsoft SQL Server...
Date: 01/26/2012
How to get "Microsoft.sqlserver.msxml6_interop.dll" without buying SQL Server 2008
The other day I was working with a customer who was in the process of developing SSIS "Control Flow"...
Date: 12/07/2011
Setting up database mirroring with certificates
We use certificates while setting up database mirroring for two partners that are in a workgroup or...
Date: 08/24/2011
Sending several files to several individuals using SSIS Send Email Task
Recently I got a case and the customer was trying to create an SSIS package to e-mail results of...
Date: 06/14/2011
.NET application doesn’t connect to the SQL server after a Database mirroring failover
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
Executing an INSERT statement on a View in linked server
Consider this scenario where you have a linked server from one SQL server to another SQL Server....
Date: 02/22/2011
No Books Online Content “in the box” for the next version of SQL Server– Denali
The Denali discs will not contain any of the Books Online content; setup only installs the help...
Date: 02/03/2011
Output parameter streaming feature in SQL Native client 11
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
Why SSIS package runs little slower on the first run
When a package is being loaded, the runtime will enumerate all of the connection managers, tasks,...
Date: 12/31/2010
Have you checked the MaximumErrorCount in your SSIS Package ?
Recently we came across a case where the customer was running a Data Flow Task that was executing to...
Date: 12/31/2010
Configuration changes needed for running SSIS 2008/2008 R2 classes in .NET4.0
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
Commonly used 32-bit CPU registers and their purpose
While debugging a dump, we commonly see various CPU registers. Each register has different purpose....
Date: 06/30/2010
Step by step N-tier configuration of Sync services for ADO.NET 2.0
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