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
1 month 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
Use Existing MSDN C++ ODBC Samples for Microsoft Linux ODBC Driver
Posted
over 1 year ago
by
SQL Server Support Content
By Gregory Suarez | Sr. Escalation Engineer | SQL Server The CTP release of the Microsoft SQL Server ODBC Driver for Linux ( http://www.microsoft.com/download/en/details.aspx?id=28160 ) opens many opportunities for Red Hat Enterprise Linux...
SQL Server KBs and Blogs
How to get "Microsoft.sqlserver.msxml6_interop.dll" without buying SQL Server 2008
Posted
over 2 years ago
by
SQL Server Support Content
The other day I was working with a customer who was in the process of developing SSIS "Control Flow" custom component. He was having an issue in compiling/building his code in Visual Studio and getting Warning about the build process about indirect...
SQL Server KBs and Blogs
Setting up database mirroring with certificates
Posted
over 2 years ago
by
SQL Server Support Content
We use certificates while setting up database mirroring for two partners that are in a workgroup or in non-trusted domains. The idea is to create a certificate on each partner, export it to the other and then setup a login to use that certificate...
SQL Server KBs and Blogs
Sending several files to several individuals using SSIS Send Email Task
Posted
over 2 years ago
by
SQL Server Support Content
Recently I got a case and the customer was trying to create an SSIS package to e-mail results of several files to several individuals and he wanted to know if there is any inbuilt task in SSIS out of the box that can do this. He was saving few files in...
SQL Server KBs and Blogs
.NET application doesn’t connect to the SQL server after a Database mirroring failover
Posted
over 2 years ago
by
SQL Server Support Content
In this blog I will discuss a connection timeout issue that one of my customers was having after failing over the mirror database. For better understanding of the issue let me discuss some key terms/concepts of database mirroring before I get into the...
SQL Server KBs and Blogs
App using SQLClient(.NET 4.0) will automatically construct an SPN when using shared memory with windows authentication
Posted
over 2 years ago
by
SQL Server Support Content
Consider the following scenario: 1) You have a .NET 4.0 application connecting to SQL Server 2005 or SQL Server 2008 edition (including SQL Server Express Edition) with ADO.NET using SQLClient provider. 2) Only Shared Memory is enabled for protocols for...
SQL Server KBs and Blogs
ADO.NET application connecting to a mirrored SQL Server Database may timeout long before the actual connection timeout elapses, sometimes within milliseconds
Posted
over 2 years ago
by
SQL Server Support Content
Recently we had few cases, where .NET Applications, connecting to a mirrored SQL Server Database, using ADO.NET SQLClient provider, in a mirrored SQL Server 2005 or SQL Server 2008 instance scenario, may intermittently fail with the following error message...
SQL Server KBs and Blogs
Executing an INSERT statement on a View in linked server
Posted
over 2 years ago
by
SQL Server Support Content
Consider this scenario where you have a linked server from one SQL server to another SQL Server. Both the SQL Servers are SQL Server 2008 SP2 on Windows 2008. Say the two SQL Servers are Server A and Server B. Linked server from Server A to Server B is...
SQL Server KBs and Blogs
No Books Online Content “in the box” for the next version of SQL Server– Denali
Posted
over 2 years ago
by
SQL Server Support Content
The Denali discs will not contain any of the Books Online content; setup only installs the help viewer and a handful of utility .chm files. All of the BOL documentation will by default come from online (MSDN). With the Microsoft strategy moving...
SQL Server KBs and Blogs
Output parameter streaming feature in SQL Native client 11
Posted
over 2 years ago
by
SQL Server Support Content
Recently we had a case where customer wanted to stream output parameter using SNAC 11. Rather than let the good research go to waste, we're posting the steps here. It’s not optimum or sometimes not even possible to define large buffer ...
SQL Server KBs and Blogs
SharePoint 2007 using ADFS v1 authentication integrated with Reporting Services 2008 : "Object Moved" error
Posted
over 2 years ago
by
SQL Server Support Content
If SharePoint 2007 is configured to use Web SSO authentication by using ADFS v1 , when trying to render a RS 2008 Report in SharePoint integrated mode, the following error occurs when clicking on the report: An unexpected error occured while connecting...
SQL Server KBs and Blogs
Why SSIS package runs little slower on the first run
Posted
over 3 years ago
by
SQL Server Support Content
When a package is being loaded, the runtime will enumerate all of the connection managers, tasks, and data flow components on the system. It does this by looking in certain directories (under <sql>\100\dts), and also by looking in COM registry for...
SQL Server KBs and Blogs
Have you checked the MaximumErrorCount in your SSIS Package ?
Posted
over 3 years ago
by
SQL Server Support Content
Recently we came across a case where the customer was running a Data Flow Task that was executing to it's completion without transferring any data. We finally figured out the whys. Rather than let the good research go to waste, we're posting the...
SQL Server KBs and Blogs
Configuration changes needed for running SSIS 2008/2008 R2 classes in .NET4.0
Posted
over 3 years ago
by
SQL Server Support Content
Recently we came across a case where the customer was developing a .NET managed application using SQL Server Integration Services (SSIS) object model. The managed application was behaving differently in different versions of Visual Studio (2008...
SQL Server KBs and Blogs
How to enable TDS parser to display TDS frames when SQLServer is listening on port other than default 1433
Posted
over 3 years ago
by
SQL Server Support Content
If you try to view a netmon trace in Netmon 3.4, you will see TDS traffic is nicely parsed for you. You will see a display similar to this: The parsing works nicely because SQLServer is listening on default tcp port 1433. But, if your SQLServer is listening...
SQL Server KBs and Blogs
Commonly used 32-bit CPU registers and their purpose
Posted
over 3 years ago
by
SQL Server Support Content
While debugging a dump, we commonly see various CPU registers. Each register has different purpose. I am trying to put them together in one place for your easy reference. You can list all the registers in windbg with “r” command: Please...
SQL Server KBs and Blogs
Step by step N-tier configuration of Sync services for ADO.NET 2.0
Posted
over 3 years ago
by
SQL Server Support Content
Recently I have worked on couple of cases where customers were trying to use N-tier configuration of Sync services for ADO.NET on IIS. In this blog we will use IIS and setup N-tier configuration of sync service for ADO.NET version 2.0 which comes as part...
SQL Server KBs and Blogs
How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2
Posted
over 3 years ago
by
SQL Server Support Content
The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL Server 2008. SQL Server 2008 Setup for standalone instance will install the .NET Framework 3.5 SP1 if it is not already installed. In Windows Server 2008 R2...
SQL Server KBs and Blogs
Creating HTTP endpoint fails with 7850 error.
Posted
over 3 years ago
by
SQL Server Support Content
Creating a HTTP endpoint in SQL Server 2005 or SQL Server 2008 may fail with the following error messages: Msg 7850, Level 16, State 1, Line 1 The user 'domain\myuser' does not have permission to register endpoint 'training_sql_endpoint' on the...
SQL Server KBs and Blogs
Tools of the Trade: Part IV - Developing WinDbg Extension DLLs
Posted
over 4 years ago
by
SQL Server Support Content
A WinDbg extension DLL is set of exported callback functions for implementing user defined commands to extract specific customized information from the memory dump(s). Extension DLLs are loaded by debugger engine and can provide extra functionality of...
SQL Server KBs and Blogs
How to connect to file-based data sources (Microsoft Access , Microsoft Excel and Text files ) from a 64 bit application
Posted
over 4 years ago
by
SQL Server Support Content
The Issue: A 64-bit process can load only 64-bit components in it's process boundary. Same is true for a 32-bit process also. So, if your application is 64 bit, you will need a 64-bit provider or driver to connect to Microsoft Access (mdb, accdb) or...
SQL Server KBs and Blogs
SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed
Posted
over 4 years ago
by
SQL Server Support Content
There is a known issue with SQL Server setup when MSXML6 component update has been installed on the system. The problem described in KB 968749 http://support.microsoft.com/kb/968749 has raised a lot of concerns by customers. The concerns are related...
SQL Server KBs and Blogs
How to configure SQL server to listen on different ports on different IP addresses?
Posted
over 4 years ago
by
SQL Server Support Content
Technorati Tags: SQL Port The following post describes how you can configure your SQL Server to listen on a different port(s) on different IP addresses that are available on your system. This procedure applies to both SQL server 2005 and SQL server...
SQL Server KBs and Blogs
Dealing with very large SQL Compact database files
Posted
over 4 years ago
by
SQL Server Support Content
Working with very large SQL Compact files, you may run into two issues: 1. Manipulating a large SQL Compact database in VS 2008 IDE requires a hotfix http://support.microsoft.com/kb/968436 Error message when you use the Visual Studio...
SQL Server KBs and Blogs
Leveraging a Hadoop cluster from SQL Server Integration Services (SSIS)
Posted
4 months ago
by
SQL Server Support Content
With the explosion of data, the open source Apache™ Hadoop™ Framework is gaining traction thanks to its huge ecosystem that has arisen around the core functionalities of Hadoop distributed file system (HDFS™) and Hadoop Map Reduce. As of today, being...
Page 3 of 6 (146 items)
1
2
3
4
5
»