Using ‘dbghelp.dll’ version ‘4.0.5’ error fixed in SQL Server 2012 SP1 CU6
If you use Extended Events you may have noticed that the ERRORLOG file gets bloated with messages like: Using ‘dbghelp.dll’ version ‘4.0.5’ every time you
If you use Extended Events you may have noticed that the ERRORLOG file gets bloated with messages like: Using ‘dbghelp.dll’ version ‘4.0.5’ every time you
Last week I was working with a client on upgrading one of their systems from SQL Server 2000 to SQL Server 2012, while also performing
Since the first release of the SQLskills Availability Group Demonstrator, I’ve had an number of requests to add the ability to enable MultiSubnetFailover in the
Extended Events are a powerful new way of troubleshooting problems with SQL Server, and the addition of UI support in SQL Server 2012 Management Studio
An important part of ensuring application functionality with Availability Groups is manually maintaining any uncontained objects across each of the replicas in the Availability Group.
Implicit conversions seem to be a growing trend in the SQL Server performance tuning work that I’ve been engaged in recently, and I’ve blogged in
This is actually a blog post I thought I’d written more than two years ago, but this morning when I went looking for it after
One of the challenges with inheriting an existing set of SQL Servers and databases when you start a new job can be determining which of
Common Table Expressions (CTEs), window functions, and views are all common things in SQL Server development these days. When CTEs and window functions were introduced
Properly configuring Windows and SQL Server to get the best performance from your server hardware is an important task for database administrators. There is a
Recently, Erin (Blog|Twitter) and I encountered a bug in SQL Server that can affect some scenarios in a very negative manner. When working with a
(If you’re having persistent problems with your virtual machine configurations and SQL Server performance, Jonathan can help you fix it – fast! Click here for
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.