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
(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
2 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
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 (3 items)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server KBs and Blogs
Why won't my PowerPivot for Excel 2010 workbook upgrade to Excel 2013?
Posted
1 day ago
by
SQL Server Support Content
Recently we've seen an issue where some Excel 2010 workbooks containing PowerPivot models encounter errors when attempting to upgrade to Excel 2013. When opening a PowerPivot model that was created in Excel 2010 in Excel 2013 you will be prompted to...
SQL Server KBs and Blogs
TCPChimney KB article for SQL Server updated with additional info and guidance – Please check.
Posted
2 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
How do I map a differential/transaction log backup to its full backup without using MSDB?
Posted
2 days ago
by
SQL Server Support Content
If you have multiple full, differential and transaction log backups, there are chances you may end up facing the error below during the restore process. “ This differential backup cannot be restored because the database has not been restored to the correct...
SQL Server KBs and Blogs
SharePoint Adventures : Claims, Named Pipes and Kerberos
Posted
7 days ago
by
SQL Server Support Content
I ran into a new Kerberos Scenario that I hadn’t hit before when I was working on the cases related to this blog post . It’s rare that I actually see a case related to the Named Pipes protocol. When I do, it is usually a customer trying to get it...
SQL Server KBs and Blogs
SharePoint Adventures : When connectivity is not connectivity
Posted
7 days ago
by
SQL Server Support Content
I’m always amazed that issues usually come in batches. I was looped into a few cases that had the following symptoms. They were running SharePoint 2010 and Reporting Services 2012 SP1. When they went to use a data source with Windows...
SQL Server KBs and Blogs
Flow Control in Always On Availability Groups – what does it mean and how do I monitor it?
Posted
8 days ago
by
SQL Server Support Content
A question was posed to me whether Flow Control which existed in Mirroring was still relevant for Availability groups. Flow Control is primarily a mechanism to gate or throttle messages to avoid use of excessive resource on the primary or secondary...
SQL Server KBs and Blogs
SQL Server–Storage Spaces/VHDx and 4K Sector Size
Posted
9 days ago
by
SQL Server Support Content
This blog outlines a new twist to my previous blog outlining issues with 4K sector sizes. SQL Server - New Drives Use 4K Sector Size: http://blogs.msdn.com/b/psssql/archive/2011/01/13/sql-server-new-drives-use-4k-sector-size.aspx In the previous post...
SQL Server KBs and Blogs
Change Data Capture gets disabled when you break mirroring and bring the database online
Posted
10 days ago
by
SQL Server Support Content
Issue ================ Recently we encountered an issue where customer performed a planned failover for a mirrored database and after the failover the new principal went into suspect mode because of some reason (which is outside the scope...
SQL Server KBs and Blogs
Implications of the SQL Server Bulk Logged recovery model on point in time restores
Posted
17 days ago
by
SQL Server Support Content
Choosing the database recovery model is one of the more important choices DBAs have. If the business does not need to recover a database to a point in time (PIT) then the SIMPLE recovery model is the choice for you. However, if PIT recovery...
SQL Server KBs and Blogs
Using PowerShell to discover Reporting Services 2012 in SharePoint
Posted
24 days ago
by
SQL Server Support Content
I was recently going through an exercise of documenting how to discover certain aspects of Reporting Services for some Kerberos work. RS 2012 in SharePoint is a totally different game though. The easiest way I could discover certain items...
SQL Server KBs and Blogs
Do NOT delete files from the Windows Installer folder
Posted
24 days ago
by
SQL Server Support Content
C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it on machines on which you have SQL Server installed you may have to rebuild the operating system and reinstall SQL Server. The Windows Installer Cache...
SQL Server KBs and Blogs
Compare SQL Failover Cluster Instance SQL and OS Node Versions using PowerShell
Posted
25 days ago
by
SQL Server Support Content
It is a common check to see if all of the nodes in a cluster are equally patched. The reason behind this is because in order to ensure stable operations and a consistent experience, it is best practice to have all nodes of a failover cluster instance...
SQL Server KBs and Blogs
How to monitor deadlock using extended events in SQL Server 2008 and later
Posted
28 days ago
by
SQL Server Support Content
Before I talk about how to monitor the deadlocks let us have a small brief what is deadlock and how we were handling them in the previous versions of SQL Server. Deadlock : A deadlock occurs when there is a cyclic dependency between two or more threads...
SQL Server KBs and Blogs
AlwaysON - HADRON Learning Series: lock_redo_blocked/redo worker Blocked on Secondary Replica
Posted
28 days ago
by
SQL Server Support Content
The topic I received most in my inbox this week was redo blocked on a secondary while attempting to acquire SCH-M (schema modify) lock. First of all, this is expected behavior and you can monitor for this with your standard blocking activities (sys.dm_exec_requests...
SQL Server KBs and Blogs
AlwaysON - HADRON Learning Series: HADR_SYNC_COMMIT vs WRITELOG wait
Posted
28 days ago
by
SQL Server Support Content
The distinction between these two wait types is subtle but very helpful in tuning your Always On environment. The committing of a transaction means the log block must be written locally as well as remotely for synchronous replicas. When in...
SQL Server KBs and Blogs
Identifying the cause of SQL Server IO bottlenecks using XPerf
Posted
1 month ago
by
SQL Server Support Content
In a previous blog post ( Troubleshooting SQL High CPU usage using Xperf ), we covered the xperf basics, what types of scenarios are appropriate for xperf, and more specifically, how to look at CPU sampling within xperf. In general, user...
SQL Server KBs and Blogs
How It Works: Always On–When Is My Secondary Failover Ready?
Posted
1 month ago
by
SQL Server Support Content
I keep running into the question: “When will my secondary allow automatic failover?” Based on the question I did some extended research and I will try to summarize in is blog post. I don’t want to turn this post into a novel so I am...
SQL Server KBs and Blogs
SQL 2012 System Health Reporting Dashboard – Visualizing sp_server_diagnostics results.
Posted
1 month ago
by
SQL Server Support Content
We have introduced the System Health Session in SQL 2008 in order to capture some critical Events to make post mortem analysis much easier. However in SQL 2008, by default the system_health session was only collected to a ring buffer and not persisted...
SQL Server KBs and Blogs
Get the Active Power Plan of Multiple Servers with PowerShell
Posted
1 month ago
by
SQL Server Support Content
It is a widely known and discussed performance hit when you don’t have an optimal power plan set on your database servers. This is one of those easy ways to get great gains by simply flicking a switch…almost literally. But what happens if...
SQL Server KBs and Blogs
SQL 2012 AlwaysOn Availability groups Automatic Failover doesn’t occur or does it – A look at the logs
Posted
1 month ago
by
SQL Server Support Content
I was dealing with an issue where we had an AlwaysOn availability group with 2 replicas configured for Automatic failover. There was a 30 second glitch where folks could not connect to the Database on the primary and automatic failover did not...
SQL Server KBs and Blogs
SQLIOSim Checksum Validations
Posted
1 month ago
by
SQL Server Support Content
I had a very specific question asked of me related to the SQLIOSIM.exe, checksum validation logic. It is pretty simple logic (on purpose) but effective so here are the basics. The key is that there are multiple memory locations used to hold the...
SQL Server KBs and Blogs
Viewing SQL Server Non-Clustered Index Page Contents
Posted
1 month ago
by
SQL Server Support Content
In this blog post I’ll take a look at what is actually stored in a non-clustered index and (re)introduce you to some tools that you can use for looking at the contents of a given data or index page. Hopefully, by the end of the examples you’ll...
SQL Server KBs and Blogs
SQL FileStream Restore and Anti-Virus
Posted
1 month ago
by
SQL Server Support Content
I encountered an interesting case with FileStream and Antivirus which I looked at with Bob Dorr, blogged about it on the PSS SQL Blog, thought I’d share that link here as well http://blogs.msdn.com/b/psssql/archive/2013/03/29/the-case-of-anti-virus-filter...
SQL Server KBs and Blogs
The Case of Anti-Virus filter drive interference with File Stream Restore
Posted
1 month ago
by
SQL Server Support Content
"Denzil and I were working on this issue for a customer and Denzil has been gracious enough to write-up a blog for all of us." – Bob Dorr From Denzil: I recently worked with a customer on a Database restore issue where the database being restored had...
SQL Server KBs and Blogs
Observing SQL Server Transaction Log Flush Sizes using Extended Events and Process Monitor
Posted
1 month ago
by
SQL Server Support Content
In this blog post we’ll take a look at how SQL Server interacts with the transaction log file using Extended Events and Process Monitor. We will see how small transactions can have a negative impact on transaction log IO throughput and how larger...
Page 1 of 6 (149 items)
1
2
3
4
5
»