The Curious Engineer

All blogs / Databases

Microsoft SQL Server Support Blog

learn.microsoft.com/en-us/archive/blogs/sqlblog

SQL Server information from the folks at Microsoft Support

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
111 from 16 Sep 2006 to 25 Jan 2017
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlblog/feed.xml

2017 7

  1. Azure Analysis Services – How to use a different user account in reporting and development tools
  2. Azure Analysis Services – How to switch to a different user account in reporting tools
  3. Azure Analysis Services processing/refresh sample AMO code
  4. SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle
  5. Azure Analysis Services Preview shows workspace databases not being deleted
  6. Azure Analysis Services Preview -How to add security group
  7. Azure Analysis Services connection error “The connection string is not valid”

2016 4

  1. Client unable to establish connection.. error when you configure ‘max server memory’ to a low value
  2. You are not able to start more than 4 SSAS tabular model instances with default configuration settings
  3. Excel 2016 PivotTable timeout error on SSAS data source after 1 minute
  4. Excel 2016 PivotTable timeout error on SSAS data source after 1 minute

2015 12

  1. SSAS tabular model database fails to restore due to out of memory error
  2. Excel 2016 PowerPivot MDX query designer error
  3. How to import data from a Teradata database into Excel 2013 using LDAP authentication
  4. Power BI Personal Gateway supplemental information
  5. SSAS MOLAP dimension size limit
  6. SSIS execution time out error when using SSISDB stored procedure [catalog].[create_execution]
  7. Error in MDX query result cell is not shown in SSRS query designer
  8. Performance problems on high cardinality column in tabular model
  9. Power BI PowerPivot report error after 30-second timeout
  10. SSAS DSV COM error from SSDT SSAS design Data Source View
  11. New SSAS tabular model parallel processing in SQL Server 2016 CTP2
  12. 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

2014 2

  1. What is SSAS error "An unexpected exception occurred" or 0xC1000016
  2. Timeout expired while publishing to SQL Database via SSDT

2013 5

  1. Is my query running fine in the cloud?
  2. Do I need to upgrade my DBA skills for the cloud?
  3. Call the movers at 1800-Move-To-CloudDb
  4. Is your WA SQL Database open to the world?
  5. Windows Azure SQL Database (WASD) Primer

2012 2

  1. Use Microsoft Linux ODBC Driver and Linked Server to access OLEDB Data sources on Remote Systems
  2. Use Existing MSDN C++ ODBC Samples for Microsoft Linux ODBC Driver

2011 10

  1. How to get "Microsoft.sqlserver.msxml6_interop.dll" without buying SQL Server 2008
  2. Setting up database mirroring with certificates
  3. Sending several files to several individuals using SSIS Send Email Task
  4. .NET application doesn’t connect to the SQL server after a Database mirroring failover
  5. App using SQLClient(.NET 4.0) will automatically construct an SPN when using shared memory with windows authentication
  6. ADO.NET application connecting to a mirrored SQL Server Database may timeout long before the actual connection timeout elapses, sometimes within milliseconds
  7. Executing an INSERT statement on a View in linked server
  8. No Books Online Content “in the box” for the next version of SQL Server– Denali
  9. Output parameter streaming feature in SQL Native client 11
  10. SharePoint 2007 using ADFS v1 authentication integrated with Reporting Services 2008 : "Object Moved" error

2010 8

  1. Why SSIS package runs little slower on the first run
  2. Have you checked the MaximumErrorCount in your SSIS Package ?
  3. Configuration changes needed for running SSIS 2008/2008 R2 classes in .NET4.0
  4. How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433
  5. Commonly used 32-bit CPU registers and their purpose
  6. Step by step N-tier configuration of Sync services for ADO.NET 2.0
  7. How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2
  8. Creating HTTP endpoint fails with 7850 error.

2009 10

  1. Tools of the Trade: Part IV - Developing WinDbg Extension DLLs
  2. How to connect to file-based data sources (Microsoft Access , Microsoft Excel and Text files ) from a 64 bit application
  3. SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed
  4. How to configure SQL server to listen on different ports on different IP addresses?
  5. Dealing with very large SQL Compact database files
  6. Performance: Tips for faster download of a large SQL Compact 3.5 database via Replication
  7. SQL Compact Performance: PostSyncCleanup to turn off UpdateStatistics during initial download of SQL Compact Replication
  8. Class not registered error after restoring an Analysis Services database that uses the SQL Server 2005 SQL Native Client.
  9. After Installation of .NET Framework 3.5 SP1 (or .Net framework 2.0 SP2) , SSIS packages using ODBC 3rd party drivers may fail
  10. Plan guides (plan freezing) in SQL Server 2005/2008

2007 11

  1. Reporting Services Staaaarrrrrtttt Up
  2. Working around the 4.2 billion tuple calculation limit in Analysis Services 2005 is possible in some cases...
  3. General network errors (GNEs), Timeout expired, SQL Server not found or Access Denied…
  4. SQL Server Support FAQ
  5. Tools of the Trade: Part III – Kerberos (I)
  6. Tools of the Trade: Part II – The Repro
  7. WHITEPAPER - Online Indexing Operations in SQL Server 2005
  8. SQL 2005 SP2 is available now!
  9. PART II - Data security enhancements in SQL Server 2005
  10. Tools of the Trade: Part I – Universal Data Link Files
  11. SQL Server 2000/2005 and DST changes

2006 40

  1. How can I limit the number of reboots when applying hotfixes and the like to SQL Server and OS?
  2. We upgraded our servers to Windows 2003 SP1, and now our data-driven application fails with strange errors!
  3. Tracking License Information in SQL 2005
  4. Installing MS06-061 on NT4
  5. Changing the location of Log files for SQL Server Reporting Services
  6. PART I - Data security enhancements in SQL Server 2005
  7. Why is the Initialization checkmark sometimes grayed out in Reporting Services 2005 Configuration Manager?
  8. 401.1 when trying to access reports from client machines
  9. “Unexpected error occurred” during SQL Server 2005 SP1 install.
  10. Help! All of my reports fail with an authentication failure!
  11. MSDTC and SQL Server on a cluster
  12. SQL Server and Network Attached Storage (NAS)
  13. SQL Server databases are not supported on compressed volumes
  14. SURVEY – Let us know what you think about Query Notification in SQL 2005
  15. WHITEPAPER - SQL Server 2005 Upgrade Technical Reference Guide
  16. Error message on launching Management Studio (and other tools in SQL 2005)
  17. Co-existence of SQL 2005 with SQL 2000
  18. Installing SQL 2005 using ISO images
  19. WHITEPAPER – Working with Tempdb in SQL 2005
  20. Microsoft Connect - Submit bugs for SQL Server 2005 Online
  21. WHITEPAPER – Physical Database Storage Design
  22. Why is a SPID blocking itself in sysprocesses? How is it possible?
  23. WHITEPAPER - SQL Server I/O Basics
  24. FAQ - Configuring Log Shipping in SQL Server
  25. WHITEPAPER - Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
  26. My database file is marked with automatic growth of XXXX% (e.g. 12800%). What’s going on?
  27. Why is my transaction log file growing rapidly? How do I stop it from eating up all my disk space?
  28. Installing SQL 2005 using the 2 CDs
  29. WHITEPAPER - Diagnose and Correct Errors 17883, 17884, 17887, and 17888
  30. How to change the startup accounts for SQL Server services?
  31. ENHANCEMENT - Database Mail in SQL 2005 64 bit and SP1
  32. ENHANCEMENT - Maintenance Cleanup Task and SP1
  33. SQL I/O Error Message and its resolution
  34. UPGRADE - Eval edtion to full blow SQL 2005 editions
  35. Update on SQL 2000 Service Pack 4
  36. Update on SQL 2000 Service Pack 3 and 3a
  37. WHITEPAPER - Failover Clustering for Microsoft SQL Server 2005 and Analysis Services
  38. Get technical support from Microsoft
  39. SUGGESTION BOX I – Let us know what you want us to blog about
  40. SQL 2005 Released Service Packs