SQL Server KBs and Blogs - Site Home

Featured

| |

SQL Server KBs and Blogs

Windows Phone App for SQL Server Support Content

Posted 3 months ago

by SQL Server Support Content
- 0 Comments
Just wanted to let you all know that we recently released a WP app (SQL Support Content) that is an RSS aggregator for SQL Server Support blogs. The app essentially provides quick access to RSS feeds of various SQL Server support blogs (including PSSSQL...
SQL Server KBs and Blogs

System Center Advisor is now free

Posted 2 months ago

by SQL Server Support Content

It has been well over a year when I wrote a series of blog posts about a product called System Center Advisor. You can read these posts at this link http://blogs.msdn.com/b/psssql/archive/tags/system+center+advisor/ When Advisor was first released, this...
SQL Server KBs and Blogs

TCPChimney KB article for SQL Server updated with additional info and guidance – Please check.

Posted 2 hours ago

by SQL Server Support Content
- 0 Comments
Just wanted to update you all about the recent changes we had made to the KB article on this subject. The KB article now gives OS specific guidance on various settings that are part of 'High Speed networking features (formerly called as Scalable Networking...

| |

SQL Server KBs and Blogs

Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

Posted 5 months ago

by SQL Server Support Content

My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with data access technologies and SSIS. I had chance to work with SQL DBA who was having issues while connecting to his SQL server machine. We...
SQL Server KBs and Blogs

Windows Phone App for SQL Server Support Content

Posted 3 months ago

by SQL Server Support Content
- 0 Comments
Just wanted to let you all know that we recently released a WP app (SQL Support Content) that is an RSS aggregator for SQL Server Support blogs. The app essentially provides quick access to RSS feeds of various SQL Server support blogs (including PSSSQL...
SQL Server KBs and Blogs

Error: "The underlying provider failed on Open" in Entity Framework application

Posted 9 months ago

by SQL Server Support Content

My name is Archana CM from Microsoft SQL Developer Support team, we support many data access technologies including Entity Framework, SSIS. I had chance to work with developer who was having issues in his Entity Framework, one of the issue was while adding...
SQL Server KBs and Blogs

Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS

Posted 5 months ago

by SQL Server Support Content

Folks, yet another stumble with SSIS and Excel. This time I am using Microsoft Office 11.0 Object Library. The code runs fine on Windows Server 2003. Below is the code sample. ======================================================= using Microsoft.Office...
SQL Server KBs and Blogs

Error while creating Linked server "Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server ‘LinkedServerName’"

Posted 9 months ago

by SQL Server Support Content

When we create linked server for SQL server 2000 on SQL server 2005/SQL server 2008 /SQL server 2008 R2 sometimes we see errors w.r.t schema. In this blog, I will discuss on why we get this type of error and also the solution to fix the error message...
SQL Server KBs and Blogs

Syntax error, permission violation, or other nonspecific error

Posted 9 months ago

by SQL Server Support Content

While developing a package in BIDS 2008 if we use SNAC 10.0 driver in OLE DB Source connection, call to parameterized stored procedure fails parsing with error: Syntax error, permission violation, or other nonspecific error If we change the connection...
SQL Server KBs and Blogs

Error While Deploying SSIS 2012 project from SSDT to SSIS Catalog : System.ComponentModel.Win32Exception: A required privilege is not held by the client

Posted 9 months ago

by SQL Server Support Content

A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": System.ComponentModel.Win32Exception: A required privilege is not held by the client. I ran across this issue in one of my newly...
SQL Server KBs and Blogs

Uneven query executions with parallelism

Posted 4 months ago

by SQL Server Support Content
- 0 Comments
We had a customer who was doing stress testing on a machine with 40 cores. They designed a program that would launch multiple connections to execute the same query repeatedly based on their requirement to handle multiple concurrent executions... Read...
SQL Server KBs and Blogs

switchoffset built-in function can cause incorrect cardinality estimate

Posted 2 months ago

by SQL Server Support Content

Recently, we received a call from a customer reported that a query was slow. Upon further investigation, his query has a predicate that look like this: select * from t o where c1 >switchoffset (Convert(datetimeoffset, GETDATE()), '-04:00') ...
SQL Server KBs and Blogs

Getting a Power View report within Excel 2013 to work with SharePoint

Posted 4 months ago

by SQL Server Support Content

I was setting up my SharePoint 2013 server to be able to use an Excel 2013 workbook that had a Power View Report in it. However, when I tried opening the workbook, I got the following error: In the ULS logs of my SharePoint server that had RS installed...
SQL Server KBs and Blogs

SharePoint Adventures : Claims, Named Pipes and Kerberos

Posted 4 days ago

by SQL Server Support Content

I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post . It’s rare that I actually see a case related to the Named Pipes protocol. When I do, it is usually a customer trying to get it...
SQL Server KBs and Blogs

SQL Server 2012 partitioned table statistics update behavior change when rebuilding index

Posted 2 months ago

by SQL Server Support Content

In this blog, I will talk about a couple of things related to statistics update when rebuilding index on a partitioned table. In past versions, when you rebuild an index, you will get statistics update equivalent to FULLSCAN for free. ...
SQL Server KBs and Blogs

AppDomain unloading messages flooding the SQL Server error log

Posted 3 months ago

by SQL Server Support Content

This blog is built directly from a customer reported issue. As I helped investigate the source of the issue I thought it would be of interest to a broader audience – hopefully you find this interesting, as well. Allow me to provide some history...
SQL Server KBs and Blogs

How to monitor deadlock using extended events in SQL Server 2008 and later

Posted 25 days ago

by SQL Server Support Content

Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server. Deadlock : A deadlock occurs when there is a cyclic dependency between two or more threads...
SQL Server KBs and Blogs

Temp table caching improvement for table valued parameters in SQL Server 2012

Posted 2 months ago

by SQL Server Support Content

I wanted to point out a nice performance improvement related to table valued parameters (TVP) in SQL Server 2012. It’s not currently documented in our online documentation. But we have had customers who inquired about this. When...
SQL Server KBs and Blogs

The Case of Anti-Virus filter drive interference with File Stream Restore

Posted 1 month ago

by SQL Server Support Content

"Denzil and I were working on this issue for a customer and Denzil has been gracious enough to write-up a blog for all of us." – Bob Dorr From Denzil: I recently worked with a customer on a Database restore issue where the database being restored had...
SQL Server KBs and Blogs

System Center Advisor is now free

Posted 2 months ago

by SQL Server Support Content

It has been well over a year when I wrote a series of blog posts about a product called System Center Advisor. You can read these posts at this link http://blogs.msdn.com/b/psssql/archive/tags/system+center+advisor/ When Advisor was first released, this...
SQL Server KBs and Blogs

How to Login to SQL Server with NT AUTHORITY\SYSTEM using PSExec Tool

Posted 5 months ago

by SQL Server Support Content

PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are For example, if SQL Server has NT AUTHORITY\SYSTEM...
SQL Server KBs and Blogs

Query hint QUERYTRACEON is now documented publically

Posted 3 months ago

by SQL Server Support Content

I just wanted to put a quick note that QUERYTRACEON is now publically documented in http://support.microsoft.com/kb/2801413/en-us . If you have situations where you don’t want to enable an optimizer trace flag globally on your server instance, you...
SQL Server KBs and Blogs

Unable to register .NET framework assembly not in the supported list

Posted 2 months ago

by SQL Server Support Content

SQL Server has supported CLR usage since version 2005. But support of .NET framework assemblies within SQL Server is limited per our support policy in KB http://support.microsoft.com/kb/922672 . Some users chose to use .NET framework assemblies...
SQL Server KBs and Blogs

Installing SQL Server on Windows 8

Posted 8 months ago

by SQL Server Support Content

One of the things I often try to do is make sure I understand the experience of customers when installing new versions of SQL Server or existing versions of SQL Server on new Windows Operating Systems. So I took a recent tour of the experience installing...
SQL Server KBs and Blogs

Don’t change value of that parameter

Posted 3 months ago

by SQL Server Support Content

Parameter sniffing is a well known among SQL User community. But I have seen variations of this frequently that need a bit creative handling and solution may not that straight forward. One of the variation is that a user changes the value...
SQL Server KBs and Blogs

Integration services packages using Execute process task with WinZip32.exe fails intermittently, when run under a SQL Server Agent Job:

Posted 2 months ago

by SQL Server Support Content

This blog is about one of the known issues that anyone would run into when executing an Integration services package that contains an Execute Process Task calling a custom or 3 rd party executable scheduled through a SQL Agent job. The scheduled job fails...
SQL Server KBs and Blogs

How It Works: CMemThread and Debugging Them

Posted 5 months ago

by SQL Server Support Content

The wait type of CMemThread shows up in outputs such as sys.dm_exec_requests. This post is intended to explain what a CMemThread is and what you might be able to do to avoid the waits. The easiest way to describe a CMemThread is to talk about...
SQL Server KBs and Blogs

SQLIOSim Checksum Validations

Posted 1 month ago

by SQL Server Support Content

I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic. It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the...

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?