SQLPerformance.com “TRANSACTION_MUTEX and Multi-Session Transaction Access”
My third guest blog post was published today on SQLPerformance.com: TRANSACTION_MUTEX and Multi-Session Transaction Access This is related to a recent SQL Server instance I
My third guest blog post was published today on SQLPerformance.com: TRANSACTION_MUTEX and Multi-Session Transaction Access This is related to a recent SQL Server instance I
Last Thursday I presented a session at the PASS Winter 2012 Performance Palooza. It was a great experience and I appreciated the opportunity. The topic
My latest course, “SQL Server: Common Performance Issue Patterns“ was just published by Pluralsight.com. The course description is as follows: “There are a wealth of problems
I wrote a new article for Simple-Talk that was published recently: Fixing Gatekeeper Row Cardinality Estimate Issues In the article I talk about a specific
My second guest blog post was published today on SQLPerformance.com: Ten Common Threats to Execution Plan Quality This is related to the subject of my
SQL Server 2012 Service Pack 1 is out today and it fixes an issue that has been around for several versions regarding distributed queries and
A quick and somewhat nuanced tip today… When evaluating sys.dm_io_virtual_file_stats against collected perfmon counter data, be careful not to erroneously invalidate the latency findings
I missed that this got published last week, so here is just a quick pointer to an article I wrote regarding the relevance of SQL
My first guest blog post published today on SQLPerformance.com: Configuring a Dedicated Network for Availability Group Communication The subject was originally motivated by a question
If you’re planning on using Availability Groups in a production environment, I highly recommend you review the following Books Online topic: Prerequisites, Restrictions, and Recommendations
Yesterday’s SQLSaturday #149 (Minnesota) was most excellent. A few comments/observations/recaps: The event was extremely well organized and professional – while still managing to maintain a
A few weeks ago I was interviewed by Richard Cambell of RunAs Radio: Joe Sack Tunes Queries in SQL Server! We talk about performance tuning,
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.