SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our current ...

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

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Power BI experts discuss ways to preserve data types with queries, optimize CPU usage, and connect with Power BI Premium User with SQL Profiler. Chris Webb built off a recent blog topic about enabling ...

This book aims to provide SQL developers with knowledge to get the most out of SQL Server 2012. How does it fare? I did wonder if the next three chapters should be in this book, but I guess as the job ...