One of the most common problems when running SQL Servers is slow queries. The help desk or database team usually hears that described as the application is slow or ...

The much-used Microsoft SQL Profiler is a tool headed toward obsolescence. What options are available once the tool is deprecated? We examine SQL Server Extended Events as a possibility. The ...

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...

"For years, DBAs asked for a simple way to gather and view SQL events data in real-time," said Josh Stephens, Vice President of Product Strategy at Idera. "We're excited to give DBAs a free solution ...

Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...