SQL Server KBs and Blogs - Site Home

Featured

| |

SQL Server KBs and Blogs

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

Posted 28 days 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

System Center Advisor is now free

Posted 3 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 4 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

High Availability for SQL Server Replication using Database Mirroring

Posted over 1 year ago

by SQL Server Support Content

Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring : Highlights of this video blog :- 1. Transactional Replication Overview. 2. Database Mirroring Overview 3. Replication with...
SQL Server KBs and Blogs

Missing MSI's/MSP's error during SQL Server Patching

Posted over 1 year ago

by SQL Server Support Content

In this video blog, we would walk you through some tips and methods to troubleshoot Missing MSI's/MSP's error during SQL Server Patching or installation. Highlights of this video blog :- 1. What are MSI's/MSP's 2. Location of Setup logs and log...
SQL Server KBs and Blogs

Optimized Bulk Loading of Data into Oracle

Posted over 1 year ago

by SQL Server Support Content

SQL Server 2008 and SQL Server 2008 R2 (Enterprise editions) support bulk loading Oracle data using Integration Services packages with the Microsoft Connector for Oracle by Attunity. For SQL Server 2005 and the non-Enterprise editions of SQL Server 2008...
SQL Server KBs and Blogs

Bulk insert command fails to insert the correct characters?

Posted over 1 year ago

by SQL Server Support Content

Bulk insert command is not inserting correct characters from a flat file into the table. For instance, the character “Ñ” is displayed as “+æ“ after getting imported in the table. In other words the characters from...
SQL Server KBs and Blogs

Can TLS certificate be used for SQL Server encryption on the wire???

Posted over 1 year ago

by SQL Server Support Content

During our recent interactions with a few customers, we were asked following questions about TLS certificates with SQL server: 1. Can TLS certificate be used with SQL Server 2008 for server-side encryption? 2. If Yes, How? To start with, let’s...
SQL Server KBs and Blogs

Failure of SQL Server 2008 Installation due to MSI error

Posted over 1 year ago

by SQL Server Support Content

Issue: Installation of SQL Server 2008 might fails with below error on 64-Bit Operating system. MSI Error: 1719 The Windows Installer Service could not be accessed. This can occur if you are running Windows in safe mode, or if Windows Installer...
SQL Server KBs and Blogs

SQL Server Replication

Posted over 1 year ago

by SQL Server Support Content

Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the “Replication in SQL server”. Highlights of the blog:- What is replication? Why we should use Replication? What is replication...
SQL Server KBs and Blogs

INF: SQL Server Compressed backup may work fine if disk space is less and may fail if disk space is more

Posted over 1 year ago

by SQL Server Support Content

In this article We are going to discuss about pre-allocation scenarios and their aftermaths for SQL Server 2008 compressed backup. We will try to simulate that compressed backup may succeed if disk space is less and may fail if disk space is more depending...
SQL Server KBs and Blogs

An interesting find about Temp tables in SQL Server

Posted over 1 year ago

by SQL Server Support Content

I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL statements, and sending them to the SQL Database engine for execution. However...
SQL Server KBs and Blogs

INF: AlwaysON – The secondary database doesn't come automatically when the primary instance of SQL Server goes down

Posted over 1 year ago

by SQL Server Support Content

In this blog we would discuss about behavior of AlwaysON where the secondary database doesn't come automatically when the primary instance goes down. The secondary database goes into Resolving state. On the failover cluster manager the resource appears...
SQL Server KBs and Blogs

INF: Limitations for SQL Agent when you have many Jobs running in SQL simultaneously

Posted over 1 year ago

by SQL Server Support Content

Recently I have had a customer complaining that when he is adding more subscriptions to his publication, distribution agent job for the newly added subscriptions would not start. And when he tried to start the distribution agent job manually, it...
SQL Server KBs and Blogs

Table partitioning concepts with sliding window example

Posted over 1 year ago

by SQL Server Support Content

Highlights of this video blog :- 1. What are Partitioned tables & benefits 2. Building Blocks of Partitioning 3. Partitioned Table Operations 4. Demo 5. Best Practices To watch the video in better quality please check the link: - http://channel9...
SQL Server KBs and Blogs

SSL Encryption for SQL Server

Posted over 1 year ago

by SQL Server Support Content

Highlights of this video blog :- 1. What is SSL Encryption 2. Why is it needed 3. Configuring SSL Encryption for SQL Server 4. Demo To watch the video in better quality, please check the link: - http://channel9.msdn.com/posts/SSL-Encryption-for...
SQL Server KBs and Blogs

What's Data Collector

Posted over 1 year ago

by SQL Server Support Content

Highlights of this video blog :- 1. What is Data collector 2. Architecture 3. MDW(Management data warehouse) setup 4. System Data Collection Presented By: - Manish Upadhyay,SE,Microsoft GTSC Reviewed By: - Karthick Krishnamurthy,TL,Microsoft GTSC...
SQL Server KBs and Blogs

INF: You may not be able to change the Design of a Table (Insert or Delete a Column) using GUI.

Posted over 1 year ago

by SQL Server Support Content

We recently worked on an issue where modifying a Table from the GUI was not allowed even though the account had read – write permissions. So, we are sharing our findings below: Let’s say you have a SQL account ‘ Account_1’ with following Database...
SQL Server KBs and Blogs

Use Microsoft Linux ODBC Driver and Linked Server to access OLEDB Data sources on Remote Systems

Posted over 1 year ago

by SQL Server Support Content

By Gregory Suarez | Sr. Escalation Engineer | SQL Server I was recently working with one of our customers when he indicated it would be great if the Microsoft Linux ODBC driver could be used to access his other database systems - in addition to Microsoft...
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

SSIS: Error 0x80070020 Unable to access the package file. Make sure the file exists and you have permission to access it.. The process cannot access the file because it is being used by another process.

Posted over 1 year ago

by SQL Server Support Content

This is my second blog and it is about a very interesting scenario that I came across when working with a SSIS package developer. The design of the package consist of one main parent package having several "Execute Package Task" that calls multiple...
SQL Server KBs and Blogs

Every Bug is a Microsoft bug until proven otherwise

Posted over 1 year ago

by SQL Server Support Content

Holiday season provides us an opportunity to take a break from our hectic schedules in GTSC and ponder over some interesting cases in past few months. I had been a strong believer in the fact that a lot of bugs attributed to Microsoft are not Microsoft’s...
SQL Server KBs and Blogs

Policy Based Management

Posted over 1 year ago

by SQL Server Support Content

Check our video blog, and get answers to your queries related to "Policy Based Management" in SQL server. This feature is helpful to ensure compliance at SQL server end. This blog will cover: What is Policy Based Management? What is facets? How we can...
SQL Server KBs and Blogs

Package Configuration File Editor for SSIS available for download

Posted over 1 year ago

by SQL Server Support Content

A new tool for SSIS 2008 and 2008 R2 is now available for editing package configuration files. The Package Configuration File Editor identifies configuration paths that are not valid and enables you to correct the paths without having to open the package...
SQL Server KBs and Blogs

Hey Mr. SSMS! Why I am unable to open .sql files using by double click

Posted over 1 year ago

by SQL Server Support Content

For SQL Server 2008/2008 R2 installed on Win 7/Windows Server 2008, if we attempt to open .sql files with SSMS closed, the file does not open up in Management studio. The SSMS windows will just open (as below) but the file will not be displayed. If the...
SQL Server KBs and Blogs

NORECOMPUTE : Can lead to SQL server performance degradation!!

Posted over 1 year ago

by SQL Server Support Content

ANALYSIS :- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat updates, here’s a snippet of what we noticed in SQL Server 2005 Vs SQL Server 2008 on the same machine. SQL 2008 ========= EventID Occurrences Description...
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

Data migration of large Sybase tables may cause TEMPDB errors

Posted over 2 years ago

by SQL Server Support Content

Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' segment is full/has no free extents. ...

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support by product

Other support links

Not an IT pro?