TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
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
2008
2008 R2
ADAM
Alwayson
Connectivity
database engine
DBVideo
Engine
How It Works
Kerberos
NONSSIS
Performance
Reporting Services
SharePoint
SharePoint Adventures
SharePoint Integration
SQL 2005
SQL 2008
SQL 2012
SQL 2014
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
SSIS
Archive
Archives
December 2014
(4)
November 2014
(5)
October 2014
(3)
September 2014
(1)
August 2014
(4)
July 2014
(5)
June 2014
(5)
May 2014
(5)
April 2014
(12)
March 2014
(3)
February 2014
(4)
January 2014
(2)
December 2013
(2)
November 2013
(14)
October 2013
(12)
September 2013
(6)
August 2013
(13)
July 2013
(10)
June 2013
(9)
May 2013
(9)
April 2013
(13)
March 2013
(15)
February 2013
(13)
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)
April 2011
(1)
February 2011
(2)
January 2011
(2)
December 2010
(2)
November 2010
(1)
August 2010
(1)
June 2010
(2)
April 2010
(1)
February 2010
(2)
January 2010
(2)
December 2009
(2)
August 2009
(1)
July 2009
(2)
August, 2013
TechNet Blogs
»
SQL Server KBs and Blogs
»
August, 2013
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
No blog posts have yet been created.
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Timeout Error from Excel Services - “Unable to refresh data for a data connection in the workbook”
Posted
over 1 year ago
by
SQL Server Support Content
Applies to: SharePoint 2010 Excel Services, SQL Server 2005, 2008, 2008 R2, 2012 Analysis Services If you ever get the following error while using Excel Services to kick off a document to query the data from an Analysis Services database, you may wonder...
Error trying to access SharePoint List from Power Query
Posted
over 1 year ago
by
SQL Server Support Content
When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID, you may see the following output in your query: DataFormat.Error: OData: The given URL neither points to an OData Service or a feed: ‘https://login.microsoftonline...
How It Works: SQL Server 2012 Database Engine Task Scheduling
Posted
over 1 year ago
by
SQL Server Support Content
Over the years the SQL Server scheduling algorithms have been documented in various publications. Specifically, ‘ The Guru’s Guide to SQL Server Architecture and Internals’ has a chapter, written by the scheduler developer (Sameer) and Ken; and...
Oops… I forgot to leave an empty SQL table partition, how can I split it with minimal IO impact?
Posted
over 1 year ago
by
SQL Server Support Content
One of the several advantages you get with partitioning a very large table is the ability to add or remove partitions instantaneously to help you with sliding window scenarios. However there are caveats if best practices aren’t followed. If the right...
Optimizing partition split when the partition is not empty
Posted
over 1 year ago
by
SQL Server Support Content
Some of our Field Engineers, Kal Yella and Denzil Ribeiro ( @DenzilRibeiro ) have posted a blog that discusses how to optimize adding a partition when either the right most, or left most partition is not empty.. It is well worth the read, so we...
Power View display issues with Page Viewer Web Part
Posted
over 1 year ago
by
SQL Server Support Content
I ran into two separate issues this week that both dealt with displaying a Power View report through a Page Viewer Web Part within a SharePoint page in SharePoint 2013. The resolution to both were the same, so I thought I would lump them both into this...
Correlating XE query_hash and query_plan_hash to sys.dm_exec_query_stats in order to retrieve Execution plans for high Resource statements.
Posted
over 1 year ago
by
SQL Server Support Content
Extended events is a powerful feature that allows us to troubleshoot performance issues within SQL Server. One of the ways you can utilize extended events to aggregate statements is described in a blog post below by Bob Dorr SQL Server 2012: RML, XEvent...
ImplicitCommitSync property not working for Access DSN
Posted
over 1 year ago
by
SQL Server Support Content
My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with SSIS. We had a scenario where one of my customers was facing an issue with saving some of the property values in DSN. Here is the blog which...
System.ComponentModel.Win32Exception: A required privilege is not held by the client while Deploying SSIS Project
Posted
over 1 year 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. We had a scenario where one of my customer was facing an issue while deploying SSIS Project in SQL Server...
Service status watcher in SQL Server Management Studio – How it works
Posted
over 1 year ago
by
SQL Server Support Content
Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) - Object Explorer shows the service status for SQL Server and SQL Agent service? We recently worked with a customer on a issue related to this and thought that this...
Back to Basics: SQL Parameter Sniffing due to Data Skews
Posted
over 1 year ago
by
SQL Server Support Content
In Denzil’s recent post about correlating XE query_hash he alluded to a relatively common issue. Most of the time a proc will run just fine, but sometimes it will run very slow. This is an issue that I tend to be seeing often as of late...
When is throttling in Windows Azure SQL Database really throttling….
Posted
over 1 year ago
by
SQL Server Support Content
During the course of this year I have spoken at several customer and internal events on troubleshooting the Windows Azure SQL Database environment. As I built my presentations, one of the confusing topics I found was a term used in Azure Database called...
[SQL 2012 query plan enhancement] I want to know why my query is not parallelized
Posted
over 1 year ago
by
SQL Server Support Content
In the past, we have got repeated questions from customers on why a particular query is not parallelized. We didn’t have a good way to let customer know the reason until SQL 2012. Starting SQL Server 2012, XML showplan is enhanced to include...