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 ...
I have a Debian install with KVM + Libvirt love. I've got a Windows Server 2008 R2 VM running with 3 drives. Originally they were set to VirtIO, but I have since changed two of the three to SATA. The ...
SQL Azure is Microsoft's cloud-based relational database service hosted in their data centers, and it's got some DBAs worrying about the future. The more I look at the technology, however, the more I ...
The database utility dba_BlockTracer extracts data about the running processes by inspecting the system view sys.sysprocesses. This view then queries the underlying system table sysprocesses. CREATE ...