Sign in
SQL Server KBs and Blogs
Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news
Options
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
2005
2005 SP2
2008
2008 R2
Adam
AlwaysON
Connectivity
Database Engine
DBVideo
Engine
How It Works
Kerberos
NONSSIS
Performance
Reporting Services
SharePoint Adventures
SQL 2005
SQL 2008
SQL 2012
SQL Server
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
SSIS
Archive
Archives
May 2013
(6)
April 2013
(13)
March 2013
(15)
February 2013
(9)
January 2013
(3)
December 2012
(16)
November 2012
(4)
October 2012
(2)
September 2012
(10)
August 2012
(6)
June 2012
(7)
May 2012
(1)
April 2012
(4)
March 2012
(5)
February 2012
(5)
January 2012
(7)
December 2011
(1)
November 2011
(2)
October 2011
(4)
September 2011
(1)
August 2011
(4)
June 2011
(2)
May 2011
(2)
February 2011
(2)
January 2011
(2)
December 2010
(2)
November 2010
(1)
June 2010
(2)
April 2010
(1)
January 2010
(2)
December 2009
(2)
August 2009
(1)
July 2009
(2)
TechNet Blogs
>
SQL Server KBs and Blogs
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
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
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...
Page 1 of 1 (2 items)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
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
Openrowset and FoxPro Database
Posted
5 months ago
by
SQL Server Support Content
I wanted to write about one of my experiences where I nearly pulled off my hair while trying to make an Openrowset call to my FoxPro Database work from my SQL Server. It was high time when we decided to move over, discard my old FoxPro databases and migrate...
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
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
How to limit connections to SQL Server until all databases are ONLINE!
Posted
5 months ago
by
SQL Server Support Content
Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this...
SQL Server KBs and Blogs
Azure SQL Database Import/Export Service - Change always brings both challenges and benefits
Posted
5 months ago
by
SQL Server Support Content
We recently upgraded the Import/Export Service to v3 of the DAC Framework ( http://technet.microsoft.com/en-us/library/ee210546.aspx ). This aligns the Import/Export service with what shipped with SQL Server 2012. Like all upgrades, this has brought both...
SQL Server KBs and Blogs
How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)
Posted
5 months ago
by
SQL Server Support Content
The NODE an operating system page, physically belongs to can be acquired using the QueryVirtualMemoryEx Windows API. SQL Server uses this API to track locality of memory allocations. This blog is a very high level view of SQL Server behavior but...
SQL Server KBs and Blogs
How It Works: SQL Server 32 bit PAE/AWE on (SQL 2005, 2008, and 2008 R2) – Not Using As Much RAM As Expected!
Posted
5 months ago
by
SQL Server Support Content
This issue was puzzling until we stepped through the code and studied it in some detail. The report was “SQL Server won’t use the physical memory I expect it to use.” Scenario: SQL Server 2008 R2, 32GB RAM - SQL only using ~22GB...
SQL Server KBs and Blogs
SQL Server 2012 Setup just got smarter…
Posted
5 months ago
by
SQL Server Support Content
For many years, I’ve been pushing for a way for our SQL Server setup to “fix itself” or “get smarter”. What I mean is that I’ve always wanted a way for setup to detect if any fixes are available online to apply as part of running the original installation...
SQL Server KBs and Blogs
AlwaysOn ERROR: Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.
Posted
5 months ago
by
SQL Server Support Content
This error surprised me when it showed up in the error log so I decided to dig into it a bit more. “Log backup for database "MyDB" on secondary replica created backup files successfully but could not ensure that a backup point has been committed...
SQL Server KBs and Blogs
FileNotFoundException with Microsoft.AnalysisServices.Xmla
Posted
5 months ago
by
SQL Server Support Content
I ran across two cases that were hitting the following Exception within SharePoint trying to run the PowerPivot Management Portal. This was located in the SharePoint ULS Log: EXCEPTION: System.IO.FileNotFoundException: Could not load file or assembly...
SQL Server KBs and Blogs
How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
Posted
5 months ago
by
SQL Server Support Content
The scenario: Table has a NTEXT column that the customer wanted converted to NVARCHAR(MAX) Data has both small and large storage for different rows Issued ALTER TABLE … ADD COLUMN …NVarCharColumn… NVARCHAR(MAX) Issued update MyTable set NVarCharColumn...
SQL Server KBs and Blogs
Analysis Services - Errors when trying to add a User as a Server Admin
Posted
6 months ago
by
SQL Server Support Content
When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the following errors: The following system error occurred: The trust relationship between the primary domain and the trusted domain failed. (Microsoft.AnalysisServices...
SQL Server KBs and Blogs
Ack! Where the heck did Azure Reporting and Data Sync go??!?!
Posted
6 months ago
by
SQL Server Support Content
As you might have noticed, we have been moving more and more of our portal functionality to the new HTML5 portal, plus all of our new features are showing up there and not in the original Silverlight portal. Unfortunately, we are stuck for some period...
SQL Server KBs and Blogs
Using a Windows Azure worker role to generate reports using Azure Reporting
Posted
6 months ago
by
SQL Server Support Content
While trying to reproduce an issue in Azure Reporting, I found myself building a simple worker role that generated a report using the ReportViewer control in server mode. I found a couple gaps in the overall content available, so I thought I would try...
SQL Server KBs and Blogs
How Can Reference Counting Be A Leading Memory Scribbler Cause?
Posted
6 months ago
by
SQL Server Support Content
The concept of the memory scribbler comes up quite a bit in support. The term can often be over used but I ran into a specific example that commonly fools people, including support engineers. The random nature and even the resulting...
SQL Server KBs and Blogs
Microsoft CSS @ PASS Summit 2012
Posted
6 months ago
by
SQL Server Support Content
This is a little later than we normally do it, but better late than never! During November 6th-9th, the US PASS Summit 2012 will be held in Seattle, Washington at the Seattle Convention Center. The Microsoft CSS team has a long history with...
SQL Server KBs and Blogs
Worker thread governance coming to Azure SQL Database
Posted
6 months ago
by
SQL Server Support Content
Starting with the service update that went out recently, soft throttling on worker threads is changing. Over the next few months, soft throttling will eventually be replaced by worker thread governance. In the meantime, users may see requests failing...
SQL Server KBs and Blogs
Could not load package because of error 0x80070002 while upgrading from SSIS 2008 to SSIS 2012
Posted
7 months ago
by
SQL Server Support Content
When doing an In-place upgrade from Microsoft SQL Server 2008 or 2008 R2 to SQL Server 2012, be aware of this little caveat with SSIS. Last week I upgraded (note, I did an in-place upgrade and not a side-by-side installation) my Sql 2008 instance to Sql...
SQL Server KBs and Blogs
T-SQL Update Takes Much Longer Than The Matching Select Statement
Posted
7 months ago
by
SQL Server Support Content
I realize the title is generic and that is because the problem is generic. On the surface it would not surprise me that an update takes longer than a select. (A little bit anyway.) There is logging, updates to index rows, triggers, replication...
SQL Server KBs and Blogs
SQL Server: Correlating Timestamps From Various Data Points
Posted
8 months ago
by
SQL Server Support Content
I was looking at data from a customer, in a different time zone (UTC+1) from mine, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging. Some times are local to the SQL...
SQL Server KBs and Blogs
Revisiting Inside Tempdb….
Posted
8 months ago
by
SQL Server Support Content
As I prepare for my next PASS Summit talk for the upcoming 2012 Summit, Inside SQLOS 2012 I was reviewing my talk from last year, Inside Tempdb , and some of the questions and feedback I received. They say it is never too late to provide all the facts...
SQL Server KBs and Blogs
Bulk Insert and Kerberos
Posted
8 months ago
by
SQL Server Support Content
I recently worked on two Bulk Insert cases that dealt with Kerberos. My favorite past time! In both cases, the customers were hitting the following error: Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file "<file name>"...
SQL Server KBs and Blogs
How It Works: SQL Server AlwaysOn Lease Timeout
Posted
8 months ago
by
SQL Server Support Content
The lease is used between the SQL Server resource DLL and the SQL Server instance to prevent split-brain from occurring for the availability group (AG). The lease is a standard signaling mechanism between the SQL Server resource DLL and the SQL Server...
SQL Server KBs and Blogs
AdomdConnectionException using PerformancePoint hitting Analysis Services
Posted
8 months ago
by
SQL Server Support Content
I was working with a customer who was encountering problems trying to use a PerformancePoint Dashboard against an Analysis Services Instance. The issue came down to the Claims to Windows Token Service (C2WTS) configuration. This is used to take...
Page 3 of 6 (146 items)
1
2
3
4
5
»