It’s easy to start tinkering with the gears of SQL query optimization. You open up SQL Server Management Studio (SSMS), monitor wait time, review the execution plan, gather object information and begin optimizing SQL until you’re running a finely…
It’s easy to start tinkering with the gears of SQL query optimization. You open up SQL Server Management Studio (SSMS), monitor wait time, review the execution plan, gather object information and begin optimizing SQL until you’re running a finely…
In our blog, “An introduction to 8 ApexSQL tools,” we introduced our Toad World® readers a new member in the Quest® family of database tools, ApexSQL. While ApexSQL has 29 (and growing) DBA and developer tools, we narrowed our focus to 8 tools that…
Foglight SQL Performance Investigator (PI) is a powerful workload analysis tool set for database professionals, which brings deep visibility into database performance. It comes with unique features such as historical multi-dimensional analysis…
With the pressures they face every day, database administrators and developers sometimes need a friendly voice of encouragement – someone who understands their struggles and can speak their…
According to Microsoft SQL Master, Brent Ozar, he’s made some terrible database performance tuning decisions throughout his career. Luckily for us, we can benefit from his mistakes and don’t have to figure everything out on our own. He’s shared his hard…
Brent Ozar knows all about going fast – he races cars and he revs up SQL Servers with breathtaking performance results daily. In his recent webcast “How to Measure SQL Server,” for Quest’s Database Training Days series, Brent reminded…