Browse by Tags

Blog Post: SQL PFE has a Pre-Con at the PASS Summit!

SQL Server Support Content

At the 2014 PASS Summit in Seattle on Tuesday November 4, Denzil Ribeiro and I (Tim Chapman) will be giving a Pre-Conference seminar entitled “ Troubleshoot Customer Performance Problems like a Microsoft Engineer .” In this full-day session ...read more

on 9 Oct 2014
Blog Post: Generating a trusted TDE Certificate in the proper format from a Certificate Authority

SQL Server Support Content

I recently worked with a customer who was attempting to deploy Transparent Database Encryption using a trusted certificate which was generated by a certificate authority (CA). They were unable to import the certificate using the CREATE CERTIFICATE command ...read more

on 4 Feb 2014
Blog Post: Connection Pooling for the SQL Server DBA

SQL Server Support Content

There are a handful of questions that DBAs get in the wild that aren’t necessarily under the jurisdiction of the typical DBA. One of those aspects is connection pooling. Far too often application teams, or network admins, or <insert ...read more

on 8 Oct 2013
Blog Post: Back to Basics: SQL Parameter Sniffing due to Data Skews

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 ...read more

on 27 Aug 2013
Blog Post: Inadvertently Promoting a Local Transaction to a Distributed Transaction

SQL Server Support Content

I recently dealt with a customer issue where they were troubleshooting MSDTC, and upon hearing the explanation of exactly what they were doing, I was a bit surprised that a distributed transaction was being used. Upon further investigation, they were ...read more

on 8 Nov 2013

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?

SQL Server KBs and Blogs

Browse by Tags

Blog Post: SQL PFE has a Pre-Con at the PASS Summit!

Blog Post: Generating a trusted TDE Certificate in the proper format from a Certificate Authority

Blog Post: Connection Pooling for the SQL Server DBA

Blog Post: Back to Basics: SQL Parameter Sniffing due to Data Skews

Blog Post: Inadvertently Promoting a Local Transaction to a Distributed Transaction