At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

eSpeaks’ Corey Noles talks with Rob Israch, President of Tipalti, about what it means to lead with Global-First Finance and how companies can build scalable, compliant operations in an increasingly ...

As data continues to explode, DBAs must constantly stay a step ahead by finding new ways to improve database efficiency and performance. Managing data in today’s complex IT environment requires ...

OCZ Technology has started offering to beta testers is ZD-XL SQL Accelerator, a card that uses solid state drive (SSD) storage to improve the performance of SQL Server databases. For OCZ, the ZD-XL ...

The Execute Direct Query event has a duration of 2.1 seconds – meaning that again there is a gap to be explained, a gap where no activity seems to be taking place in the visual (clearly visible in the ...