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
June 2013
(7)
May 2013
(9)
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
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...
Page 1 of 1 (3 items)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
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. ...
Page 5 of 7 (156 items)
«
3
4
5
6
7